subscription

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biblionumber INT 10 null
biblio.biblionumber subscription_ibfk_3 C

foreign key for biblio.biblionumber that this subscription is attached to
subscriptionid INT 10 √ null
aqorders.subscriptionid aqorders_subscriptionid N
serial.subscriptionid serial_ibfk_2 C
subscriptionhistory.subscriptionid subscription_history_ibfk_2 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 √ null
aqbooksellers.id subscription_ibfk_4 N

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

status of this subscription
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 INT 10 √ null

how many issues to show to the staff
opacdisplaycount INT 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 BIT 0 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
ccode VARCHAR 80 √ null

collection code to assign to serial items
published_on_template TEXT 65535 √ null

Template Toolkit syntax to generate the default “Published on (text)” field when receiving an issue this serial

Indexes

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

Relationships

Close relationships within degrees of separation