--DROP TABLE Transportmethod CASCADE; CREATE TABLE Transportmethod ( Transportmethod_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName) VALUES (1, '1', '2.16.840.1.113883.2.6.60.3.5.41', 'KTW'); INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName) VALUES (2, '2', '2.16.840.1.113883.2.6.60.3.5.41', 'RTW'); INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName) VALUES (3, '3', '2.16.840.1.113883.2.6.60.3.5.41', 'NAW/NEF/ITW'); INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName) VALUES (4, '4', '2.16.840.1.113883.2.6.60.3.5.41', 'RTH/ITH');