--DROP TABLE unfallart_traumaregister CASCADE;
CREATE TABLE unfallart_traumaregister (
unfallart_traumaregister_id int NOT NULL PRIMARY KEY,
code varchar(255) NOT NULL,
codeSystem varchar(255) NOT NULL,
displayName varchar(255) NOT NULL
);
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (1, 'V49', '2.16.840.1.113883.6.3', 'Car occupant injured in other and unspecified transport accidents');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (2, 'V69', '2.16.840.1.113883.6.3', 'Occupant of heavy transport vehicle injured in other and unspecified transport accidents');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (3, 'V79', '2.16.840.1.113883.6.3', 'Bus occupant injured in other and unspecified transport accidents');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (4, 'X59.9', '2.16.840.1.113883.6.3', 'Exposure to unspecified factor causing other and unspecified injury');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (5, 'W20', '2.16.840.1.113883.6.3', 'Struck by thrown, projected or falling object');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (6, 'Y00', '2.16.840.1.113883.6.3', 'Assault by blunt object');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (7, 'X96', '2.16.840.1.113883.6.3', 'Assault by explosive material');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (8, 'X99', '2.16.840.1.113883.6.3', 'Assault by sharp object');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (9, 'X93', '2.16.840.1.113883.6.3', 'Assault by handgun discharge');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (10, 'V99', '2.16.840.1.113883.6.3', 'Unspecified transport accident');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (11, 'V09', '2.16.840.1.113883.6.3', 'Pedestrian injured in other and unspecified transport accidents');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (12, 'V29.91', '2.16.840.1.113883.6.3', 'Electric (assisted) bicycle rider (driver) (passenger) injured in unspecified traffic accident');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (13, '33036003', '2.16.840.1.113883.6.96', 'Fall on same level (event)');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (14, 'LA28130-5', '2.16.840.1.113883.6.1', 'Height range of fall - Greater than 3 meters');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (15, 'LA28131-3', '2.16.840.1.113883.6.1', 'Height range of fall - Less than 3 meters');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (16, '1264045009', '2.16.840.1.113883.6.96', 'Electric scooter accident (event)');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (17, 'V19', '2.16.840.1.113883.6.3', 'Pedal cycle rider injured in other and unspecified transport accidents');
INSERT INTO unfallart_traumaregister (unfallart_traumaregister_id, code, codeSystem, displayName)
VALUES (18, 'V29.99', '2.16.840.1.113883.6.3', 'Rider (driver) (passenger) of other motorcycle injured in unspecified traffic accident');