Tables [dbo].[DashboardDevicesAndPages]
PropertyValue
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:13 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_DashboardDevicesAndPages_AccountID: AccountIDForeign Keys FK_DashboardDevicesAndPages_AccountID_Account_AccountID: [dbo].[Account].AccountIDAccountIDint4
False
ManagedDevicesbigint8
False
((0))
NonManagedDevicesbigint8
False
((0))
ManagedPagesbigint8
False
((0))
NonManagedPagesbigint8
False
((0))
MonoDevicesbigint8
False
((0))
ColorDevicesbigint8
False
((0))
MonoPagesbigint8
False
((0))
ColorPagesbigint8
False
((0))
NetworkDevicesbigint8
False
((0))
LocalDevicesbigint8
False
((0))
NetworkPagesbigint8
False
((0))
LocalPagesbigint8
False
((0))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DashboardDevicesAndPages_AccountID: AccountIDPK_DashboardDevicesAndPages_AccountIDAccountID
True
NameUpdateDeleteColumns
FK_DashboardDevicesAndPages_AccountID_Account_AccountIDCascadeCascadeAccountID->[dbo].[Account].[AccountID]
CREATE TABLE [dbo].[DashboardDevicesAndPages]
(
[AccountID] [int] NOT NULL,
[ManagedDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ManagedDevices] DEFAULT ((0)),
[NonManagedDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NonManagedDevices] DEFAULT ((0)),
[ManagedPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ManagedPages] DEFAULT ((0)),
[NonManagedPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NonManagedPages] DEFAULT ((0)),
[MonoDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_MonoDevices] DEFAULT ((0)),
[ColorDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ColorDevices] DEFAULT ((0)),
[MonoPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_MonoPages] DEFAULT ((0)),
[ColorPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ColorPages] DEFAULT ((0)),
[NetworkDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NetworkDevices] DEFAULT ((0)),
[LocalDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_LocalDevices] DEFAULT ((0)),
[NetworkPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NetworkPages] DEFAULT ((0)),
[LocalPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_LocalPages] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardDevicesAndPages] ADD CONSTRAINT [PK_DashboardDevicesAndPages_AccountID] PRIMARY KEY CLUSTERED  ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardDevicesAndPages] ADD CONSTRAINT [FK_DashboardDevicesAndPages_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE ON UPDATE CASCADE
GO