suggestions


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

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
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)

Table contained 0 rows

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