[dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup]

Property	Value
Row Count (~)	0
Created	9:05:45 AM Friday, November 22, 2024
Last Modified	9:05:46 AM Friday, November 22, 2024

	Name	Data Type	Max Length (Bytes)	Identity
	DocumentAutoUploadRuleDetailMoveTypeGroupID	int	4	1 - 1
$Indexes IX_DocumentAutoUploadRuleDetailMoveTypeGroup_RuleDetail: DocumentAutoUploadRuleDetailFID\MoveTypeGroupFID$	DocumentAutoUploadRuleDetailFID	int	4
$Indexes IX_DocumentAutoUploadRuleDetailMoveTypeGroup_RuleDetail: DocumentAutoUploadRuleDetailFID\MoveTypeGroupFID$	MoveTypeGroupFID	int	4

	Name	Columns	Unique
	PK_DocumentAutoUploadRuleDetailMoveTypeGroup	DocumentAutoUploadRuleDetailMoveTypeGroupID
	IX_DocumentAutoUploadRuleDetailMoveTypeGroup_RuleDetail	DocumentAutoUploadRuleDetailFID, MoveTypeGroupFID
	IX_DocumentAutoUploadRuleDetailMoveTypeGroup_MoveTypeGroup	MoveTypeGroupFID

Name	Delete	Columns
FK_DocumentAutoUploadRuleDetailMoveTypeGroup_DocumentAutoUploadRuleDetail	Cascade	DocumentAutoUploadRuleDetailFID->[dbo].[DocumentAutoUploadRuleDetail].[DocumentAutoUploadRuleDetailID]
FK_DocumentAutoUploadRuleDetailMoveTypeGroup_MoveTypeGroup	Cascade	MoveTypeGroupFID->[dbo].[MoveTypeGroups].[MTGroupPriKey]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup]
(
[DocumentAutoUploadRuleDetailMoveTypeGroupID] [int] NOT NULL IDENTITY(1, 1),
[DocumentAutoUploadRuleDetailFID] [int] NOT NULL,
[MoveTypeGroupFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] ADD CONSTRAINT [PK_DocumentAutoUploadRuleDetailMoveTypeGroup] PRIMARY KEY CLUSTERED  ([DocumentAutoUploadRuleDetailMoveTypeGroupID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_DocumentAutoUploadRuleDetailMoveTypeGroup_RuleDetail] ON [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] ([DocumentAutoUploadRuleDetailFID], [MoveTypeGroupFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentAutoUploadRuleDetailMoveTypeGroup_MoveTypeGroup] ON [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] ([MoveTypeGroupFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] ADD CONSTRAINT [FK_DocumentAutoUploadRuleDetailMoveTypeGroup_DocumentAutoUploadRuleDetail] FOREIGN KEY ([DocumentAutoUploadRuleDetailFID]) REFERENCES [dbo].[DocumentAutoUploadRuleDetail] ([DocumentAutoUploadRuleDetailID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] ADD CONSTRAINT [FK_DocumentAutoUploadRuleDetailMoveTypeGroup_MoveTypeGroup] FOREIGN KEY ([MoveTypeGroupFID]) REFERENCES [dbo].[MoveTypeGroups] ([MTGroupPriKey]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] TO [MssExec]
GRANT INSERT ON  [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] TO [MssExec]
GRANT DELETE ON  [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] TO [MssExec]
GRANT UPDATE ON  [dbo].[DocumentAutoUploadRuleDetailMoveTypeGroup] TO [MssExec]
GO