Tables [dbo].[AccountLocation]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:00 AM Thursday, March 21, 2019
Last Modified1:20:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_AccountLocation_LocationID: LocationIDLocationIDint4
False
1 - 1
Foreign Keys FK_AccountLocation_OnsiteInstanceID_AccountOnsiteInstance_ID: [dbo].[AccountOnsiteInstance].OnsiteInstanceIDOnsiteInstanceIDint4
False
IPv4UAddrListvarchar(max)max
True
IPv4MAddrListvarchar(max)max
True
('255.255.255.255')
IPv6UAddrListvarchar(max)max
True
IPv6MAddrListvarchar(max)max
True
('FF02::1')
FilterListvarchar(max)max
True
SnmpCommunityvarchar(1024)1024
False
('public')
RequestTimeoutsmallint2
False
((1000))
SnmpTimeoutint4
False
((1000))
HttpTimeoutint4
False
((4000))
FmaAgentTimeoutint4
False
((4000))
HostNameListvarchar(max)max
True
ModifiedDatedatetime8
True
ScheduleDataxmlmax
True
LocationUIDuniqueidentifier16
False
(newid())
LocationNamenvarchar(100)200
False
(N'Default')
IsDefaultbit1
False
((0))
DoNotScanvarchar(max)max
True
IncludeOnlyvarchar(max)max
True
Excludevarchar(max)max
True
Protocolsxmlmax
True
ScheduleInfoxmlmax
True
DeviceRetentionint4
True
ScanRatetinyint1
True
UserDataServerListvarchar(max)max
True
UserDataHourlybit1
False
((1))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_AccountLocation_LocationID: LocationIDPK_AccountLocation_LocationIDLocationID
True
NameColumns
FK_AccountLocation_OnsiteInstanceID_AccountOnsiteInstance_IDOnsiteInstanceID->[dbo].[AccountOnsiteInstance].[ID]
CREATE TABLE [dbo].[AccountLocation]
(
[LocationID] [int] NOT NULL IDENTITY(1, 1),
[OnsiteInstanceID] [int] NOT NULL,
[IPv4UAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPv4MAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_AccountLocation_IPv4MAddrList] DEFAULT ('255.255.255.255'),
[IPv6UAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPv6MAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_AccountLocation_IPv6MAddrList] DEFAULT ('FF02::1'),
[FilterList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SnmpCommunity] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AccountLocation_SnmpCommunity] DEFAULT ('public'),
[RequestTimeout] [smallint] NOT NULL CONSTRAINT [DF_AccountLocation_RequestTimeout] DEFAULT ((1000)),
[SnmpTimeout] [int] NOT NULL CONSTRAINT [DF_AccountLocation_SnmpTimeout] DEFAULT ((1000)),
[HttpTimeout] [int] NOT NULL CONSTRAINT [DF_AccountLocation_HttpTimeout] DEFAULT ((4000)),
[FmaAgentTimeout] [int] NOT NULL CONSTRAINT [DF_AccountLocation_FmaAgentTimeout] DEFAULT ((4000)),
[HostNameList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ModifiedDate] [datetime] NULL,
[ScheduleData] [xml] NULL,
[LocationUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_AccountLocation_LocationUID] DEFAULT (newid()),
[LocationName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AccountLocation_LocationName] DEFAULT (N'Default'),
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_AccountLocation_IsDefault] DEFAULT ((0)),
[DoNotScan] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IncludeOnly] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Exclude] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Protocols] [xml] NULL,
[ScheduleInfo] [xml] NULL,
[DeviceRetention] [int] NULL,
[ScanRate] [tinyint] NULL,
[UserDataServerList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDataHourly] [bit] NOT NULL CONSTRAINT [DF_AccountLocation_UserDataHourly] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountLocation] ADD CONSTRAINT [PK_AccountLocation_LocationID] PRIMARY KEY CLUSTERED  ([LocationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountLocation] ADD CONSTRAINT [FK_AccountLocation_OnsiteInstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([OnsiteInstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID])
GO