Table /home/tim/Kobo/KoboReader.sqlite.Bookmark
Bookmarks for each book

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
BookmarkID varchar 65536,10
VolumeID varchar 65536,10
content.ContentID Defined in XML R
Looks to be the ContentID of the Main book record from the content table
ContentID varchar 65536,10
content.ContentID Implied Constraint R
StartContainerPath varchar 65536,10
StartContainerChildIndex integer 11,10
StartOffset integer 11,10
EndContainerPath varchar 65536,10
EndContainerChildIndex integer 11,10
EndOffset integer 11,10
Text varchar 65536,10  √  null
Annotation varchar 65536,10  √  null
ExtraAnnotationData binary 65536,10  √  null
DateCreated varchar 65536,10  √  null
ChapterProgress real 54,10 0
Hidden varchar 65536,10 0
Version varchar 65536,10  √  null
DateModified varchar 65536,10  √  null
Creator varchar 65536,10  √  null
UUID varchar 65536,10  √  null

Analyzed at Wed Sep 05 22:43 ADT 2012

Indexes:
Column(s) Type Sort Constraint Name
BookmarkID Primary key Asc sqlite_autoindex_Bookmark_1

Close relationships  within of separation: