Events on which history is recorded.
Details of the changes caused by the audited events are in the AUDIT_PROPERTIES Table.
The AUDIT_LOG and AUDIT_PROPERTIES tables replace the HISTORY table, which no longer exists.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | AU_ACTION_ID | The record ID. | int | 4 | ||
AU_FATHER_ID | For backward compatibility. Field may be removed in future version. | int | 4 | |||
AU_USER | The user name of the user who performed the action. | varchar | 2000 | |||
AU_SESSION_ID | The ALM session ID of the session in which the action was performed. | int | 4 | |||
AU_TIME | The timestamp of the audit record according to the database server clock. | datetime | 4 | |||
AU_ACTION | The type of event. For example: INSERT, UPDATE, DELETE, and so on. | varchar | 200 | |||
AU_ENTITY_TYPE | The name of the table in which the change occurred. | varchar | 200 | |||
AU_ENTITY_ID | The record ID of the changed record in the table specified by AU_ENTITY_TYPE. | varchar | 200 | ![]() | ||
AU_DESCRIPTION | The audit record description. | varchar | 16 | ![]() |