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
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)
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 VARCHAR 128 follow_syspref_BlockExpiredPatronOpacActions

specific actions expired patrons of this category are blocked from performing or if the BlockExpiredPatronOpacActions system preference is to be followed
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
force_password_reset_when_set_by_staff BIT 0 √ null

if patrons of this category are required to reset password after being created by a staff member
exclude_from_local_holds_priority BIT 0 √ null

Exclude patrons of this category from local holds priority
noissuescharge INT 10 √ null

define maximum amount outstanding before checkouts are blocked
noissueschargeguarantees INT 10 √ null

define maximum amount that the guarantees of a patron in this category can have outstanding before checkouts are blocked
noissueschargeguarantorswithguarantees INT 10 √ null

define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked

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