--DROP TABLE Antikoagulanzien CASCADE; CREATE TABLE Antikoagulanzien ( Antikoagulanzien_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Antikoagulanzien (Antikoagulanzien_id, code, codeSystem, displayName) VALUES (1, 'B01A', '2.16.840.1.113883.6.73', 'Antithrombotic agents'); INSERT INTO Antikoagulanzien (Antikoagulanzien_id, code, codeSystem, displayName) VALUES (2, 'B01AC', '2.16.840.1.113883.6.73', 'Platelet aggregation inhibitors excl. heparin'); INSERT INTO Antikoagulanzien (Antikoagulanzien_id, code, codeSystem, displayName) VALUES (3, 'DOAK', '1.2.276.0.76.5.83', 'Direkte orale Antikoagulanzien'); INSERT INTO Antikoagulanzien (Antikoagulanzien_id, code, codeSystem, displayName) VALUES (4, 'B01AA', '2.16.840.1.113883.6.73', 'Vitamin K antagonists'); INSERT INTO Antikoagulanzien (Antikoagulanzien_id, code, codeSystem, displayName) VALUES (5, 'B01AB', '2.16.840.1.113883.6.73', 'Heparin group');