| SchemaSpy Analysis of env.sqliteApproximate 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 | |
| Database Type: SQLite - 3.7.2 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| addresses | 1 | 3 | 154,346 | ||
| associations | 3 | 0 | |||
| attachments | 1 | 4 | 22,942 | ||
| duplicates_unread_count | 2 | 4 | 137,279 | ||
| events | 1 | 12 | 0 | ||
| ews_folders | 4 | 0 | |||
| feeds | 1 | 3 | 0 | ||
| mailboxes | 4 | 7 | 28 | ||
| messages | 5 | 3 | 27 | 360,432 | |
| properties | 3 | 6 | |||
| recipients | 2 | 5 | 631,403 | ||
| sqlite_sequence | 2 | 2 | |||
| subjects | 1 | 2 | 94,714 | ||
| threads | 1 | 4 | 486,802 | ||
| 14 Tables | 83 | 1,887,954 | |||
| 0 Views | 0 |