Lines 4150-4156
CREATE TABLE illrequests (
Link Here
|
4150 |
completed date DEFAULT NULL, -- Date the request was completed |
4150 |
completed date DEFAULT NULL, -- Date the request was completed |
4151 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4151 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4152 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4152 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4153 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
4153 |
cost varchar(20) DEFAULT NULL, -- Quotes cost of request |
|
|
4154 |
price_paid varchar(20) DEFAULT NULL, -- Final cost of request |
4154 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4155 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4155 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4156 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4156 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4157 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4157 |
- |
|
|