0 rows


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_1C

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

code VARCHAR 10 null
borrower_attribute_types.code borrower_attributes_ibfk_2C

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


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