suggestions

0 rows


Columns

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

unique identifier assigned automatically by Koha
suggestedby INT 10 √ null
borrowers.borrowernumber suggestions_ibfk_suggestedby N

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
borrowers.borrowernumber suggestions_ibfk_managedby N

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
borrowers.borrowernumber suggestions_ibfk_acceptedby N

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
borrowers.borrowernumber suggestions_ibfk_rejectedby N

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
lastmodificationby INT 10 √ null
borrowers.borrowernumber suggestions_ibfk_lastmodificationby N

borrowernumber for the librarian who edit the suggestion for the last time
lastmodificationdate DATE 10 √ null

date of the last modification
STATUS VARCHAR 10

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

is the suggestion archived?
note LONGTEXT 2147483647 √ null

note entered on the suggestion
staff_note LONGTEXT 2147483647 √ null

non-public 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()

date and time the suggestion was updated
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
biblio.biblionumber suggestions_ibfk_biblionumber N

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
branches.branchcode suggestions_ibfk_branchcode N

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)

Indexes

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

Relationships

Close relationships within degrees of separation