borrower_attributes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

Row id field

borrowernumber INT 10 null
borrowers.borrowernumber borrower_attributes_ibfk_1 C

foreign key from the borrowers table, defines which patron/borrower has this attribute

code VARCHAR 10 null
borrower_attribute_types.code borrower_attributes_ibfk_2 C

foreign key from the borrower_attribute_types table, defines which custom field this value was entered for

attribute VARCHAR 255 null

custom patron field value

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
borrowernumber Performance Asc borrowernumber
code_attribute Performance Asc/Asc code + attribute

Relationships