CREATE TABLE [dbo].[PrinterAudit]
(
[PrinterAuditID] [int] NOT NULL IDENTITY(1, 1),
[PrinterIPAddr] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manufacturer] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterLocation] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterAssetNr] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PageCountTotal] [int] NULL,
[PageCountMono] [int] NULL,
[PageCountColor] [int] NULL,
[PageCountPrinter] [int] NULL,
[PageCountFax] [int] NULL,
[PageCountCopy] [int] NULL,
[PageCountList] [int] NULL,
[ScanCountTotal] [int] NULL,
[ScanCountFax] [int] NULL,
[ScanCountCopy] [int] NULL,
[ScanCountNet] [int] NULL,
[ScanCountEmail] [int] NULL,
[CovSumBlack] [float] NULL,
[CovSumCyan] [float] NULL,
[CovSumMagenta] [float] NULL,
[CovSumYellow] [float] NULL,
[CovSqSumBlack] [float] NULL,
[CovSqSumCyan] [float] NULL,
[CovSqSumMagenta] [float] NULL,
[CovSqSumYellow] [float] NULL,
[AuditID] [int] NOT NULL,
[MacAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceID] [int] NULL,
[PageCountPrinterMono] [int] NULL,
[PageCountPrinterColor] [int] NULL,
[PageCountCopyMono] [int] NULL,
[PageCountCopyColor] [int] NULL,
[ScanCountCopyMono] [int] NULL,
[ScanCountCopyColor] [int] NULL,
[HostName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceContact] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstalledMemory] [int] NULL,
[FirmwareVersion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstallationDate] [datetime] NULL,
[SheetCountTotal] [int] NULL,
[PageCountTotalUsage] [float] NULL,
[ScanCountTotalUsage] [float] NULL,
[FaxCountSend] [int] NULL,
[FaxCountReceive] [int] NULL,
[CovAverageBlack] [float] NULL,
[CovAverageCyan] [float] NULL,
[CovAverageMagenta] [float] NULL,
[CovAverageYellow] [float] NULL,
[PageCountMonoUsage] [float] NULL,
[PageCountColorUsage] [float] NULL,
[PageCountColorUsageProf] [float] NULL,
[PageCountColorUsageProfAccent] [float] NULL,
[PageCountColorUsageOffice] [float] NULL,
[PageCountColorUsageOfficeAccent] [float] NULL,
[PageCountXeroxBLevel1] [int] NULL,
[PageCountXeroxLevel2] [int] NULL,
[PageCountXeroxLevel3] [int] NULL,
[PageCountFaxMono] [int] NULL,
[PageCountFaxColor] [int] NULL,
[StapleCount] [int] NULL,
[ScanCountColor] [int] NULL,
[ScanCountMono] [int] NULL,
[TabloidCountTotal] [int] NULL,
[TabloidCountMono] [int] NULL,
[TabloidCountColor] [int] NULL,
[TabloidSheetCountTotal] [int] NULL,
[ContinuousSquareFeet] [float] NULL,
[ContinuousSquareMeters] [float] NULL,
[DoubleClickTotal] [int] NULL,
[DoubleClickMono] [int] NULL,
[DoubleClickColor] [int] NULL,
[DoubleClickFullColor] [int] NULL,
[DoubleClickTwoColor] [int] NULL,
[DoubleClickSingleColor] [int] NULL,
[DoubleClickDuplex] [int] NULL,
[DevelopmentTotal] [int] NULL,
[DevelopmentMono] [int] NULL,
[DevelopmentColor] [int] NULL,
[CopyPagesFullColor] [int] NULL,
[CopyPagesTwoColor] [int] NULL,
[CopyPagesSingleColor] [int] NULL,
[OtherPages] [int] NULL,
[OtherPagesMono] [int] NULL,
[OtherPagesColor] [int] NULL,
[OtherPagesFullColor] [int] NULL,
[OtherPagesTwoColor] [int] NULL,
[OtherPagesSingleColor] [int] NULL,
[ScansUsageMono] [float] NULL,
[ScansUsageColor] [float] NULL,
[ScansFaxMono] [int] NULL,
[ScansFaxColor] [int] NULL,
[ScansEmailMono] [int] NULL,
[ScansEmailColor] [int] NULL,
[ScansNetMono] [int] NULL,
[ScansNetColor] [int] NULL,
[TotalPagesFullColor] [int] NULL,
[TotalPagesTwoColor] [int] NULL,
[TotalPagesSingleColor] [int] NULL,
[UsagePagesFullColor] [float] NULL,
[UsagePagesTwoColor] [float] NULL,
[UsagePagesSingleColor] [float] NULL,
[PrinterPagesFullColor] [int] NULL,
[PrinterPagesTwoColor] [int] NULL,
[PrinterPagesSingleColor] [int] NULL,
[LargePagesFullColor] [int] NULL,
[LargePagesTwoColor] [int] NULL,
[LargePagesSingleColor] [int] NULL,
[LinearFeet] [float] NULL,
[MeterSource] [tinyint] NOT NULL CONSTRAINT [DF_PrinterAudit_MeterSource] DEFAULT ((0)),
[UsagePagesAccent] [float] NULL,
[PageCountAccentUsagePres] [float] NULL,
[PageCountColorUsagePres] [float] NULL,
[PageCountAccentUsageMax] [float] NULL,
[PageCountColorUsageMax] [float] NULL,
[TotalImpressions] [float] NULL,
[TotalImpressionsMono] [float] NULL,
[TotalImpressionsColor] [float] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PrinterAudit] ADD CONSTRAINT [PK_PrinterAudit_PrinterAuditID] PRIMARY KEY CLUSTERED ([PrinterAuditID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PrinterAudit] ADD CONSTRAINT [FK_PrinterAudit_AuditID_Audit_AuditID] FOREIGN KEY ([AuditID]) REFERENCES [dbo].[Audit] ([AuditID])
GO
ALTER TABLE [dbo].[PrinterAudit] ADD CONSTRAINT [FK_PrinterAudit_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID])
GO