subscription

foreign key for biblio.biblionumber that this subscription is attached to

unique key for this subscription

the librarian’s username from borrowers.userid

start date for this subscription

foreign key for aqbooksellers.id to link to the vendor

subscription length in weeks (will not be filled in if monthlength or numberlength is set)

subscription length in weeks (will not be filled in if weeklength or numberlength is set)

subscription length in weeks (will not be filled in if monthlength or weeklength is set)

frequency type links to subscription_frequencies.id

notes

status of this subscription

first issue received date

yes or no to managing the history manually

any irregularities in the subscription

the numbering pattern used links to subscription_numberpatterns.id

for foreign language subscriptions to display months, seasons, etc correctly

default call number

default shelving location (items.location)

default branches (items.homebranch)

does receiving this serial create an item record

how many issues to show to the staff

how many issues to show to the public

grace period in days

subscription end date

yes / no if the subscription is closed

date of last renewal for the subscription