Table testsql_comments.borrower_attribute_types
definitions for custom patron fields known as extended patron attributes

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
code varchar 10
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 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)
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 at Tue Dec 27 17:18 NZDT 2016

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

Close relationships  within of separation: