Columns
| 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 |
|||||
| updated | TIMESTAMP | 19 | current_timestamp() |
|
|
|||||||
| completed | DATE | 10 | √ | null |
|
|
Date the request was completed |
|||||
| medium | VARCHAR | 30 | √ | null |
|
|
The Koha request type |
|||||
| accessurl | VARCHAR | 500 | √ | null |
|
|
Potential URL for accessing item |
|||||
| cost | VARCHAR | 20 | √ | null |
|
|
Quotes cost of request |
|||||
| price_paid | VARCHAR | 20 | √ | null |
|
|
Final cost of request |
|||||
| notesopac | MEDIUMTEXT | 16777215 | √ | null |
|
|
Patron notes attached to request |
|||||
| notesstaff | MEDIUMTEXT | 16777215 | √ | null |
|
|
Staff notes attached to request |
|||||
| orderid | VARCHAR | 50 | √ | null |
|
|
Backend id attached to request |
|||||
| backend | VARCHAR | 20 | √ | null |
|
|
The backend used to create request |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | illrequest_id |
| illrequests_bcfk_2 | Performance | Asc | branchcode |
| illrequests_bibfk | Performance | Asc | biblio_id |
| illrequests_bnfk | Performance | Asc | borrowernumber |
| illrequests_safk | Performance | Asc | status_alias |
Relationships
Close relationships within degrees of separation
