voc-1.2.276.0.76.11.52-2015-11-17T000000.sql

    --DROP TABLE Allergyintolerancesubstances CASCADE;
    CREATE TABLE Allergyintolerancesubstances (
            Allergyintolerancesubstances_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO Allergyintolerancesubstances (Allergyintolerancesubstances_id, code, codeSystem, displayName)
            VALUES (1, 'ALGN', '1.2.276.0.76.3.1.195.5.52', 'Allergen');
        
    INSERT INTO Allergyintolerancesubstances (Allergyintolerancesubstances_id, code, codeSystem, displayName)
            VALUES (2, 'A07AA', '2.16.840.1.113883.6.73', 'Antibiotika');
        
    INSERT INTO Allergyintolerancesubstances (Allergyintolerancesubstances_id, code, codeSystem, displayName)
            VALUES (3, 'J01', '2.16.840.1.113883.6.73', 'Antibiotika zur systemischen Anwendung');
        
    INSERT INTO Allergyintolerancesubstances (Allergyintolerancesubstances_id, code, codeSystem, displayName)
            VALUES (4, 'V08', '2.16.840.1.113883.6.73', 'Kontrastmittel');