accident_injury

where rel_insp_nr = 101279

✎ View and edit SQL

0 records

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