NAME

Koha::Schema::Result::Subscription

TABLE: `subscription`

ACCESSORS

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

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

subscriptionid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique key for this subscription

librarian

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 1
  size: 100

the librarian's username from borrowers.userid

startdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

start date for this subscription

aqbooksellerid

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

foreign key for aqbooksellers.id to link to the vendor

cost

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

aqbudgetid

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

weeklength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

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

monthlength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

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

numberlength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

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

periodicity

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

frequency type links to subscription_frequencies.id

countissuesperunit

  data_type: 'integer'
  default_value: 1
  is_nullable: 0

notes

  data_type: 'longtext'
  is_nullable: 1

notes

status

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 100

status of this subscription

lastvalue1

  data_type: 'integer'
  is_nullable: 1

innerloop1

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

lastvalue2

  data_type: 'integer'
  is_nullable: 1

innerloop2

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

lastvalue3

  data_type: 'integer'
  is_nullable: 1

innerloop3

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

firstacquidate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

first issue received date

manualhistory

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

yes or no to managing the history manually

irregularity

  data_type: 'mediumtext'
  is_nullable: 1

any irregularities in the subscription

skip_serialseq

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

letter

  data_type: 'varchar'
  is_nullable: 1
  size: 20

numberpattern

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

the numbering pattern used links to subscription_numberpatterns.id

locale

  data_type: 'varchar'
  is_nullable: 1
  size: 80

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

distributedto

  data_type: 'mediumtext'
  is_nullable: 1

internalnotes

  data_type: 'longtext'
  is_nullable: 1

callnumber

  data_type: 'mediumtext'
  is_nullable: 1

default call number

location

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 1
  size: 80

default shelving location (items.location)

branchcode

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

default branches (items.homebranch)

lastbranch

  data_type: 'varchar'
  is_nullable: 1
  size: 10

serialsadditems

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

does receiving this serial create an item record

staffdisplaycount

  data_type: 'integer'
  is_nullable: 1

how many issues to show to the staff

opacdisplaycount

  data_type: 'integer'
  is_nullable: 1

how many issues to show to the public

graceperiod

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

grace period in days

enddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

subscription end date

closed

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

yes / no if the subscription is closed

reneweddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date of last renewal for the subscription

itemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

previousitemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

mana_id

  data_type: 'integer'
  is_nullable: 1

ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 80

collection code to assign to serial items

published_on_template

  data_type: 'text'
  is_nullable: 1

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

PRIMARY KEY

"subscriptionid"

RELATIONS

aqorders

Type: has_many

Related object: Koha::Schema::Result::Aqorder

biblionumber

Type: belongs_to

Related object: Koha::Schema::Result::Biblio

numberpattern

Type: belongs_to

periodicity

Type: belongs_to

serials

Type: has_many

Related object: Koha::Schema::Result::Serial

subscriptionhistory

Type: might_have

subscriptionroutinglists

Type: has_many