Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| biblionumber | INT | 10 | 0 |
|
|
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) |
|||||
| periodicity | INT | 10 | √ | null |
|
|
frequency type links to subscription_frequencies.id |
|||||
| countissuesperunit | INT | 10 | 1 |
|
|
|||||||
| notes | LONGTEXT | 2147483647 | √ | null |
|
|
notes |
|||||
| status | VARCHAR | 100 |
|
|
||||||||
| lastvalue1 | INT | 10 | √ | null |
|
|
||||||
| innerloop1 | INT | 10 | √ | 0 |
|
|
||||||
| lastvalue2 | INT | 10 | √ | null |
|
|
||||||
| innerloop2 | INT | 10 | √ | 0 |
|
|
||||||
| lastvalue3 | INT | 10 | √ | null |
|
|
||||||
| innerloop3 | INT | 10 | √ | 0 |
|
|
||||||
| firstacquidate | DATE | 10 | √ | null |
|
|
first issue received date |
|||||
| manualhistory | BIT | 0 | 0 |
|
|
yes or no to managing the history manually |
||||||
| irregularity | MEDIUMTEXT | 16777215 | √ | null |
|
|
any irregularities in the subscription |
|||||
| skip_serialseq | BIT | 0 | 0 |
|
|
|||||||
| letter | VARCHAR | 20 | √ | null |
|
|
||||||
| numberpattern | INT | 10 | √ | null |
|
|
the numbering pattern used links to subscription_numberpatterns.id |
|||||
| locale | VARCHAR | 80 | √ | null |
|
|
for foreign language subscriptions to display months, seasons, etc correctly |
|||||
| distributedto | MEDIUMTEXT | 16777215 | √ | null |
|
|
||||||
| internalnotes | LONGTEXT | 2147483647 | √ | null |
|
|
||||||
| callnumber | MEDIUMTEXT | 16777215 | √ | null |
|
|
default call number |
|||||
| location | VARCHAR | 80 | √ |
|
|
default shelving location (items.location) |
||||||
| branchcode | VARCHAR | 10 |
|
|
default branches (items.homebranch) |
|||||||
| lastbranch | VARCHAR | 10 | √ | null |
|
|
||||||
| serialsadditems | BIT | 0 | 0 |
|
|
does receiving this serial create an item record |
||||||
| staffdisplaycount | VARCHAR | 10 | √ | null |
|
|
how many issues to show to the staff |
|||||
| opacdisplaycount | VARCHAR | 10 | √ | null |
|
|
how many issues to show to the public |
|||||
| graceperiod | INT | 10 | 0 |
|
|
grace period in days |
||||||
| enddate | DATE | 10 | √ | null |
|
|
subscription end date |
|||||
| closed | INT | 10 | 0 |
|
|
yes / no if the subscription is closed |
||||||
| reneweddate | DATE | 10 | √ | null |
|
|
date of last renewal for the subscription |
|||||
| itemtype | VARCHAR | 10 | √ | null |
|
|
||||||
| previousitemtype | VARCHAR | 10 | √ | null |
|
|
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | subscriptionid |
| by_biblionumber | Performance | Asc | biblionumber |
| subscription_ibfk_1 | Performance | Asc | periodicity |
| subscription_ibfk_2 | Performance | Asc | numberpattern |
Relationships
Close relationships within degrees of separation
