Tables [dbo].[LdBaseRelationships]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:56 AM Thursday, March 21, 2019
Last Modified1:12:33 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_LdBaseRelationships: RelationshipIDRelationshipIDint4
False
1 - 1
Foreign Keys FK_LdBaseRelationships_ColumnID1_LdBaseColumns: [dbo].[LdBaseColumns].ColumnID1ColumnID1int4
False
Column1Filtervarchar(2000)2000
True
Column1FilterTypeIDint4
True
Foreign Keys FK_LdBaseRelationships_FKColumnID1_LdBaseColumns: [dbo].[LdBaseColumns].FKColumnID1FKColumnID1int4
False
Foreign Keys FK_LdBaseRelationships_ColumnID2_LdBaseColumns: [dbo].[LdBaseColumns].ColumnID2ColumnID2int4
True
Column2Filtervarchar(2000)2000
True
Column2FilterTypeIDint4
True
Foreign Keys FK_LdBaseRelationships_FKColumnID2_LdBaseColumns: [dbo].[LdBaseColumns].FKColumnID2FKColumnID2int4
True
MiscFiltervarchar(1500)1500
True
MiscFilterTypeIDint4
True
MiscFilter2varchar(1500)1500
True
MiscFilter2TypeIDint4
True
TypeIDint4
True
Foreign Keys FK_LdBaseRelationships_BaseID_LdBases: [dbo].[LdBases].BaseIDBaseIDint4
False
ClarifyNamebit1
False
((0))
AdditionalNamevarchar(64)64
True
ColumnNameFiltervarchar(64)64
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_LdBaseRelationships: RelationshipIDPK_LdBaseRelationshipsRelationshipID
True
80
NameColumns
FK_LdBaseRelationships_BaseID_LdBasesBaseID->[dbo].[LdBases].[BaseID]
FK_LdBaseRelationships_ColumnID1_LdBaseColumnsColumnID1->[dbo].[LdBaseColumns].[ColumnID]
FK_LdBaseRelationships_ColumnID2_LdBaseColumnsColumnID2->[dbo].[LdBaseColumns].[ColumnID]
FK_LdBaseRelationships_FKColumnID1_LdBaseColumnsFKColumnID1->[dbo].[LdBaseColumns].[ColumnID]
FK_LdBaseRelationships_FKColumnID2_LdBaseColumnsFKColumnID2->[dbo].[LdBaseColumns].[ColumnID]
CREATE TABLE [dbo].[LdBaseRelationships]
(
[RelationshipID] [int] NOT NULL IDENTITY(1, 1),
[ColumnID1] [int] NOT NULL,
[Column1Filter] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Column1FilterTypeID] [int] NULL,
[FKColumnID1] [int] NOT NULL,
[ColumnID2] [int] NULL,
[Column2Filter] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Column2FilterTypeID] [int] NULL,
[FKColumnID2] [int] NULL,
[MiscFilter] [varchar] (1500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiscFilterTypeID] [int] NULL,
[MiscFilter2] [varchar] (1500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiscFilter2TypeID] [int] NULL,
[TypeID] [int] NULL,
[BaseID] [int] NOT NULL,
[ClarifyName] [bit] NOT NULL CONSTRAINT [DF_LdBaseRelationships_ClarifyName] DEFAULT ((0)),
[AdditionalName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ColumnNameFilter] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LdBaseRelationships] ADD CONSTRAINT [PK_LdBaseRelationships] PRIMARY KEY CLUSTERED  ([RelationshipID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LdBaseRelationships] ADD CONSTRAINT [FK_LdBaseRelationships_BaseID_LdBases] FOREIGN KEY ([BaseID]) REFERENCES [dbo].[LdBases] ([BaseID])
GO
ALTER TABLE [dbo].[LdBaseRelationships] ADD CONSTRAINT [FK_LdBaseRelationships_ColumnID1_LdBaseColumns] FOREIGN KEY ([ColumnID1]) REFERENCES [dbo].[LdBaseColumns] ([ColumnID])
GO
ALTER TABLE [dbo].[LdBaseRelationships] ADD CONSTRAINT [FK_LdBaseRelationships_ColumnID2_LdBaseColumns] FOREIGN KEY ([ColumnID2]) REFERENCES [dbo].[LdBaseColumns] ([ColumnID])
GO
ALTER TABLE [dbo].[LdBaseRelationships] ADD CONSTRAINT [FK_LdBaseRelationships_FKColumnID1_LdBaseColumns] FOREIGN KEY ([FKColumnID1]) REFERENCES [dbo].[LdBaseColumns] ([ColumnID])
GO
ALTER TABLE [dbo].[LdBaseRelationships] ADD CONSTRAINT [FK_LdBaseRelationships_FKColumnID2_LdBaseColumns] FOREIGN KEY ([FKColumnID2]) REFERENCES [dbo].[LdBaseColumns] ([ColumnID])
GO