borrower_message_preferences


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 0
wants_digest BIT 0 0

Table contained 0 rows

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