|
Lines 4192-4198
CREATE TABLE illrequests (
Link Here
|
| 4192 |
CONSTRAINT `illrequests_bcfk_2` |
4192 |
CONSTRAINT `illrequests_bcfk_2` |
| 4193 |
FOREIGN KEY (`branchcode`) |
4193 |
FOREIGN KEY (`branchcode`) |
| 4194 |
REFERENCES `branches` (`branchcode`) |
4194 |
REFERENCES `branches` (`branchcode`) |
| 4195 |
ON UPDATE CASCADE ON DELETE CASCADE |
4195 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 4196 |
CONSTRAINT `illrequests_safk` |
4196 |
CONSTRAINT `illrequests_safk` |
| 4197 |
FOREIGN KEY (`status_alias`) |
4197 |
FOREIGN KEY (`status_alias`) |
| 4198 |
REFERENCES `authorised_values` (`id`) |
4198 |
REFERENCES `authorised_values` (`id`) |
| 4199 |
- |
|
|