Lines 322-336
CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as
Link Here
|
322 |
-- |
322 |
-- |
323 |
|
323 |
|
324 |
DROP TABLE IF EXISTS `borrower_debarments`; |
324 |
DROP TABLE IF EXISTS `borrower_debarments`; |
325 |
CREATE TABLE borrower_debarments ( |
325 |
CREATE TABLE borrower_debarments ( -- tracks restrictions on the patron's record |
326 |
borrower_debarment_id int(11) NOT NULL AUTO_INCREMENT, |
326 |
borrower_debarment_id int(11) NOT NULL AUTO_INCREMENT, -- unique key for the restriction |
327 |
borrowernumber int(11) NOT NULL, |
327 |
borrowernumber int(11) NOT NULL, -- foreign key for borrowers.borrowernumber for patron who is restricted |
328 |
expiration date DEFAULT NULL, |
328 |
expiration date DEFAULT NULL, -- expiration date of the restriction |
329 |
`type` enum('SUSPENSION','OVERDUES','MANUAL') NOT NULL DEFAULT 'MANUAL', |
329 |
`type` enum('SUSPENSION','OVERDUES','MANUAL') NOT NULL DEFAULT 'MANUAL', -- type of restriction |
330 |
`comment` text, |
330 |
`comment` text, -- comments about the restriction |
331 |
manager_id int(11) DEFAULT NULL, |
331 |
manager_id int(11) DEFAULT NULL, -- foreign key for borrowers.borrowernumber for the librarian managing the restriction |
332 |
created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
332 |
created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date the restriction was added |
333 |
updated timestamp NULL DEFAULT NULL, |
333 |
updated timestamp NULL DEFAULT NULL, -- date the restriction was updated |
334 |
PRIMARY KEY (borrower_debarment_id), |
334 |
PRIMARY KEY (borrower_debarment_id), |
335 |
KEY borrowernumber (borrowernumber), |
335 |
KEY borrowernumber (borrowernumber), |
336 |
CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
336 |
CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
Lines 477-483
CREATE TABLE `categories` ( -- this table shows information related to Koha patr
Link Here
|
477 |
`enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) |
477 |
`enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) |
478 |
`enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set) |
478 |
`enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set) |
479 |
`upperagelimit` smallint(6) default NULL, -- age limit for the patron |
479 |
`upperagelimit` smallint(6) default NULL, -- age limit for the patron |
480 |
`dateofbirthrequired` tinyint(1) default NULL, |
480 |
`dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category |
481 |
`finetype` varchar(30) default NULL, -- unused in Koha |
481 |
`finetype` varchar(30) default NULL, -- unused in Koha |
482 |
`bulk` tinyint(1) default NULL, |
482 |
`bulk` tinyint(1) default NULL, |
483 |
`enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron |
483 |
`enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron |
484 |
- |
|
|