USE [Master] GO CREATE DATABASE [WinAlldatESSCA] GO USE [WinAlldatESSCA] GO /****** Object: Table [dbo].[tblReportSubstanceData] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportSubstanceData]( [block_position_id] [nvarchar](50) NOT NULL, [blockid] [int] NULL, [blocknr] [int] NULL, [blockname] [nvarchar](50) NULL, [block_from] [date] NULL, [block_to] [date] NULL, [position] [int] NULL, [testsubstid] [decimal](18, 0) NOT NULL, [substanceid] [decimal](18, 0) NOT NULL, [substancename] [nvarchar](80) NULL, [concentration_id] [int] NULL, [concentration] [nvarchar](255) NULL, [contactid] [int] NULL, [contact] [nvarchar](60) NULL, [testartid] [nvarchar](1) NULL, [testart_def] [nvarchar](60) NULL, [vehicleid] [nvarchar](1) NULL, [vehicle_short] [nvarchar](255) NULL, [vehicle_def] [nvarchar](255) NULL, [patsubstance] [int] NULL, [test_count] [int] NULL, [nt_count] [int] NULL, [positive_count] [int] NULL ) ON [PRIMARY] GO /****** Object: View [dbo].[ViewReportBlockidTestartDef] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[ViewReportBlockidTestartDef] AS SELECT DISTINCT blockid, testart_def FROM tblReportSubstanceData GO /****** Object: Table [dbo].[tblReportReaction] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportReaction]( [case_block_id] [nvarchar](50) NOT NULL, [block_position_id] [nvarchar](50) NOT NULL, [case_block_position_id] [nvarchar](50) NOT NULL, [case_block_time_id] [nvarchar](50) NOT NULL, [block_position_time_id] [nvarchar](50) NOT NULL, [block_time_id] [nvarchar](50) NOT NULL, [block_position_time_react_id] [nvarchar](50) NOT NULL, [case_block_position_time_id] [nvarchar](50) NOT NULL, [fallid] [int] NOT NULL, [blockid] [int] NULL, [timeid] [nvarchar](1) NULL, [position] [int] NULL, [reactid] [int] NULL, [react_symbol] [nvarchar](8) NULL, [react_definition] [nvarchar](50) NULL, [positive] [int] NULL, [rtime] [nvarchar](6) NULL, [react_nt] [int] NULL ) ON [PRIMARY] GO /****** Object: View [dbo].[viewReportReactionNT] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewReportReactionNT] AS SELECT DISTINCT case_block_id, blockid, [position], reactid from tblReportReaction WHERE reactid = 1 OR reactid = 2 OR reactid = 3 GO /****** Object: View [dbo].[viewReportReactionPositive] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewReportReactionPositive] AS SELECT case_block_id, blockid, [position],COUNT(positive) AS positive from tblReportReaction GROUP BY case_block_id, blockid, positive, [position] HAVING positive = 1 GO /****** Object: Table [dbo].[tblAna_auspr] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblAna_auspr]( [addonfieldid] [int] NOT NULL, [auspr_codeid] [smallint] NOT NULL, [auspr_text] [nvarchar](40) NULL, CONSTRAINT [PK_tblAna_auspr] PRIMARY KEY CLUSTERED ( [addonfieldid] ASC, [auspr_codeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblAna_data] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblAna_data]( [fallid] [int] NOT NULL, [addonfieldid] [int] NOT NULL, [auspr_codeid] [smallint] NOT NULL, CONSTRAINT [PK_tblAna_data] PRIMARY KEY CLUSTERED ( [fallid] ASC, [addonfieldid] ASC, [auspr_codeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblAna_text] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblAna_text]( [addonfieldid] [int] NOT NULL, [addonfieldtext] [nvarchar](128) NULL, [valid_from] [datetime] NULL, [valid_to] [datetime] NULL, CONSTRAINT [PK_tblAna_text] PRIMARY KEY CLUSTERED ( [addonfieldid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblAnamExtended] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblAnamExtended]( [fallid] [int] NOT NULL, [smoker] [int] NULL, [smoke_from] [nvarchar](4) NULL, [smoke_to] [nvarchar](4) NULL, [smoke_cigarettes] [numeric](4, 1) NULL, [smoke_comment] [nvarchar](255) NULL, [tattoo_t1] [int] NULL, [tattoo_t2] [int] NULL, [height_k1] [int] NULL, [weight_k2] [int] NULL, [Immunmodulation_I1] [int] NULL, [Immunmodulation_I2] [int] NULL, [Immunmodulation_I3] [int] NULL, [Immunmodulation_I2A] [nvarchar](64) NULL, PRIMARY KEY CLUSTERED ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblBewert] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblBewert]( [fallid] [int] NOT NULL, [substanceid] [int] NOT NULL, [testartid] [nvarchar](1) NOT NULL, [relevanceid] [int] NULL, [kltx_rel_id] [int] NULL, [contactid] [smallint] NULL, CONSTRAINT [PK_tblBewert] PRIMARY KEY CLUSTERED ( [fallid] ASC, [substanceid] ASC, [testartid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblBewertExtended] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblBewertExtended]( [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [position] [smallint] NOT NULL, [substanceid] [int] NOT NULL, [testartid] [nvarchar](1) NOT NULL, [relevanceid] [int] NULL, [relevance_def] [text] NULL, [contactid] [smallint] NULL, CONSTRAINT [PK_tblBewertExtended] PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC, [position] ASC, [substanceid] ASC, [testartid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[tblBlock] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblBlock]( [blockid] [int] NOT NULL, [blocknr] [smallint] NULL, [contactid] [smallint] NULL, [blockname] [nvarchar](30) NULL, [block_from] [datetime] NULL, [block_to] [datetime] NULL, [testartid] [nvarchar](1) NULL, CONSTRAINT [PK_tblBlock] PRIMARY KEY CLUSTERED ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblBlocksubst] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblBlocksubst]( [blockid] [int] NOT NULL, [position] [smallint] NOT NULL, [testsubstid] [int] NULL, CONSTRAINT [PK_tblBlocksubst] PRIMARY KEY CLUSTERED ( [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblCaseEssca] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblCaseEssca]( [fallid] [int] NOT NULL, [ipatid] [int] NULL, [status] [nvarchar](1) NULL, [dateconsultation] [datetime] NULL, [station] [nvarchar](2) NULL, [atop_dermatitis] [tinyint] NULL, [rhin_allergica] [tinyint] NULL, [aller_astma] [tinyint] NULL, [kltx_letter_id] [int] NULL, [occup1] [smallint] NULL, [occup1_duration] [int] NULL, [occup2] [smallint] NULL, [occup2_duration] [int] NULL, [prev_occup1] [smallint] NULL, [Prev_occup1_duration] [int] NULL, [prev_occup2] [smallint] NULL, [prev_occup2_duration] [int] NULL, [symptoms] [smallint] NULL, [site] [smallint] NULL, [pattern] [smallint] NULL, [secondary_spread] [tinyint] NULL, [diag1] [smallint] NULL, [site1_diag1] [smallint] NULL, [site2_diag1] [smallint] NULL, [site3_diag1] [smallint] NULL, [diag2] [smallint] NULL, [site1_diag2] [smallint] NULL, [site2_diag2] [smallint] NULL, [site3_diag2] [smallint] NULL, [diag_allergic] [smallint] NULL, [diag_irritant] [smallint] NULL, [diag_endogenous] [smallint] NULL, [diag_other] [smallint] NULL, [diag_other_txt] [nvarchar](100) NULL, [occ_factors] [smallint] NULL, [endo_factors] [smallint] NULL, [exo_factors] [smallint] NULL, [leisure_1] [smallint] NULL, [leisure_2] [smallint] NULL, [leisure_3] [smallint] NULL, [contactid_1] [smallint] NULL, [contactid_2] [smallint] NULL, [contactid_3] [smallint] NULL, [semaphore] [tinyint] NULL, [statement_of_agreement] [nvarchar](1) NULL, [fallidkis] [nvarchar](32) NULL, [typ] [int] NULL, CONSTRAINT [PK_tblCaseEssca] PRIMARY KEY CLUSTERED ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblCaseIVDK] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblCaseIVDK]( [fallid] [int] NOT NULL, [ipatid] [int] NULL, [status] [nvarchar](1) NULL, [dateconsultation] [datetime] NULL, [station] [nvarchar](2) NULL, [eczema] [tinyint] NULL, [asthma] [tinyint] NULL, [rhinoconjunctivitis] [tinyint] NULL, [atop_score] [smallint] NULL, [kltx_letter_id] [int] NULL, [contactid_1] [smallint] NULL, [contactid_2] [smallint] NULL, [contactid_3] [smallint] NULL, [indication] [smallint] NULL, [diagid_a1] [smallint] NULL, [diag_1_other] [nvarchar](40) NULL, [loc_diag_1_id] [smallint] NULL, [loc_diag_1b_id] [smallint] NULL, [loc_diag_1c_id] [smallint] NULL, [loc_1_other] [nvarchar](40) NULL, [diagid_a2] [smallint] NULL, [diag_2_other] [nvarchar](40) NULL, [loc_diag_2_id] [smallint] NULL, [loc_diag_2b_id] [smallint] NULL, [loc_diag_2c_id] [smallint] NULL, [loc_2_other] [nvarchar](40) NULL, [cofactor] [tinyint] NULL, [cofactid] [smallint] NULL, [cofact_other] [nvarchar](40) NULL, [ausser_fact] [tinyint] NULL, [occup_caused] [tinyint] NULL, [hobbyworker] [tinyint] NULL, [doctorsname] [nvarchar](30) NULL, [typ] [int] NULL, [statement_of_agreement] [nvarchar](1) NULL, [fallidkis] [nvarchar](32) NULL, CONSTRAINT [PK_tblCaseIVDK] PRIMARY KEY CLUSTERED ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblCloseOldTestSeriesDKG] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblCloseOldTestSeriesDKG]( [Blocknr] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblCountryCodes] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblCountryCodes]( [Land] [nvarchar](48) NULL, [National] [nvarchar](5) NULL, [International] [nvarchar](6) NULL, [Iso_Code] [nvarchar](4) NOT NULL, CONSTRAINT [PK_tblCountryCodes] PRIMARY KEY CLUSTERED ( [Iso_Code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblExportDataLog] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblExportDataLog]( [ifallid] [int] NOT NULL, [iblockid] [int] NOT NULL, [idate] [datetime] NOT NULL, [ipatid] [int] NULL, CONSTRAINT [PK_TblExportDataLog] PRIMARY KEY CLUSTERED ( [ifallid] ASC, [iblockid] ASC, [idate] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblExportDataTmp] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblExportDataTmp]( [fallid] [int] NULL, [blockid] [int] NULL, [ipatid] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblFreeText] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblFreeText]( [kltxid] [int] NOT NULL, [lineno] [smallint] NOT NULL, [textfield] [nvarchar](60) NULL, CONSTRAINT [PK_tblFreeText] PRIMARY KEY CLUSTERED ( [kltxid] ASC, [lineno] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblFreeTextContext] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblFreeTextContext]( [kltxid] [int] NOT NULL, [fallid] [int] NULL, [context] [tinyint] NULL, CONSTRAINT [PK_tblFreeTextContext] PRIMARY KEY CLUSTERED ( [kltxid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblLogBookSys] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblLogBookSys]( [ldate] [datetime] NULL, [ltyp] [nvarchar](1) NULL, [ltext] [nvarchar](60) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblManufacture] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblManufacture]( [manufactureid] [int] NOT NULL, [manu_name_short] [nvarchar](2) NULL, [manu_name] [nvarchar](30) NULL, [manu_address] [nvarchar](90) NULL, CONSTRAINT [PK_tblManufacture] PRIMARY KEY CLUSTERED ( [manufactureid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblNewTestSeriesDKG] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblNewTestSeriesDKG]( [blocknr] [int] NULL, [blockid] [int] NULL, [block_from] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblNewUniqueTestsubstanceId] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblNewUniqueTestsubstanceId]( [testsubstid] [int] NULL, [ErsterWert von new_testsubstid] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblOccupatHist] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblOccupatHist]( [ipatid] [int] NULL, [occupid] [smallint] NULL, [active_from] [nvarchar](8) NULL, [active_to] [nvarchar](8) NULL, [changes_skin] [tinyint] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatBewert] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatBewert]( [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [position] [smallint] NOT NULL, [relevanceid] [int] NULL, [kltx_rel_id] [int] NULL, [contactid] [smallint] NULL, [testartid] [nvarchar](1) NULL, CONSTRAINT [PK_tblPatBewert] PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatblock] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatblock]( [fallid] [int] NULL, [blockid] [int] NOT NULL, [blocknr] [smallint] NULL, [contactid] [smallint] NULL, [blockname] [nvarchar](30) NULL, [testartid] [nvarchar](1) NULL, CONSTRAINT [PK_tblPatblock] PRIMARY KEY CLUSTERED ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatblocksubst] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatblocksubst]( [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [position] [smallint] NOT NULL, [esubst_name] [nvarchar](80) NULL, [concentration] [smallint] NULL, [vehicleid] [nvarchar](1) NULL, CONSTRAINT [PK_tblPatblocksubst] PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatchTest] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatchTest]( [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [datepatchtest] [datetime] NULL, CONSTRAINT [PK_tblPatchTest] PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatient] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatient]( [ipatid] [int] NOT NULL, [adminid] [nvarchar](32) NULL, [patname] [nvarchar](30) NULL, [patfirstname] [nvarchar](30) NULL, [birthname] [nvarchar](30) NULL, [birthdate] [datetime] NULL, [sex] [nvarchar](1) NULL, [street] [nvarchar](30) NULL, [zipcode] [nvarchar](10) NULL, [city] [nvarchar](30) NULL, [country] [nvarchar](3) NULL, [phone_work] [nvarchar](15) NULL, [phone_athome] [nvarchar](15) NULL, [datecurrent] [datetime] NULL, CONSTRAINT [PK_tblPatient] PRIMARY KEY CLUSTERED ( [ipatid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatientOld] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatientOld]( [ipatid] [int] NULL, [adminid] [nvarchar](32) NULL, [patname] [nvarchar](30) NULL, [patfirstname] [nvarchar](30) NULL, [birthname] [nvarchar](30) NULL, [birthdate] [datetime] NULL, [sex] [nvarchar](1) NULL, [street] [nvarchar](30) NULL, [zipcode] [nvarchar](10) NULL, [city] [nvarchar](30) NULL, [country] [nvarchar](3) NULL, [phone_work] [nvarchar](15) NULL, [phone_athome] [nvarchar](15) NULL, [datecurrent] [datetime] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblPatientTmp] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblPatientTmp]( [ipatid] [int] NULL, [adminid] [nvarchar](32) NULL, [patname] [nvarchar](30) NULL, [patfirstname] [nvarchar](30) NULL, [birthname] [nvarchar](30) NULL, [birthdate] [datetime] NULL, [sex] [nvarchar](1) NULL, [street] [nvarchar](30) NULL, [zipcode] [nvarchar](10) NULL, [city] [nvarchar](30) NULL, [country] [nvarchar](3) NULL, [phone_work] [nvarchar](15) NULL, [phone_athome] [nvarchar](15) NULL, [datecurrent] [datetime] NULL, [fallidkis] [nvarchar](32) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReaction] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReaction]( [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [timeid] [nvarchar](1) NOT NULL, [position] [smallint] NOT NULL, [reactid] [smallint] NULL, CONSTRAINT [PK_tblReaction] PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC, [timeid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReactionCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReactionCat]( [LangID] [smallint] NOT NULL, [reactid] [smallint] NOT NULL, [react_symbol] [nvarchar](8) NULL, [react_definition] [nvarchar](50) NULL, [testart] [tinyint] NULL, [positive] [tinyint] NULL, [activekey] [tinyint] NULL, [comment] [nvarchar](20) NULL, CONSTRAINT [PK_tblReactionCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [reactid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReactionCatBackup] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReactionCatBackup]( [LangID] [smallint] NOT NULL, [reactid] [smallint] NOT NULL, [react_symbol] [nvarchar](8) NULL, [react_definition] [nvarchar](50) NULL, [testart] [tinyint] NULL, [positive] [tinyint] NULL, [activekey] [tinyint] NULL, [comment] [nvarchar](20) NULL, CONSTRAINT [PK_tblReactionCatBackup] PRIMARY KEY CLUSTERED ( [LangID] ASC, [reactid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReactionCatOld] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReactionCatOld]( [LangID] [smallint] NOT NULL, [reactid] [smallint] NOT NULL, [react_symbol] [nvarchar](8) NULL, [react_definition] [nvarchar](50) NULL, [testart] [tinyint] NULL, [positive] [tinyint] NULL, [activekey] [tinyint] NULL, [comment] [nvarchar](20) NULL, CONSTRAINT [PK_tblReactionCatOld] PRIMARY KEY CLUSTERED ( [LangID] ASC, [reactid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReading] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReading]( [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [timeid] [nvarchar](1) NOT NULL, [ReadingNoteID] [int] NULL, CONSTRAINT [PK_tblReading] PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC, [timeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReadingNote] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReadingNote]( [ReadingNoteID] [int] NOT NULL, [comment] [nvarchar](40) NULL, [days] [tinyint] NULL, CONSTRAINT [PK_tblReadingNote] PRIMARY KEY CLUSTERED ( [ReadingNoteID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblRelevanceCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblRelevanceCat]( [LangID] [int] NOT NULL, [relevanceid] [int] NOT NULL, [relevance_def] [nvarchar](255) NULL, [rel_id_old] [nvarchar](255) NULL, CONSTRAINT [PK_tblRelevanceCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [relevanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportCaseData] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportCaseData]( [fallid] [int] NOT NULL, [ipatid] [int] NOT NULL, [patname] [nvarchar](30) NULL, [patfirstname] [nvarchar](30) NULL, [zipcode] [nvarchar](15) NULL, [city] [nvarchar](50) NULL, [street] [nvarchar](50) NULL, [country] [nvarchar](3) NULL, [adminid] [nvarchar](32) NULL, [age] [int] NULL, [ageclass] [nvarchar](255) NULL, [birthdate] [date] NULL, [birthdate_id] [int] NULL, [sex] [nvarchar](1) NULL, [dateconsultation] [date] NULL, [dateconsultation_id] [int] NULL, [yearconsultation] [int] NULL, [station] [nvarchar](2) NULL, [stationname] [nvarchar](255) NULL, [grouptext] [nvarchar](40) NULL, [eczema] [nvarchar](255) NULL, [asthma] [nvarchar](255) NULL, [rhinoconjunctivitis] [nvarchar](255) NULL, [diagnosis_1] [nvarchar](255) NULL, [diagnosis_1_id] [int] NULL, [localisation_1] [nvarchar](255) NULL, [diagnosis_2] [nvarchar](255) NULL, [diagnosis_2_id] [int] NULL, [localisation_2] [nvarchar](255) NULL, [test_indication] [nvarchar](255) NULL, [occupation] [nvarchar](255) NULL, [occup_caused] [nvarchar](255) NULL, [active_to] [nvarchar](8) NULL, [typ] [nvarchar](1) NULL, [rowid] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportDate] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportDate]( [date_id] [int] NOT NULL, [date_iso] [nvarchar](10) NULL, [full_date] [nvarchar](10) NULL, [calendar_day] [int] NULL, [calendar_day_of_year] [int] NULL, [calendar_week] [int] NULL, [calendar_weekday] [int] NULL, [calendar_month] [int] NULL, [calendar_year] [int] NULL, [calendar_short_year] [int] NULL, [calendar_half_year] [int] NULL, [calendar_quarter] [int] NULL, [calendar_day_text] [nvarchar](2) NULL, [calendar_day_of_year_text] [nvarchar](3) NULL, [calendar_week_text] [nvarchar](2) NULL, [calendar_weekday_text] [nvarchar](25) NULL, [calendar_month_text] [nvarchar](2) NULL, [calendar_month_name] [nvarchar](25) NULL, [calendar_year_text] [nvarchar](4) NULL, [calendar_short_year_text] [nvarchar](4) NULL, [calendar_half_year_text] [nvarchar](2) NULL, [calendar_quarter_text] [nvarchar](2) NULL, PRIMARY KEY CLUSTERED ( [date_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportInfo] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportInfo]( [lastrun] [nvarchar](10) NULL, [lasttime] [nvarchar](50) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportOptions] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportOptions]( [list_alias] [nvarchar](250) NOT NULL, [list_name] [nvarchar](250) NULL, [list_index] [int] NULL, [list_from] [nvarchar](10) NULL, [list_to] [nvarchar](10) NULL, [column_1] [nvarchar](250) NULL, [filter_1] [nvarchar](250) NULL, [exact_1] [int] NULL, [column_2] [nvarchar](250) NULL, [filter_2] [nvarchar](250) NULL, [exact_2] [int] NULL, [column_3] [nvarchar](250) NULL, [filter_3] [nvarchar](250) NULL, [exact_3] [int] NULL, [column_4] [nvarchar](250) NULL, [filter_4] [nvarchar](250) NULL, [exact_4] [int] NULL, [column_5] [nvarchar](250) NULL, [filter_5] [nvarchar](250) NULL, [exact_5] [int] NULL, [column_6] [nvarchar](250) NULL, [filter_6] [nvarchar](250) NULL, [exact_6] [int] NULL, [column_7] [nvarchar](250) NULL, [filter_7] [nvarchar](250) NULL, [exact_7] [int] NULL, [column_8] [nvarchar](250) NULL, [filter_8] [nvarchar](250) NULL, [exact_8] [int] NULL, CONSTRAINT [PK_tblReportOptions] PRIMARY KEY CLUSTERED ( [list_alias] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportPatchTest] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportPatchTest]( [case_block_id] [nvarchar](50) NOT NULL, [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [datepatchtest] [datetime] NULL, [datepatchtest_id] [int] NULL, [substance_count] [int] NULL, [nt_count] [int] NULL, [positive_count] [int] NULL, PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportRating] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportRating]( [fallid] [int] NOT NULL, [substanceid] [bigint] NULL, [testartid] [nvarchar](1) NULL, [relevanceid] [int] NULL, [contactid] [int] NULL, [relevance_def] [nvarchar](255) NULL, [textfield] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportReading] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportReading]( [case_block_id] [nvarchar](50) NOT NULL, [case_block_time_id] [nvarchar](50) NOT NULL, [block_time_id] [nvarchar](50) NOT NULL, [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [timeid] [nvarchar](1) NULL, [rtime] [nvarchar](6) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblSelectionCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblSelectionCat]( [LangID] [smallint] NOT NULL, [catid] [smallint] NOT NULL, [catvalue] [smallint] NOT NULL, [cattext] [nvarchar](60) NULL, [catgroupid] [smallint] NULL, [catlevel] [int] NULL, CONSTRAINT [PK_tblSelectionCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [catid] ASC, [catvalue] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblSortedTestsubstances] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblSortedTestsubstances]( [testsubstid] [int] NULL, [block_from] [datetime] NULL, [new_testsubstid] [int] NULL, [blockid] [int] NULL, [blocknr] [int] NULL, [position] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblStationCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblStationCat]( [LangID] [smallint] NOT NULL, [station] [nvarchar](2) NOT NULL, [station_def] [nvarchar](20) NULL, [groupid] [tinyint] NULL, [grouptext] [nvarchar](40) NULL, [activeflag] [bit] NOT NULL, CONSTRAINT [PK_tblStationCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [station] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblSubstance] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblSubstance]( [substanceid] [int] NOT NULL, [substancename] [nvarchar](80) NULL, [substancename_inci] [nvarchar](50) NULL, [kltx_vork_id] [int] NULL, CONSTRAINT [PK_tblSubstance] PRIMARY KEY CLUSTERED ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblSubstDeposit] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblSubstDeposit]( [substanceid] [int] NOT NULL, [lineno] [smallint] NOT NULL, [textfield] [nvarchar](80) NULL, CONSTRAINT [PK_tblSubstDeposit] PRIMARY KEY CLUSTERED ( [substanceid] ASC, [lineno] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblTestartCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblTestartCat]( [LangID] [smallint] NOT NULL, [testartid] [nvarchar](1) NOT NULL, [testart_def] [nvarchar](20) NULL, [testart] [tinyint] NULL, [RelevanceID] [int] NULL, CONSTRAINT [PK_tblTestartCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [testartid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblTestSeriesNotUsedDKG] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblTestSeriesNotUsedDKG]( [blockid] [int] NULL, [block_from] [datetime] NULL, [block_to] [datetime] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblTestsubst] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblTestsubst]( [testsubstid] [int] NOT NULL, [substanceid] [int] NULL, [manufactureid] [int] NULL, [orderid] [nvarchar](10) NULL, [concentration] [smallint] NULL, [vehicleid] [nvarchar](1) NULL, CONSTRAINT [PK_tblTestsubst] PRIMARY KEY CLUSTERED ( [testsubstid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblTimeCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblTimeCat]( [LangID] [smallint] NOT NULL, [timeid] [nvarchar](1) NOT NULL, [time] [nvarchar](6) NULL, [days] [smallint] NULL, CONSTRAINT [PK_tblTimeCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [timeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblVehicleCat] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblVehicleCat]( [LangID] [smallint] NOT NULL, [vehicleid] [nvarchar](1) NOT NULL, [vehicle_def] [nvarchar](20) NULL, [vehicle_short] [nvarchar](3) NULL, CONSTRAINT [PK_tblVehicleCat] PRIMARY KEY CLUSTERED ( [LangID] ASC, [vehicleid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[TRANSACTION_LOG] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TRANSACTION_LOG]( [SQL] [text] NULL, [OLD_VALUES] [text] NULL, [DATE_ADDED] [datetime] NULL, [DATE_UPDATED] [datetime] NULL, [USER_ADDED] [nvarchar](104) NULL, [USER_UPDATED] [nvarchar](104) NULL, [ROWID] [int] IDENTITY(1,1) NOT NULL, CONSTRAINT [PK_TRANSACTION_LOG] PRIMARY KEY CLUSTERED ( [ROWID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[USER_LOG] Script Date: 16.01.2024 17:00:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[USER_LOG]( [USER_NAME] [nvarchar](104) NULL, [WIN_USER_NAME] [nvarchar](104) NULL, [COMPUTER_NAME] [nvarchar](104) NULL, [USER_ROLL] [int] NULL, [DATE_ADDED] [datetime] NULL, [DATE_UPDATED] [datetime] NULL, [USER_ADDED] [nvarchar](104) NULL, [USER_UPDATED] [nvarchar](104) NULL, [ROW_ID] [int] IDENTITY(1,1) NOT NULL, CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED ( [ROW_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Index [ID__tblBewert1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewert1] ON [dbo].[tblBewert] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBewert2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewert2] ON [dbo].[tblBewert] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBewert3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewert3] ON [dbo].[tblBewert] ( [relevanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBewertExtended1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewertExtended1] ON [dbo].[tblBewertExtended] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBewertExtended2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewertExtended2] ON [dbo].[tblBewertExtended] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBewertExtended3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewertExtended3] ON [dbo].[tblBewertExtended] ( [relevanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBewertExtended4] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBewertExtended4] ON [dbo].[tblBewertExtended] ( [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBlock1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBlock1] ON [dbo].[tblBlock] ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblBlock2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBlock2] ON [dbo].[tblBlock] ( [testartid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblBlock3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblBlock3] ON [dbo].[tblBlock] ( [contactid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblPatBewert1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblPatBewert1] ON [dbo].[tblPatBewert] ( [relevanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblPatBewert2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblPatBewert2] ON [dbo].[tblPatBewert] ( [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [__tblPatblocksubst_blockid] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [__tblPatblocksubst_blockid] ON [dbo].[tblPatblocksubst] ( [blockid] ASC ) INCLUDE([position],[esubst_name]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblPatblocksubst1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblPatblocksubst1] ON [dbo].[tblPatblocksubst] ( [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [__tblPatchTest] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [__tblPatchTest] ON [dbo].[tblPatchTest] ( [datepatchtest] ASC ) INCLUDE([fallid],[blockid]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [__tblReaction_fallid] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [__tblReaction_fallid] ON [dbo].[tblReaction] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [__tblReaction_position] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [__tblReaction_position] ON [dbo].[tblReaction] ( [blockid] ASC, [position] ASC ) INCLUDE([reactid]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReaction1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReaction1] ON [dbo].[tblReaction] ( [reactid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReaction2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReaction2] ON [dbo].[tblReaction] ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReaction3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReaction3] ON [dbo].[tblReaction] ( [blockid] ASC, [position] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReaction4] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReaction4] ON [dbo].[tblReaction] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReactionCat1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReactionCat1] ON [dbo].[tblReactionCat] ( [reactid] ASC, [positive] ASC, [LangID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [__tblReading] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [__tblReading] ON [dbo].[tblReading] ( [blockid] ASC ) INCLUDE([timeid]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportCaseData1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportCaseData1] ON [dbo].[tblReportCaseData] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportCaseData2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportCaseData2] ON [dbo].[tblReportCaseData] ( [birthdate_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportCaseData3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportCaseData3] ON [dbo].[tblReportCaseData] ( [dateconsultation_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportPatchTest1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest1] ON [dbo].[tblReportPatchTest] ( [case_block_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportPatchTest2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest2] ON [dbo].[tblReportPatchTest] ( [datepatchtest_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportPatchTest3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest3] ON [dbo].[tblReportPatchTest] ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportPatchTest4] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest4] ON [dbo].[tblReportPatchTest] ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportRating1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportRating1] ON [dbo].[tblReportRating] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportRating2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportRating2] ON [dbo].[tblReportRating] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction1] ON [dbo].[tblReportReaction] ( [block_position_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction2] ON [dbo].[tblReportReaction] ( [case_block_position_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction3] ON [dbo].[tblReportReaction] ( [case_block_position_time_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportReaction4] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction4] ON [dbo].[tblReportReaction] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction5] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction5] ON [dbo].[tblReportReaction] ( [case_block_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction6] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction6] ON [dbo].[tblReportReaction] ( [case_block_time_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportReaction7] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction7] ON [dbo].[tblReportReaction] ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReading1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReading1] ON [dbo].[tblReportReading] ( [case_block_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReading2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReading2] ON [dbo].[tblReportReading] ( [case_block_time_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportSubstanceData1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportSubstanceData1] ON [dbo].[tblReportSubstanceData] ( [block_position_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportSubstanceData2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportSubstanceData2] ON [dbo].[tblReportSubstanceData] ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportSubstanceData3] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportSubstanceData3] ON [dbo].[tblReportSubstanceData] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblSelectionCat1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblSelectionCat1] ON [dbo].[tblSelectionCat] ( [cattext] ASC, [LangID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblTestartCat1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblTestartCat1] ON [dbo].[tblTestartCat] ( [testartid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblTestartCat2] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblTestartCat2] ON [dbo].[tblTestartCat] ( [testartid] ASC, [RelevanceID] ASC, [LangID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblTestsubst1] Script Date: 16.01.2024 17:00:30 ******/ CREATE NONCLUSTERED INDEX [ID__tblTestsubst1] ON [dbo].[tblTestsubst] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [smoke_cigarettes] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [tattoo_t1] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [tattoo_t2] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [height_k1] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [weight_k2] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [Immunmodulation_I1] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [Immunmodulation_I2] GO ALTER TABLE [dbo].[tblAnamExtended] ADD DEFAULT ((0)) FOR [Immunmodulation_I3] GO ALTER TABLE [dbo].[tblCaseEssca] ADD DEFAULT ('') FOR [fallidkis] GO ALTER TABLE [dbo].[tblCaseIVDK] ADD DEFAULT ('') FOR [fallidkis] GO ALTER TABLE [dbo].[tblPatientTmp] ADD DEFAULT ('') FOR [fallidkis] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__patna__16CE6296] DEFAULT ('-') FOR [patname] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__patfi__17C286CF] DEFAULT ('-') FOR [patfirstname] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__zipco__18B6AB08] DEFAULT ('-') FOR [zipcode] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReportC__city__19AACF41] DEFAULT ('-') FOR [city] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__stree__1A9EF37A] DEFAULT ('-') FOR [street] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__count__1B9317B3] DEFAULT ('-') FOR [country] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__admin__1C873BEC] DEFAULT ('-') FOR [adminid] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__agecl__1D7B6025] DEFAULT ('-') FOR [ageclass] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReportCa__sex__1E6F845E] DEFAULT ('-') FOR [sex] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF_tblReportCaseData_station] DEFAULT ('-') FOR [station] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF_tblReportCaseData_stationname] DEFAULT ('-') FOR [stationname] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__eczem__1F63A897] DEFAULT ('-') FOR [eczema] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__asthm__2057CCD0] DEFAULT ('-') FOR [asthma] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__rhino__214BF109] DEFAULT ('-') FOR [rhinoconjunctivitis] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__diagn__22401542] DEFAULT ('-') FOR [diagnosis_1] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__local__2334397B] DEFAULT ('-') FOR [localisation_1] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__diagn__24285DB4] DEFAULT ('-') FOR [diagnosis_2] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__local__251C81ED] DEFAULT ('-') FOR [localisation_2] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__test___2610A626] DEFAULT ('-') FOR [test_indication] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__occup__2704CA5F] DEFAULT ('-') FOR [occupation] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__occup__27F8EE98] DEFAULT ('-') FOR [occup_caused] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__activ__28ED12D1] DEFAULT ('-') FOR [active_to] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF_tblReportCaseData_typ] DEFAULT ('-') FOR [typ] GO ALTER TABLE [dbo].[tblReportPatchTest] ADD DEFAULT ((0)) FOR [substance_count] GO ALTER TABLE [dbo].[tblReportPatchTest] ADD DEFAULT ((0)) FOR [positive_count] GO ALTER TABLE [dbo].[tblReportRating] ADD CONSTRAINT [DF_tblReportRating_testartid] DEFAULT ('-') FOR [testartid] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [timeid] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [react_symbol] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [react_definition] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [rtime] GO ALTER TABLE [dbo].[tblReportReading] ADD DEFAULT ('-') FOR [timeid] GO ALTER TABLE [dbo].[tblReportReading] ADD DEFAULT ('-') FOR [rtime] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__block__2AD55B43] DEFAULT ('-') FOR [blockname] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__subst__2BC97F7C] DEFAULT ('-') FOR [substancename] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__conce__2CBDA3B5] DEFAULT ((0)) FOR [concentration_id] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__conce__2DB1C7EE] DEFAULT ('-') FOR [concentration] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__conta__2EA5EC27] DEFAULT ('-') FOR [contact] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__testa__2F9A1060] DEFAULT ('-') FOR [testartid] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__testa__308E3499] DEFAULT ('-') FOR [testart_def] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__vehic__318258D2] DEFAULT ('-') FOR [vehicleid] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__vehic__32767D0B] DEFAULT ('-') FOR [vehicle_short] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__vehic__336AA144] DEFAULT ('-') FOR [vehicle_def] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__patsu__345EC57D] DEFAULT ((0)) FOR [patsubstance] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD DEFAULT ((0)) FOR [test_count] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD DEFAULT ((0)) FOR [nt_count] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD DEFAULT ((0)) FOR [positive_count] GO USE [Master] GO CREATE DATABASE [WinAlldatESSCAReport] GO USE [WinAlldatESSCAReport] GO /****** Object: Table [dbo].[tblReportSubstanceData] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportSubstanceData]( [block_position_id] [nvarchar](50) NOT NULL, [blockid] [int] NULL, [blocknr] [int] NULL, [blockname] [nvarchar](50) NULL, [block_from] [date] NULL, [block_to] [date] NULL, [position] [int] NULL, [testsubstid] [decimal](18, 0) NOT NULL, [substanceid] [decimal](18, 0) NOT NULL, [substancename] [nvarchar](80) NULL, [concentration_id] [int] NULL, [concentration] [nvarchar](255) NULL, [contactid] [int] NULL, [contact] [nvarchar](60) NULL, [testartid] [nvarchar](1) NULL, [testart_def] [nvarchar](60) NULL, [vehicleid] [nvarchar](1) NULL, [vehicle_short] [nvarchar](255) NULL, [vehicle_def] [nvarchar](255) NULL, [patsubstance] [int] NULL, [test_count] [int] NULL, [nt_count] [int] NULL, [positive_count] [int] NULL ) ON [PRIMARY] GO /****** Object: View [dbo].[ViewReportBlockidTestartDef] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[ViewReportBlockidTestartDef] AS SELECT DISTINCT blockid, testart_def FROM tblReportSubstanceData GO /****** Object: Table [dbo].[tblReportReaction] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportReaction]( [case_block_id] [nvarchar](50) NOT NULL, [block_position_id] [nvarchar](50) NOT NULL, [case_block_position_id] [nvarchar](50) NOT NULL, [case_block_time_id] [nvarchar](50) NOT NULL, [block_position_time_id] [nvarchar](50) NOT NULL, [block_time_id] [nvarchar](50) NOT NULL, [block_position_time_react_id] [nvarchar](50) NOT NULL, [case_block_position_time_id] [nvarchar](50) NOT NULL, [fallid] [int] NOT NULL, [blockid] [int] NULL, [timeid] [nvarchar](1) NULL, [position] [int] NULL, [reactid] [int] NULL, [react_symbol] [nvarchar](8) NULL, [react_definition] [nvarchar](50) NULL, [positive] [int] NULL, [rtime] [nvarchar](6) NULL, [react_nt] [int] NULL ) ON [PRIMARY] GO /****** Object: View [dbo].[viewReportReactionNT] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewReportReactionNT] AS SELECT DISTINCT case_block_id, blockid, [position], reactid from tblReportReaction WHERE reactid = 1 OR reactid = 2 OR reactid = 3 GO /****** Object: View [dbo].[viewReportReactionPositive] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewReportReactionPositive] AS SELECT case_block_id, blockid, [position],COUNT(positive) AS positive from tblReportReaction GROUP BY case_block_id, blockid, positive, [position] HAVING positive = 1 GO /****** Object: Table [dbo].[tblReportCaseData] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportCaseData]( [fallid] [int] NOT NULL, [ipatid] [int] NOT NULL, [patname] [nvarchar](30) NULL, [patfirstname] [nvarchar](30) NULL, [zipcode] [nvarchar](15) NULL, [city] [nvarchar](50) NULL, [street] [nvarchar](50) NULL, [country] [nvarchar](3) NULL, [adminid] [nvarchar](32) NULL, [age] [int] NULL, [ageclass] [nvarchar](255) NULL, [birthdate] [date] NULL, [birthdate_id] [int] NULL, [sex] [nvarchar](1) NULL, [dateconsultation] [date] NULL, [dateconsultation_id] [int] NULL, [yearconsultation] [int] NULL, [station] [nvarchar](2) NULL, [stationname] [nvarchar](255) NULL, [grouptext] [nvarchar](40) NULL, [eczema] [nvarchar](255) NULL, [asthma] [nvarchar](255) NULL, [rhinoconjunctivitis] [nvarchar](255) NULL, [diagnosis_1] [nvarchar](255) NULL, [diagnosis_1_id] [int] NULL, [localisation_1] [nvarchar](255) NULL, [diagnosis_2] [nvarchar](255) NULL, [diagnosis_2_id] [int] NULL, [localisation_2] [nvarchar](255) NULL, [test_indication] [nvarchar](255) NULL, [occupation] [nvarchar](255) NULL, [occup_caused] [nvarchar](255) NULL, [active_to] [nvarchar](8) NULL, [typ] [nvarchar](1) NULL, [rowid] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportDate] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportDate]( [date_id] [int] NOT NULL, [date_iso] [nvarchar](10) NULL, [full_date] [nvarchar](10) NULL, [calendar_day] [int] NULL, [calendar_day_of_year] [int] NULL, [calendar_week] [int] NULL, [calendar_weekday] [int] NULL, [calendar_month] [int] NULL, [calendar_year] [int] NULL, [calendar_short_year] [int] NULL, [calendar_half_year] [int] NULL, [calendar_quarter] [int] NULL, [calendar_day_text] [nvarchar](2) NULL, [calendar_day_of_year_text] [nvarchar](3) NULL, [calendar_week_text] [nvarchar](2) NULL, [calendar_weekday_text] [nvarchar](25) NULL, [calendar_month_text] [nvarchar](2) NULL, [calendar_month_name] [nvarchar](25) NULL, [calendar_year_text] [nvarchar](4) NULL, [calendar_short_year_text] [nvarchar](4) NULL, [calendar_half_year_text] [nvarchar](2) NULL, [calendar_quarter_text] [nvarchar](2) NULL, PRIMARY KEY CLUSTERED ( [date_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportInfo] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportInfo]( [lastrun] [nvarchar](10) NULL, [lasttime] [nvarchar](50) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportOptions] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportOptions]( [list_alias] [nvarchar](250) NOT NULL, [list_name] [nvarchar](250) NULL, [list_index] [int] NULL, [list_from] [nvarchar](10) NULL, [list_to] [nvarchar](10) NULL, [column_1] [nvarchar](250) NULL, [filter_1] [nvarchar](250) NULL, [exact_1] [int] NULL, [column_2] [nvarchar](250) NULL, [filter_2] [nvarchar](250) NULL, [exact_2] [int] NULL, [column_3] [nvarchar](250) NULL, [filter_3] [nvarchar](250) NULL, [exact_3] [int] NULL, [column_4] [nvarchar](250) NULL, [filter_4] [nvarchar](250) NULL, [exact_4] [int] NULL, [column_5] [nvarchar](250) NULL, [filter_5] [nvarchar](250) NULL, [exact_5] [int] NULL, [column_6] [nvarchar](250) NULL, [filter_6] [nvarchar](250) NULL, [exact_6] [int] NULL, [column_7] [nvarchar](250) NULL, [filter_7] [nvarchar](250) NULL, [exact_7] [int] NULL, [column_8] [nvarchar](250) NULL, [filter_8] [nvarchar](250) NULL, [exact_8] [int] NULL, CONSTRAINT [PK_tblReportOptions] PRIMARY KEY CLUSTERED ( [list_alias] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportPatchTest] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportPatchTest]( [case_block_id] [nvarchar](50) NOT NULL, [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [datepatchtest] [datetime] NULL, [datepatchtest_id] [int] NULL, [substance_count] [int] NULL, [nt_count] [int] NULL, [positive_count] [int] NULL, PRIMARY KEY CLUSTERED ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportRating] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportRating]( [fallid] [int] NOT NULL, [substanceid] [bigint] NULL, [testartid] [nvarchar](1) NULL, [relevanceid] [int] NULL, [contactid] [int] NULL, [relevance_def] [nvarchar](255) NULL, [textfield] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tblReportReading] Script Date: 16.01.2024 17:02:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblReportReading]( [case_block_id] [nvarchar](50) NOT NULL, [case_block_time_id] [nvarchar](50) NOT NULL, [block_time_id] [nvarchar](50) NOT NULL, [fallid] [int] NOT NULL, [blockid] [int] NOT NULL, [timeid] [nvarchar](1) NULL, [rtime] [nvarchar](6) NULL ) ON [PRIMARY] GO /****** Object: Index [ID__tblReportCaseData1] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportCaseData1] ON [dbo].[tblReportCaseData] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportCaseData2] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportCaseData2] ON [dbo].[tblReportCaseData] ( [birthdate_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportCaseData3] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportCaseData3] ON [dbo].[tblReportCaseData] ( [dateconsultation_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportPatchTest1] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest1] ON [dbo].[tblReportPatchTest] ( [case_block_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportPatchTest2] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest2] ON [dbo].[tblReportPatchTest] ( [datepatchtest_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportPatchTest3] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest3] ON [dbo].[tblReportPatchTest] ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportPatchTest4] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportPatchTest4] ON [dbo].[tblReportPatchTest] ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportRating1] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportRating1] ON [dbo].[tblReportRating] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportRating2] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportRating2] ON [dbo].[tblReportRating] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction1] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction1] ON [dbo].[tblReportReaction] ( [block_position_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction2] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction2] ON [dbo].[tblReportReaction] ( [case_block_position_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction3] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction3] ON [dbo].[tblReportReaction] ( [case_block_position_time_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportReaction4] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction4] ON [dbo].[tblReportReaction] ( [fallid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction5] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction5] ON [dbo].[tblReportReaction] ( [case_block_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportReaction6] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction6] ON [dbo].[tblReportReaction] ( [case_block_time_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportReaction7] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportReaction7] ON [dbo].[tblReportReaction] ( [fallid] ASC, [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ID__tblReportSubstanceData1] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportSubstanceData1] ON [dbo].[tblReportSubstanceData] ( [block_position_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportSubstanceData2] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportSubstanceData2] ON [dbo].[tblReportSubstanceData] ( [blockid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [ID__tblReportSubstanceData3] Script Date: 16.01.2024 17:02:00 ******/ CREATE NONCLUSTERED INDEX [ID__tblReportSubstanceData3] ON [dbo].[tblReportSubstanceData] ( [substanceid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__patna__16CE6296] DEFAULT ('-') FOR [patname] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__patfi__17C286CF] DEFAULT ('-') FOR [patfirstname] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__zipco__18B6AB08] DEFAULT ('-') FOR [zipcode] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReportC__city__19AACF41] DEFAULT ('-') FOR [city] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__stree__1A9EF37A] DEFAULT ('-') FOR [street] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__count__1B9317B3] DEFAULT ('-') FOR [country] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__admin__1C873BEC] DEFAULT ('-') FOR [adminid] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__agecl__1D7B6025] DEFAULT ('-') FOR [ageclass] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReportCa__sex__1E6F845E] DEFAULT ('-') FOR [sex] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF_tblReportCaseData_station] DEFAULT ('-') FOR [station] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF_tblReportCaseData_stationname] DEFAULT ('-') FOR [stationname] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__eczem__1F63A897] DEFAULT ('-') FOR [eczema] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__asthm__2057CCD0] DEFAULT ('-') FOR [asthma] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__rhino__214BF109] DEFAULT ('-') FOR [rhinoconjunctivitis] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__diagn__22401542] DEFAULT ('-') FOR [diagnosis_1] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__local__2334397B] DEFAULT ('-') FOR [localisation_1] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__diagn__24285DB4] DEFAULT ('-') FOR [diagnosis_2] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__local__251C81ED] DEFAULT ('-') FOR [localisation_2] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__test___2610A626] DEFAULT ('-') FOR [test_indication] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__occup__2704CA5F] DEFAULT ('-') FOR [occupation] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__occup__27F8EE98] DEFAULT ('-') FOR [occup_caused] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF__tblReport__activ__28ED12D1] DEFAULT ('-') FOR [active_to] GO ALTER TABLE [dbo].[tblReportCaseData] ADD CONSTRAINT [DF_tblReportCaseData_typ] DEFAULT ('-') FOR [typ] GO ALTER TABLE [dbo].[tblReportPatchTest] ADD DEFAULT ((0)) FOR [substance_count] GO ALTER TABLE [dbo].[tblReportPatchTest] ADD DEFAULT ((0)) FOR [positive_count] GO ALTER TABLE [dbo].[tblReportRating] ADD CONSTRAINT [DF_tblReportRating_testartid] DEFAULT ('-') FOR [testartid] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [timeid] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [react_symbol] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [react_definition] GO ALTER TABLE [dbo].[tblReportReaction] ADD DEFAULT ('-') FOR [rtime] GO ALTER TABLE [dbo].[tblReportReading] ADD DEFAULT ('-') FOR [timeid] GO ALTER TABLE [dbo].[tblReportReading] ADD DEFAULT ('-') FOR [rtime] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__block__2AD55B43] DEFAULT ('-') FOR [blockname] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__subst__2BC97F7C] DEFAULT ('-') FOR [substancename] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__conce__2CBDA3B5] DEFAULT ((0)) FOR [concentration_id] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__conce__2DB1C7EE] DEFAULT ('-') FOR [concentration] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__conta__2EA5EC27] DEFAULT ('-') FOR [contact] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__testa__2F9A1060] DEFAULT ('-') FOR [testartid] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__testa__308E3499] DEFAULT ('-') FOR [testart_def] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__vehic__318258D2] DEFAULT ('-') FOR [vehicleid] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__vehic__32767D0B] DEFAULT ('-') FOR [vehicle_short] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__vehic__336AA144] DEFAULT ('-') FOR [vehicle_def] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD CONSTRAINT [DF__tblReport__patsu__345EC57D] DEFAULT ((0)) FOR [patsubstance] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD DEFAULT ((0)) FOR [test_count] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD DEFAULT ((0)) FOR [nt_count] GO ALTER TABLE [dbo].[tblReportSubstanceData] ADD DEFAULT ((0)) FOR [positive_count] GO