--DROP TABLE ActivityOfDailyLivingScale CASCADE; CREATE TABLE ActivityOfDailyLivingScale ( ActivityOfDailyLivingScale_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActivityOfDailyLivingScale (ActivityOfDailyLivingScale_id, code, codeSystem, displayName) VALUES (1, '0', '2.16.840.1.113883.6.257.755', 'INDEPENDENT'); INSERT INTO ActivityOfDailyLivingScale (ActivityOfDailyLivingScale_id, code, codeSystem, displayName) VALUES (2, '1', '2.16.840.1.113883.6.257.755', 'SUPERVISION'); INSERT INTO ActivityOfDailyLivingScale (ActivityOfDailyLivingScale_id, code, codeSystem, displayName) VALUES (3, '2', '2.16.840.1.113883.6.257.755', 'LIMITED ASSISTANCE'); INSERT INTO ActivityOfDailyLivingScale (ActivityOfDailyLivingScale_id, code, codeSystem, displayName) VALUES (4, '3', '2.16.840.1.113883.6.257.755', 'EXTENSIVE ASSISTANCE'); INSERT INTO ActivityOfDailyLivingScale (ActivityOfDailyLivingScale_id, code, codeSystem, displayName) VALUES (5, '4', '2.16.840.1.113883.6.257.755', 'TOTAL DEPENDENCE'); INSERT INTO ActivityOfDailyLivingScale (ActivityOfDailyLivingScale_id, code, codeSystem, displayName) VALUES (6, '8', '2.16.840.1.113883.6.257.755', 'ACTIVITY DID NOT OCCUR');