--DROP TABLE APPCModalitaet CASCADE; CREATE TABLE APPCModalitaet ( APPCModalitaet_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (1, '0', '1.2.40.0.34.5.38.1', 'Modalitaet unbestimmt'); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (2, '1', '1.2.40.0.34.5.38.1', 'Röntgen'); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (3, '2', '1.2.40.0.34.5.38.1', 'CT'); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (4, '3', '1.2.40.0.34.5.38.1', 'MRT'); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (5, '4', '1.2.40.0.34.5.38.1', 'US'); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (6, '5', '1.2.40.0.34.5.38.1', 'NUK'); INSERT INTO APPCModalitaet (APPCModalitaet_id, code, codeSystem, displayName) VALUES (7, '6', '1.2.40.0.34.5.38.1', 'PET');