bookcover_info

9470 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
recordType VARCHAR 20 √ NULL
recordId VARCHAR 50 √ NULL
firstLoaded INT 10 null
lastUsed INT 10 null
imageSource VARCHAR 100 √ NULL
sourceWidth INT 10 √ NULL
sourceHeight INT 10 √ NULL
thumbnailLoaded BOOLEAN 3 √ 0
mediumLoaded BOOLEAN 3 √ 0
largeLoaded BOOLEAN 3 √ 0
uploadedImage BOOLEAN 3 √ 0
disallowThirdPartyCover BOOLEAN 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
imageSource Performance Asc imageSource
lastUsed Performance Asc lastUsed
record_info Must be unique Asc/Asc recordType + recordId

Relationships