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