Table env.sqlite.attachments Generated by
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
message_id integer 2000000000,10  √  null
messages.ROWID Defined in XML R
name 2000000000,10  √  null
type 2000000000,10  √  null

Table contained 22,942 rows at Thu Dec 01 14:57 PST 2011

Column(s) Type Sort Constraint Name Anomalies
type Performance Asc attachments_type_index  
message_id + name Must be unique Asc/Asc sqlite_autoindex_attachments_1 These unique columns are also nullable

Close relationships  within of separation: