SchemaSpy Analysis of testdb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Thu Feb 15 22:06 UTC 2024 |
| |||||
|
testdb.public contains 92 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
wms_shp_order | c_created | timestamp | 29,6 | √ | null | ||
wms_shp_order | c_created_by | varchar | 255 | √ | null | ||
wms_shp_order | c_customer_no | varchar | 255 | √ | null | ||
wms_shp_order | c_latest_due | timestamp | 29,6 | √ | null | ||
wms_shp_order | c_locked | bool | 1 | √ | null | ||
wms_shp_order | c_next_allocation | timestamp | 29,6 | √ | null | ||
wms_shp_order | c_ol | int8 | 19 | √ | null | ||
wms_shp_order | c_order_id | varchar | 20 | ||||
wms_shp_order | c_order_state | varchar | 255 | √ | null | ||
wms_shp_order | c_pid | varchar | 255 | ||||
wms_shp_order | c_pk | int8 | 19 | ||||
wms_shp_order | c_priority | int4 | 10 | √ | null | ||
wms_shp_order | c_problem_message | varchar | 255 | √ | null | ||
wms_shp_order | c_problem_message_no | int4 | 10 | √ | null | ||
wms_shp_order | c_problem_occurred | timestamp | 29,6 | √ | null | ||
wms_shp_order | c_start_date | timestamp | 29,6 | √ | null | ||
wms_shp_order | c_start_mode | varchar | 255 | √ | null | ||
wms_shp_order | c_type | varchar | 255 | √ | null | ||
wms_shp_order | c_updated | timestamp | 29,6 | √ | null | ||
wms_shp_order | c_updated_by | varchar | 255 | √ | null | ||
wms_shp_order_detail | c_key | varchar | 255 | ||||
wms_shp_order_detail | c_order_id | varchar | 20 | ||||
wms_shp_order_detail | c_value | varchar | 255 | √ | null | ||
wms_shp_order_position | c_created | timestamp | 29,6 | √ | null | ||
wms_shp_order_position | c_created_by | varchar | 255 | √ | null | ||
wms_shp_order_position | c_latest_due | timestamp | 29,6 | √ | null | ||
wms_shp_order_position | c_locked | bool | 1 | √ | null | ||
wms_shp_order_position | c_next_allocation | timestamp | 29,6 | √ | null | ||
wms_shp_order_position | c_ol | int8 | 19 | √ | null | ||
wms_shp_order_position | c_order_id | varchar | 20 | ||||
wms_shp_order_position | c_order_state | varchar | 255 | √ | null | ||
wms_shp_order_position | c_pid | varchar | 255 | ||||
wms_shp_order_position | c_pk | int8 | 19 | ||||
wms_shp_order_position | c_position_no | int4 | 10 | ||||
wms_shp_order_position | c_priority | int4 | 10 | √ | null | ||
wms_shp_order_position | c_problem_message | varchar | 255 | √ | null | ||
wms_shp_order_position | c_problem_message_no | int4 | 10 | √ | null | ||
wms_shp_order_position | c_problem_occurred | timestamp | 29,6 | √ | null | ||
wms_shp_order_position | c_product_pk | int8 | 19 | ||||
wms_shp_order_position | c_qty_alloc | varchar | 16 | √ | null | ||
wms_shp_order_position | c_qty_crossdock | varchar | 16 | √ | null | ||
wms_shp_order_position | c_qty_ordered | varchar | 16 | ||||
wms_shp_order_position | c_qty_type_alloc | varchar | 255 | √ | null | ||
wms_shp_order_position | c_qty_type_crossdock | varchar | 255 | √ | null | ||
wms_shp_order_position | c_qty_type_ordered | varchar | 255 | ||||
wms_shp_order_position | c_source_location_groups | varchar | 1024 | √ | null | ||
wms_shp_order_position | c_start_earliest | timestamp | 29,6 | √ | null | ||
wms_shp_order_position | c_target_name | varchar | 255 | √ | null | ||
wms_shp_order_position | c_target_type | varchar | 255 | √ | null | ||
wms_shp_order_position | c_to_start_mode | varchar | 255 | √ | null | ||
wms_shp_order_position | c_updated | timestamp | 29,6 | √ | null | ||
wms_shp_order_position | c_updated_by | varchar | 255 | √ | null | ||
wms_shp_order_position_detail | c_key | varchar | 255 | ||||
wms_shp_order_position_detail | c_order_id | varchar | 20 | ||||
wms_shp_order_position_detail | c_position_no | int4 | 10 | ||||
wms_shp_order_position_detail | c_value | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_created | timestamp | 29,6 | √ | null | ||
wms_shp_order_position_split | c_created_by | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_load_unit_pkey | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_ol | int8 | 19 | √ | null | ||
wms_shp_order_position_split | c_pk | int8 | 19 | ||||
wms_shp_order_position_split | c_position_pk | int8 | 19 | ||||
wms_shp_order_position_split | c_priority | int4 | 10 | √ | null | ||
wms_shp_order_position_split | c_problem_message | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_problem_message_no | int4 | 10 | √ | null | ||
wms_shp_order_position_split | c_problem_occurred | timestamp | 29,6 | √ | null | ||
wms_shp_order_position_split | c_product_pk | int8 | 19 | √ | null | ||
wms_shp_order_position_split | c_qty | varchar | 16 | ||||
wms_shp_order_position_split | c_quantity_type | varchar | 255 | ||||
wms_shp_order_position_split | c_reservation_id | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_split_no | int4 | 10 | ||||
wms_shp_order_position_split | c_start_mode | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_target_name | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_target_type | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_transport_unit_bk | varchar | 255 | √ | null | ||
wms_shp_order_position_split | c_updated | timestamp | 29,6 | √ | null | ||
wms_shp_order_position_split | c_updated_by | varchar | 255 | √ | null | ||
wms_shp_product | c_created | timestamp | 29,6 | √ | null | ||
wms_shp_product | c_created_by | varchar | 255 | √ | null | ||
wms_shp_product | c_description | varchar | 255 | √ | null | ||
wms_shp_product | c_foreign_pid | varchar | 255 | ||||
wms_shp_product | c_label | varchar | 255 | √ | null | ||
wms_shp_product | c_ol | int8 | 19 | √ | null | ||
wms_shp_product | c_pid | varchar | 255 | ||||
wms_shp_product | c_pk | int8 | 19 | ||||
wms_shp_product | c_sku | varchar | 255 | ||||
wms_shp_product | c_stock_zone | varchar | 255 | √ | null | ||
wms_shp_product | c_updated | timestamp | 29,6 | √ | null | ||
wms_shp_product | c_updated_by | varchar | 255 | √ | null | ||
wms_shp_product_detail | c_key | varchar | 255 | ||||
wms_shp_product_detail | c_product_pk | int8 | 19 | ||||
wms_shp_product_detail | c_value | varchar | 255 | √ | null |