Lines 4188-4194
CREATE TABLE illrequests (
Link Here
|
4188 |
CONSTRAINT `illrequests_bcfk_2` |
4188 |
CONSTRAINT `illrequests_bcfk_2` |
4189 |
FOREIGN KEY (`branchcode`) |
4189 |
FOREIGN KEY (`branchcode`) |
4190 |
REFERENCES `branches` (`branchcode`) |
4190 |
REFERENCES `branches` (`branchcode`) |
4191 |
ON UPDATE CASCADE ON DELETE CASCADE |
4191 |
ON UPDATE CASCADE ON DELETE CASCADE, |
4192 |
CONSTRAINT `illrequests_safk` |
4192 |
CONSTRAINT `illrequests_safk` |
4193 |
FOREIGN KEY (`status_alias`) |
4193 |
FOREIGN KEY (`status_alias`) |
4194 |
REFERENCES `authorised_values` (`id`) |
4194 |
REFERENCES `authorised_values` (`id`) |
4195 |
- |
|
|