borrower_message_preferences

Columns

Related columns Constraint Comments

Search:

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

BIT

0

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation