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.module message_transports_ibfk_3 C
letter_code varchar 20
letter.code message_transports_ibfk_3 C
branchcode varchar 10
letter.branchcode message_transports_ibfk_3 C

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

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
letter_module + letter_code + branchcode Performance Asc/Asc/Asc message_transports_ibfk_3

Close relationships  within of separation: