Table testsql_comments.message_transports Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
message_attribute_id int 10
message_attributes
message_transport_type varchar 20
message_transport_types
is_digest bit 0 0
letter_module varchar 20
letter
letter_code varchar 20
letter
branchcode varchar 10
letter

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

Indexes:
Column(s) Type Sort
message_attribute_id + message_transport_type + is_digest Primary key Asc/Asc/Asc
letter_module + letter_code Performance Asc/Asc
message_transport_type Performance Asc
letter_module + letter_code + branchcode Performance Asc/Asc/Asc

Close relationships  within of separation: