<<

NAME

Koha::Schema::Result::Suggestion

TABLE: suggestions

ACCESSORS

suggestionid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique identifier assigned automatically by Koha

suggestedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

borrowernumber for the person making the suggestion, foreign key linking to the borrowers table

suggesteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 0

date the suggestion was submitted

managedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table

manageddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the suggestion was updated

acceptedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table

accepteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the suggestion was marked as accepted

rejectedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table

rejecteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the suggestion was marked as rejected

lastmodificationby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

borrowernumber for the librarian who edit the suggestion for the last time

lastmodificationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date of the last modification

STATUS

  accessor: 'status'
  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)

archived

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

is the suggestion archived?

note

  data_type: 'longtext'
  is_nullable: 1

note entered on the suggestion

staff_note

  data_type: 'longtext'
  is_nullable: 1

non-public note entered on the suggestion

author

  data_type: 'varchar'
  is_nullable: 1
  size: 80

author of the suggested item

title

  data_type: 'varchar'
  is_nullable: 1
  size: 255

title of the suggested item

copyrightdate

  data_type: 'smallint'
  is_nullable: 1

copyright date of the suggested item

publishercode

  data_type: 'varchar'
  is_nullable: 1
  size: 255

publisher of the suggested item

date

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

date and time the suggestion was updated

volumedesc

  data_type: 'varchar'
  is_nullable: 1
  size: 255

publicationyear

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

place

  data_type: 'varchar'
  is_nullable: 1
  size: 255

publication place of the suggested item

isbn

  data_type: 'varchar'
  is_nullable: 1
  size: 30

isbn of the suggested item

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key linking the suggestion to the biblio table after the suggestion has been ordered

reason

  data_type: 'mediumtext'
  is_nullable: 1

reason for accepting or rejecting the suggestion

patronreason

  data_type: 'mediumtext'
  is_nullable: 1

reason for making the suggestion

budgetid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key linking the suggested budget to the aqbudgets table

branchcode

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

foreign key linking the suggested branch to the branches table

collectiontitle

  data_type: 'mediumtext'
  is_nullable: 1

collection name for the suggested item

itemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 30

suggested item type

quantity

  data_type: 'smallint'
  is_nullable: 1

suggested quantity to be purchased

currency

  data_type: 'varchar'
  is_nullable: 1
  size: 10

suggested currency for the suggested price

price

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

suggested price

total

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

suggested total cost (price*quantity updated for currency)

PRIMARY KEY

• "suggestionid"

RELATIONS

acceptedby

Type: belongs_to

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

biblionumber

Type: belongs_to

Related object: Koha::Schema::Result::Biblio

branchcode

Type: belongs_to

Related object: Koha::Schema::Result::Branch

budgetid

Type: belongs_to

Related object: Koha::Schema::Result::Aqbudget

lastmodificationby

Type: belongs_to

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

managedby

Type: belongs_to

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

rejectedby

Type: belongs_to

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

suggestedby

Type: belongs_to

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

<<