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