patronimage


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber INT 10 null
borrowers.borrowernumber patronimage_fk1 C

the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)

mimetype VARCHAR 15 null

the format of the image (png, jpg, etc)

imagefile MEDIUMBLOB 16777215 null

the image

Table contained 0 rows

Indexes

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

Relationships