--DROP TABLE epSOSTelecomAddress CASCADE; CREATE TABLE epSOSTelecomAddress ( epSOSTelecomAddress_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (1, 'AS', '2.16.840.1.113883.5.1119', 'answering service'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (2, 'EC', '2.16.840.1.113883.5.1119', 'emergency contact'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (3, 'H', '2.16.840.1.113883.5.1119', 'home'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (4, 'HP', '2.16.840.1.113883.5.1119', 'primary home'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (5, 'HV', '2.16.840.1.113883.5.1119', 'vacation home'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (6, 'MC', '2.16.840.1.113883.5.1119', 'mobile contact'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (7, 'PG', '2.16.840.1.113883.5.1119', 'pager'); INSERT INTO epSOSTelecomAddress (epSOSTelecomAddress_id, code, codeSystem, displayName) VALUES (8, 'WP', '2.16.840.1.113883.5.1119', 'work place');