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