Tables [dbo].[ListDialogGroupDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:14 AM Thursday, March 21, 2019
Last Modified1:12:36 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ListDialogGroupDetails: GroupID\DialogType\DescriptionForeign Keys FK_ListDialogGroupDetails_GroupID_ListDialogGroups: [dbo].[ListDialogGroups].GroupIDGroupIDint4
False
Cluster Primary Key PK_ListDialogGroupDetails: GroupID\DialogType\DescriptionForeign Keys FK_ListDialogGroupDetails_DialogType_ListDialogTypes: [dbo].[ListDialogTypes].DialogTypeDialogTypevarchar(32)32
False
AdditionalWherevarchar(1024)1024
False
DefaultFiltervarchar(255)255
False
ReferenceColPositionint4
True
TransactionTypeColPositionint4
True
AdditionalWhere2varchar(255)255
False
('')
Cluster Primary Key PK_ListDialogGroupDetails: GroupID\DialogType\DescriptionDescriptionvarchar(64)64
False
('')
SecuredObjectIDvarchar(30)30
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ListDialogGroupDetails: GroupID\DialogType\DescriptionPK_ListDialogGroupDetailsGroupID, DialogType, Description
True
80
NameNo CheckColumns
FK_ListDialogGroupDetails_DialogType_ListDialogTypes
True
DialogType->[dbo].[ListDialogTypes].[DialogType]
FK_ListDialogGroupDetails_GroupID_ListDialogGroups
True
GroupID->[dbo].[ListDialogGroups].[GroupID]
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