Lines 4143-4149
CREATE TABLE illrequests (
Link Here
|
4143 |
completed date DEFAULT NULL, -- Date the request was completed |
4143 |
completed date DEFAULT NULL, -- Date the request was completed |
4144 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4144 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4145 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4145 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4146 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
4146 |
cost varchar(20) DEFAULT NULL, -- Quotes cost of request |
|
|
4147 |
price_paid varchar(20) DEFAULT NULL, -- Final cost of request |
4147 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4148 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4148 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4149 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4149 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4150 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4150 |
- |
|
|