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