categories

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
categorycode VARCHAR 10
borrower_attribute_types.category_code borrower_attribute_types_ibfk_1 R
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
identity_provider_domains.default_category_id identity_provider_domain_ibfk_3 C
item_circulation_alert_preferences.categorycode Implied Constraint R
overduerules.categorycode Implied Constraint R
pseudonymized_transactions.categorycode Implied Constraint R
statistics.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)
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_place_ill_in_opac BIT 0 1

can this patron category place interlibrary loan requests
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

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