Tables [dbo].[AccountOnsiteInstanceLog]
PropertyValue
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 NullsIdentity
Cluster Primary Key PK_AccountOnsiteInstanceLog_ID: IDIDint4
False
1 - 1
Foreign Keys FK_AccountOnsiteInstanceLog_AccountOnsiteInstanceOperationID_AccountOnsiteInstanceOperation_OperationGUID: [dbo].[AccountOnsiteInstanceOperation].AccountOnsiteInstanceOperationIDAccountOnsiteInstanceOperationIDuniqueidentifier16
False
Foreign Keys FK_AccountOnsiteInstanceLog_AccountOnsiteInstanceID_AccountOnsiteInstance_ID: [dbo].[AccountOnsiteInstance].AccountOnsiteInstanceIDAccountOnsiteInstanceIDint4
False
StartDatedatetime8
False
EndDatedatetime8
False
Datavarbinary(max)max
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_AccountOnsiteInstanceLog_ID: IDPK_AccountOnsiteInstanceLog_IDID
True
NameDeleteColumns
FK_AccountOnsiteInstanceLog_AccountOnsiteInstanceID_AccountOnsiteInstance_IDAccountOnsiteInstanceID->[dbo].[AccountOnsiteInstance].[ID]
FK_AccountOnsiteInstanceLog_AccountOnsiteInstanceOperationID_AccountOnsiteInstanceOperation_OperationGUIDCascadeAccountOnsiteInstanceOperationID->[dbo].[AccountOnsiteInstanceOperation].[OperationGUID]
CREATE TABLE [dbo].[AccountOnsiteInstanceLog]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[AccountOnsiteInstanceOperationID] [uniqueidentifier] NOT NULL,
[AccountOnsiteInstanceID] [int] NOT NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[Data] [varbinary] (max) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceLog] ADD CONSTRAINT [PK_AccountOnsiteInstanceLog_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceLog] ADD CONSTRAINT [FK_AccountOnsiteInstanceLog_AccountOnsiteInstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([AccountOnsiteInstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID])
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceLog] ADD CONSTRAINT [FK_AccountOnsiteInstanceLog_AccountOnsiteInstanceOperationID_AccountOnsiteInstanceOperation_OperationGUID] FOREIGN KEY ([AccountOnsiteInstanceOperationID]) REFERENCES [dbo].[AccountOnsiteInstanceOperation] ([OperationGUID]) ON DELETE CASCADE
GO