<<

NAME

Koha::Schema::Result::ReturnClaim

TABLE: return_claims

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

Unique ID of the return claim

itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

ID of the item

issue_id

  data_type: 'integer'
  is_nullable: 1

ID of the checkout that triggered the claim

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

ID of the patron

notes

  data_type: 'mediumtext'
  is_nullable: 1

Notes about the claim

created_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Time and date the claim was created

created_by

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

ID of the staff member that registered the claim

updated_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Time and date of the latest change on the claim (notes)

updated_by

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

ID of the staff member that updated the claim

resolution

  data_type: 'varchar'
  is_nullable: 1
  size: 80

Resolution code (RETURN_CLAIM_RESOLUTION AVs)

resolved_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Time and date the claim was resolved

resolved_by

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

ID of the staff member that resolved the claim

PRIMARY KEY

• "id"

UNIQUE CONSTRAINTS

item_issue

• "itemnumber"
• "issue_id"

RELATIONS

borrowernumber

Type: belongs_to

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

created_by

Type: belongs_to

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

itemnumber

Type: belongs_to

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

resolved_by

Type: belongs_to

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

updated_by

Type: belongs_to

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

checkout

Type: belongs_to

Related object: Koha::Schema::Result::Issue

old_checkout

Type: belongs_to

Related object: Koha::Schema::Result::OldIssue

item

Type: belongs_to

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

<<