Lines 3016-3022
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
3016 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
3016 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
3017 |
lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time |
3017 |
lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time |
3018 |
lastmodificationdate date default NULL, -- date of the last modification |
3018 |
lastmodificationdate date default NULL, -- date of the last modification |
3019 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
3019 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category) |
3020 |
`archived` TINYINT(1) NOT NULL DEFAULT 0, -- is the suggestion archived? |
3020 |
`archived` TINYINT(1) NOT NULL DEFAULT 0, -- is the suggestion archived? |
3021 |
`note` LONGTEXT, -- note entered on the suggestion |
3021 |
`note` LONGTEXT, -- note entered on the suggestion |
3022 |
`author` varchar(80) default NULL, -- author of the suggested item |
3022 |
`author` varchar(80) default NULL, -- author of the suggested item |
3023 |
- |
|
|