<<

NAME

Koha::Schema::Result::Reserve

TABLE: reserves

ACCESSORS

reserve_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

borrowernumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

foreign key from the borrowers table defining which patron this hold is for

reservedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the hold was placed

biblionumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

foreign key from the biblio table defining which bib record this hold is on

deleted_biblionumber

  data_type: 'integer'
  is_nullable: 1

links the hold to the deleted bibliographic record (deletedbiblio.biblionumber)

item_group_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key from the item_groups table defining if this is an item group level hold

branchcode

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

foreign key from the branches table defining which branch the patron wishes to pick this hold up at

desk_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key from the desks table defining which desk the patron should pick this hold up at

notificationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

currently unused

reminderdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

currently unused

cancellationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date this hold was cancelled

cancellation_reason

  data_type: 'varchar'
  is_nullable: 1
  size: 80

optional authorised value CANCELLATION_REASON

reservenotes

  data_type: 'longtext'
  is_nullable: 1

notes related to this hold

priority

  data_type: 'smallint'
  default_value: 1
  is_nullable: 0

where in the queue the patron sits

found

  data_type: 'varchar'
  is_nullable: 1
  size: 1

a one letter code defining what the status is of the hold is after it has been confirmed

timestamp

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

the date and time this hold was last updated

itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with

waitingdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was marked as waiting for the patron at the library

expirationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the hold expires (calculated value)

patron_expiration_date

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the hold expires - usually the date entered by the patron to say they don't need the hold after a certain date

lowestPriority

  accessor: 'lowest_priority'
  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

suspend

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

suspend_until

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

itemtype

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

If record level hold, the optional itemtype of the item the patron is requesting

item_level_hold

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

Is the hold placed at item level

non_priority

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

Is this a non priority hold

PRIMARY KEY

• "reserve_id"

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

club_holds_to_patron_holds

Type: has_many

Related object: Koha::Schema::Result::ClubHoldsToPatronHold

desk

Type: belongs_to

Related object: Koha::Schema::Result::Desk

item_group

Type: belongs_to

Related object: Koha::Schema::Result::ItemGroup

itemnumber

Type: belongs_to

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

itemtype

Type: belongs_to

Related object: Koha::Schema::Result::Itemtype

<<