Tables [dbo].[SITContact]
Properties
PropertyValue
HeapYes
Row Count (~)0
Created9:00:51 AM Friday, December 7, 2018
Last Modified7:32:45 PM Tuesday, September 24, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Primary Key PK_SITContact: SITContactIDSITContactIDint4
No
1 - 1
Foreign Keys FK_SITContact_Orders: [dbo].[Orders].OrderFIDIndexes IX_SITContact_OrderFID_SITTypeFID_AgentContactFID_MilitaryCarrierContactFID: OrderFID\SITTypeFID\AgentContactFID\MilitaryCarrierContactFIDOrderFIDint4
No
Foreign Keys FK_SITContact_SITType: [dbo].[SITType].SITTypeFIDIndexes IX_SITContact_OrderFID_SITTypeFID_AgentContactFID_MilitaryCarrierContactFID: OrderFID\SITTypeFID\AgentContactFID\MilitaryCarrierContactFIDSITTypeFIDint4
No
Foreign Keys FK_SITContact_AgentContactFID: [dbo].[AgentContact].AgentContactFIDIndexes IX_SITContact_OrderFID_SITTypeFID_AgentContactFID_MilitaryCarrierContactFID: OrderFID\SITTypeFID\AgentContactFID\MilitaryCarrierContactFIDAgentContactFIDint4
Yes
Foreign Keys FK_SITContact_MilitaryContactFID: [dbo].[MilitaryCarrierContact].MilitaryCarrierContactFIDIndexes IX_SITContact_OrderFID_SITTypeFID_AgentContactFID_MilitaryCarrierContactFID: OrderFID\SITTypeFID\AgentContactFID\MilitaryCarrierContactFIDMilitaryCarrierContactFIDint4
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_SITContact: SITContactIDPK_SITContactSITContactID
Yes
IX_SITContact_OrderFID_SITTypeFID_AgentContactFID_MilitaryCarrierContactFIDOrderFID, SITTypeFID, AgentContactFID, MilitaryCarrierContactFID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_SITContact_AgentContactFIDAgentContactFID->[dbo].[AgentContact].[AgentContactID]
FK_SITContact_MilitaryContactFIDMilitaryCarrierContactFID->[dbo].[MilitaryCarrierContact].[MilitaryCarrierContactID]
FK_SITContact_OrdersOrderFID->[dbo].[Orders].[PriKey]
FK_SITContact_SITTypeSITTypeFID->[dbo].[SITType].[SITTypeID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[SITContact]
(
[SITContactID] [int] NOT NULL IDENTITY(1, 1),
[OrderFID] [int] NOT NULL,
[SITTypeFID] [int] NOT NULL,
[AgentContactFID] [int] NULL,
[MilitaryCarrierContactFID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SITContact] ADD CONSTRAINT [PK_SITContact] PRIMARY KEY NONCLUSTERED  ([SITContactID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SITContact] ADD CONSTRAINT [IX_SITContact_OrderFID_SITTypeFID_AgentContactFID_MilitaryCarrierContactFID] UNIQUE NONCLUSTERED  ([OrderFID], [SITTypeFID], [AgentContactFID], [MilitaryCarrierContactFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SITContact] ADD CONSTRAINT [FK_SITContact_AgentContactFID] FOREIGN KEY ([AgentContactFID]) REFERENCES [dbo].[AgentContact] ([AgentContactID])
GO
ALTER TABLE [dbo].[SITContact] ADD CONSTRAINT [FK_SITContact_MilitaryContactFID] FOREIGN KEY ([MilitaryCarrierContactFID]) REFERENCES [dbo].[MilitaryCarrierContact] ([MilitaryCarrierContactID])
GO
ALTER TABLE [dbo].[SITContact] ADD CONSTRAINT [FK_SITContact_Orders] FOREIGN KEY ([OrderFID]) REFERENCES [dbo].[Orders] ([PriKey])
GO
ALTER TABLE [dbo].[SITContact] ADD CONSTRAINT [FK_SITContact_SITType] FOREIGN KEY ([SITTypeFID]) REFERENCES [dbo].[SITType] ([SITTypeID])
GO
GRANT SELECT ON  [dbo].[SITContact] TO [MssExec]
GRANT INSERT ON  [dbo].[SITContact] TO [MssExec]
GRANT DELETE ON  [dbo].[SITContact] TO [MssExec]
GRANT UPDATE ON  [dbo].[SITContact] TO [MssExec]
GO
Uses