Table testsql_comments.borrower_message_preferences 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
borrower_message_preference_id int 10  √ 
borrower_message_transport_preferences.borrower_message_preference_id borrower_message_transport_preferences_ibfk_1 C
borrowernumber int 10  √  null
borrowers.borrowernumber borrower_message_preferences_ibfk_1 C
categorycode varchar 10  √  null
categories.categorycode borrower_message_preferences_ibfk_3 C
message_attribute_id int 10  √  0
message_attributes.message_attribute_id borrower_message_preferences_ibfk_2 C
days_in_advance int 10  √  0
wants_digest bit 0 0

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
borrower_message_preference_id Primary key Asc PRIMARY
borrowernumber Performance Asc borrowernumber
categorycode Performance Asc categorycode
message_attribute_id Performance Asc message_attribute_id

Close relationships  within of separation: