Tables [dbo].[UserDataAudit]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:38 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_UserDataAudit_AuditID: AuditIDForeign Keys FK_UserDataAudit_AuditID_Audit_AuditID: [dbo].[Audit].AuditIDAuditIDint4
False
Sourcevarchar(32)32
False
Devicesint4
False
Workstationsint4
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_UserDataAudit_AuditID: AuditIDPK_UserDataAudit_AuditIDAuditID
True
NameUpdateDeleteColumns
FK_UserDataAudit_AuditID_Audit_AuditIDCascadeCascadeAuditID->[dbo].[Audit].[AuditID]
CREATE TABLE [dbo].[UserDataAudit]
(
[AuditID] [int] NOT NULL,
[Source] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Devices] [int] NOT NULL,
[Workstations] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDataAudit] ADD CONSTRAINT [PK_UserDataAudit_AuditID] PRIMARY KEY CLUSTERED  ([AuditID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDataAudit] ADD CONSTRAINT [FK_UserDataAudit_AuditID_Audit_AuditID] FOREIGN KEY ([AuditID]) REFERENCES [dbo].[Audit] ([AuditID]) ON DELETE CASCADE ON UPDATE CASCADE
GO