CREATE TABLE [dbo].[DBFileRollups]
(
[DBFileRollupID] [int] NOT NULL IDENTITY(1, 1),
[SourceDBFileLinkTypeID] [int] NULL,
[SourceColumn] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestDBFileLinkTypeID] [int] NULL,
[AdditionalFrom] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManyFiles] [bit] NOT NULL CONSTRAINT [DF_DBFileRollups_ManyFiles] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DBFileRollups] ADD CONSTRAINT [FK_DBFileRollups_DestDBFileLinkTypeID_DBFileLinkType] FOREIGN KEY ([DestDBFileLinkTypeID]) REFERENCES [dbo].[DBFileLinkType] ([DBFileLinkTypeID])
GO
ALTER TABLE [dbo].[DBFileRollups] ADD CONSTRAINT [FK_DBFileRollups_SourceDBFileLinkTypeID_DBFileLinkType] FOREIGN KEY ([SourceDBFileLinkTypeID]) REFERENCES [dbo].[DBFileLinkType] ([DBFileLinkTypeID])
GO