Table /home/tim/Kobo/KoboReader.sqlite.Shelf
Holds the Shelves created to hold book lists

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
CreationDate varchar 65536,10  √  null
Id varchar 65536,10  √  null
Rules.Id Implied Constraint R
The ID associated Shelf record
InternalName varchar 65536,10  √  null
ShelfContent.ShelfName Defined in XML R
The Name for the Shelf
LastModified varchar 65536,10  √  null
Name varchar 65536,10  √  null
Type varchar 65536,10  √  null
_IsDeleted varchar 65536,10  √  null
_IsVisible 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
InternalName Primary key Asc sqlite_autoindex_Shelf_1 This unique column is also nullable
CreationDate Performance Asc shelf_creationdate_index  
Id Performance Asc shelf_id_index  
Name Performance Asc shelf_name_index  

Close relationships  within of separation: