Lines 3012-3018
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
3012 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
3012 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
3013 |
lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time |
3013 |
lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time |
3014 |
lastmodificationdate date default NULL, -- date of the last modification |
3014 |
lastmodificationdate date default NULL, -- date of the last modification |
3015 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
3015 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category) |
3016 |
`note` LONGTEXT, -- note entered on the suggestion |
3016 |
`note` LONGTEXT, -- note entered on the suggestion |
3017 |
`author` varchar(80) default NULL, -- author of the suggested item |
3017 |
`author` varchar(80) default NULL, -- author of the suggested item |
3018 |
`title` varchar(255) default NULL, -- title of the suggested item |
3018 |
`title` varchar(255) default NULL, -- title of the suggested item |
3019 |
- |
|
|