--DROP TABLE LanguageAbilityMode CASCADE; CREATE TABLE LanguageAbilityMode ( LanguageAbilityMode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO LanguageAbilityMode (LanguageAbilityMode_id, code, codeSystem, displayName) VALUES (1, 'ESGN', '2.16.840.1.113883.5.60', 'Expressed signed'); INSERT INTO LanguageAbilityMode (LanguageAbilityMode_id, code, codeSystem, displayName) VALUES (2, 'ESP', '2.16.840.1.113883.5.60', 'Expressed spoken'); INSERT INTO LanguageAbilityMode (LanguageAbilityMode_id, code, codeSystem, displayName) VALUES (3, 'EWR', '2.16.840.1.113883.5.60', 'Expressed written'); INSERT INTO LanguageAbilityMode (LanguageAbilityMode_id, code, codeSystem, displayName) VALUES (4, 'RSGN', '2.16.840.1.113883.5.60', 'Received signed'); INSERT INTO LanguageAbilityMode (LanguageAbilityMode_id, code, codeSystem, displayName) VALUES (5, 'RSP', '2.16.840.1.113883.5.60', 'Received spoken'); INSERT INTO LanguageAbilityMode (LanguageAbilityMode_id, code, codeSystem, displayName) VALUES (6, 'RWR', '2.16.840.1.113883.5.60', 'Received written');