Table testsql_comments.overduerules_transport_types Generated by
SchemaSpy
Legend: SourceForge.net
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  √ 
fieldmapping.id 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

Indexes:
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: