Lines 1759-1764
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1759 |
`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 |
1759 |
`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 |
1760 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1760 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1761 |
`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) |
1761 |
`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) |
|
|
1762 |
`pickupexpired` DATE DEFAULT NULL, -- if hold has been waiting but it expired before it was picked up, the expiration date is set here |
1762 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, |
1763 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, |
1763 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, |
1764 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, |
1764 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1765 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
Lines 1770-1775
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1770 |
KEY `biblionumber` (`biblionumber`), |
1771 |
KEY `biblionumber` (`biblionumber`), |
1771 |
KEY `itemnumber` (`itemnumber`), |
1772 |
KEY `itemnumber` (`itemnumber`), |
1772 |
KEY `branchcode` (`branchcode`), |
1773 |
KEY `branchcode` (`branchcode`), |
|
|
1774 |
KEY `reserves_pickupexpired` (`pickupexpired`), |
1773 |
KEY `itemtype` (`itemtype`), |
1775 |
KEY `itemtype` (`itemtype`), |
1774 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1776 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1775 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1777 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
Lines 1799-1804
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1799 |
`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 |
1801 |
`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 |
1800 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1802 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1801 |
`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) |
1803 |
`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) |
|
|
1804 |
`pickupexpired` DATE DEFAULT NULL, -- if hold has been waiting but it expired before it was picked up, the expiration date is set here |
1802 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1805 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1803 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1806 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1804 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1807 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
Lines 1809-1814
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1809 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1812 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1810 |
KEY `old_reserves_itemnumber` (`itemnumber`), |
1813 |
KEY `old_reserves_itemnumber` (`itemnumber`), |
1811 |
KEY `old_reserves_branchcode` (`branchcode`), |
1814 |
KEY `old_reserves_branchcode` (`branchcode`), |
|
|
1815 |
KEY `old_reserves_pickupexpired` (`pickupexpired`), |
1812 |
KEY `old_reserves_itemtype` (`itemtype`), |
1816 |
KEY `old_reserves_itemtype` (`itemtype`), |
1813 |
CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1817 |
CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1814 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1818 |
ON DELETE SET NULL ON UPDATE SET NULL, |