Tables [dbo].[XmlInterfaceBranch]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)21
Created3:35:21 PM Tuesday, May 8, 2012
Last Modified7:27:51 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDescription
Cluster Primary Key PK_XmlInterfaceBranch: XmlInterfaceBranchIDXmlInterfaceBranchIDint4
No
1 - 1The primary key.
Foreign Keys FK_XmlInterfaceBranch_XmlInterface: [dbo].[XmlInterface].XmlInterfaceFIDIndexes IX_XmlInterface_Branch: XmlInterfaceFID\BranchFIDIndexes IX_XmlInterfaceBranch_Interface_Branch: XmlInterfaceFID\BranchFIDIndexes IX_XmlInterface_Branch_ExternalCode: XmlInterfaceFID\BranchFID\ExternalCodeIndexes IX_XmlInterfaceBranch_Interface_ExternalCode: XmlInterfaceFID\ExternalCodeXmlInterfaceFIDint4
No
Foreign Keys FK_XmlInterfaceBranch_Branch: [dbo].[Branch].BranchFIDIndexes IX_XmlInterface_Branch: XmlInterfaceFID\BranchFIDIndexes IX_XmlInterfaceBranch_Interface_Branch: XmlInterfaceFID\BranchFIDIndexes IX_XmlInterface_Branch_ExternalCode: XmlInterfaceFID\BranchFID\ExternalCodeBranchFIDint4
No
Foreign Keys FK_XmlInterfaceBranch_AuthorityType: [dbo].[AuthorityTypes].AuthorityFIDAuthorityFIDint4
No
Indexes IX_XmlInterface_Branch_ExternalCode: XmlInterfaceFID\BranchFID\ExternalCodeIndexes IX_XmlInterfaceBranch_Interface_ExternalCode: XmlInterfaceFID\ExternalCodeExternalCodevarchar(50)50
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_XmlInterfaceBranch: XmlInterfaceBranchIDPK_XmlInterfaceBranchXmlInterfaceBranchID
Yes
IX_XmlInterface_BranchXmlInterfaceFID, BranchFID
Yes
IX_XmlInterface_Branch_ExternalCodeXmlInterfaceFID, BranchFID, ExternalCode
Yes
IX_XmlInterfaceBranch_Interface_BranchXmlInterfaceFID, BranchFID
IX_XmlInterfaceBranch_Interface_ExternalCodeXmlInterfaceFID, ExternalCode
Foreign Keys Foreign Keys
NameDeleteColumns
FK_XmlInterfaceBranch_AuthorityTypeAuthorityFID->[dbo].[AuthorityTypes].[AuthPriKey]
FK_XmlInterfaceBranch_BranchBranchFID->[dbo].[Branch].[BranchPriKey]
FK_XmlInterfaceBranch_XmlInterfaceCascadeXmlInterfaceFID->[dbo].[XmlInterface].[XmlInterfaceID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[XmlInterfaceBranch]
(
[XmlInterfaceBranchID] [int] NOT NULL IDENTITY(1, 1),
[XmlInterfaceFID] [int] NOT NULL,
[BranchFID] [int] NOT NULL,
[AuthorityFID] [int] NOT NULL,
[ExternalCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlInterfaceBranch] ADD CONSTRAINT [PK_XmlInterfaceBranch] PRIMARY KEY CLUSTERED  ([XmlInterfaceBranchID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlInterfaceBranch] ADD CONSTRAINT [IX_XmlInterface_Branch] UNIQUE NONCLUSTERED  ([XmlInterfaceFID], [BranchFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlInterfaceBranch] ADD CONSTRAINT [IX_XmlInterface_Branch_ExternalCode] UNIQUE NONCLUSTERED  ([XmlInterfaceFID], [BranchFID], [ExternalCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlInterfaceBranch_Interface_Branch] ON [dbo].[XmlInterfaceBranch] ([XmlInterfaceFID], [BranchFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlInterfaceBranch_Interface_ExternalCode] ON [dbo].[XmlInterfaceBranch] ([XmlInterfaceFID], [ExternalCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlInterfaceBranch] ADD CONSTRAINT [FK_XmlInterfaceBranch_AuthorityType] FOREIGN KEY ([AuthorityFID]) REFERENCES [dbo].[AuthorityTypes] ([AuthPriKey])
GO
ALTER TABLE [dbo].[XmlInterfaceBranch] ADD CONSTRAINT [FK_XmlInterfaceBranch_Branch] FOREIGN KEY ([BranchFID]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[XmlInterfaceBranch] ADD CONSTRAINT [FK_XmlInterfaceBranch_XmlInterface] FOREIGN KEY ([XmlInterfaceFID]) REFERENCES [dbo].[XmlInterface] ([XmlInterfaceID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[XmlInterfaceBranch] TO [MssExec]
GRANT INSERT ON  [dbo].[XmlInterfaceBranch] TO [MssExec]
GRANT DELETE ON  [dbo].[XmlInterfaceBranch] TO [MssExec]
GRANT UPDATE ON  [dbo].[XmlInterfaceBranch] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'The primary key.', 'SCHEMA', N'dbo', 'TABLE', N'XmlInterfaceBranch', 'COLUMN', N'XmlInterfaceBranchID'
GO
Uses