← BackSQL

voc-1.2.276.0.76.11.68-2011-12-19T000000.sql

Download
    --DROP TABLE InsuredAssocEntity CASCADE;
    CREATE TABLE InsuredAssocEntity (
            InsuredAssocEntity_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO InsuredAssocEntity (InsuredAssocEntity_id, code, codeSystem, displayName)
            VALUES (1, 'FAMDEP', '2.16.840.1.113883.5.111', 'family dependent');
        
    INSERT INTO InsuredAssocEntity (InsuredAssocEntity_id, code, codeSystem, displayName)
            VALUES (2, 'SELF', '2.16.840.1.113883.5.111', 'self');