Tables [dbo].[LookUpCtrlTypeFormFilterIncludeDpds]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:20 AM Thursday, March 21, 2019
Last Modified1:12:37 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_LookUpCtrlTypeFormFilterIncludeDpds_TypeFormFilterID_LookUpCtrlTypeFormFilterIncludes: [dbo].[LookUpCtrlTypeFormFilterIncludes].TypeFormFilterIDTypeFormFilterIDint4
False
Foreign Keys FK_LookUpCtrlTypeFormFilterIncludeDpds_DependentTypeFormID_LookUpCtrlTypeForms: [dbo].[LookUpCtrlTypeForms].DependentTypeFormIDDependentTypeFormIDint4
False
ReplaceMatchvarchar(64)64
False
LookupFieldNamevarchar(64)64
False
Cluster Primary Key PK_LookUpCtrlTypeFormFilterIncludeDpds: LookUpCtrlTypeFormFilterIncludeDpdIDLookUpCtrlTypeFormFilterIncludeDpdIDint4
False
1 - 1
Requiredbit1
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_LookUpCtrlTypeFormFilterIncludeDpds: LookUpCtrlTypeFormFilterIncludeDpdIDPK_LookUpCtrlTypeFormFilterIncludeDpdsLookUpCtrlTypeFormFilterIncludeDpdID
True
80
NameColumns
FK_LookUpCtrlTypeFormFilterIncludeDpds_DependentTypeFormID_LookUpCtrlTypeFormsDependentTypeFormID->[dbo].[LookUpCtrlTypeForms].[TypeFormID]
FK_LookUpCtrlTypeFormFilterIncludeDpds_TypeFormFilterID_LookUpCtrlTypeFormFilterIncludesTypeFormFilterID->[dbo].[LookUpCtrlTypeFormFilterIncludes].[TypeFormFilterID]
CREATE TABLE [dbo].[LookUpCtrlTypeFormFilterIncludeDpds]
(
[TypeFormFilterID] [int] NOT NULL,
[DependentTypeFormID] [int] NOT NULL,
[ReplaceMatch] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LookupFieldName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LookUpCtrlTypeFormFilterIncludeDpdID] [int] NOT NULL IDENTITY(1, 1),
[Required] [bit] NOT NULL CONSTRAINT [DF_LookUpCtrlTypeFormFilterIncludeDpds_Required] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypeFormFilterIncludeDpds] ADD CONSTRAINT [PK_LookUpCtrlTypeFormFilterIncludeDpds] PRIMARY KEY CLUSTERED  ([LookUpCtrlTypeFormFilterIncludeDpdID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LookUpCtrlTypeFormFilterIncludeDpds] ADD CONSTRAINT [FK_LookUpCtrlTypeFormFilterIncludeDpds_DependentTypeFormID_LookUpCtrlTypeForms] FOREIGN KEY ([DependentTypeFormID]) REFERENCES [dbo].[LookUpCtrlTypeForms] ([TypeFormID])
GO
ALTER TABLE [dbo].[LookUpCtrlTypeFormFilterIncludeDpds] ADD CONSTRAINT [FK_LookUpCtrlTypeFormFilterIncludeDpds_TypeFormFilterID_LookUpCtrlTypeFormFilterIncludes] FOREIGN KEY ([TypeFormFilterID]) REFERENCES [dbo].[LookUpCtrlTypeFormFilterIncludes] ([TypeFormFilterID])
GO