voc-1.2.276.0.76.11.60-2015-09-18T000000.sql

    --DROP TABLE Multiresistantorganisms CASCADE;
    CREATE TABLE Multiresistantorganisms (
            Multiresistantorganisms_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO Multiresistantorganisms (Multiresistantorganisms_id, code, codeSystem, displayName)
            VALUES (1, 'AMRO', '1.2.276.0.76.5.441', 'Multiresistenter Keim');
        
    INSERT INTO Multiresistantorganisms (Multiresistantorganisms_id, code, codeSystem, displayName)
            VALUES (2, 'MRSA', '1.2.276.0.76.5.441', 'MRSA');
        
    INSERT INTO Multiresistantorganisms (Multiresistantorganisms_id, code, codeSystem, displayName)
            VALUES (3, '3MRGN', '1.2.276.0.76.5.441', 'gramnegative Stäbchen, bei der noch eine der Antibiotikagruppen wirksam ist');
        
    INSERT INTO Multiresistantorganisms (Multiresistantorganisms_id, code, codeSystem, displayName)
            VALUES (4, '4MRGN', '1.2.276.0.76.5.441', 'gramnegative Stäbchen, die gegen alle vier Gruppen resistent sind');
        
    INSERT INTO Multiresistantorganisms (Multiresistantorganisms_id, code, codeSystem, displayName)
            VALUES (5, 'VRE', '1.2.276.0.76.5.441', 'VRE');