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