Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| batch_details_history_id | int8 | 19 | null |
|
|
|||||
| sub_location_id | int8 | 19 | null |
|
|
|||||
| sub_location_name | text | 2147483647 | null |
|
|
Name of sub-location as of the time the batch was edited. Not updated if sub-location is later renamed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| batch_details_history_sub_locations_pkey | Primary key | Asc/Asc | batch_details_history_id + sub_location_id |
| batch_details_history_sub_locations_sub_location_id_idx | Performance | Asc | sub_location_id |