CREATE TABLE [dbo].[ListDialogGroupDetails]
(
[GroupID] [int] NOT NULL,
[DialogType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AdditionalWhere] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DefaultFilter] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReferenceColPosition] [int] NULL,
[TransactionTypeColPosition] [int] NULL,
[AdditionalWhere2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ListDialogGroupDetails_AdditionalWhere2] DEFAULT (''),
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ListDialogGroupDetails_Description] DEFAULT (''),
[SecuredObjectID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ListDialogGroupDetails_SecuredObjectID] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ListDialogGroupDetails] ADD CONSTRAINT [PK_ListDialogGroupDetails] PRIMARY KEY CLUSTERED ([GroupID], [DialogType], [Description]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ListDialogGroupDetails] WITH NOCHECK ADD CONSTRAINT [FK_ListDialogGroupDetails_DialogType_ListDialogTypes] FOREIGN KEY ([DialogType]) REFERENCES [dbo].[ListDialogTypes] ([DialogType])
GO
ALTER TABLE [dbo].[ListDialogGroupDetails] WITH NOCHECK ADD CONSTRAINT [FK_ListDialogGroupDetails_GroupID_ListDialogGroups] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[ListDialogGroups] ([GroupID])
GO