Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| c_locked | bool | 1 | √ | null |
|
|
|||||
| c_position_no | int4 | 10 | null |
|
|
||||||
| c_priority | int4 | 10 | √ | null |
|
|
|||||
| c_problem_message_no | int4 | 10 | √ | null |
|
|
|||||
| c_created | timestamp | 29,6 | √ | null |
|
|
|||||
| c_latest_due | timestamptz | 35,6 | √ | null |
|
|
|||||
| c_next_allocation | timestamptz | 35,6 | √ | null |
|
|
|||||
| c_ol | int8 | 19 | √ | null |
|
|
|||||
| c_order_pk | int8 | 19 | null |
|
|
||||||
| c_pk | int8 | 19 | null |
|
|
||||||
| c_problem_occurred | timestamp | 29,6 | √ | null |
|
|
|||||
| c_product_pk | int8 | 19 | null |
|
|
||||||
| c_start_earliest | timestamptz | 35,6 | √ | null |
|
|
|||||
| c_updated | timestamp | 29,6 | √ | null |
|
|
|||||
| c_qty_alloc | varchar | 16 | √ | null |
|
|
|||||
| c_qty_crossdock | varchar | 16 | √ | null |
|
|
|||||
| c_qty_ordered | varchar | 16 | null |
|
|
||||||
| c_source_location_groups | varchar | 1024 | √ | null |
|
|
|||||
| c_created_by | varchar | 255 | √ | null |
|
|
|||||
| c_order_state | varchar | 255 | null |
|
|
||||||
| c_pid | varchar | 255 | null |
|
|
||||||
| c_problem_message | varchar | 255 | √ | null |
|
|
|||||
| c_qty_type_alloc | varchar | 255 | √ | null |
|
|
|||||
| c_qty_type_crossdock | varchar | 255 | √ | null |
|
|
|||||
| c_qty_type_ordered | varchar | 255 | null |
|
|
||||||
| c_target_name | varchar | 255 | √ | null |
|
|
|||||
| c_target_type | varchar | 255 | √ | null |
|
|
|||||
| c_to_start_mode | varchar | 255 | null |
|
|
||||||
| c_updated_by | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| wms_shp_order_position_pkey | Primary key | Asc | c_pk |
| uc_shp_order_id_pos | Must be unique | Asc/Asc | c_order_pk + c_position_no |
| wms_shp_order_position_c_pid_key | Must be unique | Asc | c_pid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| wms_shp_order_position_c_order_state_check | ((c_order_state)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'CREATED'::character varying, 'AVAILABLE'::character varying, 'PROCESSING'::character varying, 'PROCESSED'::character varying, 'COMMISSIONING'::character varying, 'FAILURE_WMS'::character varying, 'FAILURE_TMS'::character varying, 'COMPLETED'::character varying, 'ON_TRUCK'::character varying, 'SHIPPED'::character varying])::text[])) |
| wms_shp_order_position_c_to_start_mode_check | ((c_to_start_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[])) |