|
Lines 4134-4139
CREATE TABLE illrequests (
Link Here
|
| 4134 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
4134 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
| 4135 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
4135 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
| 4136 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
4136 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
|
|
4137 |
status_alias integer DEFAULT NULL, -- Foreign key to relevant authorised_values.id |
| 4137 |
placed date DEFAULT NULL, -- Date the request was placed |
4138 |
placed date DEFAULT NULL, -- Date the request was placed |
| 4138 |
replied date DEFAULT NULL, -- Last API response |
4139 |
replied date DEFAULT NULL, -- Last API response |
| 4139 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
4140 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
|
Lines 4154-4159
CREATE TABLE illrequests (
Link Here
|
| 4154 |
FOREIGN KEY (`branchcode`) |
4155 |
FOREIGN KEY (`branchcode`) |
| 4155 |
REFERENCES `branches` (`branchcode`) |
4156 |
REFERENCES `branches` (`branchcode`) |
| 4156 |
ON UPDATE CASCADE ON DELETE CASCADE |
4157 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
|
4158 |
CONSTRAINT `illrequests_safk` |
| 4159 |
FOREIGN KEY (`status_alias`) |
| 4160 |
REFERENCES `authorised_values` (`id`) |
| 4161 |
ON DELETE SET NULL |
| 4157 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4162 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4158 |
|
4163 |
|
| 4159 |
-- |
4164 |
-- |
| 4160 |
- |
|
|