Table testsql_comments.biblioimages
local cover 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
imagenumber int 10  √  unique identifier for the image
biblionumber int 10
biblio
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
imagenumber Primary key Asc
biblionumber Performance Asc

Close relationships  within of separation: