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 TINYINT 3 0

yes or no to managing the history manually
irregularity MEDIUMTEXT 16777215 √ NULL

any irregularities in the subscription
skip_serialseq TINYINT 3 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 TINYINT 3 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 TINYINT 3 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)
subscription_s_pk Primary key Asc subscriptionid
PRIMARY Must be unique 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