subscription


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
aqorders.subscriptionid aqorders_subscriptionid C
subscriptionroutinglist.subscriptionid subscriptionroutinglist_ibfk_2 C

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
subscription_frequencies.id subscription_ibfk_1 N

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
subscription_numberpatterns.id subscription_ibfk_2 N

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
itemtypes.itemtype Implied Constraint R
previousitemtype VARCHAR 10 null
mana_id INT 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