Tables [dbo].[DocumentAutoDownloadRuleDetail]
Properties
PropertyValue
Row Count (~)0
Created7:35:23 PM Thursday, August 29, 2024
Last Modified7:35:26 PM Thursday, August 29, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_DocumentAutoDownloadRuleDetail: DocumentAutoDownloadRuleDetailIDDocumentAutoDownloadRuleDetailIDint4
No
1 - 1
Foreign Keys FK_DocumentAutoDownloadRuleDetail_DocumentAutoDownloadRule: [dbo].[DocumentAutoDownloadRule].DocumentAutoDownloadRuleFIDIndexes IX_DocumentAutoDownloadRuleDetail_Rule: DocumentAutoDownloadRuleFID\SortOrderDocumentAutoDownloadRuleFIDint4
No
Foreign Keys FK_DocumentAutoDownloadRuleDetail_DocumentAutoDownloadRuleItem: [dbo].[DocumentAutoDownloadRuleItem].DocumentAutoDownloadRuleItemFIDIndexes IX_DocumentAutoDownloadRuleDetail_Item: DocumentAutoDownloadRuleItemFIDDocumentAutoDownloadRuleItemFIDint4
No
Indexes IX_DocumentAutoDownloadRuleDetail_Rule: DocumentAutoDownloadRuleFID\SortOrderSortOrderint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_DocumentAutoDownloadRuleDetail: DocumentAutoDownloadRuleDetailIDPK_DocumentAutoDownloadRuleDetailDocumentAutoDownloadRuleDetailID
Yes
IX_DocumentAutoDownloadRuleDetail_RuleDocumentAutoDownloadRuleFID, SortOrder
Yes
IX_DocumentAutoDownloadRuleDetail_ItemDocumentAutoDownloadRuleItemFID
Foreign Keys Foreign Keys
NameDeleteColumns
FK_DocumentAutoDownloadRuleDetail_DocumentAutoDownloadRuleCascadeDocumentAutoDownloadRuleFID->[dbo].[DocumentAutoDownloadRule].[DocumentAutoDownloadRuleID]
FK_DocumentAutoDownloadRuleDetail_DocumentAutoDownloadRuleItemCascadeDocumentAutoDownloadRuleItemFID->[dbo].[DocumentAutoDownloadRuleItem].[DocumentAutoDownloadRuleItemID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[DocumentAutoDownloadRuleDetail]
(
[DocumentAutoDownloadRuleDetailID] [int] NOT NULL IDENTITY(1, 1),
[DocumentAutoDownloadRuleFID] [int] NOT NULL,
[DocumentAutoDownloadRuleItemFID] [int] NOT NULL,
[SortOrder] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoDownloadRuleDetail] ADD CONSTRAINT [PK_DocumentAutoDownloadRuleDetail] PRIMARY KEY CLUSTERED  ([DocumentAutoDownloadRuleDetailID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_DocumentAutoDownloadRuleDetail_Rule] ON [dbo].[DocumentAutoDownloadRuleDetail] ([DocumentAutoDownloadRuleFID], [SortOrder]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentAutoDownloadRuleDetail_Item] ON [dbo].[DocumentAutoDownloadRuleDetail] ([DocumentAutoDownloadRuleItemFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoDownloadRuleDetail] ADD CONSTRAINT [FK_DocumentAutoDownloadRuleDetail_DocumentAutoDownloadRule] FOREIGN KEY ([DocumentAutoDownloadRuleFID]) REFERENCES [dbo].[DocumentAutoDownloadRule] ([DocumentAutoDownloadRuleID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DocumentAutoDownloadRuleDetail] ADD CONSTRAINT [FK_DocumentAutoDownloadRuleDetail_DocumentAutoDownloadRuleItem] FOREIGN KEY ([DocumentAutoDownloadRuleItemFID]) REFERENCES [dbo].[DocumentAutoDownloadRuleItem] ([DocumentAutoDownloadRuleItemID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[DocumentAutoDownloadRuleDetail] TO [MssExec]
GRANT INSERT ON  [dbo].[DocumentAutoDownloadRuleDetail] TO [MssExec]
GRANT DELETE ON  [dbo].[DocumentAutoDownloadRuleDetail] TO [MssExec]
GRANT UPDATE ON  [dbo].[DocumentAutoDownloadRuleDetail] TO [MssExec]
GO
Uses
Used By