CREATE TABLE [dbo].[HARAUDITEVENTRESOURCEL2]
(
[AUDITEVENTOBJID] [int] NOT NULL,
[RESOURCEOBJID] [int] NULL,
[RESOURCENAME] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RESOURCETYPEOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAUDITEVENTRESOURCEL2] ADD CONSTRAINT [HARAUDITEVENTRESOURCEL2_PK] PRIMARY KEY CLUSTERED ([AUDITEVENTOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAUDITEVENTRSRCL2_RESID_IND] ON [dbo].[HARAUDITEVENTRESOURCEL2] ([RESOURCEOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAUDITEVENTRSRCL2_RTID_IND] ON [dbo].[HARAUDITEVENTRESOURCEL2] ([RESOURCETYPEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAUDITEVENTRESOURCEL2] ADD CONSTRAINT [HARAUDITEVENTRSRCL2_AUDID_FK] FOREIGN KEY ([AUDITEVENTOBJID]) REFERENCES [dbo].[HARAUDITEVENT] ([AUDITEVENTOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARAUDITEVENTRESOURCEL2] ADD CONSTRAINT [HARAUDITEVENTRSRCL2_RTID_FK] FOREIGN KEY ([RESOURCETYPEOBJID]) REFERENCES [dbo].[HARRESOURCETYPE] ([RESOURCETYPEOBJID])
GO
EXEC sp_addextendedproperty N'Caption', N'The HARAUDITEVENTRESOURCEL2 table stores the resource information for the second level (or second top-most) ancestor resource associated with an audit log event. ', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTRESOURCEL2', 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'HARAUDITEVENTRESOURCEL2', 'COLUMN', N'AUDITEVENTOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the second-level resource affected by the auditable action', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTRESOURCEL2', 'COLUMN', N'RESOURCENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the CA SCM object which is operated on by the auditable action. Depending on the action, this identifier is a reference to the CA SCM tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.  Note: The broker object identifier always has identifier 1.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTRESOURCEL2', 'COLUMN', N'RESOURCEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the resource type associated with the second-level ancestor associated with the resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENTRESOURCEL2', 'COLUMN', N'RESOURCETYPEOBJID'
GO