--DROP TABLE UICC_clinical_pathological CASCADE; CREATE TABLE UICC_clinical_pathological ( UICC_clinical_pathological_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO UICC_clinical_pathological (UICC_clinical_pathological_id, code, codeSystem, displayName) VALUES (1, 'p', '2.16.840.1.113883.15.16', 'p'); INSERT INTO UICC_clinical_pathological (UICC_clinical_pathological_id, code, codeSystem, displayName) VALUES (2, 'c', '2.16.840.1.113883.15.16', 'c');