SchemaSpy Analysis of env.sqlite - ColumnsApproximate schema for the sqlite database used by current (V5) versions of Mail.app Generated by
SchemaSpy
Generated by SchemaSpy on Thu Dec 01 14:57 PST 2011
Legend:
Primary key columns
Columns with indexes
 

env.sqlite contains 83 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
addresses address 2000000000,10  √  null
recipients address_id integer 2000000000,10  √  null
events associated_id_string 2000000000,10  √  null
messages automated_conversation integer 2000000000,10  √  null
messages color 2000000000,10  √  null
addresses comment 2000000000,10  √  null
messages conversation_id integer 2000000000,10  √  null
messages date_created integer 2000000000,10  √  null
messages date_last_viewed integer 2000000000,10  √  null
messages date_received integer 2000000000,10  √  null
messages date_sent integer 2000000000,10  √  null
mailboxes deleted_count integer 2000000000,10  √  null
associations document_id blob 2000000000,10  √  null
messages document_id blob 2000000000,10  √  null
messages encoding 2000000000,10  √  null
events end_date integer 2000000000,10  √  null
feeds feed_url 2000000000,10  √  null
messages flagged 2000000000,10  √  null
messages flags integer 2000000000,10  √  null
ews_folders folder_id 2000000000,10  √  null
messages fuzzy_ancestor integer 2000000000,10  √  null
events ical_uid 2000000000,10  √  null
messages in_reply_to 2000000000,10  √  null
events is_all_day integer 2000000000,10  √  null
threads is_originator 2000000000,10  √  null
events is_response_requested integer 2000000000,10  √  null
properties key 2000000000,10  √  null
events location 2000000000,10  √  null
messages mailbox integer 2000000000,10  √  null
duplicates_unread_count mailbox_id integer 2000000000,10  √  null
ews_folders mailbox_id integer 2000000000,10  √  null
feeds mailbox_id integer 2000000000,10  √  null
associations message_id 2000000000,10  √  null
attachments message_id integer 2000000000,10  √  null
duplicates_unread_count message_id 2000000000,10
events message_id integer 2000000000,10  √  null
messages message_id 2000000000,10  √  null
recipients message_id integer 2000000000,10  √  null
threads message_id integer 2000000000,10  √  null
attachments name 2000000000,10  √  null
sqlite_sequence name 2000000000,10  √  null
messages original_mailbox integer 2000000000,10  √  null
events original_receiving_account 2000000000,10  √  null
events out_of_date integer 2000000000,10  √  null
messages pad 2000000000,10  √  null
recipients position integer 2000000000,10  √  null
events processed integer 2000000000,10  √  null
messages read 2000000000,10  √  null
threads reference 2000000000,10  √  null
messages remote_id integer 2000000000,10  √  null
messages remote_mailbox integer 2000000000,10  √  null
addresses ROWID integer 2000000000,10  √  null
associations ROWID integer 2000000000,10  √  null
attachments ROWID integer 2000000000,10  √  null
duplicates_unread_count ROWID integer 2000000000,10  √  null
events ROWID integer 2000000000,10  √   √  null
ews_folders ROWID integer 2000000000,10  √  null
feeds ROWID integer 2000000000,10  √  null
mailboxes ROWID integer 2000000000,10  √  null
messages ROWID integer 2000000000,10  √   √  null
properties ROWID integer 2000000000,10  √  null
recipients ROWID integer 2000000000,10  √  null
subjects ROWID integer 2000000000,10  √  null
threads ROWID integer 2000000000,10  √  null
messages sender integer 2000000000,10  √  null
sqlite_sequence seq 2000000000,10  √  null
messages size integer 2000000000,10  √  null
messages snippet text 2000000000,10  √  null
events start_date integer 2000000000,10  √  null
messages subject integer 2000000000,10  √  null
subjects subject 2000000000,10  √  null
messages subject_prefix 2000000000,10  √  null
ews_folders sync_state 2000000000,10  √  null
mailboxes total_count integer 2000000000,10  √  null
attachments type 2000000000,10  √  null
messages type integer 2000000000,10  √  null
recipients type 2000000000,10  √  null
duplicates_unread_count unread_count integer 2000000000,10  √  null
mailboxes unread_count integer 2000000000,10  √  null
mailboxes unread_count_adjusted_for_duplicates integer 2000000000,10  √  null
mailboxes unseen_count integer 2000000000,10  √  null
mailboxes url 2000000000,10  √  null
properties value 2000000000,10  √  null