[dbo].[HARAUDITEVENTDESCRIPTION]
CREATE TABLE [dbo].[HARAUDITEVENTDESCRIPTION]
(
[AUDITEVENTOBJID] [int] NOT NULL,
[EVENTDESCRIPTION] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAUDITEVENTDESCRIPTION] ADD CONSTRAINT [HARAUDITEVENTDESCRIPTION_PK] PRIMARY KEY CLUSTERED ([AUDITEVENTOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAUDITEVENTDESCRIPTION] ADD CONSTRAINT [HARAUDITEVENTDESC_AUDID_FK] FOREIGN KEY ([AUDITEVENTOBJID]) REFERENCES [dbo].[HARAUDITEVENT] ([AUDITEVENTOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARAUDITEVENTDESCRIPTION table stores the description field for the auditable action recorded by the audit system. ', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTDESCRIPTION', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Sequence Object ID identifying the audit log entry for a particular audit action. This column identifies a record in the HARAUDITEVENT tables.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTDESCRIPTION', 'COLUMN', N'AUDITEVENTOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'This column is a textual description of the audit log event. This column is for future use.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTDESCRIPTION', 'COLUMN', N'EVENTDESCRIPTION'
GO
![Foreign Keys HARAUDITEVENTDESC_AUDID_FK: [dbo].[HARAUDITEVENT].AUDITEVENTOBJID](../../Images/fk.gif)
