--DROP TABLE x_ActRelationshipExternalReference CASCADE; CREATE TABLE x_ActRelationshipExternalReference ( x_ActRelationshipExternalReference_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO x_ActRelationshipExternalReference (x_ActRelationshipExternalReference_id, code, codeSystem, displayName) VALUES (1, 'ELNK', '2.16.840.1.113883.5.1002', 'episodeLink'); INSERT INTO x_ActRelationshipExternalReference (x_ActRelationshipExternalReference_id, code, codeSystem, displayName) VALUES (2, 'REFR', '2.16.840.1.113883.5.1002', 'refers to'); INSERT INTO x_ActRelationshipExternalReference (x_ActRelationshipExternalReference_id, code, codeSystem, displayName) VALUES (3, 'RPLC', '2.16.840.1.113883.5.1002', 'replaces'); INSERT INTO x_ActRelationshipExternalReference (x_ActRelationshipExternalReference_id, code, codeSystem, displayName) VALUES (4, 'SPRT', '2.16.840.1.113883.5.1002', 'has support'); INSERT INTO x_ActRelationshipExternalReference (x_ActRelationshipExternalReference_id, code, codeSystem, displayName) VALUES (5, 'SUBJ', '2.16.840.1.113883.5.1002', 'has subject'); INSERT INTO x_ActRelationshipExternalReference (x_ActRelationshipExternalReference_id, code, codeSystem, displayName) VALUES (6, 'XCRPT', '2.16.840.1.113883.5.1002', 'Excerpts');