Lines 2775-2780
CREATE TABLE `illrequests` (
Link Here
|
2775 |
`illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number', |
2775 |
`illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number', |
2776 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request', |
2776 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request', |
2777 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'Potential bib linked to request', |
2777 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'Potential bib linked to request', |
|
|
2778 |
`date_due` datetime DEFAULT NULL COMMENT 'Custom date due specified by backend, leave NULL for default date_due calculation', |
2778 |
`branchcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The branch associated with the request', |
2779 |
`branchcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The branch associated with the request', |
2779 |
`status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current Koha status of request', |
2780 |
`status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current Koha status of request', |
2780 |
`status_alias` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Foreign key to relevant authorised_values.authorised_value', |
2781 |
`status_alias` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Foreign key to relevant authorised_values.authorised_value', |
2781 |
- |
|
|