--DROP TABLE ELGA_Dosisparameter CASCADE; CREATE TABLE ELGA_Dosisparameter ( ELGA_Dosisparameter_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Dosisparameter (ELGA_Dosisparameter_id, code, codeSystem, displayName) VALUES (1, '111636', '1.2.840.10008.2.16.4', 'Entrance Exposure at RP'); INSERT INTO ELGA_Dosisparameter (ELGA_Dosisparameter_id, code, codeSystem, displayName) VALUES (2, '111637', '1.2.840.10008.2.16.4', 'Accumulated Average Glandular Dose'); INSERT INTO ELGA_Dosisparameter (ELGA_Dosisparameter_id, code, codeSystem, displayName) VALUES (3, '113507', '1.2.840.10008.2.16.4', 'Administered activity'); INSERT INTO ELGA_Dosisparameter (ELGA_Dosisparameter_id, code, codeSystem, displayName) VALUES (4, '113722', '1.2.840.10008.2.16.4', 'Dose Area Product Total'); INSERT INTO ELGA_Dosisparameter (ELGA_Dosisparameter_id, code, codeSystem, displayName) VALUES (5, '113813', '1.2.840.10008.2.16.4', 'CT Dose Length Product Total'); INSERT INTO ELGA_Dosisparameter (ELGA_Dosisparameter_id, code, codeSystem, displayName) VALUES (6, '113839', '1.2.840.10008.2.16.4', 'Effective Dose');