CREATE TABLE [dbo].[AccountOnsiteInstanceMibWalk]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[AccountOnsiteInstanceOperationID] [uniqueidentifier] NOT NULL,
[AccountOnsiteInstanceID] [int] NOT NULL,
[RequestDate] [datetime] NOT NULL,
[Device] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Details] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Data] [varbinary] (max) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceMibWalk] ADD CONSTRAINT [PK_AccountOnsiteInstanceMibWalk_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceMibWalk] ADD CONSTRAINT [FK_AccountOnsiteInstanceMibWalk_AccountOnsiteInstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([AccountOnsiteInstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID])
GO
ALTER TABLE [dbo].[AccountOnsiteInstanceMibWalk] ADD CONSTRAINT [FK_AccountOnsiteInstanceMibWalk_AccountOnsiteInstanceOperationID_AccountOnsiteInstanceOperation_OperationGUID] FOREIGN KEY ([AccountOnsiteInstanceOperationID]) REFERENCES [dbo].[AccountOnsiteInstanceOperation] ([OperationGUID]) ON DELETE CASCADE
GO