|
Lines 1382-1403
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
| 1382 |
-- Table structure for table `old_reserves` |
1382 |
-- Table structure for table `old_reserves` |
| 1383 |
-- |
1383 |
-- |
| 1384 |
DROP TABLE IF EXISTS `old_reserves`; |
1384 |
DROP TABLE IF EXISTS `old_reserves`; |
| 1385 |
CREATE TABLE `old_reserves` ( |
1385 |
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have been completed (either filled or cancelled) |
| 1386 |
`borrowernumber` int(11) default NULL, |
1386 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for |
| 1387 |
`reservedate` date default NULL, |
1387 |
`reservedate` date default NULL, -- the date the hold was places |
| 1388 |
`biblionumber` int(11) default NULL, |
1388 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
| 1389 |
`constrainttype` varchar(1) default NULL, |
1389 |
`constrainttype` varchar(1) default NULL, |
| 1390 |
`branchcode` varchar(10) default NULL, |
1390 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
| 1391 |
`notificationdate` date default NULL, |
1391 |
`notificationdate` date default NULL, -- currently unused |
| 1392 |
`reminderdate` date default NULL, |
1392 |
`reminderdate` date default NULL, -- currently unused |
| 1393 |
`cancellationdate` date default NULL, |
1393 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
| 1394 |
`reservenotes` mediumtext, |
1394 |
`reservenotes` mediumtext, -- notes related to this hold |
| 1395 |
`priority` smallint(6) default NULL, |
1395 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
| 1396 |
`found` varchar(1) default NULL, |
1396 |
`found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed |
| 1397 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
1397 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
| 1398 |
`itemnumber` int(11) default NULL, |
1398 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |
| 1399 |
`waitingdate` date default NULL, |
1399 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
| 1400 |
`expirationdate` DATE DEFAULT NULL, |
1400 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
| 1401 |
`lowestPriority` tinyint(1) NOT NULL, |
1401 |
`lowestPriority` tinyint(1) NOT NULL, |
| 1402 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1402 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
| 1403 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1403 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
|
Lines 1557-1578
CREATE TABLE `reserveconstraints` (
Link Here
|
| 1557 |
-- |
1557 |
-- |
| 1558 |
|
1558 |
|
| 1559 |
DROP TABLE IF EXISTS `reserves`; |
1559 |
DROP TABLE IF EXISTS `reserves`; |
| 1560 |
CREATE TABLE `reserves` ( |
1560 |
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha |
| 1561 |
`borrowernumber` int(11) NOT NULL default 0, |
1561 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
| 1562 |
`reservedate` date default NULL, |
1562 |
`reservedate` date default NULL, -- the date the hold was places |
| 1563 |
`biblionumber` int(11) NOT NULL default 0, |
1563 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
| 1564 |
`constrainttype` varchar(1) default NULL, |
1564 |
`constrainttype` varchar(1) default NULL, |
| 1565 |
`branchcode` varchar(10) default NULL, |
1565 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
| 1566 |
`notificationdate` date default NULL, |
1566 |
`notificationdate` date default NULL, -- currently unused |
| 1567 |
`reminderdate` date default NULL, |
1567 |
`reminderdate` date default NULL, -- currently unused |
| 1568 |
`cancellationdate` date default NULL, |
1568 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
| 1569 |
`reservenotes` mediumtext, |
1569 |
`reservenotes` mediumtext, -- notes related to this hold |
| 1570 |
`priority` smallint(6) default NULL, |
1570 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
| 1571 |
`found` varchar(1) default NULL, |
1571 |
`found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed |
| 1572 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
1572 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
| 1573 |
`itemnumber` int(11) default NULL, |
1573 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |
| 1574 |
`waitingdate` date default NULL, |
1574 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
| 1575 |
`expirationdate` DATE DEFAULT NULL, |
1575 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
| 1576 |
`lowestPriority` tinyint(1) NOT NULL, |
1576 |
`lowestPriority` tinyint(1) NOT NULL, |
| 1577 |
KEY priorityfoundidx (priority,found), |
1577 |
KEY priorityfoundidx (priority,found), |
| 1578 |
KEY `borrowernumber` (`borrowernumber`), |
1578 |
KEY `borrowernumber` (`borrowernumber`), |
| 1579 |
- |
|
|