Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| c_pos_no | int4 | 10 | null |
|
|
||||||
| c_created | timestamp | 29,6 | √ | null |
|
|
|||||
| c_latest_due | timestamptz | 35,6 | √ | null |
|
|
|||||
| c_ol | int8 | 19 | √ | null |
|
|
|||||
| c_pk | int8 | 19 | null |
|
|
||||||
| c_updated | timestamp | 29,6 | √ | null |
|
|
|||||
| c_qty_expected | varchar | 16 | null |
|
|
||||||
| c_qty_received | varchar | 16 | √ | null |
|
|
|||||
| c_created_by | varchar | 255 | √ | null |
|
|
|||||
| c_expected_receipt_at | varchar | 255 | √ | null |
|
|
|||||
| c_order_id | varchar | 255 | null |
|
|
||||||
| c_qty_expected_type | varchar | 255 | null |
|
|
||||||
| c_qty_received_type | varchar | 255 | √ | null |
|
|
|||||
| c_sku | varchar | 255 | null |
|
|
||||||
| c_state | varchar | 255 | null |
|
|
||||||
| c_updated_by | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| wms_rec_order_pos_product_pkey | Primary key | Asc | c_pk |
| uc_order_id_pos | Must be unique | Asc/Asc | c_order_id + c_pos_no |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| wms_rec_order_pos_product_c_state_check | ((c_state)::text = ANY ((ARRAY['CREATED'::character varying, 'PROCESSING'::character varying, 'CANCELED'::character varying, 'PARTIALLY_COMPLETED'::character varying, 'COMPLETED'::character varying])::text[])) |