--DROP TABLE MaritalStatus CASCADE; CREATE TABLE MaritalStatus ( MaritalStatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (1, 'A', '2.16.840.1.113883.5.2', 'Annulled'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (2, 'D', '2.16.840.1.113883.5.2', 'Divorced'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (3, 'I', '2.16.840.1.113883.5.2', 'Interlocutory'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (4, 'L', '2.16.840.1.113883.5.2', 'Legally Separated'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (5, 'M', '2.16.840.1.113883.5.2', 'Married'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (6, 'P', '2.16.840.1.113883.5.2', 'Polygamous'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (7, 'S', '2.16.840.1.113883.5.2', 'Never Married'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (8, 'T', '2.16.840.1.113883.5.2', 'Domestic partner'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (9, 'W', '2.16.840.1.113883.5.2', 'Widowed'); --DROP TABLE MaritalStatus CASCADE; CREATE TABLE MaritalStatus ( MaritalStatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (1, 'A', '2.16.840.1.113883.5.2', 'Annulled'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (2, 'D', '2.16.840.1.113883.5.2', 'Divorced'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (3, 'I', '2.16.840.1.113883.5.2', 'Interlocutory'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (4, 'L', '2.16.840.1.113883.5.2', 'Legally Separated'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (5, 'M', '2.16.840.1.113883.5.2', 'Married'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (6, 'P', '2.16.840.1.113883.5.2', 'Polygamous'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (7, 'S', '2.16.840.1.113883.5.2', 'Never Married'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (8, 'T', '2.16.840.1.113883.5.2', 'Domestic partner'); INSERT INTO MaritalStatus (MaritalStatus_id, code, codeSystem, displayName) VALUES (9, 'W', '2.16.840.1.113883.5.2', 'Widowed');