--DROP TABLE Unfallart CASCADE; CREATE TABLE Unfallart ( Unfallart_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (1, 'AU', '1.2.276.0.76.5.76', 'Unfall als PKW/LKW Insasse'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (2, 'MC', '1.2.276.0.76.5.76', 'Motorradunfall'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (3, 'CY', '1.2.276.0.76.5.76', 'Fahrradunfall'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (4, 'PE', '1.2.276.0.76.5.76', 'Fußgängerunfall'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (5, 'OA', '1.2.276.0.76.5.76', 'Sonstiger Verkehrsunfall'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (6, 'F3', '1.2.276.0.76.5.76', 'Sturz mit Fallhöhe >= 3m'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (7, 'FP', '1.2.276.0.76.5.76', 'Sturz mit Fallhöhe < 3m'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (8, 'HI', '1.2.276.0.76.5.76', 'Schlagverletzung'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (9, 'SH', '1.2.276.0.76.5.76', 'Schussverletzung'); INSERT INTO Unfallart (Unfallart_id, code, codeSystem, displayName) VALUES (10, 'ET', '1.2.276.0.76.5.76', 'Stichverletzung');