<<

NAME

Koha::Schema::Result::ArticleRequest

TABLE: article_requests

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

title

  data_type: 'mediumtext'
  is_nullable: 1

author

  data_type: 'mediumtext'
  is_nullable: 1

volume

  data_type: 'mediumtext'
  is_nullable: 1

issue

  data_type: 'mediumtext'
  is_nullable: 1

date

  data_type: 'mediumtext'
  is_nullable: 1

pages

  data_type: 'mediumtext'
  is_nullable: 1

chapters

  data_type: 'mediumtext'
  is_nullable: 1

patron_notes

  data_type: 'mediumtext'
  is_nullable: 1

status

  data_type: 'enum'
  default_value: 'REQUESTED'
  extra: {list => ["REQUESTED","PENDING","PROCESSING","COMPLETED","CANCELED"]}
  is_nullable: 0

notes

  data_type: 'mediumtext'
  is_nullable: 1

format

  data_type: 'enum'
  default_value: 'PHOTOCOPY'
  extra: {list => ["PHOTOCOPY","SCAN"]}
  is_nullable: 0

urls

  data_type: 'mediumtext'
  is_nullable: 1

cancellation_reason

  data_type: 'varchar'
  is_nullable: 1
  size: 80

optional authorised value AR_CANCELLATION

debit_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Debit line with cost for article scan request

created_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Be careful with two timestamps in one table not allowing NULL

updated_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

toc_request

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

borrower requested table of contents

PRIMARY KEY

RELATIONS

biblionumber

Type: belongs_to

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

borrowernumber

Type: belongs_to

Related object: Koha::Schema::Result::Borrower

branchcode

Type: belongs_to

Related object: Koha::Schema::Result::Branch

debit

Type: belongs_to

Related object: Koha::Schema::Result::Accountline

itemnumber

Type: belongs_to

Related object: Koha::Schema::Result::Item

<<