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