--DROP TABLE accident_type CASCADE;
CREATE TABLE accident_type (
accident_type_id int NOT NULL PRIMARY KEY,
code varchar(255) NOT NULL,
codeSystem varchar(255) NOT NULL,
displayName varchar(255) NOT NULL
);
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (1, 'LA28131-3', '2.16.840.1.113883.6.1', 'Height range of fall - Less than 3 meters');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (2, 'LA28130-5', '2.16.840.1.113883.6.1', 'Height range of fall - Greater than 3 meters');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (3, '33036003', '2.16.840.1.113883.6.96', 'Fall on same level (event)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (4, '269796009', '2.16.840.1.113883.6.96', 'Shotgun accident (event)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (5, '274923000', '2.16.840.1.113883.6.96', 'Accident caused by edge tool (event)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (6, '429061003', '2.16.840.1.113883.6.96', 'Injury due to impact of moving subject with the stationary object (disorder)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (7, '39826003', '2.16.840.1.113883.6.96', 'Struck by explosion (event)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (8, '33980000', '2.16.840.1.113883.6.96', 'Deflagration (physical force)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (9, '219236005', '2.16.840.1.113883.6.96', 'Assault by striking with blunt object (event)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (10, '242984003', '2.16.840.1.113883.6.96', 'Injury of unknown intent due to impact with moving vehicle (disorder)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (11, '242023009', '2.16.840.1.113883.6.96', 'Asphyxia by burial under powder or solid matter (event)');
INSERT INTO accident_type (accident_type_id, code, codeSystem, displayName)
VALUES (12, '242559006', '2.16.840.1.113883.6.96', 'Accident caused by surface earth or water movement (event)');