--DROP TABLE PostalAddressUse CASCADE; CREATE TABLE PostalAddressUse ( PostalAddressUse_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (1, 'BAD', '2.16.840.1.113883.5.1119', 'bad address'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (2, 'CONF', '2.16.840.1.113883.5.1119', 'confidential'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (3, 'DIR', '2.16.840.1.113883.5.1119', 'direct'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (4, 'H', '2.16.840.1.113883.5.1119', 'home address'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (5, 'HP', '2.16.840.1.113883.5.1119', 'primary home'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (6, 'HV', '2.16.840.1.113883.5.1119', 'vacation home'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (7, 'PHYS', '2.16.840.1.113883.5.1119', 'physical visit address'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (8, 'PST', '2.16.840.1.113883.5.1119', 'postal address'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (9, 'PUB', '2.16.840.1.113883.5.1119', 'public'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (10, 'TMP', '2.16.840.1.113883.5.1119', 'temporary'); INSERT INTO PostalAddressUse (PostalAddressUse_id, code, codeSystem, displayName) VALUES (11, 'WP', '2.16.840.1.113883.5.1119', 'work place');