rejecteddate date default NULL, -- date the suggestion was marked as rejected
lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time
lastmodificationdate date default NULL, -- date of the last modification
- `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
+ `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)
`archived` TINYINT(1) NOT NULL DEFAULT 0, -- is the suggestion archived?
`note` LONGTEXT, -- note entered on the suggestion
`author` varchar(80) default NULL, -- author of the suggested item