Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| c_height | int4 | 10 | √ | null |
|
|
|||||
| c_length | int4 | 10 | √ | null |
|
|
|||||
| c_overbooking_allowed | bool | 1 | √ | null |
|
|
|||||
| c_rev_type | int2 | 5 | √ | null |
|
|
|||||
| c_width | int4 | 10 | √ | null |
|
|
|||||
| c_created | timestamp | 29,6 | √ | null |
|
|
|||||
| c_pk | int8 | 19 | null |
|
|
||||||
| c_preferable_storage_location | int8 | 19 | √ | null |
|
|
|||||
| c_rev | int8 | 19 | null |
|
|
||||||
| c_updated | timestamp | 29,6 | √ | null |
|
|
|||||
| c_weight | varchar | 16 | √ | null |
|
|
|||||
| c_account | varchar | 255 | √ | null |
|
|
|||||
| c_av_state | varchar | 255 | √ | null |
|
|
|||||
| c_base_unit_qty | varchar | 255 | √ | null |
|
|
|||||
| c_base_unit_type | varchar | 255 | √ | null |
|
|
|||||
| c_classification | varchar | 255 | √ | null |
|
|
|||||
| c_created_by | varchar | 255 | √ | null |
|
|
|||||
| c_description | varchar | 255 | √ | null |
|
|
|||||
| c_description_text | varchar | 255 | √ | null |
|
|
|||||
| c_group | varchar | 255 | √ | null |
|
|
|||||
| c_label | varchar | 255 | √ | null |
|
|
|||||
| c_pid | varchar | 255 | √ | null |
|
|
|||||
| c_sku | varchar | 255 | √ | null |
|
|
|||||
| c_stock_zone | varchar | 255 | √ | null |
|
|
|||||
| c_uom | varchar | 255 | √ | null |
|
|
|||||
| c_updated_by | varchar | 255 | √ | null |
|
|
|||||
| c_weight_type | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| wms_inv_product_log_pkey | Primary key | Asc/Asc | c_pk + c_rev |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| wms_inv_product_log_c_av_state_check | ((c_av_state)::text = ANY ((ARRAY['LOCKED'::character varying, 'QC_LOCKED'::character varying, 'AVAILABLE'::character varying])::text[])) |