--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', '1.2.276.0.76.3.1.195.5.41', 'KTW');
INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName)
VALUES (2, '2', '1.2.276.0.76.3.1.195.5.41', 'RTW');
INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName)
VALUES (3, '3', '1.2.276.0.76.3.1.195.5.41', 'NAW/NEF/ITW');
INSERT INTO Transportmethod (Transportmethod_id, code, codeSystem, displayName)
VALUES (4, '4', '1.2.276.0.76.3.1.195.5.41', 'RTH/ITH');