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