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

Close relationships within degrees of separation