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