illrequests

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
illrequest_id BIGINT UNSIGNED 20 null
illcomments.illrequest_id illcomments_ifkC
illrequestattributes.illrequest_id illrequestattributes_ifkC
borrowernumber INT 10 null
borrowers.borrowernumber illrequests_bnfkC
biblio_id INT 10 null
branchcode VARCHAR 50 null
branches.branchcode illrequests_bcfk_2C
status VARCHAR 50 null
status_alias VARCHAR 80 null
authorised_values.authorised_value illrequests_safkN
placed DATE 10 null
replied DATE 10 null
updated TIMESTAMP 19 current_timestamp()
completed DATE 10 null
medium VARCHAR 30 null
accessurl VARCHAR 500 null
cost VARCHAR 20 null
price_paid VARCHAR 20 null
notesopac MEDIUMTEXT 16777215 null
notesstaff MEDIUMTEXT 16777215 null
orderid VARCHAR 50 null
backend VARCHAR 20 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc illrequest_id
illrequests_bcfk_2 Performance Asc branchcode
illrequests_bnfk Performance Asc borrowernumber
illrequests_safk Performance Asc status_alias

Relationships