--DROP TABLE HL7BasicConfidentialityKind CASCADE; CREATE TABLE HL7BasicConfidentialityKind ( HL7BasicConfidentialityKind_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO HL7BasicConfidentialityKind (HL7BasicConfidentialityKind_id, code, codeSystem, displayName) VALUES (1, 'N', '2.16.840.1.113883.5.25', 'normal'); INSERT INTO HL7BasicConfidentialityKind (HL7BasicConfidentialityKind_id, code, codeSystem, displayName) VALUES (2, 'R', '2.16.840.1.113883.5.25', 'restricted'); INSERT INTO HL7BasicConfidentialityKind (HL7BasicConfidentialityKind_id, code, codeSystem, displayName) VALUES (3, 'V', '2.16.840.1.113883.5.25', 'very restricted');