Lines 485-492
CREATE TABLE `branch_borrower_circ_rules` (
Link Here
|
485 |
-- |
485 |
-- |
486 |
|
486 |
|
487 |
DROP TABLE IF EXISTS `default_borrower_circ_rules`; |
487 |
DROP TABLE IF EXISTS `default_borrower_circ_rules`; |
488 |
CREATE TABLE `default_borrower_circ_rules` ( |
488 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
489 |
`categorycode` VARCHAR(10) NOT NULL, |
489 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
490 |
`maxissueqty` int(4) default NULL, |
490 |
`maxissueqty` int(4) default NULL, |
491 |
PRIMARY KEY (`categorycode`), |
491 |
PRIMARY KEY (`categorycode`), |
492 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
492 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
Lines 978-1003
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
978 |
-- |
978 |
-- |
979 |
|
979 |
|
980 |
DROP TABLE IF EXISTS `issuingrules`; |
980 |
DROP TABLE IF EXISTS `issuingrules`; |
981 |
CREATE TABLE `issuingrules` ( |
981 |
CREATE TABLE `issuingrules` ( -- circulation and fine rules |
982 |
`categorycode` varchar(10) NOT NULL default '', |
982 |
`categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode) |
983 |
`itemtype` varchar(10) NOT NULL default '', |
983 |
`itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype) |
984 |
`restrictedtype` tinyint(1) default NULL, |
984 |
`restrictedtype` tinyint(1) default NULL, -- not used? always NULL |
985 |
`rentaldiscount` decimal(28,6) default NULL, |
985 |
`rentaldiscount` decimal(28,6) default NULL, -- percent discount on the rental charge for this item |
986 |
`reservecharge` decimal(28,6) default NULL, |
986 |
`reservecharge` decimal(28,6) default NULL, |
987 |
`fine` decimal(28,6) default NULL, |
987 |
`fine` decimal(28,6) default NULL, -- fine amount |
988 |
`finedays` int(11) default NULL, |
988 |
`finedays` int(11) default NULL, -- suspension in days |
989 |
`firstremind` int(11) default NULL, |
989 |
`firstremind` int(11) default NULL, -- fine grace period |
990 |
`chargeperiod` int(11) default NULL, |
990 |
`chargeperiod` int(11) default NULL, -- how often the fine amount is charged |
991 |
`accountsent` int(11) default NULL, |
991 |
`accountsent` int(11) default NULL, -- not used? always NULL |
992 |
`chargename` varchar(100) default NULL, |
992 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
993 |
`maxissueqty` int(4) default NULL, |
993 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
994 |
`issuelength` int(4) default NULL, |
994 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
995 |
`lengthunit` varchar(10) default 'days', |
995 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
996 |
`hardduedate` date default NULL, |
996 |
`hardduedate` date default NULL, -- hard due date |
997 |
`hardduedatecompare` tinyint NOT NULL default "0", |
997 |
`hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before) |
998 |
`renewalsallowed` smallint(6) NOT NULL default "0", |
998 |
`renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed |
999 |
`reservesallowed` smallint(6) NOT NULL default "0", |
999 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
1000 |
`branchcode` varchar(10) NOT NULL default '', |
1000 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
1001 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
1001 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
1002 |
KEY `categorycode` (`categorycode`), |
1002 |
KEY `categorycode` (`categorycode`), |
1003 |
KEY `itemtype` (`itemtype`) |
1003 |
KEY `itemtype` (`itemtype`) |
1004 |
- |
|
|