<<

NAME

Koha::Schema::Result::Issue

TABLE: issues

ACCESSORS

issue_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key for issues table

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

foreign key, linking this to the borrowers table for the patron this item was checked out to

issuer_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key, linking this to the borrowers table for the user who checked out this item

itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

foreign key, linking this to the items table for the item that was checked out

date_due

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

datetime the item is due (yyyy-mm-dd hh:mm::ss)

branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key, linking to the branches table for the location the item was checked out

returndate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the item was returned, will be NULL until moved to old_issues

lastreneweddate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the item was last renewed

renewals_count

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

lists the number of times the item was renewed

unseen_renewals

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

lists the number of consecutive times the item was renewed without being seen

auto_renew

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 1

automatic renewal

auto_renew_error

  data_type: 'varchar'
  is_nullable: 1
  size: 32

automatic renewal error

timestamp

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

the date and time this record was last touched

issuedate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the item was checked out or issued

onsite_checkout

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

in house use flag

note

  data_type: 'longtext'
  is_nullable: 1

issue note text

notedate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

datetime of issue note (yyyy-mm-dd hh:mm::ss)

noteseen

  data_type: 'integer'
  is_nullable: 1

describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null

PRIMARY KEY

UNIQUE CONSTRAINTS

itemnumber

RELATIONS

accountlines

Type: has_many

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

borrowernumber

Type: belongs_to

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

issuer

Type: belongs_to

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

itemnumber

Type: belongs_to

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

renewals

Type: has_many

Related object: Koha::Schema::Result::CheckoutRenewal

return_claim

Type: might_have

Related object: Koha::Schema::Result::ReturnClaim

<<