|
Lines 1847-1852
CREATE TABLE `patronimage` ( -- information related to patron images
Link Here
|
| 1847 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1847 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1848 |
|
1848 |
|
| 1849 |
-- |
1849 |
-- |
|
|
1850 |
-- Table structure for table `recalls` |
| 1851 |
-- |
| 1852 |
|
| 1853 |
DROP TABLE IF EXISTS `recalls`; |
| 1854 |
CREATE TABLE `recalls` ( -- information related to recalls in Koha |
| 1855 |
`recall_id` int(11) NOT NULL auto_increment, -- primary key |
| 1856 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron requested a recall |
| 1857 |
`recalldate` date default NULL, -- the date the recall request was placed |
| 1858 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this request is for |
| 1859 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick up their recall from |
| 1860 |
`cancellationdate` date default NULL, -- the date this recall was cancelled |
| 1861 |
`recallnotes` mediumtext, -- notes related to this recall |
| 1862 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
| 1863 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the recall is after it has been requested. R=requested, O=overdue, W=awaiting pickup, E=expired |
| 1864 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this recall was last updated |
| 1865 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the recall request was placed on |
| 1866 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
| 1867 |
`expirationdate` DATE DEFAULT NULL, -- the date the recall expires |
| 1868 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- the optional itemtype of the item the patron is requesting |
| 1869 |
PRIMARY KEY (`recall_id`), |
| 1870 |
KEY `priorityfoundidx` (priority,found), |
| 1871 |
KEY `borrowernumber` (`borrowernumber`), |
| 1872 |
KEY `biblionumber` (`biblionumber`), |
| 1873 |
KEY `itemnumber` (`itemnumber`), |
| 1874 |
KEY `branchcode` (`branchcode`), |
| 1875 |
KEY `itemtype` (`itemtype`), |
| 1876 |
CONSTRAINT `recalls_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1877 |
CONSTRAINT `recalls_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1878 |
CONSTRAINT `recalls_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1879 |
CONSTRAINT `recalls_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1880 |
CONSTRAINT `recalls_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1881 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1882 |
|
| 1883 |
-- |
| 1884 |
-- Table structure for table `old_recalls` |
| 1885 |
-- |
| 1886 |
|
| 1887 |
DROP TABLE IF EXISTS `old_recalls`; |
| 1888 |
CREATE TABLE `old_recalls` ( -- information related to recalls in Koha |
| 1889 |
`recall_id` int(11) NOT NULL auto_increment, -- primary key |
| 1890 |
`borrowernumber` int(11) NULL default 0, -- foreign key from the borrowers table defining which patron requested a recall |
| 1891 |
`recalldate` date default NULL, -- the date the recall request was placed |
| 1892 |
`biblionumber` int(11) NULL default 0, -- foreign key from the biblio table defining which bib record this request is for |
| 1893 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick up their recall from |
| 1894 |
`cancellationdate` date default NULL, -- the date this recall was cancelled |
| 1895 |
`recallnotes` mediumtext, -- notes related to this recall |
| 1896 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
| 1897 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the recall is after it has been requested. R=requested, O=overdue, W=awaiting pickup, E=expired |
| 1898 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this recall was last updated |
| 1899 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the recall request was placed on |
| 1900 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
| 1901 |
`expirationdate` DATE DEFAULT NULL, -- the date the recall expires |
| 1902 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- the optional itemtype of the item the patron is requesting |
| 1903 |
PRIMARY KEY (`recall_id`), |
| 1904 |
KEY `old_recalls_borrowernumber` (`borrowernumber`), |
| 1905 |
KEY `old_recalls_biblionumber` (`biblionumber`), |
| 1906 |
KEY `old_recalls_itemnumber` (`itemnumber`), |
| 1907 |
KEY `old_recalls_branchcode` (`branchcode`), |
| 1908 |
KEY `old_recalls_itemtype` (`itemtype`), |
| 1909 |
CONSTRAINT `old_recalls_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
| 1910 |
CONSTRAINT `old_recalls_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
| 1911 |
CONSTRAINT `old_recalls_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
| 1912 |
CONSTRAINT `old_recalls_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL |
| 1913 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1914 |
|
| 1915 |
-- |
| 1850 |
-- Table structure for table `reserves` |
1916 |
-- Table structure for table `reserves` |
| 1851 |
-- |
1917 |
-- |
| 1852 |
|
1918 |
|
| 1853 |
- |
|
|