Table testsql_comments.overduerules_transport_types Generated by
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
id int 10  √ Implied Constraint R
branchcode varchar 10
overduerules.branchcode overduerules_fk C
categorycode varchar 10
overduerules.categorycode overduerules_fk C
letternumber int 10 1
message_transport_type varchar 20 email
message_transport_types.message_transport_type mtt_fk C

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
message_transport_type Performance Asc mtt_fk
branchcode + categorycode Performance Asc/Asc overduerules_fk

Close relationships  within of separation: