SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Dec 21 23:24 UTC 2020
Legend:
Primary key columns
Columns with indexes
 

testdb.public contains 26 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
tms_problem_history c_created timestamp 29,6  √  null
tms_problem_history c_fk_to int8 19  √  null
tms_problem_history c_message varchar 255  √  null
tms_problem_history c_no varchar 255  √  null
tms_problem_history c_occurred timestamp 29,6  √  null
tms_problem_history c_ol int8 19  √  null
tms_problem_history c_pk int8 19
tms_problem_history c_updated timestamp 29,6  √  null
tms_problem_history p_key varchar 255  √  null
tms_transport_order c_created timestamp 29,6  √  null
tms_transport_order c_end_date timestamp 29,6  √  null
tms_transport_order c_message varchar 255  √  null
tms_transport_order c_no varchar 255  √  null
tms_transport_order c_occurred timestamp 29,6  √  null
tms_transport_order c_ol int8 19  √  null
tms_transport_order c_pid varchar 255
tms_transport_order c_pk int8 19
tms_transport_order c_priority varchar 255  √  null
tms_transport_order c_source_location varchar 255  √  null
tms_transport_order c_start_date timestamp 29,6  √  null
tms_transport_order c_state varchar 255  √  null
tms_transport_order c_target_location varchar 255  √  null
tms_transport_order c_target_location_group varchar 255  √  null
tms_transport_order c_transport_unit_bk varchar 255  √  null
tms_transport_order c_updated timestamp 29,6  √  null
tms_transport_order p_key varchar 255  √  null