← BackSQL

voc-1.2.276.0.76.11.412-2017-02-08T000000.sql

Download
    --DROP TABLE Laterality CASCADE;
    CREATE TABLE Laterality (
            Laterality_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO Laterality (Laterality_id, code, codeSystem, displayName)
            VALUES (1, 'L', '1.2.276.0.76.5.412', 'Left');
        
    INSERT INTO Laterality (Laterality_id, code, codeSystem, displayName)
            VALUES (2, 'R', '1.2.276.0.76.5.412', 'Right');
        
    INSERT INTO Laterality (Laterality_id, code, codeSystem, displayName)
            VALUES (3, 'B', '1.2.276.0.76.5.412', 'Bilateral');
        
    INSERT INTO Laterality (Laterality_id, code, codeSystem, displayName)
            VALUES (4, 'U', '1.2.276.0.76.5.412', 'Unilateral');
        
    INSERT INTO Laterality (Laterality_id, code, codeSystem, displayName)
            VALUES (5, 'A', '1.2.276.0.76.5.412', 'Atypical');