Table testsql_comments.borrower_message_preferences Generated by
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 Tue Dec 27 17:18 NZDT 2016

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: