Lines 1224-1230
CREATE TABLE `bookings` (
Link Here
|
1224 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this booking is for', |
1224 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this booking is for', |
1225 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this booking is on', |
1225 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this booking is on', |
1226 |
`item_id` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed a booking for', |
1226 |
`item_id` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed a booking for', |
1227 |
`pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for booking pickup library', |
1227 |
`pickup_library_id` varchar(10) NOT NULL COMMENT 'Identifier for booking pickup library', |
1228 |
`start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', |
1228 |
`start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', |
1229 |
`end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', |
1229 |
`end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', |
1230 |
PRIMARY KEY (`booking_id`), |
1230 |
PRIMARY KEY (`booking_id`), |
1231 |
- |
|
|