Table testdb.public.tms_problem_history Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_pk int8 19
tms_transport_order.c_pk Implied Constraint R
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_no varchar 255  √  null
c_message_text varchar 255  √  null
c_occurred timestamp 29,6  √  null
p_key varchar 255  √  null
c_fk_to int8 19  √  null
tms_transport_order.c_pk fki67ypmss9e63p5ahurlia1wf1 R

Table contained 1 rows at Thu Feb 15 22:09 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc tms_problem_history_pkey

Close relationships: