Lines 4389-4395
CREATE TABLE `reserves` (
Link Here
|
4389 |
`borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for', |
4389 |
`borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for', |
4390 |
`reservedate` date DEFAULT NULL COMMENT 'the date the hold was placed', |
4390 |
`reservedate` date DEFAULT NULL COMMENT 'the date the hold was placed', |
4391 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this hold is on', |
4391 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this hold is on', |
4392 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at', |
4392 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0 COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at', |
4393 |
`desk_id` int(11) DEFAULT NULL COMMENT 'foreign key from the desks table defining which desk the patron should pick this hold up at', |
4393 |
`desk_id` int(11) DEFAULT NULL COMMENT 'foreign key from the desks table defining which desk the patron should pick this hold up at', |
4394 |
`notificationdate` date DEFAULT NULL COMMENT 'currently unused', |
4394 |
`notificationdate` date DEFAULT NULL COMMENT 'currently unused', |
4395 |
`reminderdate` date DEFAULT NULL COMMENT 'currently unused', |
4395 |
`reminderdate` date DEFAULT NULL COMMENT 'currently unused', |
4396 |
- |
|
|