7 description: unique identifier assigned automatically by Koha
12 description: patron_id for the person making the suggestion, foreign key linking to the
17 description: the suggestion was submitted
22 description: patron_id for the librarian managing the suggestion, foreign key linking
23 to the borrowers table
29 description: date the suggestion was updated
34 description: patron_id for the librarian who accepted the suggestion, foreign key
35 linking to the borrowers table
41 description: date the suggestion was marked as accepted
46 description: patron_id for the librarian who rejected the suggestion, foreign key
47 linking to the borrowers table
53 description: date the suggestion was marked as rejected
54 last_status_change_by:
58 description: patron the suggestion was last modified by
59 last_status_change_date:
64 description: date the suggestion was last modified
67 description: Suggestion status
77 description: note entered on the suggestion
82 description: author of the suggested item
87 description: title of the suggested item
92 description: copyright date of the suggested item
97 description: publisher of the suggested item
103 description: timestamp of date created
108 description: volume description
113 description: year of publication
118 description: publication place of the suggested item
123 description: isbn of the suggested item
128 description: foreign key linking the suggestion to the biblio table after the
129 suggestion has been ordered
134 description: reason for accepting or rejecting the suggestion
139 description: reason for making the suggestion
144 description: foreign key linking the suggested budget to the aqbudgets table
149 description: foreign key linking the suggested branch to the branches table
154 description: collection name for the suggested item
159 description: suggested item type
164 description: suggested quantity to be purchased
169 description: suggested currency for the suggested price
174 description: suggested price
179 description: suggested total cost (price*quantity updated for currency)
184 description: archived (processed) suggestion
185 additionalProperties: false