Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
illrequest_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
ILL request number |
|||||
borrowernumber | INT | 10 | √ | null |
|
|
Patron associated with request |
|||||
biblio_id | INT | 10 | √ | null |
|
|
Potential bib linked to request |
|||||
deleted_biblio_id | INT | 10 | √ | null |
|
|
Deleted bib linked to request |
|||||
due_date | DATETIME | 19 | √ | null |
|
|
Custom date due specified by backend, leave NULL for default date_due calculation |
|||||
branchcode | VARCHAR | 50 | null |
|
|
The branch associated with the request |
||||||
status | VARCHAR | 50 | √ | null |
|
|
Current Koha status of request |
|||||
status_alias | VARCHAR | 80 | √ | null |
|
|
Foreign key to relevant authorised_values.authorised_value |
|||||
placed | DATE | 10 | √ | null |
|
|
Date the request was placed |
|||||
replied | DATE | 10 | √ | null |
|
|
Last API response |