<<

NAME

Koha::Schema::Result::Serial

TABLE: serial

ACCESSORS

serialid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique key for the issue

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

foreign key for the biblio.biblionumber that this issue is attached to

subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

foreign key to the subscription.subscriptionid that this issue is part of

serialseq

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

issue information (volume, number, etc)

serialseq_x

  data_type: 'varchar'
  is_nullable: 1
  size: 100

first part of issue information

serialseq_y

  data_type: 'varchar'
  is_nullable: 1
  size: 100

second part of issue information

serialseq_z

  data_type: 'varchar'
  is_nullable: 1
  size: 100

third part of issue information

status

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

status code for this issue (see manual for full descriptions)

planneddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date expected

notes

  data_type: 'mediumtext'
  is_nullable: 1

notes

publisheddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date published

publisheddatetext

  data_type: 'varchar'
  is_nullable: 1
  size: 100

date published (descriptive)

claimdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date claimed

claims_count

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

number of claims made related to this issue

routingnotes

  data_type: 'mediumtext'
  is_nullable: 1

notes from the routing list

PRIMARY KEY

RELATIONS

biblionumber

Type: belongs_to

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

serialitems

Type: has_many

Related object: Koha::Schema::Result::Serialitem

subscriptionid

Type: belongs_to

Related object: Koha::Schema::Result::Subscription

<<