Tables [dbo].[ServiceData]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:28 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ServiceData_AuditID_DeviceID: AuditID\DeviceIDForeign Keys FK_ServiceData_AuditID_Audit_AuditID: [dbo].[Audit].AuditIDAuditIDint4
False
Cluster Primary Key PK_ServiceData_AuditID_DeviceID: AuditID\DeviceIDForeign Keys FK_ServiceData_DeviceID_Device_DeviceID: [dbo].[Device].DeviceIDDeviceIDint4
False
PrinterStatusint4
True
PrinterErrornvarchar(64)128
True
PrinterErrorDecodedint4
True
ConsoleMessagenvarchar(250)500
True
PageCountTotalint4
True
PageCountMonoint4
True
PageCountColorint4
True
AlertAllEventsint4
True
AlertCriticalEventsint4
True
AlertSysUpTimedatetime8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ServiceData_AuditID_DeviceID: AuditID\DeviceIDPK_ServiceData_AuditID_DeviceIDAuditID, DeviceID
True
80
NameNo CheckColumns
FK_ServiceData_AuditID_Audit_AuditID
True
AuditID->[dbo].[Audit].[AuditID]
FK_ServiceData_DeviceID_Device_DeviceID
True
DeviceID->[dbo].[Device].[DeviceID]
CREATE TABLE [dbo].[ServiceData]
(
[AuditID] [int] NOT NULL,
[DeviceID] [int] NOT NULL,
[PrinterStatus] [int] NULL,
[PrinterError] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterErrorDecoded] [int] NULL,
[ConsoleMessage] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PageCountTotal] [int] NULL,
[PageCountMono] [int] NULL,
[PageCountColor] [int] NULL,
[AlertAllEvents] [int] NULL,
[AlertCriticalEvents] [int] NULL,
[AlertSysUpTime] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServiceData] ADD CONSTRAINT [PK_ServiceData_AuditID_DeviceID] PRIMARY KEY CLUSTERED  ([AuditID], [DeviceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServiceData] WITH NOCHECK ADD CONSTRAINT [FK_ServiceData_AuditID_Audit_AuditID] FOREIGN KEY ([AuditID]) REFERENCES [dbo].[Audit] ([AuditID])
GO
ALTER TABLE [dbo].[ServiceData] WITH NOCHECK ADD CONSTRAINT [FK_ServiceData_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID])
GO
  • [dbo].[fmav_LargestAccounts]