Table env.sqlite.recipients Generated by
SchemaSpy
Legend:
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
type 2000000000,10  √  null
address_id integer 2000000000,10  √  null
addresses.ROWID Defined in XML R
position integer 2000000000,10  √  null

Table contained 631,403 rows at Thu Dec 01 14:57 PST 2011

Indexes:
Column(s) Type Sort Constraint Name
address_id Performance Asc recipients_address_index
message_id + position Performance Asc/Asc recipients_message_id_index

Close relationships  within of separation: