Table testsql_comments.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
mailoverseeing smallint 5  √  0
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 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 3  √  null 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 18:01 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
suggestionid Primary key Asc PRIMARY
managedby Performance Asc managedby
suggestedby Performance Asc suggestedby

Close relationships: