SchemaSpy Analysis of /home/tim/Kobo/KoboReader.sqlite - ColumnsKobo EReader DatabaseDatabase Schema Version: 52 Generated by
SchemaSpy
Generated on Wed Sep 05 22:43 ADT 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

/home/tim/Kobo/KoboReader.sqlite contains 153 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
AbTest Bit integer 11,10  √  null
AbTest Checksum varchar 65536,10  √  null
AbTest DefaultValue integer 11,10  √  null
AbTest FeatureId varchar 65536,10  √  null
AbTest IsEnabled integer 11,10  √  null
Achievement Acknowledged varchar 65536,10  √  null
Achievement Checksum varchar 65536,10  √  null
Achievement CompleteDescription varchar 65536,10  √  null
Achievement DateCreated varchar 65536,10  √  null
Achievement Difficulty integer 11,10  √  null
Achievement EventLogDescription varchar 65536,10  √  null
Achievement FacebookImageId varchar 65536,10  √  null
Achievement Hidden varchar 65536,10  √  null
Achievement Id varchar 65536,10 The GUID for the Achievement
Achievement ImageId varchar 65536,10
Achievement IncompleteDescription varchar 65536,10  √  null
Achievement Name varchar 65536,10
Achievement Ordinal integer 11,10  √  null
Achievement PercentComplete integer 11,10  √  null
Achievement Presented varchar 65536,10  √  null
Achievement Synchronized varchar 65536,10  √  null
Achievement UserId varchar 65536,10  √  null The GUID for the User that the Achievement is for
Bookmark Annotation varchar 65536,10  √  null
Bookmark BookmarkID varchar 65536,10
Bookmark ChapterProgress real 54,10 0
Bookmark ContentID varchar 65536,10
Bookmark Creator varchar 65536,10  √  null
Bookmark DateCreated varchar 65536,10  √  null
Bookmark DateModified varchar 65536,10  √  null
Bookmark EndContainerChildIndex integer 11,10
Bookmark EndContainerPath varchar 65536,10
Bookmark EndOffset integer 11,10
Bookmark ExtraAnnotationData binary 65536,10  √  null
Bookmark Hidden varchar 65536,10 0
Bookmark StartContainerChildIndex integer 11,10
Bookmark StartContainerPath varchar 65536,10
Bookmark StartOffset integer 11,10
Bookmark Text varchar 65536,10  √  null
Bookmark UUID varchar 65536,10  √  null
Bookmark Version varchar 65536,10  √  null
Bookmark VolumeID varchar 65536,10 Looks to be the ContentID of the Main book record from the content table
content ___ExpirationStatus integer 11,10  √  null Values: 3 - Book was deleted
content ___FileOffset integer 11,10  √  null
content ___FileSize integer 11,10  √  null
content ___NumPages integer 11,10  √  null
content ___PercentRead integer 11,10  √  null
content ___SyncTime varchar 65536,10  √  null
content ___UserID varchar 65536,10 The GUID for the User that the Content is licensed for
content Accessibility integer 11,10  √  1 Values: 1 = Local Book, 4 = Recomendation, 6 - Preview
content adobe_location varchar 65536,10  √  null
content Attribution varchar 65536,10  √  null
content AverageRating integer 11,10  √  0
content 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
content BookmarkWordOffset integer 11,10  √  null
content BookshelfTags varchar 65536,10  √  null
content BookTitle varchar 65536,10  √  null
content ChapterIDBookmarked varchar 65536,10  √  null
content ContentID varchar 65536,10 Main book content identifier, used as link to multiple tables
content ContentType varchar 65536,10 Values: 6 - Kobo book, 9 - Chapter/Section
content ContentURL varchar 65536,10  √  null
content DateCreated varchar 65536,10  √  null
content DateLastRead varchar 65536,10  √  null Update when updating the ReadStatus (FirstTimeReading too)
content Depth integer 11,10  √  null
content Description varchar 65536,10  √  null
content EpubType integer 11,10 -1
content FavouritesIndex varchar 65536,10 -1 Values: -1 - not a favourite, 1 = favourite
content FeedbackType integer 11,10  √  0
content FeedbackTypeSynced integer 11,10  √  0
content FirstTimeReading varchar 65536,10  √  null Update when updating the ReadStatus (DateLastRead too)
content ImageId varchar 65536,10  √  null
content InWishlist varchar 65536,10 FALSE
content ISBN varchar 65536,10  √  null
content IsDownloaded varchar 65536,10 1
content IsEncrypted varchar 65536,10  √  null
content IsSocialEnabled varchar 65536,10 TRUE
content Language varchar 65536,10  √  null
content MimeType varchar 65536,10 Used with ContentType to decide what type of book
content NumShortcovers integer 11,10  √  null
content PageProgressDirection varchar 65536,10  √  null
content ParagraphBookmarked integer 11,10  √  null
content PublicationId varchar 65536,10  √  null
content Publisher varchar 65536,10  √  null
content ReadStatus integer 11,10  √  null Values: 1 - Im_Reading, 2 - Read, 3 - Closed
content ShortCoverKey varchar 65536,10  √  null
content Title varchar 65536,10  √  null
content VolumeIndex integer 11,10  √  null
content WishlistedDate varchar 65536,10  √  "0000-00-00T00??.000"
content_keys elementId varchar 65536,10
content_keys elementKey varchar 65536,10  √  null
content_keys volumeId varchar 65536,10 Looks to be the ContentID of the Main book record from the content table
content_settings ActivityFacebookShare varchar 65536,10  √  TRUE
content_settings ContentID varchar 65536,10 Looks to be the ContentID of the Main book record from the content table
content_settings ContentType integer 11,10
content_settings DateModified varchar 65536,10
content_settings ReadingAlignment varchar 65536,10  √  null
content_settings ReadingFontFamily varchar 65536,10  √  null
content_settings ReadingFontSize integer 11,10  √  null
content_settings ReadingLeftMargin integer 11,10  √  null
content_settings ReadingLineHeight integer 11,10  √  null
content_settings ReadingPublisherMode integer 11,10  √  null
content_settings ReadingRightMargin integer 11,10  √  null
DbVersion version integer 11,10
Event Checksum varchar 65536,10  √  null
Event ContentID varchar 65536,10  √  null Looks to be the ContentID of the Main book record from the content table
Event EventCount integer 11,10  √  0
Event EventType integer 11,10
Event ExtraData binary 65536,10  √  null
Event FirstOccurrence varchar 65536,10  √  null
Event LastOccurrence varchar 65536,10  √  null
publications mastheadImage varchar 65536,10  √  null
publications publicationId varchar 65536,10 The ID associated with the Magazine or Newspaper
publications publicationName varchar 65536,10  √  null
ratings ContentID varchar 65536,10 The ID associated with the book
ratings DateModified varchar 65536,10
ratings Rating integer 11,10  √  null
ratings Review varchar 65536,10  √  null
Rules AchievementId varchar 65536,10  √  null The ID associated Achievement record that the rule is related to
Rules Checksum varchar 65536,10  √  null
Rules ConjunctionType integer 11,10  √  null
Rules EventProperty varchar 65536,10  √  null
Rules EventType varchar 65536,10  √  null
Rules GoalValue varchar 65536,10
Rules Id varchar 65536,10
Rules IsConjunction varchar 65536,10  √  null
Rules Operation integer 11,10
Rules ParentRuleId varchar 65536,10  √  null
Shelf _IsDeleted varchar 65536,10  √  null
Shelf _IsSynced varchar 65536,10  √  null
Shelf _IsVisible varchar 65536,10  √  null
Shelf CreationDate varchar 65536,10  √  null
Shelf Id varchar 65536,10  √  null The ID associated Shelf record
Shelf InternalName varchar 65536,10  √  null The Name for the Shelf
Shelf LastModified varchar 65536,10  √  null
Shelf Name varchar 65536,10  √  null
Shelf Type varchar 65536,10  √  null
ShelfContent _IsDeleted varchar 65536,10  √  null
ShelfContent _IsSynced varchar 65536,10  √  null
ShelfContent ContentId varchar 65536,10  √  null The ID of the associated Book record
ShelfContent DateModified varchar 65536,10  √  null
ShelfContent ShelfName varchar 65536,10  √  null The ID of the associated Shelf record
shortcover_page FormattedPage varchar 65536,10  √  null
shortcover_page PageNumber integer 11,10  √  null
shortcover_page shortcoverId varchar 65536,10 The ID of the associated book record
user ___DeviceID varchar 65536,10
user UserDisplayName varchar 65536,10  √  null
user UserEmail varchar 65536,10  √  null The email address associated with the content
user UserID varchar 65536,10
user UserKey varchar 65536,10
volume_shortcovers shortcoverId varchar 65536,10
volume_shortcovers volumeId varchar 65536,10 The ID of the associated shorcover book
volume_shortcovers VolumeIndex integer 11,10  √  null
volume_tabs tabId varchar 65536,10 'abcdefff-ffff-ffff-ffff-fffffffffffd'
volume_tabs volumeId varchar 65536,10 The ID of the associated book record