Koha::Schema::Result::OldReserve
old_reserves
data_type: 'integer' is_nullable: 0
primary key
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
foreign key from the borrowers table defining which patron this hold is for
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date the hold was places
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
foreign key from the biblio table defining which bib record this hold is on
data_type: 'integer' is_nullable: 1
links the hold to the deleted bibliographic record (deletedbiblio.biblionumber)
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
data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 size: 10
foreign key from the branches table defining which branch the patron wishes to pick this hold up at
data_type: 'integer' is_nullable: 1
foreign key from the desks table defining which desk the patron should pick this hold up at
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
currently unused
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
currently unused
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date this hold was cancelled
data_type: 'varchar' is_nullable: 1 size: 80
optional authorised value CANCELLATION_REASON
data_type: 'longtext' is_nullable: 1
notes related to this hold
data_type: 'smallint' default_value: 1 is_nullable: 0
where in the queue the patron sits
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
data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0
the date and time this hold was last updated
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
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
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)
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
accessor: 'lowest_priority' data_type: 'tinyint' default_value: 0 is_nullable: 0
has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
data_type: 'tinyint' default_value: 0 is_nullable: 0
in this hold suspended (1 for yes, 0 for no)
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
the date this hold is suspended until (NULL for infinitely)
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
data_type: 'tinyint' default_value: 0 is_nullable: 0
Is the hold placed at item level
data_type: 'tinyint' default_value: 0 is_nullable: 0
Is this a non priority hold
Type: belongs_to
Related object: Koha::Schema::Result::Biblio
Type: belongs_to
Related object: Koha::Schema::Result::Borrower
Type: belongs_to
Related object: Koha::Schema::Result::Branch
Type: belongs_to
Related object: Koha::Schema::Result::ItemGroup
Type: belongs_to
Related object: Koha::Schema::Result::Item
Type: belongs_to
Related object: Koha::Schema::Result::Itemtype