Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| audit_id | int8 | 19 | null |
|
|
|||
| audit_time | timestamptz | 35,6 | null |
|
|
|||
| audit_action | text | 2147483647 | null |
|
|
|||
| audit_user | int4 | 10 | √ | null |
|
|
||
| audit_ws | int4 | 10 | √ | null |
|
|
||
| id | int8 | 19 | null |
|
|
|||
| creator | int8 | 19 | null |
|
|
|||
| create_date | timestamptz | 35,6 | √ | null |
|
|
||
| editor | int8 | 19 | null |
|
|
|||
| edit_date | timestamptz | 35,6 | √ | null |
|
|
||
| record | int8 | 19 | null |
|
|
|||
| owning_lib | int4 | 10 | null |
|
|
|||
| label | text | 2147483647 | null |
|
|
|||
| deleted | bool | 1 | null |
|
|
|||
| prefix | int4 | 10 | null |
|
|
|||
| suffix | int4 | 10 | null |
|
|
|||
| label_class | int8 | 19 | null |
|
|
|||
| label_sortkey | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| asset_call_number_history_pkey | Primary key | Asc | audit_id |
| aud_asset_cn_hist_creator_idx | Performance | Asc | creator |
| aud_asset_cn_hist_editor_idx | Performance | Asc | editor |
Relationships
Close relationships within degrees of separation
