Table testsql_comments.patronimage
information related to patron images

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber int 10
borrowers
the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)
mimetype varchar 15 the format of the image (png, jpg, etc)
imagefile mediumblob 16777215 the image

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

Indexes:
Column(s) Type Sort
borrowernumber Primary key Asc

Close relationships  within of separation: