article_requests

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
borrowernumber INT 10 null
borrowers.borrowernumber article_requests_ibfk_1C
biblionumber INT 10 null
biblio.biblionumber article_requests_ibfk_2C
itemnumber INT 10 null
items.itemnumber article_requests_ibfk_3N
branchcode VARCHAR 10 null
branches.branchcode article_requests_ibfk_4N
title MEDIUMTEXT 16777215 null
author MEDIUMTEXT 16777215 null
volume MEDIUMTEXT 16777215 null
issue MEDIUMTEXT 16777215 null
date MEDIUMTEXT 16777215 null
pages MEDIUMTEXT 16777215 null
chapters MEDIUMTEXT 16777215 null
patron_notes MEDIUMTEXT 16777215 null
status enum('PENDING', 'PROCESSING', 'COMPLETED', 'CANCELED') 10 PENDING
notes MEDIUMTEXT 16777215 null
created_on TIMESTAMP 19 null

Be careful with two timestamps in one table not allowing NULL

updated_on TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
biblionumber Performance Asc biblionumber
borrowernumber Performance Asc borrowernumber
branchcode Performance Asc branchcode
itemnumber Performance Asc itemnumber

Relationships