Table testsql_comments.suggestions
purchase suggestions

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
suggestionid int 10  √  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 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 mediumtext 16777215  √  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
deletedbiblio.biblionumber Implied Constraint R
foreign key linking the suggestion to the biblio table after the suggestion has been ordered
reason text 65535  √  null reason for accepting or rejecting the suggestion
patronreason text 65535  √  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 Implied Constraint R
foreign key linking the suggested branch to the branches table
collectiontitle text 65535  √  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 at Tue Dec 27 17:18 NZDT 2016

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

Close relationships  within of separation: