|
Lines 4167-4172
CREATE TABLE illrequests (
Link Here
|
| 4167 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
4167 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
| 4168 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
4168 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
| 4169 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
4169 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
|
|
4170 |
status_alias integer DEFAULT NULL, -- Foreign key to relevant authorised_values.id |
| 4170 |
placed date DEFAULT NULL, -- Date the request was placed |
4171 |
placed date DEFAULT NULL, -- Date the request was placed |
| 4171 |
replied date DEFAULT NULL, -- Last API response |
4172 |
replied date DEFAULT NULL, -- Last API response |
| 4172 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
4173 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
|
Lines 4188-4193
CREATE TABLE illrequests (
Link Here
|
| 4188 |
FOREIGN KEY (`branchcode`) |
4189 |
FOREIGN KEY (`branchcode`) |
| 4189 |
REFERENCES `branches` (`branchcode`) |
4190 |
REFERENCES `branches` (`branchcode`) |
| 4190 |
ON UPDATE CASCADE ON DELETE CASCADE |
4191 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
|
4192 |
CONSTRAINT `illrequests_safk` |
| 4193 |
FOREIGN KEY (`status_alias`) |
| 4194 |
REFERENCES `authorised_values` (`id`) |
| 4195 |
ON DELETE SET NULL |
| 4191 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4196 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4192 |
|
4197 |
|
| 4193 |
-- |
4198 |
-- |
| 4194 |
- |
|
|