Table /home/tim/Kobo/KoboReader.sqlite.ShelfContent
Holds the books associated with each Shelf

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
ShelfName varchar 65536,10  √  null
Shelf.InternalName Defined in XML R
The ID of the associated Shelf record
ContentId varchar 65536,10  √  null
content.ContentID Defined in XML R
The ID of the associated Book record
DateModified varchar 65536,10  √  null
_IsDeleted varchar 65536,10  √  null
_IsSynced varchar 65536,10  √  null

Analyzed at Wed Sep 05 22:43 ADT 2012

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ShelfName + ContentId Primary key Asc/Asc sqlite_autoindex_ShelfContent_1 These unique columns are also nullable
DateModified Performance Asc shelfcontent_datemodified_index  

Close relationships  within of separation: