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