Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| accession_id | int8 | 19 | null |
|
|
|||||
| updated_time | timestamptz | 35,6 | null |
|
|
|||||
| old_state_id | int4 | 10 | √ | null |
|
|
Null if this is the initial state for a new accession. |
|||
| new_state_id | int4 | 10 | null |
|
|
|||||
| reason | text | 2147483647 | null |
|
|
|||||
| updated_by | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| accession_state_history_accession_id_idx | Performance | Asc | accession_id |
| accession_state_history_new_state_id_updated_time_idx | Performance | Asc/Asc | new_state_id + updated_time |