--DROP TABLE ELGA_NullFlavor CASCADE; CREATE TABLE ELGA_NullFlavor ( ELGA_NullFlavor_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (1, 'NI', '2.16.840.1.113883.5.1008', 'NoInformation'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (2, 'OTH', '2.16.840.1.113883.5.1008', 'Other'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (3, 'NINF', '2.16.840.1.113883.5.1008', 'Negative infinity'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (4, 'PINF', '2.16.840.1.113883.5.1008', 'Positive infinity'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (5, 'MSK', '2.16.840.1.113883.5.1008', 'Masked'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (6, 'NA', '2.16.840.1.113883.5.1008', 'Not applicable'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (7, 'UNK', '2.16.840.1.113883.5.1008', 'Unknown'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (8, 'ASKU', '2.16.840.1.113883.5.1008', 'Asked, but unknown'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (9, 'NAV', '2.16.840.1.113883.5.1008', 'Temporarily unavailable'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (10, 'NASK', '2.16.840.1.113883.5.1008', 'Not asked'); INSERT INTO ELGA_NullFlavor (ELGA_NullFlavor_id, code, codeSystem, displayName) VALUES (11, 'TRC', '2.16.840.1.113883.5.1008', 'Trace');