|
Lines 1895-1901
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
| 1895 |
`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 |
1895 |
`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 |
| 1896 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1896 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
| 1897 |
`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) |
1897 |
`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) |
| 1898 |
`lowestPriority` tinyint(1) NOT NULL, |
1898 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, |
| 1899 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1899 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
| 1900 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1900 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
| 1901 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1901 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
|
Lines 1934-1940
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
| 1934 |
`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 |
1934 |
`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 |
| 1935 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1935 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
| 1936 |
`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) |
1936 |
`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) |
| 1937 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1937 |
`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) |
| 1938 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1938 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
| 1939 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1939 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
| 1940 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1940 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
| 1941 |
- |
|
|