NAME

Koha::Schema::Result::Subscription

TABLE: `subscription`

ACCESSORS

biblionumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

subscriptionid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

librarian

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

startdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

aqbooksellerid

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

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

monthlength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

numberlength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

periodicity

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

countissuesperunit

  data_type: 'integer'
  default_value: 1
  is_nullable: 0

notes

  data_type: 'longtext'
  is_nullable: 1

status

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

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

manualhistory

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

irregularity

  data_type: 'mediumtext'
  is_nullable: 1

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

locale

  data_type: 'varchar'
  is_nullable: 1
  size: 80

distributedto

  data_type: 'mediumtext'
  is_nullable: 1

internalnotes

  data_type: 'longtext'
  is_nullable: 1

callnumber

  data_type: 'mediumtext'
  is_nullable: 1

location

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

branchcode

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

lastbranch

  data_type: 'varchar'
  is_nullable: 1
  size: 10

serialsadditems

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

staffdisplaycount

  data_type: 'varchar'
  is_nullable: 1
  size: 10

opacdisplaycount

  data_type: 'varchar'
  is_nullable: 1
  size: 10

graceperiod

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

enddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

closed

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

reneweddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

itemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

previousitemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

PRIMARY KEY

"subscriptionid"

RELATIONS

aqorders

Type: has_many

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

numberpattern

Type: belongs_to

periodicity

Type: belongs_to

subscriptionroutinglists

Type: has_many