SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Oct 18 20:49 UTC 2021
Legend:
Primary key columns
Columns with indexes
 

testdb.public contains 207 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
wms_inv_load_unit c_created timestamp 29,6  √  null
wms_inv_load_unit c_height int4 10  √  null
wms_inv_load_unit c_label varchar 255  √  null
wms_inv_load_unit c_length int4 10  √  null
wms_inv_load_unit c_load_unit_type varchar 255
wms_inv_load_unit c_locked bool 1  √  null
wms_inv_load_unit c_mixed_products bool 1  √  null
wms_inv_load_unit c_ol int8 19  √  null
wms_inv_load_unit c_physical_pos varchar 255
wms_inv_load_unit c_pid varchar 255
wms_inv_load_unit c_pk int8 19
wms_inv_load_unit c_product_pk int8 19  √  null
wms_inv_load_unit c_transport_unit_pk int8 19
wms_inv_load_unit c_uom varchar 255  √  null
wms_inv_load_unit c_updated timestamp 29,6  √  null
wms_inv_load_unit c_width int4 10  √  null
wms_inv_load_unit_type c_created timestamp 29,6  √  null
wms_inv_load_unit_type c_description varchar 255  √  null
wms_inv_load_unit_type c_inner_height int4 10  √  null
wms_inv_load_unit_type c_inner_length int4 10  √  null
wms_inv_load_unit_type c_inner_width int4 10  √  null
wms_inv_load_unit_type c_ol int8 19  √  null
wms_inv_load_unit_type c_outer_height int4 10  √  null
wms_inv_load_unit_type c_outer_length int4 10  √  null
wms_inv_load_unit_type c_outer_width int4 10  √  null
wms_inv_load_unit_type c_pid varchar 255
wms_inv_load_unit_type c_pk int8 19
wms_inv_load_unit_type c_type varchar 255
wms_inv_load_unit_type c_updated timestamp 29,6  √  null
wms_inv_load_unit_type c_weight_max varchar 255  √  null
wms_inv_load_unit_type c_weight_max_type varchar 255  √  null
wms_inv_load_unit_type c_weight_tare varchar 255  √  null
wms_inv_load_unit_type c_weight_tare_type varchar 255  √  null
wms_inv_location c_aisle varchar 4
wms_inv_location c_area varchar 4
wms_inv_location c_created timestamp 29,6  √  null
wms_inv_location c_description varchar 255  √  null
wms_inv_location c_erp_code varchar 255  √  null
wms_inv_location c_foreign_pid varchar 255  √  null
wms_inv_location c_incoming_active bool 1  √  null
wms_inv_location c_last_inventory_date timestamp 22  √  null
wms_inv_location c_last_pick_date timestamp 22  √  null
wms_inv_location c_location_group varchar 255  √  null
wms_inv_location c_mixed_products bool 1  √  null
wms_inv_location c_no_max_transport_units int4 10  √  null
wms_inv_location c_ol int8 19  √  null
wms_inv_location c_outgoing_active bool 1  √  null
wms_inv_location c_pid varchar 255
wms_inv_location c_pk int8 19
wms_inv_location c_plc_state int4 10  √  null
wms_inv_location c_updated timestamp 29,6  √  null
wms_inv_location c_x varchar 4
wms_inv_location c_y varchar 4
wms_inv_location c_z varchar 4
wms_inv_packaging_unit c_actual_location int8 19  √  null
wms_inv_packaging_unit c_av_state varchar 255
wms_inv_packaging_unit c_created timestamp 29,6  √  null
wms_inv_packaging_unit c_fifo_date timestamp 29,6  √  null
wms_inv_packaging_unit c_height int4 10  √  null
wms_inv_packaging_unit c_labels varchar 1024  √  null
wms_inv_packaging_unit c_length int4 10  √  null
wms_inv_packaging_unit c_load_unit int8 19  √  null
wms_inv_packaging_unit c_lot_pkey varchar 255  √  null
wms_inv_packaging_unit c_message_no int4 10  √  null
wms_inv_packaging_unit c_message_text varchar 255  √  null
wms_inv_packaging_unit c_ol int8 19  √  null
wms_inv_packaging_unit c_parent int8 19  √  null
wms_inv_packaging_unit c_pid varchar 255
wms_inv_packaging_unit c_pk int8 19
wms_inv_packaging_unit c_product_pk int8 19  √  null
wms_inv_packaging_unit c_qty varchar 16
wms_inv_packaging_unit c_qty_type varchar 255
wms_inv_packaging_unit c_serial_number varchar 255  √  null
wms_inv_packaging_unit c_uom varchar 255  √  null
wms_inv_packaging_unit c_updated timestamp 29,6  √  null
wms_inv_packaging_unit c_weight varchar 255  √  null
wms_inv_packaging_unit c_weight_type varchar 255  √  null
wms_inv_packaging_unit c_width int4 10  √  null
wms_inv_packaging_unit physical_position varchar 255  √  null
wms_inv_packaging_unit_log c_actual_location int8 19  √  null
wms_inv_packaging_unit_log c_av_state varchar 255  √  null
wms_inv_packaging_unit_log c_created timestamp 29,6  √  null
wms_inv_packaging_unit_log c_fifo_date timestamp 29,6  √  null
wms_inv_packaging_unit_log c_height int4 10  √  null
wms_inv_packaging_unit_log c_labels varchar 1024  √  null
wms_inv_packaging_unit_log c_length int4 10  √  null
wms_inv_packaging_unit_log c_load_unit int8 19  √  null
wms_inv_packaging_unit_log c_lot_pkey varchar 255  √  null
wms_inv_packaging_unit_log c_message_no int4 10  √  null
wms_inv_packaging_unit_log c_message_text varchar 255  √  null
wms_inv_packaging_unit_log c_parent int8 19  √  null
wms_inv_packaging_unit_log c_pid varchar 255  √  null
wms_inv_packaging_unit_log c_pk int8 19
wms_inv_packaging_unit_log c_product_pk int8 19  √  null
wms_inv_packaging_unit_log c_qty varchar 16  √  null
wms_inv_packaging_unit_log c_qty_type varchar 255  √  null
wms_inv_packaging_unit_log c_rev int8 19
wms_inv_packaging_unit_log c_rev_type int2 5  √  null
wms_inv_packaging_unit_log c_serial_number varchar 255  √  null
wms_inv_packaging_unit_log c_uom varchar 255  √  null
wms_inv_packaging_unit_log c_updated timestamp 29,6  √  null
wms_inv_packaging_unit_log c_weight varchar 255  √  null
wms_inv_packaging_unit_log c_weight_type varchar 255  √  null
wms_inv_packaging_unit_log c_width int4 10  √  null
wms_inv_packaging_unit_log physical_position varchar 255  √  null
wms_inv_product c_account varchar 255  √  null
wms_inv_product c_av_state varchar 255  √  null
wms_inv_product c_base_unit_qty varchar 16
wms_inv_product c_base_unit_type varchar 255
wms_inv_product c_classification varchar 255  √  null
wms_inv_product c_created timestamp 29,6  √  null
wms_inv_product c_description varchar 255  √  null
wms_inv_product c_group varchar 255  √  null
wms_inv_product c_height int4 10  √  null
wms_inv_product c_label varchar 255  √  null
wms_inv_product c_length int4 10  √  null
wms_inv_product c_ol int8 19  √  null
wms_inv_product c_pid varchar 255
wms_inv_product c_pk int8 19
wms_inv_product c_preferable_storage_location int8 19  √  null
wms_inv_product c_sku varchar 255
wms_inv_product c_stock_zone varchar 255  √  null
wms_inv_product c_uom varchar 255  √  null
wms_inv_product c_updated timestamp 29,6  √  null
wms_inv_product c_weight varchar 16  √  null
wms_inv_product c_weight_type varchar 255  √  null
wms_inv_product c_width int4 10  √  null
wms_inv_product_detail c_key varchar 255
wms_inv_product_detail c_product_pk int8 19
wms_inv_product_detail c_value varchar 255  √  null
wms_inv_product_stacking_rule c_allowed_product int8 19
wms_inv_product_stacking_rule c_base_product int8 19
wms_inv_product_stacking_rule c_created timestamp 29,6  √  null
wms_inv_product_stacking_rule c_no_products int4 10
wms_inv_product_stacking_rule c_ol int8 19  √  null
wms_inv_product_stacking_rule c_pid varchar 255
wms_inv_product_stacking_rule c_pk int8 19
wms_inv_product_stacking_rule c_updated timestamp 29,6  √  null
wms_inv_product_unit c_created timestamp 29,6  √  null
wms_inv_product_unit c_description varchar 255  √  null
wms_inv_product_unit c_height int4 10  √  null
wms_inv_product_unit c_label varchar 255  √  null
wms_inv_product_unit c_length int4 10  √  null
wms_inv_product_unit c_ol int8 19  √  null
wms_inv_product_unit c_pid varchar 255
wms_inv_product_unit c_pk int8 19
wms_inv_product_unit c_product_pk int8 19
wms_inv_product_unit c_qty varchar 16
wms_inv_product_unit c_qty_type varchar 255
wms_inv_product_unit c_uom varchar 255  √  null
wms_inv_product_unit c_updated timestamp 29,6  √  null
wms_inv_product_unit c_width int4 10  √  null
wms_inv_product_unit_detail c_key varchar 255
wms_inv_product_unit_detail c_product_unit_pk int8 19
wms_inv_product_unit_detail c_value varchar 255  √  null
wms_inv_reservation c_created timestamp 29,6  √  null
wms_inv_reservation c_ol int8 19  √  null
wms_inv_reservation c_packaging_unit_pk int8 19
wms_inv_reservation c_pid varchar 255
wms_inv_reservation c_pk int8 19
wms_inv_reservation c_qty_reserved varchar 16  √  null
wms_inv_reservation c_qty_type_reserved varchar 255  √  null
wms_inv_reservation c_reserved_at timestamp 22  √  null
wms_inv_reservation c_reserved_by varchar 255  √  null
wms_inv_reservation c_updated timestamp 29,6  √  null
wms_inv_reservation_log c_created timestamp 29,6  √  null
wms_inv_reservation_log c_packaging_unit_pk int8 19  √  null
wms_inv_reservation_log c_pid varchar 255  √  null
wms_inv_reservation_log c_pk int8 19
wms_inv_reservation_log c_qty_reserved varchar 16  √  null
wms_inv_reservation_log c_qty_type_reserved varchar 255  √  null
wms_inv_reservation_log c_reserved_at timestamp 22  √  null
wms_inv_reservation_log c_reserved_by varchar 255  √  null
wms_inv_reservation_log c_rev int8 19
wms_inv_reservation_log c_rev_type int2 5  √  null
wms_inv_reservation_log c_updated timestamp 29,6  √  null
wms_inv_revision c_pk int8 19
wms_inv_revision c_timestamp int8 19  √  null
wms_inv_revision c_user varchar 255  √  null
wms_inv_task c_created timestamp 29,6  √  null
wms_inv_task c_disc varchar 31
wms_inv_task c_ol int8 19  √  null
wms_inv_task c_pid varchar 255
wms_inv_task c_pk int8 19
wms_inv_task c_state varchar 255  √  null
wms_inv_task c_updated timestamp 29,6  √  null
wms_inv_task customer_order_id varchar 255  √  null
wms_inv_task load_unit_type varchar 255  √  null
wms_inv_task parts int4 10  √  null
wms_inv_task transport_unitbk varchar 255  √  null
wms_inv_transport_unit c_acknowledged bool 1  √  null
wms_inv_transport_unit c_actual_location int8 19
wms_inv_transport_unit c_actual_location_date timestamp 29,6  √  null
wms_inv_transport_unit c_created timestamp 29,6  √  null
wms_inv_transport_unit c_customer_order_id varchar 255  √  null
wms_inv_transport_unit c_foreign_pid varchar 255  √  null
wms_inv_transport_unit c_height int4 10  √  null
wms_inv_transport_unit c_length int4 10  √  null
wms_inv_transport_unit c_ol int8 19  √  null
wms_inv_transport_unit c_pid varchar 255
wms_inv_transport_unit c_pk int8 19
wms_inv_transport_unit c_state varchar 255  √  null
wms_inv_transport_unit c_target varchar 255  √  null
wms_inv_transport_unit c_transport_unit_bk varchar 255
wms_inv_transport_unit c_transport_unit_type varchar 255
wms_inv_transport_unit c_updated timestamp 29,6  √  null
wms_inv_transport_unit c_width int4 10  √  null