categories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
categorycode VARCHAR 10
borrower_message_preferences.categorycode borrower_message_preferences_ibfk_3 C
borrower_modifications.categorycode Implied Constraint R
borrowers.categorycode borrowers_ibfk_1 R
categories_branches.categorycode categories_branches_ibfk_1 C
circulation_rules.categorycode circ_rules_ibfk_2 C
deletedborrowers.categorycode Implied Constraint R
item_circulation_alert_preferences.categorycode Implied Constraint R
overduerules.categorycode Implied Constraint R

unique primary key used to idenfity the patron category
description LONGTEXT 2147483647 √ null

description of the patron category
enrolmentperiod SMALLINT 5 √ null

number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)
enrolmentperioddate DATE 10 √ null

date the patron is enrolled until (will be NULL if enrolmentperiod is set)
upperagelimit SMALLINT 5 √ null

age limit for the patron
dateofbirthrequired BIT 0 √ null

the minimum age required for the patron category
finetype VARCHAR 30 √ null

unused in Koha
bulk BIT 0 √ null
enrolmentfee DECIMAL 28,6 √ null

enrollment fee for the patron
overduenoticerequired BIT 0 √ null

are overdue notices sent to this patron category (1 for yes, 0 for no)
issuelimit SMALLINT 5 √ null

unused in Koha
reservefee DECIMAL 28,6 √ null

cost to place holds
hidelostitems BIT 0 0

are lost items shown to this category (1 for yes, 0 for no)
category_type VARCHAR 1 A

type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
BlockExpiredPatronOpacActions BIT 0 -1

wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions
default_privacy enum('default', 'never', 'forever') 8 default

Default privacy setting for this patron category
checkprevcheckout VARCHAR 7 inherit

produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.
reset_password BIT 0 √ null

if patrons of this category can do the password reset flow,
change_password BIT 0 √ null

if patrons of this category can change their passwords in the OAPC

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc categorycode
categorycode Must be unique Asc categorycode

Relationships

Close relationships within degrees of separation