borrower_attribute_types


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_1 C
borrower_attributes.code borrower_attributes_ibfk_2 C
marc_matchers.code Implied Constraint R

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 client (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

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation