accident_injury
where rel_insp_nr = 102129
0 records
CREATE TABLE "accident_injury" ( [summary_nr] INTEGER REFERENCES [accident]([summary_nr]), [rel_insp_nr] INTEGER REFERENCES [inspection]([activity_nr]), [age] INTEGER, [sex] TEXT, [nature_of_inj] INTEGER REFERENCES [injury]([accident_number]), [part_of_body] INTEGER REFERENCES [body_part]([accident_number]), [src_of_injury] INTEGER REFERENCES [injury_source]([accident_number]), [event_type] INTEGER REFERENCES [event_type]([accident_number]), [evn_factor] INTEGER REFERENCES [environmental]([accident_number]), [hum_factor] INTEGER REFERENCES [human]([accident_number]), [occ_code] INTEGER REFERENCES [occupation]([accident_number]), [degree_of_inj] INTEGER REFERENCES [degree_injury]([accident_number]), [task_assigned] INTEGER REFERENCES [task]([accident_number]), [hazsub] TEXT, [const_op] INTEGER REFERENCES [operator]([accident_number]), [const_op_cause] INTEGER REFERENCES [operator]([accident_number]), [fat_cause] INTEGER REFERENCES [fatality]([accident_number]), [fall_distance] INTEGER, [fall_ht] INTEGER, [injury_line_nr] INTEGER, [load_dt] TEXT );