categories

14 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 TINYINT 3 √ NULL

the minimum age required for the patron category
enrolmentfee DECIMAL 28,6 √ NULL

enrollment fee for the patron
overduenoticerequired TINYINT 3 √ 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 TINYINT 3 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') 7 'default'

Default privacy setting for this patron category
checkprevcheckout enum('yes', 'no', 'inherit') 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 TINYINT 3 1

can this patron category place interlibrary loan requests
can_be_guarantee TINYINT 3 0

if patrons of this category can be guarantees
reset_password TINYINT 3 √ NULL

if patrons of this category can do the password reset flow,
change_password TINYINT 3 √ 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 TINYINT 3 √ NULL

set required password strength for patrons in this category
force_password_reset_when_set_by_staff TINYINT 3 √ NULL

if patrons of this category are required to reset password after being created by a staff member
exclude_from_local_holds_priority TINYINT 3 √ 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
enforce_expiry_notice TINYINT 3 0

enforce the patron expiry notice for this category

Indexes

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

Relationships

Close relationships within degrees of separation