--DROP TABLE IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare CASCADE; CREATE TABLE IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare ( IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (1, 'BIL', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Bildungseinrichtung'); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (2, 'FOR', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Forschungseinrichtung'); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (3, 'GEN', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Gen-Analysedienste'); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (4, 'MDK', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Medizinischer Dienst der Krankenversicherung'); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (5, 'PAT', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Patient außerhalb der Betreuung '); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (6, 'SPE', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Spendedienste'); INSERT INTO IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare (IHEXDShealthcareFacilityTypeCodeOutsidePatientReleatedHealthcare_id, code, codeSystem, displayName) VALUES (7, 'VER', '1.3.6.1.4.1.19376.3.276.1.5.3', 'Versicherungsträger');