Lines 1208-1214
CREATE TABLE `bookings` (
Link Here
|
1208 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this booking is for', |
1208 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this booking is for', |
1209 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this booking is on', |
1209 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this booking is on', |
1210 |
`item_id` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed a booking for', |
1210 |
`item_id` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed a booking for', |
1211 |
`pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for booking pickup library', |
1211 |
`pickup_library_id` varchar(10) NOT NULL COMMENT 'Identifier for booking pickup library', |
1212 |
`start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', |
1212 |
`start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', |
1213 |
`end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', |
1213 |
`end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', |
1214 |
PRIMARY KEY (`booking_id`), |
1214 |
PRIMARY KEY (`booking_id`), |
1215 |
- |
|
|