| code |
VARCHAR |
10 |
|
|
null |
|
|
unique key used to identify each custom field |
| description |
VARCHAR |
255 |
|
|
null |
|
|
description for each custom field |
| repeatable |
BIT |
0 |
|
|
0 |
|
|
defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no) |
| unique_id |
BIT |
0 |
|
|
0 |
|
|
defines if this value needs to be unique (1 for yes, 0 for no) |
| opac_display |
BIT |
0 |
|
|
0 |
|
|
defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no) |
| opac_editable |
BIT |
0 |
|
|
0 |
|
|
defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no) |
| staff_searchable |
BIT |
0 |
|
|
0 |
|
|
defines if this field is searchable via the patron search in the staff interface (1 for yes, 0 for no) |
| searched_by_default |
BIT |
0 |
|
|
0 |
|
|
defines if this field is included in “Standard” patron searches in the staff interface (1 for yes, 0 for no) |
| authorised_value_category |
VARCHAR |
32 |
√ |
|
null |
|
|
foreign key from authorised_values that links this custom field to an authorized value category |
| display_checkout |
BIT |
0 |
|
|
0 |
|
|
defines if this field displays in checkout screens |
