--DROP TABLE Pregnancystatus CASCADE; CREATE TABLE Pregnancystatus ( Pregnancystatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Pregnancystatus (Pregnancystatus_id, code, codeSystem, displayName) VALUES (1, '1', '1.2.276.0.76.3.1.195.5.46', 'Patient ist schwanger'); INSERT INTO Pregnancystatus (Pregnancystatus_id, code, codeSystem, displayName) VALUES (2, '0', '1.2.276.0.76.3.1.195.5.46', 'Patient ist nicht schwanger'); --DROP TABLE Pregnancystatus CASCADE; CREATE TABLE Pregnancystatus ( Pregnancystatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Pregnancystatus (Pregnancystatus_id, code, codeSystem, displayName) VALUES (1, '1', '2.16.840.1.113883.2.6.60.3.5.46', 'Patient ist schwanger'); INSERT INTO Pregnancystatus (Pregnancystatus_id, code, codeSystem, displayName) VALUES (2, '0', '2.16.840.1.113883.2.6.60.3.5.46', 'Patient ist nicht schwanger'); --DROP TABLE Pregnancystatus CASCADE; CREATE TABLE Pregnancystatus ( Pregnancystatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Pregnancystatus (Pregnancystatus_id, code, codeSystem, displayName) VALUES (1, '77386006', '2.16.840.1.113883.6.96', 'Patient currently pregnant (finding)'); INSERT INTO Pregnancystatus (Pregnancystatus_id, code, codeSystem, displayName) VALUES (2, '60001007', '2.16.840.1.113883.6.96', 'Not pregnant (finding)');