CREATE TABLE [dbo].[UserDataMetric]
(
[DeviceID] [int] NOT NULL,
[AuditID] [int] NOT NULL,
[UserDataUserID] [int] NOT NULL,
[UserDataApplicationID] [int] NOT NULL,
[TimeID] [int] NOT NULL,
[Jobs] [int] NOT NULL,
[Mono] [int] NULL,
[Color] [int] NULL,
[Large] [int] NULL,
[Duplex] [int] NULL,
[JobsMono] [int] NULL,
[JobsColor] [int] NULL,
[JobsLarge] [int] NULL,
[JobsDuplex] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDataMetric] ADD CONSTRAINT [PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID] PRIMARY KEY CLUSTERED ([DeviceID], [AuditID], [UserDataUserID], [UserDataApplicationID], [TimeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDataMetric] ADD CONSTRAINT [FK_UserDataMetric_AuditID_Audit_AuditID] FOREIGN KEY ([AuditID]) REFERENCES [dbo].[Audit] ([AuditID])
GO
ALTER TABLE [dbo].[UserDataMetric] ADD CONSTRAINT [FK_UserDataMetric_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[UserDataMetric] ADD CONSTRAINT [FK_UserDataMetric_TimeID_Time_ID] FOREIGN KEY ([TimeID]) REFERENCES [dbo].[Time] ([ID])
GO
ALTER TABLE [dbo].[UserDataMetric] ADD CONSTRAINT [FK_UserDataMetric_UserDataApplicationID_UserDataApplication_ID] FOREIGN KEY ([UserDataApplicationID]) REFERENCES [dbo].[UserDataApplication] ([ID])
GO
ALTER TABLE [dbo].[UserDataMetric] ADD CONSTRAINT [FK_UserDataMetric_UserDataUserID_UserDataUser_ID] FOREIGN KEY ([UserDataUserID]) REFERENCES [dbo].[UserDataUser] ([ID])
GO