--DROP TABLE GuardianType CASCADE; CREATE TABLE GuardianType ( GuardianType_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO GuardianType (GuardianType_id, code, codeSystem, displayName) VALUES (1, 'a', '2.16.756.5.30.1.112.3.1.201812.2', 'accompaniment'); INSERT INTO GuardianType (GuardianType_id, code, codeSystem, displayName) VALUES (2, 'r', '2.16.756.5.30.1.112.3.1.201812.2', 'representation'); INSERT INTO GuardianType (GuardianType_id, code, codeSystem, displayName) VALUES (3, 'c', '2.16.756.5.30.1.112.3.1.201812.2', 'cooperation'); INSERT INTO GuardianType (GuardianType_id, code, codeSystem, displayName) VALUES (4, 'g', '2.16.756.5.30.1.112.3.1.201812.2', 'general guardianship');