← BackSQL

voc-1.2.276.0.76.3.1.195.11.19-2024-08-08T203301.sql

Download
    --DROP TABLE kvfall CASCADE;
    CREATE TABLE kvfall (
            kvfall_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO kvfall (kvfall_id, code, codeSystem, displayName)
            VALUES (1, 'AKV', '1.2.276.0.76.3.1.195.5.97', 'KV-Fall');
        
    INSERT INTO kvfall (kvfall_id, code, codeSystem, displayName)
            VALUES (2, 'AOTH', '1.2.276.0.76.3.1.195.5.97', 'kein KV-Fall');