|
Lines 4100-4105
CREATE TABLE illrequests (
Link Here
|
| 4100 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
4100 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
| 4101 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
4101 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
| 4102 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
4102 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
|
|
4103 |
status_alias integer DEFAULT NULL, -- Foreign key to relevant authorised_values.id |
| 4103 |
placed date DEFAULT NULL, -- Date the request was placed |
4104 |
placed date DEFAULT NULL, -- Date the request was placed |
| 4104 |
replied date DEFAULT NULL, -- Last API response |
4105 |
replied date DEFAULT NULL, -- Last API response |
| 4105 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
4106 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
|
Lines 4120-4125
CREATE TABLE illrequests (
Link Here
|
| 4120 |
FOREIGN KEY (`branchcode`) |
4121 |
FOREIGN KEY (`branchcode`) |
| 4121 |
REFERENCES `branches` (`branchcode`) |
4122 |
REFERENCES `branches` (`branchcode`) |
| 4122 |
ON UPDATE CASCADE ON DELETE CASCADE |
4123 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
|
4124 |
CONSTRAINT `illrequests_safk` |
| 4125 |
FOREIGN KEY (`status_alias`) |
| 4126 |
REFERENCES `authorised_values` (`id`) |
| 4127 |
ON DELETE SET NULL |
| 4123 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4128 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4124 |
|
4129 |
|
| 4125 |
-- |
4130 |
-- |
| 4126 |
- |
|
|