Table env.sqlite.threads 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
reference 2000000000,10  √  null
is_originator 2000000000,10  √  null

Table contained 486,802 rows at Thu Dec 01 14:57 PST 2011

Indexes:
Column(s) Type Sort Constraint Name
message_id Performance Asc references_message_id_index
reference Performance Asc references_reference_index

Close relationships  within of separation: