Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c_acknowledged | bool | 1 | √ | null |
|
|
||||||||
| c_height | int4 | 10 | √ | null |
|
|
||||||||
| c_length | int4 | 10 | √ | null |
|
|
||||||||
| c_width | int4 | 10 | √ | null |
|
|
||||||||
| c_actual_location | int8 | 19 | null |
|
|
|||||||||
| c_actual_location_date | timestamp | 29,6 | √ | null |
|
|
||||||||
| c_created | timestamp | 29,6 | √ | null |
|
|
||||||||
| c_ol | int8 | 19 | √ | null |
|
|
||||||||
| c_pk | int8 | 19 | null |
|
|
|||||||||
| c_reconciled_at | timestamp | 22 | √ | null |
|
|
||||||||
| c_updated | timestamp | 29,6 | √ | null |
|
|
||||||||
| c_created_by | varchar | 255 | √ | null |
|
|
||||||||
| c_customer_order_id | varchar | 255 | √ | null |
|
|
||||||||
| c_foreign_pid | varchar | 255 | √ | null |
|
|
||||||||
| c_pid | varchar | 255 | null |
|
|
|||||||||
| c_reconciled_by | varchar | 255 | √ | null |
|
|
||||||||
| c_state | varchar | 255 | √ | null |
|
|
||||||||
| c_target | varchar | 255 | √ | null |
|
|
||||||||
| c_transport_unit_bk | varchar | 255 | null |
|
|
|||||||||
| c_transport_unit_type | varchar | 255 | null |
|
|
|||||||||
| c_updated_by | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| wms_inv_transport_unit_pkey | Primary key | Asc | c_pk |
| uc_inv_tu_barcode | Must be unique | Asc | c_transport_unit_bk |
| uc_inv_tu_foreign_pid | Must be unique | Asc | c_foreign_pid |
| wms_inv_transport_unit_c_pid_key | Must be unique | Asc | c_pid |