Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
|
|
foreign key from the biblio table defining which bib record this booking is on |
|||||
item_id | INT | 10 | √ | null |
|
|
foreign key from the items table defining the specific item the patron has placed a booking for |
||||
start_date | DATETIME | 19 | √ | null |
|
|
the start date of the booking |
||||
end_date | DATETIME | 19 | √ | null |
|
|
the end date of the booking |