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 Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: