| biblionumber |
INT |
10 |
|
|
null |
|
| biblio.biblionumber |
subscription_ibfk_3 |
C |
|
foreign key for biblio.biblionumber that this subscription is attached to |
| subscriptionid |
INT |
10 |
|
√ |
null |
|
|
unique key for this subscription |
| librarian |
VARCHAR |
100 |
√ |
|
|
|
|
the librarian’s username from borrowers.userid |
| startdate |
DATE |
10 |
√ |
|
null |
|
|
start date for this subscription |
| aqbooksellerid |
INT |
10 |
√ |
|
0 |
|
|
foreign key for aqbooksellers.id to link to the vendor |
| cost |
INT |
10 |
√ |
|
0 |
|
|
|
| aqbudgetid |
INT |
10 |
√ |
|
0 |
|
|
|
| weeklength |
INT |
10 |
√ |
|
0 |
|
|
subscription length in weeks (will not be filled in if monthlength or numberlength is set) |
| monthlength |
INT |
10 |
√ |
|
0 |
|
|
subscription length in weeks (will not be filled in if weeklength or numberlength is set) |
| numberlength |
INT |
10 |
√ |
|
0 |
|
|
subscription length in weeks (will not be filled in if monthlength or weeklength is set) |
