SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sun Oct 03 21:46 UTC 2021
Legend:
Primary key columns
Columns with indexes
 

testdb.public contains 158 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
com_account c_created timestamp 29,6  √  null
com_account c_default bool 1
com_account c_identifier varchar 255
com_account c_name varchar 255
com_account c_ol int8 19  √  null
com_account c_pid varchar 255
com_account c_pk int8 19
com_account c_updated timestamp 29,6  √  null
com_barcode c_created timestamp 29,6  √  null
com_barcode c_current varchar 40  √  null
com_barcode c_name varchar 255  √  null
com_barcode c_ol int8 19  √  null
com_barcode c_pk int8 19
com_barcode c_updated timestamp 29,6  √  null
com_location c_account varchar 255  √  null
com_location c_aisle varchar 255  √  null
com_location c_area varchar 255  √  null
com_location c_check_state varchar 255  √  null
com_location c_classification varchar 255  √  null
com_location c_considered_in_allocation bool 1  √  null
com_location c_counting_active bool 1  √  null
com_location c_created timestamp 29,6  √  null
com_location c_description varchar 255  √  null
com_location c_direct_booking_allowed bool 1  √  null
com_location c_erp_code varchar 255  √  null
com_location c_group varchar 255  √  null
com_location c_incoming_active bool 1  √  null
com_location c_labels varchar 1024  √  null
com_location c_last_movement timestamp 29,6  √  null
com_location c_lg_counting_active bool 1  √  null
com_location c_location_group int8 19  √  null
com_location c_location_type int8 19  √  null
com_location c_maximum_weight numeric 19,2  √  null
com_location c_no_max_transport_units int4 10  √  null
com_location c_ol int8 19  √  null
com_location c_outgoing_active bool 1  √  null
com_location c_pid varchar 255
com_location c_pk int8 19
com_location c_plc_code varchar 255  √  null
com_location c_plc_state int4 10  √  null
com_location c_stock_zone varchar 255  √  null
com_location c_updated timestamp 29,6  √  null
com_location c_x varchar 255  √  null
com_location c_y varchar 255  √  null
com_location c_z varchar 255  √  null
com_location_group c_account varchar 255  √  null
com_location_group c_created timestamp 29,6  √  null
com_location_group c_description varchar 255  √  null
com_location_group c_group_counting_active bool 1  √  null
com_location_group c_group_state_in varchar 255  √  null
com_location_group c_group_state_out varchar 255  √  null
com_location_group c_group_type varchar 255  √  null
com_location_group c_in_locker int8 19  √  null
com_location_group c_max_fill_level float4 8,8  √  null
com_location_group c_name varchar 20
com_location_group c_ol int8 19  √  null
com_location_group c_op_mode varchar 255  √  null
com_location_group c_out_locker int8 19  √  null
com_location_group c_parent int8 19  √  null
com_location_group c_pid varchar 255
com_location_group c_pk int8 19
com_location_group c_system_code varchar 255  √  null
com_location_group c_system_name varchar 255  √  null
com_location_group c_updated timestamp 29,6  √  null
com_location_message c_location_id int8 19
com_location_message c_message_id int8 19
com_location_type c_created timestamp 29,6  √  null
com_location_type c_description varchar 255  √  null
com_location_type c_height int4 10  √  null
com_location_type c_length int4 10  √  null
com_location_type c_ol int8 19  √  null
com_location_type c_pid varchar 255
com_location_type c_pk int8 19
com_location_type c_type varchar 255
com_location_type c_updated timestamp 29,6  √  null
com_location_type c_width int4 10  √  null
com_srv_revision c_pk int8 19
com_srv_revision c_timestamp int8 19  √  null
com_srv_revision c_user varchar 255  √  null
com_transport_unit c_actual_location int8 19
com_transport_unit c_actual_location_date timestamp 29,6  √  null
com_transport_unit c_barcode varchar 20
com_transport_unit c_created timestamp 29,6  √  null
com_transport_unit c_empty bool 1  √  null
com_transport_unit c_group_id varchar 255  √  null
com_transport_unit c_inventory_date timestamp 29,6  √  null
com_transport_unit c_inventory_user varchar 255  √  null
com_transport_unit c_ol int8 19  √  null
com_transport_unit c_parent int8 19  √  null
com_transport_unit c_pid varchar 255
com_transport_unit c_pk int8 19
com_transport_unit c_state varchar 255  √  null
com_transport_unit c_target_location int8 19  √  null
com_transport_unit c_transport_unit_type int8 19
com_transport_unit c_updated timestamp 29,6  √  null
com_transport_unit c_weight numeric 19,2  √  null
com_transport_unit c_weight_uom int4 10  √  null
com_transport_unit_log c_actual_location int8 19  √  null
com_transport_unit_log c_actual_location_date timestamp 29,6  √  null
com_transport_unit_log c_barcode varchar 20  √  null
com_transport_unit_log c_created timestamp 29,6  √  null
com_transport_unit_log c_empty bool 1  √  null
com_transport_unit_log c_group_id varchar 255  √  null
com_transport_unit_log c_inventory_date timestamp 29,6  √  null
com_transport_unit_log c_inventory_user varchar 255  √  null
com_transport_unit_log c_parent int8 19  √  null
com_transport_unit_log c_pid varchar 255  √  null
com_transport_unit_log c_pk int8 19
com_transport_unit_log c_rev int8 19
com_transport_unit_log c_rev_type int2 5  √  null
com_transport_unit_log c_state varchar 255  √  null
com_transport_unit_log c_target_location int8 19  √  null
com_transport_unit_log c_transport_unit_type int8 19  √  null
com_transport_unit_log c_updated timestamp 29,6  √  null
com_transport_unit_log c_weight numeric 19,2  √  null
com_transport_unit_log c_weight_uom int4 10  √  null
com_transport_unit_type c_compatibility varchar 255  √  null
com_transport_unit_type c_created timestamp 29,6  √  null
com_transport_unit_type c_description varchar 255  √  null
com_transport_unit_type c_height int4 10  √  null
com_transport_unit_type c_length int4 10  √  null
com_transport_unit_type c_ol int8 19  √  null
com_transport_unit_type c_payload numeric 19,2  √  null
com_transport_unit_type c_pid varchar 255
com_transport_unit_type c_pk int8 19
com_transport_unit_type c_type varchar 255
com_transport_unit_type c_updated timestamp 29,6  √  null
com_transport_unit_type c_weight_max numeric 19,2  √  null
com_transport_unit_type c_weight_tare numeric 19,2  √  null
com_transport_unit_type c_width int4 10  √  null
com_type_placing_rule c_allowed_location_type int8 19
com_type_placing_rule c_created timestamp 29,6  √  null
com_type_placing_rule c_ol int8 19  √  null
com_type_placing_rule c_pk int8 19
com_type_placing_rule c_privilege_level int4 10
com_type_placing_rule c_tut_id int8 19
com_type_placing_rule c_updated timestamp 29,6  √  null
com_type_stacking_rule c_allowed_transport_unit_type int8 19
com_type_stacking_rule c_created timestamp 29,6  √  null
com_type_stacking_rule c_no_transport_units int4 10
com_type_stacking_rule c_ol int8 19  √  null
com_type_stacking_rule c_pk int8 19
com_type_stacking_rule c_transport_unit_type int8 19  √  null
com_type_stacking_rule c_updated timestamp 29,6  √  null
com_unit_error c_created timestamp 29,6  √  null
com_unit_error c_error_no varchar 255  √  null
com_unit_error c_error_text varchar 255  √  null
com_unit_error c_ol int8 19  √  null
com_unit_error c_pid varchar 255
com_unit_error c_pk int8 19
com_unit_error c_tu_id int8 19
com_unit_error c_updated timestamp 29,6  √  null
cor_message c_created timestamp 29,6  √  null
cor_message c_message_no int4 10  √  null
cor_message c_message_text varchar 255  √  null
cor_message c_ol int8 19  √  null
cor_message c_pk int8 19
cor_message c_updated timestamp 29,6  √  null