--DROP TABLE ELGA_SignificantPathogens CASCADE; CREATE TABLE ELGA_SignificantPathogens ( ELGA_SignificantPathogens_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (1, 'SP001', '1.2.40.0.34.5.45', 'Adenovirus im Konjunktivalabstrich (*)'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (2, 'SP002', '1.2.40.0.34.5.45', 'HIV'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (3, 'SP003', '1.2.40.0.34.5.45', 'Bacillus anthracis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (4, 'SP004', '1.2.40.0.34.5.45', 'Influenza A/H5'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (5, 'SP005', '1.2.40.0.34.5.45', 'Influenza A/H5N1'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (6, 'SP006', '1.2.40.0.34.5.45', 'Clostridium botulinum'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (7, 'SP007', '1.2.40.0.34.5.45', 'Brucella spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (8, 'SP008', '1.2.40.0.34.5.45', 'Campylobacter spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (9, 'SP009', '1.2.40.0.34.5.45', 'Chlamydia trachomatis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (10, 'SP010', '1.2.40.0.34.5.45', 'Vibrio cholerae'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (11, 'SP011', '1.2.40.0.34.5.45', 'Denguevirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (12, 'SP012', '1.2.40.0.34.5.45', 'Corynebacterium diphtheriae'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (13, 'SP013', '1.2.40.0.34.5.45', 'Corynebacterium ulcerans'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (14, 'SP014', '1.2.40.0.34.5.45', 'Ebolavirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (15, 'SP015', '1.2.40.0.34.5.45', 'Escherichia coli, sonstige darmpathogene Stämme'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (16, 'SP016', '1.2.40.0.34.5.45', 'Echinococcus spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (17, 'SP017', '1.2.40.0.34.5.45', 'Rickettsia prowazekii'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (18, 'SP018', '1.2.40.0.34.5.45', 'FSME-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (19, 'SP019', '1.2.40.0.34.5.45', 'Gelbfieber-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (20, 'SP020', '1.2.40.0.34.5.45', 'Giardia lamblia'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (21, 'SP021', '1.2.40.0.34.5.45', 'Neisseria gonorrhoeae'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (22, 'SP022', '1.2.40.0.34.5.45', 'Haemophilus influenzae'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (23, 'SP023', '1.2.40.0.34.5.45', 'Hantavirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (24, 'SP024', '1.2.40.0.34.5.45', 'Hepatitis-A-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (25, 'SP025', '1.2.40.0.34.5.45', 'Hepatitis-B-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (26, 'SP026', '1.2.40.0.34.5.45', 'Hepatitis-C-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (27, 'SP027', '1.2.40.0.34.5.45', 'HDV - Hepatitis-D-Virus akut'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (28, 'SP028', '1.2.40.0.34.5.45', 'HEV - akute Virushepatitis E'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (29, 'SP029', '1.2.40.0.34.5.45', 'Influenzavirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (30, 'SP030', '1.2.40.0.34.5.45', 'Bordetella pertussis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (31, 'SP031', '1.2.40.0.34.5.45', 'Cryptosporidium spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (32, 'SP032', '1.2.40.0.34.5.45', 'Lassavirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (33, 'SP033', '1.2.40.0.34.5.45', 'Borrelia recurrentis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (34, 'SP034', '1.2.40.0.34.5.45', 'Legionella spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (35, 'SP035', '1.2.40.0.34.5.45', 'Mycobacterium leprae'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (36, 'SP036', '1.2.40.0.34.5.45', 'Leptospira interrogans'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (37, 'SP037', '1.2.40.0.34.5.45', 'Listeria monocytogenes'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (38, 'SP038', '1.2.40.0.34.5.45', 'Plasmodium spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (39, 'SP039', '1.2.40.0.34.5.45', 'Marburgvirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (40, 'SP040', '1.2.40.0.34.5.45', 'Masernvirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (41, 'SP041', '1.2.40.0.34.5.45', 'Neisseria meningitidis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (42, 'SP042', '1.2.40.0.34.5.45', 'Mumpsvirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (43, 'SP043', '1.2.40.0.34.5.45', 'Norovirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (44, 'SP044', '1.2.40.0.34.5.45', 'Chlamydophila psittaci'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (45, 'SP045', '1.2.40.0.34.5.45', 'Yersinia pestis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (46, 'SP046', '1.2.40.0.34.5.45', 'Streptococcus pneumoniae'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (47, 'SP047', '1.2.40.0.34.5.45', 'Variola-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (48, 'SP048', '1.2.40.0.34.5.45', 'Poliovirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (49, 'SP049', '1.2.40.0.34.5.45', 'Coxiella burnetii'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (50, 'SP050', '1.2.40.0.34.5.45', 'Rotavirus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (51, 'SP051', '1.2.40.0.34.5.45', 'Rubella-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (52, 'SP052', '1.2.40.0.34.5.45', 'Rubella-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (53, 'SP053', '1.2.40.0.34.5.45', 'Salmonella spp. außer S. Typhi und S. Paratyphi'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (54, 'SP054', '1.2.40.0.34.5.45', 'SARS-Coronavirus, SARS-CoV'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (55, 'SP055', '1.2.40.0.34.5.45', 'Shigella spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (56, 'SP056', '1.2.40.0.34.5.45', 'Treponema pallidum'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (57, 'SP057', '1.2.40.0.34.5.45', 'Clostridium tetani'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (58, 'SP058', '1.2.40.0.34.5.45', 'Lyssa-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (59, 'SP059', '1.2.40.0.34.5.45', 'Toxoplasma gondii'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (60, 'SP060', '1.2.40.0.34.5.45', 'Trichinella spp.'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (61, 'SP061', '1.2.40.0.34.5.45', 'Mycobacterium-tuberculosis-Komplex'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (62, 'SP062', '1.2.40.0.34.5.45', 'Francisella tularensis'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (63, 'SP063', '1.2.40.0.34.5.45', 'Salmonella typhi'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (64, 'SP064', '1.2.40.0.34.5.45', 'Salmonella paratyphi'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (65, 'SP065', '1.2.40.0.34.5.45', 'West-Nil-Virus'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (66, 'SP066', '1.2.40.0.34.5.45', 'Yersinia enterocolitica'); INSERT INTO ELGA_SignificantPathogens (ELGA_SignificantPathogens_id, code, codeSystem, displayName) VALUES (67, 'SP067', '1.2.40.0.34.5.45', 'Yersinia pseudotuberculosis');