Koha::Schema::Result::Issue
issues
data_type: 'integer' is_auto_increment: 1 is_nullable: 0
primary key for issues table
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
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
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
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
datetime the item is due (yyyy-mm-dd hh:mm::ss)
data_type: 'varchar' is_nullable: 1 size: 10
foreign key, linking to the branches table for the location the item was checked out
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
date the item was returned, will be NULL until moved to old_issues
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
date the item was last renewed
data_type: 'tinyint' default_value: 0 is_nullable: 0
lists the number of times the item was renewed
data_type: 'tinyint' default_value: 0 is_nullable: 0
lists the number of consecutive times the item was renewed without being seen
data_type: 'tinyint' default_value: 0 is_nullable: 1
automatic renewal
data_type: 'varchar' is_nullable: 1 size: 32
automatic renewal error
data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0
the date and time this record was last touched
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
date the item was checked out or issued
data_type: 'integer' default_value: 0 is_nullable: 0
in house use flag
data_type: 'longtext' is_nullable: 1
issue note text
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
datetime of issue note (yyyy-mm-dd hh:mm::ss)
data_type: 'integer' is_nullable: 1
describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
itemnumber
Type: has_many
Related object: Koha::Schema::Result::Accountline
Type: belongs_to
Related object: Koha::Schema::Result::Borrower
Type: belongs_to
Related object: Koha::Schema::Result::Borrower
Type: belongs_to
Related object: Koha::Schema::Result::Item
Type: has_many
Related object: Koha::Schema::Result::CheckoutRenewal
Type: might_have
Related object: Koha::Schema::Result::ReturnClaim