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

Table contained 0 rows


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