Description
Events on which history is recorded.
Remarks
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.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| AU_ENTITY_TYPE_ENTITY_ID_IDX | |||
| AU_PRIMARYKEY | | | |
| AU_TIME_IDX |
Objects that depend on td.AUDIT_LOG
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | AUTR_27990060_QPM_MILESTONES | Trigger | 2 | |
| AUTR_345769792_ENVIRONMENTS | Trigger | 2 | |
| AUTR_363696399_TESTCYCL | Trigger | 2 | |
| AUTR1386687709_COMPONENT | Trigger | 2 | |
| AUTR1815529430_RESULTS | Trigger | 2 | |
| AUTR1916707492_TEST_CONFIGS | Trigger | 2 | |
| AUTR2571410_TEST | Trigger | 2 | |
| AUTR64594118_CYCLE | Trigger | 2 | |
| AUTR66132_BUG | Trigger | 2 | |
| AUTR81022_REQ | Trigger | 2 | |
| AUTR81515_RUN | Trigger | 2 | |
 | td.BUG | Table | Information about defects. | 1 |
| td.COMPONENT | Table | Business Process Components. | 1 |
| td.CYCLE | Table | Test sets. | 1 |
| td.ENVIRONMENTS | Table | Testing environments. | 1 |
| MVTR_BUG | Trigger | 2 | |
| MVTR_REQ | Trigger | 2 | |
| td.QPM_MILESTONES | Table | Significant periods for quality measurements in the context of a RELEASE. | 1 |
| td.REQ | Table | Details of individual requirements and the structure of the requirements tree. | 1 |
| td.RESULTS | Table | The results of a RUN. | 1 |
| td.RUN | Table | Execution records for test instances. | 1 |
| td.TEST | Table | Details of the design test from the test plan module. | 1 |
| td.TEST_CONFIGS | Table | The data to be used in the run of a Test. | 1 |
| td.TESTCYCL | Table | Instances of design tests in test sets. | 1 |
 | td.V_TESTSET_REQ_COVER | View | 2 |
See Also