← BackSQL

cs-1.2.276.0.76.5.440-2015-09-18T000000.sql

Download
        --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', '', '');