Lines 4128-4134
CREATE TABLE illrequests (
Link Here
|
4128 |
completed date DEFAULT NULL, -- Date the request was completed |
4128 |
completed date DEFAULT NULL, -- Date the request was completed |
4129 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4129 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4130 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4130 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4131 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
4131 |
cost varchar(20) DEFAULT NULL, -- Quotes cost of request |
|
|
4132 |
price_paid varchar(20) DEFAULT NULL, -- Final cost of request |
4132 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4133 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4133 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4134 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4134 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4135 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4135 |
- |
|
|