borrower_attribute_types

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
code VARCHAR 64 null
borrower_attribute_types_branches.bat_code borrower_attribute_types_branches_ibfk_1 C
borrower_attributes.code borrower_attributes_ibfk_2 C
localization.code Implied Constraint R
message_queue.letter_code Implied Constraint R
pseudonymized_borrower_attributes.code anonymized_borrower_attributes_ibfk_2 C

unique key used to identify each custom field
description VARCHAR 255 null

description for each custom field
repeatable BOOLEAN 3 0

defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no)
unique_id BOOLEAN 3 0

defines if this value needs to be unique (1 for yes, 0 for no)
is_date BOOLEAN 3 0
opac_display BOOLEAN 3 0

defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no)
opac_editable BOOLEAN 3 0

defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no)
staff_searchable BOOLEAN 3 0

defines if this field is searchable via the patron search in the staff interface (1 for yes, 0 for no)
searched_by_default BOOLEAN 3 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 BOOLEAN 3 0

defines if this field displays in checkout screens
category_code VARCHAR 10 √ NULL
categories.categorycode borrower_attribute_types_ibfk_1 R

defines a category for an attribute_type
class VARCHAR 255 ''

defines a class for an attribute_type
keep_for_pseudonymization BOOLEAN 3 0

defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)
mandatory BOOLEAN 3 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
category_code Performance Asc category_code

Relationships

Close relationships within degrees of separation