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 |
- |
|
|