Tables [dbo].[DocumentAutoUploadRuleDetailVanLine]
Properties
PropertyValue
Row Count (~)6
Created7:35:53 PM Tuesday, June 11, 2024
Last Modified7:35:54 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_DocumentAutoUploadRuleDetailVanLine: DocumentAutoUploadRuleDetailVanLineIDDocumentAutoUploadRuleDetailVanLineIDint4
No
1 - 1
Foreign Keys FK_DocumentAutoUploadRuleDetailVanLine_DocumentAutoUploadRuleDetail: [dbo].[DocumentAutoUploadRuleDetail].DocumentAutoUploadRuleDetailFIDIndexes IX_DocumentAutoUploadRuleDetailVanLine_RuleDetail: DocumentAutoUploadRuleDetailFID\VanLineFIDDocumentAutoUploadRuleDetailFIDint4
No
Foreign Keys FK_DocumentAutoUploadRuleDetailVanLine_VanLine: [dbo].[VanLine].VanLineFIDIndexes IX_DocumentAutoUploadRuleDetailVanLine_RuleDetail: DocumentAutoUploadRuleDetailFID\VanLineFIDIndexes IX_DocumentAutoUploadRuleDetailVanLine_VanLine: VanLineFIDVanLineFIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_DocumentAutoUploadRuleDetailVanLine: DocumentAutoUploadRuleDetailVanLineIDPK_DocumentAutoUploadRuleDetailVanLineDocumentAutoUploadRuleDetailVanLineID
Yes
IX_DocumentAutoUploadRuleDetailVanLine_RuleDetailDocumentAutoUploadRuleDetailFID, VanLineFID
Yes
IX_DocumentAutoUploadRuleDetailVanLine_VanLineVanLineFID
Foreign Keys Foreign Keys
NameDeleteColumns
FK_DocumentAutoUploadRuleDetailVanLine_DocumentAutoUploadRuleDetailCascadeDocumentAutoUploadRuleDetailFID->[dbo].[DocumentAutoUploadRuleDetail].[DocumentAutoUploadRuleDetailID]
FK_DocumentAutoUploadRuleDetailVanLine_VanLineCascadeVanLineFID->[dbo].[VanLine].[VLPriKey]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[DocumentAutoUploadRuleDetailVanLine]
(
[DocumentAutoUploadRuleDetailVanLineID] [int] NOT NULL IDENTITY(1, 1),
[DocumentAutoUploadRuleDetailFID] [int] NOT NULL,
[VanLineFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoUploadRuleDetailVanLine] ADD CONSTRAINT [PK_DocumentAutoUploadRuleDetailVanLine] PRIMARY KEY CLUSTERED  ([DocumentAutoUploadRuleDetailVanLineID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_DocumentAutoUploadRuleDetailVanLine_RuleDetail] ON [dbo].[DocumentAutoUploadRuleDetailVanLine] ([DocumentAutoUploadRuleDetailFID], [VanLineFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentAutoUploadRuleDetailVanLine_VanLine] ON [dbo].[DocumentAutoUploadRuleDetailVanLine] ([VanLineFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentAutoUploadRuleDetailVanLine] ADD CONSTRAINT [FK_DocumentAutoUploadRuleDetailVanLine_DocumentAutoUploadRuleDetail] FOREIGN KEY ([DocumentAutoUploadRuleDetailFID]) REFERENCES [dbo].[DocumentAutoUploadRuleDetail] ([DocumentAutoUploadRuleDetailID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DocumentAutoUploadRuleDetailVanLine] ADD CONSTRAINT [FK_DocumentAutoUploadRuleDetailVanLine_VanLine] FOREIGN KEY ([VanLineFID]) REFERENCES [dbo].[VanLine] ([VLPriKey]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[DocumentAutoUploadRuleDetailVanLine] TO [MssExec]
GRANT INSERT ON  [dbo].[DocumentAutoUploadRuleDetailVanLine] TO [MssExec]
GRANT DELETE ON  [dbo].[DocumentAutoUploadRuleDetailVanLine] TO [MssExec]
GRANT UPDATE ON  [dbo].[DocumentAutoUploadRuleDetailVanLine] TO [MssExec]
GO
Uses