Tables [dbo].[AccountOnsiteInstanceMibWalk]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
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_AccountOnsiteInstanceMibWalk_ID: IDIDint4
False
1 - 1
Foreign Keys FK_AccountOnsiteInstanceMibWalk_AccountOnsiteInstanceOperationID_AccountOnsiteInstanceOperation_OperationGUID: [dbo].[AccountOnsiteInstanceOperation].AccountOnsiteInstanceOperationIDAccountOnsiteInstanceOperationIDuniqueidentifier16
False
Foreign Keys FK_AccountOnsiteInstanceMibWalk_AccountOnsiteInstanceID_AccountOnsiteInstance_ID: [dbo].[AccountOnsiteInstance].AccountOnsiteInstanceIDAccountOnsiteInstanceIDint4
False
RequestDatedatetime8
False
Devicenvarchar(250)500
True
Detailsnvarchar(max)max
True
Datavarbinary(max)max
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_AccountOnsiteInstanceMibWalk_ID: IDPK_AccountOnsiteInstanceMibWalk_IDID
True
NameDeleteColumns
FK_AccountOnsiteInstanceMibWalk_AccountOnsiteInstanceID_AccountOnsiteInstance_IDAccountOnsiteInstanceID->[dbo].[AccountOnsiteInstance].[ID]
FK_AccountOnsiteInstanceMibWalk_AccountOnsiteInstanceOperationID_AccountOnsiteInstanceOperation_OperationGUIDCascadeAccountOnsiteInstanceOperationID->[dbo].[AccountOnsiteInstanceOperation].[OperationGUID]
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