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: