Table /home/tim/Kobo/KoboReader.sqlite.content
The content table holds the book record and the \'chapter\' record for each book. Book records have a Null value in the BookID column and \'Chapter\' recors have the ContentID of the \'Book\' record in the BookID column

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
ContentID varchar 65536,10
Bookmark.ContentID Implied Constraint R
Bookmark.VolumeID Defined in XML R
content_keys.volumeId Defined in XML R
content_settings.ContentID Defined in XML R
Event.ContentID Defined in XML R
ratings.ContentID Defined in XML R
ShelfContent.ContentId Defined in XML R
volume_shortcovers.volumeId Defined in XML R
volume_tabs.volumeId Defined in XML R
Main book content identifier, used as link to multiple tables
ContentType varchar 65536,10 Values: 6 - Kobo book, 9 - Chapter/Section
MimeType varchar 65536,10 Used with ContentType to decide what type of book
BookID varchar 65536,10  √  null This is the ContentID for the book that the row is related to. If it is Null, it is the book record
BookTitle varchar 65536,10  √  null
ImageId varchar 65536,10  √  null
Title varchar 65536,10  √  null
Attribution varchar 65536,10  √  null
Description varchar 65536,10  √  null
DateCreated varchar 65536,10  √  null
ShortCoverKey varchar 65536,10  √  null
adobe_location varchar 65536,10  √  null
Publisher varchar 65536,10  √  null
IsEncrypted varchar 65536,10  √  null
DateLastRead varchar 65536,10  √  null Update when updating the ReadStatus (FirstTimeReading too)
FirstTimeReading varchar 65536,10  √  null Update when updating the ReadStatus (DateLastRead too)
ChapterIDBookmarked varchar 65536,10  √  null
ParagraphBookmarked integer 11,10  √  null
BookmarkWordOffset integer 11,10  √  null
NumShortcovers integer 11,10  √  null
VolumeIndex integer 11,10  √  null
___NumPages integer 11,10  √  null
ReadStatus integer 11,10  √  null Values: 1 - Im_Reading, 2 - Read, 3 - Closed
___SyncTime varchar 65536,10  √  null
___UserID varchar 65536,10
user.UserID Defined in XML R
The GUID for the User that the Content is licensed for
PublicationId varchar 65536,10  √  null
publications.publicationId Defined in XML R
___FileOffset integer 11,10  √  null
___FileSize integer 11,10  √  null
___PercentRead integer 11,10  √  null
___ExpirationStatus integer 11,10  √  null Values: 3 - Book was deleted
FavouritesIndex varchar 65536,10 -1 Values: -1 - not a favourite, 1 = favourite
Accessibility integer 11,10  √  1 Values: 1 = Local Book, 4 = Recomendation, 6 - Preview
ContentURL varchar 65536,10  √  null
Language varchar 65536,10  √  null
BookshelfTags varchar 65536,10  √  null
IsDownloaded varchar 65536,10 1
FeedbackType integer 11,10  √  0
AverageRating integer 11,10  √  0
Depth integer 11,10  √  null
PageProgressDirection varchar 65536,10  √  null
InWishlist varchar 65536,10 FALSE
ISBN varchar 65536,10  √  null
WishlistedDate varchar 65536,10  √  "0000-00-00T00??.000"
FeedbackTypeSynced integer 11,10  √  0
IsSocialEnabled varchar 65536,10 TRUE
EpubType integer 11,10 -1

Analyzed at Wed Sep 05 22:43 ADT 2012

Indexes:
Column(s) Type Sort Constraint Name
ContentID Primary key Asc sqlite_autoindex_content_1
Attribution Performance Asc content_attribution_index
BookID Performance Asc content_bookid_index
DateLastRead Performance Asc content_date_last_read_index
MimeType Performance Asc content_mime_type
Title Performance Asc content_title_index

Close relationships  within of separation: