--DROP TABLE IHEXDScontentTypeCode CASCADE; CREATE TABLE IHEXDScontentTypeCode ( IHEXDScontentTypeCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (1, '1', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Patientenkontakt'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (2, '2', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Verlegung'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (3, '3', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Entlassung'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (4, '4', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Überweisung/Einweisung'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (5, '5', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Aufnahme'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (6, '6', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Anforderung'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (7, '7', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Auf Anfrage'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (8, '8', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Veranlassung durch Patient'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (9, '9', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Konsil/Zweitmeinung'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (10, '10', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Systemwechsel/Archivierung'); INSERT INTO IHEXDScontentTypeCode (IHEXDScontentTypeCode_id, code, codeSystem, displayName) VALUES (11, '11', '1.3.6.1.4.1.19376.3.276.1.5.12', 'Monitoring');