Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
biblionumber | INT | 10 | null |
|
|
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) |