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