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 |