1 CREATE TABLE IF NOT EXISTS form_soccer_injury (
2 id bigint(20) NOT NULL auto_increment,
3 activity tinyint(1) NOT NULL DEFAULT 1, -- 0 if deleted
5 siinjtime time DEFAULT NULL, -- time-of-day of injury
7 -- The enumerations below start at a value of 1 - 0 would indicate
8 -- an unknown or nonconformant value.
10 -- 1st qtr, 2nd qtr, 3rd qtr, 4th qtr, warmup, extra time, cooldown,
11 -- training warmup, training session, training cooldown:
12 sigametime int(11) NOT NULL DEFAULT 0,
14 -- tackling, tackled, collision, kicked, elbow, ball, other contact,
15 -- passing, shooting, running, dribbling, heading, jumping, landing, fall,
16 -- stretching, twisting/turning, throwing, diving, other non-contact:
17 simechanism int(11) NOT NULL DEFAULT 0,
18 simech_other varchar(255) DEFAULT '',
20 -- pitch, training, artificial, allweather, indoor, gym, other:
21 sisurface int(11) NOT NULL DEFAULT 0,
23 -- defender, midfield-offense, midfield-defense, wingback, forward,
24 -- striker, goalkeeper, starting-lineup, substitute:
25 siposition int(11) NOT NULL DEFAULT 0,
27 -- molded cleats, detachable cleats, indoor shoes, turf shoes:
28 sifootwear int(11) NOT NULL DEFAULT 0,
30 siequip_1 tinyint(1) NOT NULL DEFAULT 0, -- shin pads
31 siequip_2 tinyint(1) NOT NULL DEFAULT 0, -- gloves
32 siequip_3 tinyint(1) NOT NULL DEFAULT 0, -- ankle strapping
33 siequip_4 tinyint(1) NOT NULL DEFAULT 0, -- knee strapping
34 siequip_5 tinyint(1) NOT NULL DEFAULT 0, -- bracing
35 siequip_6 tinyint(1) NOT NULL DEFAULT 0, -- synthetic cast
37 -- left, right, bilateral, n/a:
38 siside int(11) NOT NULL DEFAULT 0,
40 -- immediately, later, not at all:
41 siremoved int(11) NOT NULL DEFAULT 0,
43 sitreat_1 tinyint(1) NOT NULL DEFAULT 0, -- hospital a&e dept
44 sitreat_2 tinyint(1) NOT NULL DEFAULT 0, -- general practitioner
45 sitreat_3 tinyint(1) NOT NULL DEFAULT 0, -- physiotherapist
46 sitreat_4 tinyint(1) NOT NULL DEFAULT 0, -- nurse
47 sitreat_5 tinyint(1) NOT NULL DEFAULT 0, -- hospital specialist
48 sitreat_6 tinyint(1) NOT NULL DEFAULT 0, -- osteopath
49 sitreat_7 tinyint(1) NOT NULL DEFAULT 0, -- chiropractor
50 sitreat_8 tinyint(1) NOT NULL DEFAULT 0, -- sports massage therapist
51 sitreat_9 tinyint(1) NOT NULL DEFAULT 0, -- sports physician
52 sitreat_10 tinyint(1) NOT NULL DEFAULT 0, -- other
53 sitreat_other varchar(255) DEFAULT '',
55 -- if player is unlikely to return to play:
56 sinoreturn tinyint(1) NOT NULL DEFAULT 0,