Tables [dbo].[DBFileRollups]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:18 AM Thursday, March 21, 2019
Last Modified1:10:48 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
DBFileRollupIDint4
False
1 - 1
Foreign Keys FK_DBFileRollups_SourceDBFileLinkTypeID_DBFileLinkType: [dbo].[DBFileLinkType].SourceDBFileLinkTypeIDSourceDBFileLinkTypeIDint4
True
SourceColumnvarchar(1000)1000
True
Foreign Keys FK_DBFileRollups_DestDBFileLinkTypeID_DBFileLinkType: [dbo].[DBFileLinkType].DestDBFileLinkTypeIDDestDBFileLinkTypeIDint4
True
AdditionalFromvarchar(1000)1000
True
ManyFilesbit1
False
((0))
NameColumns
FK_DBFileRollups_DestDBFileLinkTypeID_DBFileLinkTypeDestDBFileLinkTypeID->[dbo].[DBFileLinkType].[DBFileLinkTypeID]
FK_DBFileRollups_SourceDBFileLinkTypeID_DBFileLinkTypeSourceDBFileLinkTypeID->[dbo].[DBFileLinkType].[DBFileLinkTypeID]
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