Tables [dbo].[AccountOnsiteInstanceOperation]
PropertyValue
HeapTrue
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK_AccountOnsiteInstanceOperation_OperationGUID: OperationGUIDOperationGUIDuniqueidentifier16
False
Foreign Keys FK_AccountOnsiteInstanceOperation_AccountOnsiteInstanceID_AccountOnsiteInstance_ID: [dbo].[AccountOnsiteInstance].AccountOnsiteInstanceIDAccountOnsiteInstanceIDint4
False
Typetinyint1
False
Foreign Keys FK_AccountOnsiteInstanceOperation_ContactID_Contact_ContactID: [dbo].[Contact].ContactIDContactIDint4
True
StartTimedatetime8
False
Statustinyint1
False
RequestDataxmlmax
False
ResultDataxmlmax
True
KeyNameKey ColumnsUnique
Primary Key PK_AccountOnsiteInstanceOperation_OperationGUID: OperationGUIDPK_AccountOnsiteInstanceOperation_OperationGUIDOperationGUID
True
NameDeleteColumns
FK_AccountOnsiteInstanceOperation_AccountOnsiteInstanceID_AccountOnsiteInstance_IDCascadeAccountOnsiteInstanceID->[dbo].[AccountOnsiteInstance].[ID]
FK_AccountOnsiteInstanceOperation_ContactID_Contact_ContactIDContactID->[dbo].[Contact].[ContactID]
CREATE TABLE [dbo].[AccountOnsiteInstanceOperation]
(
[OperationGUID] [uniqueidentifier] NOT NULL,
[AccountOnsiteInstanceID] [int] NOT NULL,
[Type] [tinyint] NOT NULL,
[ContactID] [int] NULL,
[StartTime] [datetime] NOT NULL,
[Status] [tinyint] NOT NULL,
[RequestData] [xml] NOT NULL,
[ResultData] [xml] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceOperation] ADD CONSTRAINT [PK_AccountOnsiteInstanceOperation_OperationGUID] PRIMARY KEY NONCLUSTERED  ([OperationGUID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceOperation] ADD CONSTRAINT [FK_AccountOnsiteInstanceOperation_AccountOnsiteInstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([AccountOnsiteInstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceOperation] ADD CONSTRAINT [FK_AccountOnsiteInstanceOperation_ContactID_Contact_ContactID] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO