|
Lines 3808-3823
CREATE TABLE `illrequests` (
Link Here
|
| 3808 |
`batch_id` int(11) DEFAULT NULL COMMENT 'Optional ID of batch that this request belongs to', |
3808 |
`batch_id` int(11) DEFAULT NULL COMMENT 'Optional ID of batch that this request belongs to', |
| 3809 |
PRIMARY KEY (`illrequest_id`), |
3809 |
PRIMARY KEY (`illrequest_id`), |
| 3810 |
KEY `illrequests_bnfk` (`borrowernumber`), |
3810 |
KEY `illrequests_bnfk` (`borrowernumber`), |
| 3811 |
KEY `illrequests_manfk` (`managedby`), |
|
|
| 3812 |
KEY `illrequests_bcfk_2` (`branchcode`), |
3811 |
KEY `illrequests_bcfk_2` (`branchcode`), |
| 3813 |
KEY `illrequests_safk` (`status_alias`), |
3812 |
KEY `illrequests_safk` (`status_alias`), |
| 3814 |
KEY `illrequests_bibfk` (`biblio_id`), |
3813 |
KEY `illrequests_bibfk` (`biblio_id`), |
| 3815 |
KEY `illrequests_ibfk` (`batch_id`), |
3814 |
KEY `illrequests_ibfk` (`batch_id`), |
|
|
3815 |
KEY `illrequests_manfk` (`managedby`), |
| 3816 |
CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
3816 |
CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3817 |
CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3817 |
CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 3818 |
CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3818 |
CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 3819 |
CONSTRAINT `illrequests_manfk` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
| 3820 |
CONSTRAINT `illrequests_ibfk` FOREIGN KEY (`batch_id`) REFERENCES `illbatches` (`ill_batch_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
3819 |
CONSTRAINT `illrequests_ibfk` FOREIGN KEY (`batch_id`) REFERENCES `illbatches` (`ill_batch_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
3820 |
CONSTRAINT `illrequests_manfk` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 3821 |
CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE |
3821 |
CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE |
| 3822 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3822 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3823 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3823 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3824 |
- |
|
|