Table env.sqlite.duplicates_unread_count Generated by
SchemaSpy
Legend:
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
ROWID integer 2000000000,10  √  null
message_id 2000000000,10
messages.ROWID Defined in XML R
mailbox_id integer 2000000000,10  √  null
mailboxes.ROWID Defined in XML R
unread_count integer 2000000000,10  √  null

Table contained 137,279 rows at Thu Dec 01 14:57 PST 2011

Indexes:
Column(s) Type Sort Constraint Name
message_id + mailbox_id Must be unique Asc/Asc sqlite_autoindex_duplicates_unread_count_1

Close relationships  within of separation: