Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) |
||||||||||
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 |
||||||||||
category_code | VARCHAR | 10 | √ | null |
|
|
defines a category for an attribute_type |