<<

NAME

Koha::Schema::Result::CourseItem

TABLE: course_items

ACCESSORS

ci_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

course item id

itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

items.itemnumber for the item on reserve

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

biblio.biblionumber for the bibliographic record on reserve

itype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

new itemtype for the item to have while on reserve (optional)

itype_enabled

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

indicates if itype should be changed while on course reserve

itype_storage

  data_type: 'varchar'
  is_nullable: 1
  size: 10

a place to store the itype when item is on course reserve

ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 80

new category code for the item to have while on reserve (optional)

ccode_enabled

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

indicates if ccode should be changed while on course reserve

ccode_storage

  data_type: 'varchar'
  is_nullable: 1
  size: 80

a place to store the ccode when item is on course reserve

homebranch

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

new home branch for the item to have while on reserve (optional)

homebranch_enabled

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

indicates if homebranch should be changed while on course reserve

homebranch_storage

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

a place to store the homebranch when item is on course reserve

holdingbranch

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

new holding branch for the item to have while on reserve (optional)

holdingbranch_enabled

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

indicates if itype should be changed while on course reserve

holdingbranch_storage

  data_type: 'varchar'
  is_nullable: 1
  size: 10

a place to store the holdingbranch when item is on course reserve

location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

new shelving location for the item to have while on reseve (optional)

location_enabled

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

indicates if itype should be changed while on course reserve

location_storage

  data_type: 'varchar'
  is_nullable: 1
  size: 80

a place to store the location when the item is on course reserve

enabled

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

if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'

timestamp

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

PRIMARY KEY

UNIQUE CONSTRAINTS

itemnumber

RELATIONS

biblionumber

Type: belongs_to

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

course_reserves

Type: has_many

Related object: Koha::Schema::Result::CourseReserve

holdingbranch

Type: belongs_to

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

homebranch

Type: belongs_to

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

homebranch_storage

Type: belongs_to

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

itemnumber

Type: belongs_to

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

<<