novelist_data

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
groupedRecordPermanentId CHAR 40 null
lastUpdate INT 10 √ NULL
hasNovelistData BOOLEAN 3 √ NULL
groupedRecordHasISBN BOOLEAN 3 √ NULL
primaryISBN VARCHAR 13 √ NULL
seriesTitle VARCHAR 255 √ NULL
seriesNote VARCHAR 255 √ NULL
volume VARCHAR 32 √ NULL
jsonResponse MEDIUMBLOB 16777215 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
groupedRecordPermanentId Performance Asc groupedRecordPermanentId
primaryISBN Performance Asc primaryISBN
series Performance Asc/Asc seriesTitle + volume

Relationships