--DROP TABLE zuweiser CASCADE;
CREATE TABLE zuweiser (
zuweiser_id int NOT NULL PRIMARY KEY,
code varchar(255) NOT NULL,
codeSystem varchar(255) NOT NULL,
displayName varchar(255) NOT NULL,
statusCode varchar(255),
effectiveDate varchar(255),
expirationDate varchar(255),
officialReleaseDate varchar(255),
);
INSERT INTO zuweiser (zuweiser_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (1, 'KVNPIK', '1.2.276.0.76.5.440', 'KV-Notfallpraxis am Krankenhaus', 'active', '2015-09-18T00:00:00', '', '');
INSERT INTO zuweiser (zuweiser_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (2, 'KVNDAK', '1.2.276.0.76.5.440', 'KV-Notdienst außerhalb des Krankenhauses', 'active', '2015-09-18T00:00:00', '', '');