--DROP TABLE LanguageAbilityProficiency CASCADE; CREATE TABLE LanguageAbilityProficiency ( LanguageAbilityProficiency_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO LanguageAbilityProficiency (LanguageAbilityProficiency_id, code, codeSystem, displayName) VALUES (1, 'E', '2.16.840.1.113883.5.61', 'Excellent'); INSERT INTO LanguageAbilityProficiency (LanguageAbilityProficiency_id, code, codeSystem, displayName) VALUES (2, 'F', '2.16.840.1.113883.5.61', 'Fair'); INSERT INTO LanguageAbilityProficiency (LanguageAbilityProficiency_id, code, codeSystem, displayName) VALUES (3, 'G', '2.16.840.1.113883.5.61', 'Good'); INSERT INTO LanguageAbilityProficiency (LanguageAbilityProficiency_id, code, codeSystem, displayName) VALUES (4, 'P', '2.16.840.1.113883.5.61', 'Poor');