Table testsql_comments.biblioimages
local cover 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
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 Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: