illrequests

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
illrequest_id BIGINT UNSIGNED 20 √ null
illcomments.illrequest_id illcomments_ifk C
illrequestattributes.illrequest_id illrequestattributes_ifk C

ILL request number
borrowernumber INT 10 √ NULL
borrowers.borrowernumber illrequests_bnfk C

Patron associated with request
biblio_id INT 10 √ NULL
biblio.biblionumber illrequests_bibfk N

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
branches.branchcode illrequests_bcfk_2 C

The branch associated with the request
status VARCHAR 50 √ NULL

Current Koha status of request
status_alias VARCHAR 80 √ NULL
authorised_values.authorised_value illrequests_safk N

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
batch_id INT 10 √ NULL
illbatches.ill_batch_id illrequests_ibfk N

Optional ID of batch that this request belongs to

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_ibfk Performance Asc batch_id
illrequests_safk Performance Asc status_alias

Relationships

Close relationships within degrees of separation