suggestions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
suggestionid INT 10 √ null

unique identifier assigned automatically by Koha
suggestedby INT 10 0

borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
suggesteddate DATE 10 null

date the suggestion was submitted
managedby INT 10 √ null

borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
manageddate DATE 10 √ null

date the suggestion was updated
acceptedby INT 10 √ null

borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
accepteddate DATE 10 √ null

date the suggestion was marked as accepted
rejectedby INT 10 √ null

borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table
rejecteddate DATE 10 √ null

date the suggestion was marked as rejected
STATUS VARCHAR 10

suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
note LONGTEXT 2147483647 √ null

note entered on the suggestion
author VARCHAR 80 √ null

author of the suggested item
title VARCHAR 255 √ null

title of the suggested item
copyrightdate SMALLINT 5 √ null

copyright date of the suggested item
publishercode VARCHAR 255 √ null

publisher of the suggested item
date TIMESTAMP 19 current_timestamp()
volumedesc VARCHAR 255 √ null
publicationyear SMALLINT 5 √ 0
place VARCHAR 255 √ null

publication place of the suggested item
isbn VARCHAR 30 √ null
social_data.isbn Implied Constraint R

isbn of the suggested item
biblionumber INT 10 √ null

foreign key linking the suggestion to the biblio table after the suggestion has been ordered
reason MEDIUMTEXT 16777215 √ null

reason for accepting or rejecting the suggestion
patronreason MEDIUMTEXT 16777215 √ null

reason for making the suggestion
budgetid INT 10 √ null
aqbudgets.budget_id suggestions_budget_id_fk N

foreign key linking the suggested budget to the aqbudgets table
branchcode VARCHAR 10 √ null

foreign key linking the suggested branch to the branches table
collectiontitle MEDIUMTEXT 16777215 √ null

collection name for the suggested item
itemtype VARCHAR 30 √ null

suggested item type
quantity SMALLINT 5 √ null

suggested quantity to be purchased
currency VARCHAR 10 √ null
currency.currency Implied Constraint R

suggested currency for the suggested price
price DECIMAL 28,6 √ null

suggested price
total DECIMAL 28,6 √ null

suggested total cost (price*quantity updated for currency)

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc suggestionid
biblionumber Performance Asc biblionumber
branchcode Performance Asc branchcode
managedby Performance Asc managedby
status Performance Asc STATUS
suggestedby Performance Asc suggestedby
suggestions_budget_id_fk Performance Asc budgetid

Relationships

Close relationships within degrees of separation