Table testsql_comments.biblioimages
local cover images

Generated by
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
imagenumber int 10  √  unique identifier for the image
biblionumber int 10
biblio.biblionumber bibliocoverimage_fk1 C
foreign key from biblio table to link to biblionumber
mimetype varchar 15 image type
imagefile mediumblob 16777215 image file contents
thumbnail mediumblob 16777215 thumbnail file contents

Table contained 0 rows at Tue Dec 27 16:10 NZDT 2016

Column(s) Type Sort Constraint Name
imagenumber Primary key Asc PRIMARY
biblionumber Performance Asc bibliocoverimage_fk1

Close relationships  within of separation: