| 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 | √ | null |
|
|
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) |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | subscriptionid |
| subscription_ibfk_1 | Performance | Asc | periodicity |
| subscription_ibfk_2 | Performance | Asc | numberpattern |
| subscription_ibfk_3 | Performance | Asc | biblionumber |
| subscription_ibfk_4 | Performance | Asc | aqbooksellerid |
