Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| categorycode | VARCHAR | 10 |
|
|
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 |
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
