SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Feb 15 22:06 UTC 2024
Legend:
Primary key columns
Columns with indexes
 

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