cs-1.2.276.0.76.3.1.195.5.53-2019-08-15T000000.sql

        --DROP TABLE aktin_cs_referral_actions CASCADE;
        CREATE TABLE aktin_cs_referral_actions (
            aktin_cs_referral_actions_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 aktin_cs_referral_actions (aktin_cs_referral_actions_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, '1', '1.2.276.0.76.3.1.195.5.53', 'intern: OP / Intervention (z.B. Herzkatheter, Endoskopie, ...)', 'draft', '', '', '');
        
            INSERT INTO aktin_cs_referral_actions (aktin_cs_referral_actions_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (2, '2', '1.2.276.0.76.3.1.195.5.53', 'extern: OP / Intervention (z.B. Herzkatheter, Endoskopie, ...)', 'draft', '', '', '');
        
            INSERT INTO aktin_cs_referral_actions (aktin_cs_referral_actions_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (3, '3', '1.2.276.0.76.3.1.195.5.53', 'intern: Überwachung (ICU / IMC / Chest-Pain-Unit / Stroke)', 'draft', '', '', '');
        
            INSERT INTO aktin_cs_referral_actions (aktin_cs_referral_actions_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (4, '4', '1.2.276.0.76.3.1.195.5.53', 'extern: Überwachung (ICU / IMC / Chest-Pain-Unit / Stroke)', 'draft', '', '', '');
        
            INSERT INTO aktin_cs_referral_actions (aktin_cs_referral_actions_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (5, '5', '1.2.276.0.76.3.1.195.5.53', 'intern: Normalstation', 'draft', '', '', '');
        
            INSERT INTO aktin_cs_referral_actions (aktin_cs_referral_actions_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (6, '6', '1.2.276.0.76.3.1.195.5.53', 'extern: Normalstation', 'draft', '', '', '');