← BackSQL

voc-2.16.840.1.113883.11.21.2-2017-03-06T000000.sql

Download
    --DROP TABLE ActStatusCodeActiveCompletedAbortedSuspended CASCADE;
    CREATE TABLE ActStatusCodeActiveCompletedAbortedSuspended (
            ActStatusCodeActiveCompletedAbortedSuspended_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
            VALUES (1, 'completed', '2.16.840.1.113883.5.14', 'Completed');
        
    INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
            VALUES (2, 'aborted', '2.16.840.1.113883.5.14', 'Aborted');
        
    INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
            VALUES (3, 'active', '2.16.840.1.113883.5.14', 'Active');
        
    INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
            VALUES (4, 'suspended', '2.16.840.1.113883.5.14', 'Suspended');