Table testsql_comments.message_transports 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
message_attribute_id int 10
message_attributes.message_attribute_id message_transports_ibfk_1 C
message_transport_type varchar 20
message_transport_types.message_transport_type message_transports_ibfk_2 C
is_digest bit 0 0
letter_module varchar 20
letter_code varchar 20
branchcode varchar 10
refund_lost_item_fee_rules.branchcode Implied Constraint R

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

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

Close relationships  within of separation: