borrower_message_preferences

350 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrower_message_preference_id INT 10 √ null
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 √ NULL
wants_digest BOOLEAN 3 0

Indexes

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

Relationships

Close relationships within degrees of separation