| 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 |
|||||
| 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 |
|||||
| updated | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||||||
| completed | DATE | 10 | √ | null |
|
|
Date the request was completed |
