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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
code varchar 10
borrower_attribute_types_branches
borrower_attributes
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)
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 at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
code Primary key Asc
authorised_value_category Performance Asc

Close relationships  within of separation: