--DROP TABLE ActSubstanceAdministrationCode CASCADE; CREATE TABLE ActSubstanceAdministrationCode ( ActSubstanceAdministrationCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActSubstanceAdministrationCode (ActSubstanceAdministrationCode_id, code, codeSystem, displayName) VALUES (1, 'BOOSTER', '2.16.840.1.113883.5.4', 'Booster Immunization'); INSERT INTO ActSubstanceAdministrationCode (ActSubstanceAdministrationCode_id, code, codeSystem, displayName) VALUES (2, 'DRUG', '2.16.840.1.113883.5.4', 'Drug therapy'); INSERT INTO ActSubstanceAdministrationCode (ActSubstanceAdministrationCode_id, code, codeSystem, displayName) VALUES (3, 'IMMUNIZ', '2.16.840.1.113883.5.4', 'Immunization'); INSERT INTO ActSubstanceAdministrationCode (ActSubstanceAdministrationCode_id, code, codeSystem, displayName) VALUES (4, 'INITIMMUNIZ', '2.16.840.1.113883.5.4', 'Initial Immunization');