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