Tables Involved in Audit

To perform audit for events, you must store details pertaining to the events and handlers in the following tables.

Table Name

Description

EVENT MASTER

It contains all the registered events and their properties.

EVENT HANDLER MAP

In this table, the handlers IDs are mapped to the event IDs.

EVENT HANDLER MASTER

This table contains the list of handlers.

AUDIT MASTER

In this table, the Audit IDs are mapped to the event IDs.

AUDIT DATA MASTER

This table contains the properties (fields that will be captured for auditing) of the audit IDs.


The relationships between the tables are as follows: