CREATE TABLE [dbo].[LookUpCtrlTypeFilters]
(
[TypeFilterID] [int] NOT NULL IDENTITY(1, 1),
[Type] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FilterName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DisplayName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FilterString] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Complex] [bit] NOT NULL,
[FilterClass] [int] NOT NULL,
[CodeDependent] [bit] NOT NULL,
[StaticFilter] [bit] NOT NULL CONSTRAINT [DF_LookUpCtrlTypeFilters_StaticFilter] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypeFilters] ADD CONSTRAINT [PK__LookUpCt__7E4BE8DB554D8E94] PRIMARY KEY CLUSTERED ([TypeFilterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypeFilters] ADD CONSTRAINT [FK_LookUpCtrlTypeFilters_Type_LookUpCtrlTypes] FOREIGN KEY ([Type]) REFERENCES [dbo].[LookUpCtrlTypes] ([Type])
GO