voc-1.2.276.0.76.3.1.195.11.23-2024-07-22T165110.sql

    --DROP TABLE substance_used CASCADE;
    CREATE TABLE substance_used (
            substance_used_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (1, 'LA28145-3', '2.16.840.1.113883.6.1', 'Patient is not influenced by substance use');
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (2, 'LA28144-6', '2.16.840.1.113883.6.1', 'Unknown substance');
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (3, 'LA28139-6', '2.16.840.1.113883.6.1', 'Alcohol');
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (4, 'LA22650-8', '2.16.840.1.113883.6.1', 'Medication');
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (5, 'LA28141-2', '2.16.840.1.113883.6.1', 'Illegal drug');
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (6, 'LA28142-0', '2.16.840.1.113883.6.1', 'Multiple substances');
        
    INSERT INTO substance_used (substance_used_id, code, codeSystem, displayName)
            VALUES (7, 'LA46-8', '2.16.840.1.113883.6.1', 'Other');