Table /home/tim/Kobo/KoboReader.sqlite.Achievement
Holds the Achievements that are used for badges. This table is related to the Rule table only

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
Acknowledged varchar 65536,10  √  null
CompleteDescription varchar 65536,10  √  null
DateCreated varchar 65536,10  √  null
Difficulty integer 11,10  √  null
EventLogDescription varchar 65536,10  √  null
Hidden varchar 65536,10  √  null
Id varchar 65536,10
Rules.AchievementId Defined in XML R
Rules.Id Implied Constraint R
The GUID for the Achievement
ImageId varchar 65536,10
IncompleteDescription varchar 65536,10  √  null
Name varchar 65536,10
Ordinal integer 11,10  √  null
PercentComplete integer 11,10  √  null
Presented varchar 65536,10  √  null
Synchronized varchar 65536,10  √  null
UserId varchar 65536,10  √  null
user.UserID Defined in XML R
The GUID for the User that the Achievement is for
Checksum varchar 65536,10  √  null
FacebookImageId varchar 65536,10  √  null

Analyzed at Wed Sep 05 22:43 ADT 2012

Indexes:
Column(s) Type Sort Constraint Name
Id Primary key Asc sqlite_autoindex_Achievement_1

Close relationships  within of separation: