Table testsql_comments.patronimage
information related to patron images

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber int 10
borrowers.borrowernumber patronimage_fk1 C
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 Jun 26 09:07 NZST 2017

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

Close relationships  within of separation: