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