--DROP TABLE DGC_TypeofTest_VS CASCADE; CREATE TABLE DGC_TypeofTest_VS ( DGC_TypeofTest_VS_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (1, '96121-9', '2.16.840.1.113883.6.1', 'SARS-CoV-2 E-Gen ql. /BAL PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (2, '94315-9', '2.16.840.1.113883.6.1', 'SARS-CoV-2 E-Gen ql. /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (3, '96122-7', '2.16.840.1.113883.6.1', 'SARS-CoV-2 E-Gen ql. /NP PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (4, '96120-1', '2.16.840.1.113883.6.1', 'SARS-CoV-2 RdRP-Gen ql. /BAL PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (5, '94314-2', '2.16.840.1.113883.6.1', 'SARS-CoV-2 RdRP-Gen ql. /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (6, '96123-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2 RdRP-Gen ql. /NP PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (7, '94309-2', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (8, '94759-8', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /NP PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (9, '94845-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /OF PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (10, '94500-6', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /RT PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (11, '94746-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (12, '94745-7', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA /RT PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (13, '94558-4', '2.16.840.1.113883.6.1', 'SARS-CoV-2 Ag Resp Ql IA.rapid');