Table testsql_comments.patronimage 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 18:01 NZDT 2016

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

Close relationships  within of separation: