| booking_id |
INT |
10 |
|
√ |
null |
|
|
primary key |
| patron_id |
INT |
10 |
|
|
0 |
|
|
foreign key from the borrowers table defining which patron this booking is for |
| biblio_id |
INT |
10 |
|
|
0 |
|
| biblio.biblionumber |
bookings_ibfk_2 |
C |
|
foreign key from the biblio table defining which bib record this booking is on |
| item_id |
INT |
10 |
√ |
|
null |
|
| items.itemnumber |
bookings_ibfk_3 |
C |
|
foreign key from the items table defining the specific item the patron has placed a booking for |
| pickup_library_id |
VARCHAR |
10 |
|
|
null |
|
|
Identifier for booking pickup library |
| start_date |
DATETIME |
19 |
√ |
|
null |
|
|
the start date of the booking |
| end_date |
DATETIME |
19 |
√ |
|
null |
|
|
the end date of the booking |
| creation_date |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
the timestamp for when a booking was created |
| modification_date |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
the timestamp for when a booking has been updated |
| status |
enum('new', 'cancelled', 'completed') |
9 |
|
|
new |
|
|
current status of the booking |
