--DROP TABLE APPCLateralitaet CASCADE; CREATE TABLE APPCLateralitaet ( APPCLateralitaet_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO APPCLateralitaet (APPCLateralitaet_id, code, codeSystem, displayName) VALUES (1, '0', '1.2.40.0.34.5.38.2', 'Lateralitaet unbestimmt'); INSERT INTO APPCLateralitaet (APPCLateralitaet_id, code, codeSystem, displayName) VALUES (2, '1', '1.2.40.0.34.5.38.2', 'rechts'); INSERT INTO APPCLateralitaet (APPCLateralitaet_id, code, codeSystem, displayName) VALUES (3, '2', '1.2.40.0.34.5.38.2', 'links'); INSERT INTO APPCLateralitaet (APPCLateralitaet_id, code, codeSystem, displayName) VALUES (4, '3', '1.2.40.0.34.5.38.2', 'beidseits'); INSERT INTO APPCLateralitaet (APPCLateralitaet_id, code, codeSystem, displayName) VALUES (5, '4', '1.2.40.0.34.5.38.2', 'unpaariges Organ'); INSERT INTO APPCLateralitaet (APPCLateralitaet_id, code, codeSystem, displayName) VALUES (6, '5', '1.2.40.0.34.5.38.2', 'Atypische Situation ( - Transplantat etc.)');