--DROP TABLE diagnosis CASCADE; CREATE TABLE diagnosis ( diagnosis_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO diagnosis (diagnosis_id, code, codeSystem, displayName) VALUES (1, 'R56.0', '2.16.840.1.113883.6.96', 'Febrile convulsions'); INSERT INTO diagnosis (diagnosis_id, code, codeSystem, displayName) VALUES (2, 'F44.5', '2.16.840.1.113883.6.96', 'Dissociative convulsions'); INSERT INTO diagnosis (diagnosis_id, code, codeSystem, displayName) VALUES (3, 'G45.9', '2.16.840.1.113883.6.96', 'Transient cerebral ischaemic attack, unspecified'); INSERT INTO diagnosis (diagnosis_id, code, codeSystem, displayName) VALUES (4, 'I21.0', '1.2.276.0.76.5.409', 'Acute transmural myocardial infarction of anterior wall');