Tables [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup]
Properties
PropertyValue
Row Count (~)0
Created7:34:24 PM Tuesday, June 11, 2024
Last Modified7:34:24 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_DocumentAutoDownloadRuleDetailMoveTypeGroup: DocumentAutoDownloadRuleDetailMoveTypeGroupIDDocumentAutoDownloadRuleDetailMoveTypeGroupIDint4
No
1 - 1
Foreign Keys FK_DocumentAutoDownloadRuleDetailMoveTypeGroup_DocumentAutoDownloadRuleDetail: [dbo].[DocumentAutoDownloadRuleDetail].DocumentAutoDownloadRuleDetailFIDIndexes IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_RuleDetail: DocumentAutoDownloadRuleDetailFID\MoveTypeGroupFIDDocumentAutoDownloadRuleDetailFIDint4
No
Foreign Keys FK_DocumentAutoDownloadRuleDetailMoveTypeGroup_MoveTypeGroup: [dbo].[MoveTypeGroups].MoveTypeGroupFIDIndexes IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_RuleDetail: DocumentAutoDownloadRuleDetailFID\MoveTypeGroupFIDIndexes IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_MoveTypeGroup: MoveTypeGroupFIDMoveTypeGroupFIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_DocumentAutoDownloadRuleDetailMoveTypeGroup: DocumentAutoDownloadRuleDetailMoveTypeGroupIDPK_DocumentAutoDownloadRuleDetailMoveTypeGroupDocumentAutoDownloadRuleDetailMoveTypeGroupID
Yes
IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_RuleDetailDocumentAutoDownloadRuleDetailFID, MoveTypeGroupFID
Yes
IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_MoveTypeGroupMoveTypeGroupFID
Foreign Keys Foreign Keys
NameDeleteColumns
FK_DocumentAutoDownloadRuleDetailMoveTypeGroup_DocumentAutoDownloadRuleDetailCascadeDocumentAutoDownloadRuleDetailFID->[dbo].[DocumentAutoDownloadRuleDetail].[DocumentAutoDownloadRuleDetailID]
FK_DocumentAutoDownloadRuleDetailMoveTypeGroup_MoveTypeGroupCascadeMoveTypeGroupFID->[dbo].[MoveTypeGroups].[MTGroupPriKey]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup]
(
[DocumentAutoDownloadRuleDetailMoveTypeGroupID] [int] NOT NULL IDENTITY(1, 1),
[DocumentAutoDownloadRuleDetailFID] [int] NOT NULL,
[MoveTypeGroupFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] ADD CONSTRAINT [PK_DocumentAutoDownloadRuleDetailMoveTypeGroup] PRIMARY KEY CLUSTERED  ([DocumentAutoDownloadRuleDetailMoveTypeGroupID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_RuleDetail] ON [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] ([DocumentAutoDownloadRuleDetailFID], [MoveTypeGroupFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentAutoDownloadRuleDetailMoveTypeGroup_MoveTypeGroup] ON [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] ([MoveTypeGroupFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] ADD CONSTRAINT [FK_DocumentAutoDownloadRuleDetailMoveTypeGroup_DocumentAutoDownloadRuleDetail] FOREIGN KEY ([DocumentAutoDownloadRuleDetailFID]) REFERENCES [dbo].[DocumentAutoDownloadRuleDetail] ([DocumentAutoDownloadRuleDetailID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] ADD CONSTRAINT [FK_DocumentAutoDownloadRuleDetailMoveTypeGroup_MoveTypeGroup] FOREIGN KEY ([MoveTypeGroupFID]) REFERENCES [dbo].[MoveTypeGroups] ([MTGroupPriKey]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] TO [MssExec]
GRANT INSERT ON  [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] TO [MssExec]
GRANT DELETE ON  [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] TO [MssExec]
GRANT UPDATE ON  [dbo].[DocumentAutoDownloadRuleDetailMoveTypeGroup] TO [MssExec]
GO
Uses