You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
59 lines
2.5 KiB
59 lines
2.5 KiB
CREATE TABLE IF NOT EXISTS form_soccer_injury ( |
|
id bigint(20) NOT NULL auto_increment, |
|
activity tinyint(1) NOT NULL DEFAULT 1, -- 0 if deleted |
|
|
|
siinjtime time DEFAULT NULL, -- time-of-day of injury |
|
|
|
-- The enumerations below start at a value of 1 - 0 would indicate |
|
-- an unknown or nonconformant value. |
|
|
|
-- 1st qtr, 2nd qtr, 3rd qtr, 4th qtr, warmup, extra time, cooldown, |
|
-- training warmup, training session, training cooldown: |
|
sigametime int(11) NOT NULL DEFAULT 0, |
|
|
|
-- tackling, tackled, collision, kicked, elbow, ball, other contact, |
|
-- passing, shooting, running, dribbling, heading, jumping, landing, fall, |
|
-- stretching, twisting/turning, throwing, diving, other non-contact: |
|
simechanism int(11) NOT NULL DEFAULT 0, |
|
simech_other varchar(255) DEFAULT '', |
|
|
|
-- pitch, training, artificial, allweather, indoor, gym, other: |
|
sisurface int(11) NOT NULL DEFAULT 0, |
|
|
|
-- defender, midfield-offense, midfield-defense, wingback, forward, |
|
-- striker, goalkeeper, starting-lineup, substitute: |
|
siposition int(11) NOT NULL DEFAULT 0, |
|
|
|
-- molded cleats, detachable cleats, indoor shoes, turf shoes: |
|
sifootwear int(11) NOT NULL DEFAULT 0, |
|
|
|
siequip_1 tinyint(1) NOT NULL DEFAULT 0, -- shin pads |
|
siequip_2 tinyint(1) NOT NULL DEFAULT 0, -- gloves |
|
siequip_3 tinyint(1) NOT NULL DEFAULT 0, -- ankle strapping |
|
siequip_4 tinyint(1) NOT NULL DEFAULT 0, -- knee strapping |
|
siequip_5 tinyint(1) NOT NULL DEFAULT 0, -- bracing |
|
siequip_6 tinyint(1) NOT NULL DEFAULT 0, -- synthetic cast |
|
|
|
-- left, right, bilateral, n/a: |
|
siside int(11) NOT NULL DEFAULT 0, |
|
|
|
-- immediately, later, not at all: |
|
siremoved int(11) NOT NULL DEFAULT 0, |
|
|
|
sitreat_1 tinyint(1) NOT NULL DEFAULT 0, -- hospital a&e dept |
|
sitreat_2 tinyint(1) NOT NULL DEFAULT 0, -- general practitioner |
|
sitreat_3 tinyint(1) NOT NULL DEFAULT 0, -- physiotherapist |
|
sitreat_4 tinyint(1) NOT NULL DEFAULT 0, -- nurse |
|
sitreat_5 tinyint(1) NOT NULL DEFAULT 0, -- hospital specialist |
|
sitreat_6 tinyint(1) NOT NULL DEFAULT 0, -- osteopath |
|
sitreat_7 tinyint(1) NOT NULL DEFAULT 0, -- chiropractor |
|
sitreat_8 tinyint(1) NOT NULL DEFAULT 0, -- sports massage therapist |
|
sitreat_9 tinyint(1) NOT NULL DEFAULT 0, -- sports physician |
|
sitreat_10 tinyint(1) NOT NULL DEFAULT 0, -- other |
|
sitreat_other varchar(255) DEFAULT '', |
|
|
|
-- if player is unlikely to return to play: |
|
sinoreturn tinyint(1) NOT NULL DEFAULT 0, |
|
|
|
PRIMARY KEY (id) |
|
) ENGINE=InnoDB;
|
|
|