SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Mar 05 14:32 UTC 2024
Legend:
Primary key columns
Columns with indexes
 

testdb.public contains 47 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
mvm_problem_history c_fk_movement int8 19  √  null
mvm_movement c_group_pk int8 19  √  null
mvm_movement c_ol int8 19  √  null
mvm_movement_group c_ol int8 19  √  null
mvm_problem_history c_ol int8 19  √  null
mvm_movement c_pk int8 19
mvm_movement_group c_pk int8 19
mvm_problem_history c_pk int8 19
mvm_movement c_end_date timestamp 22  √  null
mvm_movement c_latest_due timestamp 22  √  null
mvm_movement c_start_date timestamp 22  √  null
mvm_movement c_start_earliest_date timestamp 22  √  null
mvm_movement c_created timestamp 29,6  √  null
mvm_movement_group c_created timestamp 29,6  √  null
mvm_problem_history c_created timestamp 29,6  √  null
mvm_movement c_occurred timestamp 29,6  √  null
mvm_problem_history c_occurred timestamp 29,6  √  null
mvm_movement c_updated timestamp 29,6  √  null
mvm_movement_group c_updated timestamp 29,6  √  null
mvm_problem_history c_updated timestamp 29,6  √  null
mvm_movement c_created_by varchar 255  √  null
mvm_movement_group c_created_by varchar 255  √  null
mvm_problem_history c_created_by varchar 255  √  null
mvm_movement c_initiator varchar 255
mvm_movement c_mode varchar 255
mvm_movement_group c_name varchar 255
mvm_movement c_no varchar 255  √  null
mvm_problem_history c_no varchar 255  √  null
mvm_movement c_pid varchar 255
mvm_movement_group c_pid varchar 255
mvm_problem_history c_pid varchar 255
mvm_movement c_priority varchar 255
mvm_movement c_sku varchar 255  √  null
mvm_movement c_source_location varchar 255  √  null
mvm_movement c_source_location_group_name varchar 255  √  null
mvm_movement c_state varchar 255  √  null
mvm_movement_group c_state varchar 255  √  null
mvm_movement c_target_location varchar 255  √  null
mvm_movement c_target_location_group_name varchar 255
mvm_movement c_transport_unit_bk varchar 255
mvm_movement c_type varchar 255
mvm_movement c_updated_by varchar 255  √  null
mvm_movement_group c_updated_by varchar 255  √  null
mvm_problem_history c_updated_by varchar 255  √  null
mvm_movement_group c_user varchar 255  √  null
mvm_movement c_message varchar 1024  √  null
mvm_problem_history c_message varchar 1024  √  null