Tables [dbo].[AccountOnsiteInstance]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:24 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_AccountOnsiteInstance_ID: IDIDint4
False
1 - 1
Foreign Keys FK_AccountOnsiteInstance_AccountID_Account_AccountID: [dbo].[Account].AccountIDAccountIDint4
False
InstanceGUIDuniqueidentifier16
False
UpdateDatedatetime8
True
LocalMACAddressvarchar(max)max
True
LocalIPAddressvarchar(max)max
True
HostNamenvarchar(256)512
True
OSNamenvarchar(256)512
True
ExternalIPAddressnvarchar(256)512
True
ExternalIPCountrynvarchar(256)512
True
ExternalIPRegionnvarchar(256)512
True
ExternalIPCitynvarchar(256)512
True
ExternalIPLatitudenvarchar(256)512
True
ExternalIPLongitudenvarchar(256)512
True
NumberOfIPsbigint8
True
IsDefaultbit1
False
((0))
InstanceNamenvarchar(256)512
True
FallbackCentralUrlvarchar(200)200
True
FallbackCentralUIDuniqueidentifier16
True
AutoUpdatebit1
False
((1))
ManageIPsLocallybit1
False
((0))
DetectRangesbit1
False
((0))
IgnoreNotReportingbit1
False
((0))
IsReadOnlybit1
False
((0))
IsDisabledbit1
False
((0))
GlobalSettingsxmlmax
True
ProxySettingsxmlmax
True
Destinationsxmlmax
True
TroubleshootingRangesxmlmax
True
TroubleshootingFoundxmlmax
True
TroubleshootingNotFoundxmlmax
True
EnableTroubleshootingbit1
False
((0))
EventLoggingLeveltinyint1
False
((1))
Deletedbit1
False
((0))
JAMCStatusvarchar(200)200
True
JAMCStatusDetailsvarchar(2000)2000
True
JAMCLastOnlinedatetime8
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_AccountOnsiteInstance_ID: IDPK_AccountOnsiteInstance_IDID
True
NameDeleteColumns
FK_AccountOnsiteInstance_AccountID_Account_AccountIDCascadeAccountID->[dbo].[Account].[AccountID]
CREATE TABLE [dbo].[AccountOnsiteInstance]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[InstanceGUID] [uniqueidentifier] NOT NULL,
[UpdateDate] [datetime] NULL,
[LocalMACAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalIPAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OSName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPAddress] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPCountry] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPRegion] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPCity] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPLatitude] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPLongitude] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumberOfIPs] [bigint] NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IsDefault] DEFAULT ((0)),
[InstanceName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FallbackCentralUrl] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FallbackCentralUID] [uniqueidentifier] NULL,
[AutoUpdate] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_AutoUpdate] DEFAULT ((1)),
[ManageIPsLocally] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_ManageIPsLocally] DEFAULT ((0)),
[DetectRanges] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_DetectRanges] DEFAULT ((0)),
[IgnoreNotReporting] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IgnoreNotReporting] DEFAULT ((0)),
[IsReadOnly] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IsReadOnly] DEFAULT ((0)),
[IsDisabled] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IsDisabled] DEFAULT ((0)),
[GlobalSettings] [xml] NULL,
[ProxySettings] [xml] NULL,
[Destinations] [xml] NULL,
[TroubleshootingRanges] [xml] NULL,
[TroubleshootingFound] [xml] NULL,
[TroubleshootingNotFound] [xml] NULL,
[EnableTroubleshooting] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_EnableTroubleshooting] DEFAULT ((0)),
[EventLoggingLevel] [tinyint] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_EventLoggingLevel] DEFAULT ((1)),
[Deleted] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_Deleted] DEFAULT ((0)),
[JAMCStatus] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JAMCStatusDetails] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JAMCLastOnline] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstance] ADD CONSTRAINT [PK_AccountOnsiteInstance_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstance] ADD CONSTRAINT [FK_AccountOnsiteInstance_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO