Tables [dbo].[Audit]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:39 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_Audit_AuditID: AuditIDAuditIDint4
False
1 - 1
Foreign Keys FK_Audit_AccountID_Account_AccountID: [dbo].[Account].AccountIDAccountIDint4
False
AuditDatedatetime8
False
Descriptionnvarchar(64)128
True
Sourcevarchar(32)32
False
Foreign Keys FK_Audit_ContactID_Contact_ContactID: [dbo].[Contact].ContactIDContactIDint4
True
UserIPAddrvarchar(64)64
True
SourceVersionvarchar(32)32
True
ExpectedNextSyncdatetime8
True
TaskTypesmallint2
True
RetentionPoliciesHashCodeint4
True
Foreign Keys FK_Audit_LocationID_AccountLocation_LocationID: [dbo].[AccountLocation].LocationIDLocationIDint4
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Audit_AuditID: AuditIDPK_Audit_AuditIDAuditID
True
NameDeleteColumns
FK_Audit_AccountID_Account_AccountIDCascadeAccountID->[dbo].[Account].[AccountID]
FK_Audit_ContactID_Contact_ContactIDContactID->[dbo].[Contact].[ContactID]
FK_Audit_LocationID_AccountLocation_LocationIDLocationID->[dbo].[AccountLocation].[LocationID]
CREATE TABLE [dbo].[Audit]
(
[AuditID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[AuditDate] [datetime] NOT NULL,
[Description] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Source] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContactID] [int] NULL,
[UserIPAddr] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceVersion] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExpectedNextSync] [datetime] NULL,
[TaskType] [smallint] NULL,
[RetentionPoliciesHashCode] [int] NULL,
[LocationID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [PK_Audit_AuditID] PRIMARY KEY CLUSTERED  ([AuditID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [FK_Audit_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [FK_Audit_ContactID_Contact_ContactID] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [FK_Audit_LocationID_AccountLocation_LocationID] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[AccountLocation] ([LocationID])
GO