Tables [dbo].[UserDataMetric]
PropertyValue
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:40 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID: DeviceID\AuditID\UserDataUserID\UserDataApplicationID\TimeIDForeign Keys FK_UserDataMetric_DeviceID_Device_DeviceID: [dbo].[Device].DeviceIDDeviceIDint4
False
Cluster Primary Key PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID: DeviceID\AuditID\UserDataUserID\UserDataApplicationID\TimeIDForeign Keys FK_UserDataMetric_AuditID_Audit_AuditID: [dbo].[Audit].AuditIDAuditIDint4
False
Cluster Primary Key PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID: DeviceID\AuditID\UserDataUserID\UserDataApplicationID\TimeIDForeign Keys FK_UserDataMetric_UserDataUserID_UserDataUser_ID: [dbo].[UserDataUser].UserDataUserIDUserDataUserIDint4
False
Cluster Primary Key PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID: DeviceID\AuditID\UserDataUserID\UserDataApplicationID\TimeIDForeign Keys FK_UserDataMetric_UserDataApplicationID_UserDataApplication_ID: [dbo].[UserDataApplication].UserDataApplicationIDUserDataApplicationIDint4
False
Cluster Primary Key PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID: DeviceID\AuditID\UserDataUserID\UserDataApplicationID\TimeIDForeign Keys FK_UserDataMetric_TimeID_Time_ID: [dbo].[Time].TimeIDTimeIDint4
False
Jobsint4
False
Monoint4
True
Colorint4
True
Largeint4
True
Duplexint4
True
JobsMonoint4
True
JobsColorint4
True
JobsLargeint4
True
JobsDuplexint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeID: DeviceID\AuditID\UserDataUserID\UserDataApplicationID\TimeIDPK_UserDataMetric_DeviceID_AuditID_UserDataUserID_UserDataApplicationID_TimeIDDeviceID, AuditID, UserDataUserID, UserDataApplicationID, TimeID
True
NameUpdateDeleteColumns
FK_UserDataMetric_AuditID_Audit_AuditIDAuditID->[dbo].[Audit].[AuditID]
FK_UserDataMetric_DeviceID_Device_DeviceIDCascadeCascadeDeviceID->[dbo].[Device].[DeviceID]
FK_UserDataMetric_TimeID_Time_IDTimeID->[dbo].[Time].[ID]
FK_UserDataMetric_UserDataApplicationID_UserDataApplication_IDUserDataApplicationID->[dbo].[UserDataApplication].[ID]
FK_UserDataMetric_UserDataUserID_UserDataUser_IDUserDataUserID->[dbo].[UserDataUser].[ID]
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