0 rows


Column Type Size Nulls Auto Default Children Parents Comments
categorycode VARCHAR 10
borrower_attribute_types.category_code borrower_attribute_types_ibfk_1R
borrower_message_preferences.categorycode borrower_message_preferences_ibfk_3C
borrower_modifications.categorycode Implied ConstraintR
borrowers.categorycode borrowers_ibfk_1R
categories_branches.categorycode categories_branches_ibfk_1C
circulation_rules.categorycode circ_rules_ibfk_2C
deletedborrowers.categorycode Implied ConstraintR
identity_provider_domains.default_category_id identity_provider_domain_ibfk_3C
item_circulation_alert_preferences.categorycode Implied ConstraintR
overduerules.categorycode Implied ConstraintR
pseudonymized_transactions.categorycode Implied ConstraintR
statistics.categorycode Implied ConstraintR

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)

password_expiry_days SMALLINT 5 null

number of days after which the patron must reset their password

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’.

can_be_guarantee BIT 0 0

if patrons of this category can be guarantees

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

min_password_length SMALLINT 5 null

set minimum password length for patrons in this category

require_strong_password BIT 0 null

set required password strength for patrons in this category

exclude_from_local_holds_priority BIT 0 null

Exclude patrons of this category from local holds priority


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