--DROP TABLE ELGA_NoInformation CASCADE; CREATE TABLE ELGA_NoInformation ( ELGA_NoInformation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_NoInformation (ELGA_NoInformation_id, code, codeSystem, displayName) VALUES (1, '182849000', '2.16.840.1.113883.6.96', 'no drug therapy prescribed'); INSERT INTO ELGA_NoInformation (ELGA_NoInformation_id, code, codeSystem, displayName) VALUES (2, '408350003', '2.16.840.1.113883.6.96', 'patient not on self-medications');