Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| c_created | timestamp | 29,6 | √ | null |
|
|
|||||
| c_end_date | timestamp | 22 | √ | null |
|
|
|||||
| c_group_pk | int8 | 19 | √ | null |
|
|
|||||
| c_latest_due | timestamp | 22 | √ | null |
|
|
|||||
| c_occurred | timestamp | 29,6 | √ | null |
|
|
|||||
| c_ol | int8 | 19 | √ | null |
|
|
|||||
| c_pk | int8 | 19 | null |
|
|
||||||
| c_start_date | timestamp | 22 | √ | null |
|
|
|||||
| c_start_earliest_date | timestamp | 22 | √ | null |
|
|
|||||
| c_updated | timestamp | 29,6 | √ | null |
|
|
|||||
| c_message | varchar | 1024 | √ | null |
|
|
|||||
| c_created_by | varchar | 255 | √ | null |
|
|
|||||
| c_initiator | varchar | 255 | null |
|
|
||||||
| c_mode | varchar | 255 | null |
|
|
||||||
| c_no | varchar | 255 | √ | null |
|
|
|||||
| c_pid | varchar | 255 | null |
|
|
||||||
| c_priority | varchar | 255 | null |
|
|
||||||
| c_sku | varchar | 255 | √ | null |
|
|
|||||
| c_source_location | varchar | 255 | √ | null |
|
|
|||||
| c_source_location_group_name | varchar | 255 | √ | null |
|
|
|||||
| c_state | varchar | 255 | √ | null |
|
|
|||||
| c_target_location | varchar | 255 | √ | null |
|
|
|||||
| c_target_location_group_name | varchar | 255 | null |
|
|
||||||
| c_transport_unit_bk | varchar | 255 | null |
|
|
||||||
| c_type | varchar | 255 | null |
|
|
||||||
| c_updated_by | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| mvm_movement_pkey | Primary key | Asc | c_pk |
| mvm_movement_c_pid_key | Must be unique | Asc | c_pid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| mvm_movement_c_priority_check | ((c_priority)::text = ANY ((ARRAY['HIGHEST'::character varying, 'HIGH'::character varying, 'NORMAL'::character varying, 'LOW'::character varying, 'LOWEST'::character varying])::text[])) |
| mvm_movement_c_mode_check | ((c_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[])) |
| mvm_movement_c_type_check | ((c_type)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'MANUAL'::character varying, 'STOCK_CHECK'::character varying, 'INBOUND'::character varying, 'OUTBOUND'::character varying, 'CLEARING'::character varying, 'EMPTIES'::character varying, 'REPLENISHMENT'::character varying, 'RECONCILIATION'::character varying, 'RELOCATION'::character varying, 'WAREHOUSE_RELOCATION'::character varying])::text[])) |
| mvm_movement_c_state_check | ((c_state)::text = ANY ((ARRAY['INACTIVE'::character varying, 'ACTIVE'::character varying, 'CANCELLED'::character varying, 'DONE'::character varying])::text[])) |