<<

NAME

Koha::Schema::Result::Illrequest

TABLE: illrequests

ACCESSORS

illrequest_id

  data_type: 'bigint'
  extra: {unsigned => 1}
  is_auto_increment: 1
  is_nullable: 0

ILL request number

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Patron associated with request

biblio_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Potential bib linked to request

deleted_biblio_id

  data_type: 'integer'
  is_nullable: 1

Deleted bib linked to request

due_date

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Custom date due specified by backend, leave NULL for default date_due calculation

branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 0
  size: 50

The branch associated with the request

status

  data_type: 'varchar'
  is_nullable: 1
  size: 50

Current Koha status of request

status_alias

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

Foreign key to relevant authorised_values.authorised_value

placed

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Date the request was placed

replied

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Last API response

updated

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

completed

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Date the request was completed

medium

  data_type: 'varchar'
  is_nullable: 1
  size: 30

The Koha request type

accessurl

  data_type: 'varchar'
  is_nullable: 1
  size: 500

Potential URL for accessing item

cost

  data_type: 'varchar'
  is_nullable: 1
  size: 20

Quotes cost of request

price_paid

  data_type: 'varchar'
  is_nullable: 1
  size: 20

Final cost of request

notesopac

  data_type: 'mediumtext'
  is_nullable: 1

Patron notes attached to request

notesstaff

  data_type: 'mediumtext'
  is_nullable: 1

Staff notes attached to request

orderid

  data_type: 'varchar'
  is_nullable: 1
  size: 50

Backend id attached to request

backend

  data_type: 'varchar'
  is_nullable: 1
  size: 20

The backend used to create request

batch_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Optional ID of batch that this request belongs to

PRIMARY KEY

• "illrequest_id"

RELATIONS

batch

Type: belongs_to

Related object: Koha::Schema::Result::Illbatch

biblio

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

illcomments

Type: has_many

Related object: Koha::Schema::Result::Illcomment

illrequestattributes

Type: has_many

Related object: Koha::Schema::Result::Illrequestattribute

status_alias

Type: belongs_to

Related object: Koha::Schema::Result::AuthorisedValue

<<