borrower_attribute_types

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
code VARCHAR 10 null
borrower_attribute_types_branches.bat_code borrower_attribute_types_branches_ibfk_1C
borrower_attributes.code borrower_attributes_ibfk_2C
marc_matchers.code Implied ConstraintR
pseudonymized_borrower_attributes.code anonymized_borrower_attributes_ibfk_2C

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
category_code VARCHAR 10 null
class VARCHAR 255
keep_for_pseudonymization BIT 0 0

defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)

mandatory BIT 0 0

defines if the attribute is mandatory or not

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc code
auth_val_cat_idx Performance Asc authorised_value_category

Relationships