Table testsql_comments.patronimage 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
alert.borrowernumber Implied Constraint R
borrower_modifications.borrowernumber Implied Constraint R
deletedborrowers.borrowernumber Implied Constraint R
linktracker.borrowernumber Implied Constraint R
messages.borrowernumber Implied Constraint R
notifys.borrowernumber Implied Constraint R
reserveconstraints.borrowernumber Implied Constraint R
saved_sql.borrowernumber Implied Constraint R
statistics.borrowernumber Implied Constraint R
tmp_holdsqueue.borrowernumber Implied Constraint R
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 Tue Dec 27 18:01 NZDT 2016

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

Close relationships  within of separation: