|
Quality Center Database |
|
|
Quality Center Database |
Events on which history is recorded.
Details of the changes caused by the audited events are in the AUDIT_PROPERTIES Table.
| Column Name | Description | Datatype | Length | Allow Nulls |
|
|---|---|---|---|---|---|
 |
AU_ACTION_ID | The record ID. | Integer | 4 | |
| AU_FATHER_ID | For backward compatibility. Field may be removed in future version. | Integer | 4 | ||
| AU_USER | The user name of the user who performed the action. | VarChar | 2000 | ||
| AU_SESSION_ID | The Quality Center session ID of the session in which the action was performed. | Integer | 4 | ||
| AU_TIME | The timestamp of the audit record according to the database server clock. | DBTimeStamp | 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. | LongVarChar | 16 |
|
| Index | Primary | Unique |
|---|---|---|
| AU_PRIMARYKEY |
|
|
| AU_ENTITY_TYPE_ENTITY_ID_IDX |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |