SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Nov 05 09:42 UTC 2024
Legend:
Primary key columns
Columns with indexes
 

testdb.public contains 30 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
tms_problem_history c_created timestamp 29,6  √  null
tms_transport_order c_created timestamp 29,6  √  null
tms_problem_history c_created_by varchar 255  √  null
tms_transport_order c_created_by varchar 255  √  null
tms_transport_order c_end_date timestamp 29,6  √  null
tms_problem_history c_fk_to int8 19  √  null
tms_problem_history c_message_text varchar 255  √  null
tms_transport_order c_message_text varchar 255  √  null
tms_problem_history c_no varchar 255  √  null
tms_transport_order c_no varchar 255  √  null
tms_problem_history c_occurred timestamp 29,6  √  null
tms_transport_order c_occurred timestamp 29,6  √  null
tms_problem_history c_ol int8 19  √  null
tms_transport_order c_ol int8 19  √  null
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_problem_history c_updated timestamp 29,6  √  null
tms_transport_order c_updated timestamp 29,6  √  null
tms_problem_history c_updated_by varchar 255  √  null
tms_transport_order c_updated_by varchar 255  √  null
tms_problem_history p_key varchar 255  √  null
tms_transport_order p_key varchar 255  √  null
tms_transport_order c_pid varchar 255
tms_problem_history c_pk int8 19
tms_transport_order c_pk int8 19