|
Lines 322-331
CREATE TABLE `categories` ( -- this table shows information related to Koha patr
Link Here
|
| 322 |
`dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category |
322 |
`dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category |
| 323 |
`finetype` varchar(30) default NULL, -- unused in Koha |
323 |
`finetype` varchar(30) default NULL, -- unused in Koha |
| 324 |
`bulk` tinyint(1) default NULL, |
324 |
`bulk` tinyint(1) default NULL, |
| 325 |
`enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron |
325 |
`enrolmentfee` decimal(19,6) default NULL, -- enrollment fee for the patron |
| 326 |
`overduenoticerequired` tinyint(1) default NULL, -- are overdue notices sent to this patron category (1 for yes, 0 for no) |
326 |
`overduenoticerequired` tinyint(1) default NULL, -- are overdue notices sent to this patron category (1 for yes, 0 for no) |
| 327 |
`issuelimit` smallint(6) default NULL, -- unused in Koha |
327 |
`issuelimit` smallint(6) default NULL, -- unused in Koha |
| 328 |
`reservefee` decimal(28,6) default NULL, -- cost to place holds |
328 |
`reservefee` decimal(19,6) default NULL, -- cost to place holds |
| 329 |
`hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no) |
329 |
`hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no) |
| 330 |
`category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) |
330 |
`category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) |
| 331 |
`BlockExpiredPatronOpacActions` tinyint(1) NOT NULL default '-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 |
331 |
`BlockExpiredPatronOpacActions` tinyint(1) NOT NULL default '-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 |
| 332 |
- |
|
|