Table env.sqlite.mailboxes 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
duplicates_unread_count.mailbox_id Defined in XML R
feeds.mailbox_id Defined in XML R
messages.mailbox Defined in XML R
messages.original_mailbox Defined in XML R
url 2000000000,10  √  null
total_count integer 2000000000,10  √  null
unread_count integer 2000000000,10  √  null
unseen_count integer 2000000000,10  √  null
deleted_count integer 2000000000,10  √  null
unread_count_adjusted_for_duplicates integer 2000000000,10  √  null

Table contained 28 rows at Thu Dec 01 14:57 PST 2011

Indexes:
Column(s) Type Sort Constraint Name Anomalies
url Must be unique Asc sqlite_autoindex_mailboxes_1 This unique column is also nullable

Close relationships  within of separation: