Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| application_id | int4 | 10 | √ | null |
|
|
Application Id. |
|
| created_at | timestamptz | 35,6 | √ | null |
|
|
Timestamp of the operation recorded. |
|
| op | "audit"."operation" | 2147483647 | √ | null |
|
|
Type of operation: INSERT/UPDATE/DELETE/TRUNCATE/SNAPSHOT. |
|
| table_name | name | 2147483647 | √ | null |
|
|
Table name. |
|
| record_id | uuid | 2147483647 | √ | null |
|
|
Identifier that uniquely identifies a record by primary key primary key + table_oid. |
|
| record | jsonb | 2147483647 | √ | null |
|
|
New record in Json format. |
|
| old_record | jsonb | 2147483647 | √ | null |
|
|
Old record in Json format. |
|
| item | varchar | 2147483647 | √ | null |
|
|
Main object affected by the operation (i.e. status, or file name or RFI type). |
|
| family_name | varchar | 2147483647 | √ | null |
|
|
First Name of the user who performed the operation. |
|
| given_name | varchar | 2147483647 | √ | null |
|
|
Last Name of the user who performed the operation. |
|
| session_sub | varchar | 2147483647 | √ | null |
|
|
Session sub of the user who performed the operation. |
|
| external_analyst | bool | 1 | √ | null |
|
|
User is an external analyst |
|
| created_by | int4 | 10 | √ | null |
|
|
User id that triggered this operation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| history_item_index | Performance | Asc | application_id |
Relationships
Close relationships within degrees of separation
