Table env.sqlite.messages 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
attachments.message_id Defined in XML R
duplicates_unread_count.message_id Defined in XML R
events.message_id Defined in XML R
recipients.message_id Defined in XML R
threads.message_id Defined in XML R
message_id 2000000000,10  √  null
document_id blob 2000000000,10  √  null
in_reply_to 2000000000,10  √  null
remote_id integer 2000000000,10  √  null
sender integer 2000000000,10  √  null
subject_prefix 2000000000,10  √  null
subject integer 2000000000,10  √  null
subjects.ROWID Defined in XML R
date_sent integer 2000000000,10  √  null
date_received integer 2000000000,10  √  null
date_created integer 2000000000,10  √  null
date_last_viewed integer 2000000000,10  √  null
mailbox integer 2000000000,10  √  null
mailboxes.ROWID Defined in XML R
remote_mailbox integer 2000000000,10  √  null
original_mailbox integer 2000000000,10  √  null
mailboxes.ROWID Defined in XML R
flags integer 2000000000,10  √  null
read 2000000000,10  √  null
flagged 2000000000,10  √  null
size integer 2000000000,10  √  null
color 2000000000,10  √  null
encoding 2000000000,10  √  null
type integer 2000000000,10  √  null
pad 2000000000,10  √  null
conversation_id integer 2000000000,10  √  null
snippet text 2000000000,10  √  null
fuzzy_ancestor integer 2000000000,10  √  null
automated_conversation integer 2000000000,10  √  null

Table contained 360,432 rows at Thu Dec 01 14:57 PST 2011

Indexes:
Column(s) Type Sort Constraint Name
date_created Performance Asc date_created_index
date_received Performance Asc date_index
date_last_viewed Performance Asc date_last_viewed_index
conversation_id Performance Asc message_conversation_id_index
document_id Performance Asc message_document_id_index
flagged Performance Asc message_flagged_index
fuzzy_ancestor Performance Asc message_fuzzy_ancestor_index
mailbox + date_received Performance Asc/Asc message_mailbox_index
message_id Performance Asc message_message_id_index
read Performance Asc message_read_index
remote_mailbox + remote_id Performance Asc/Asc message_remote_mailbox_index
sender + subject + automated_conversation Performance Asc/Asc/Asc message_sender_subject_automated_conversation_index
subject + fuzzy_ancestor Performance Asc/Asc message_subject_fuzzy_ancestor_index
type Performance Asc message_type_index

Close relationships  within of separation: