Table survey.options
User responses to the additional questions

 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
sid int 10 0
comparisons.sid FK_options_cid
Session id
cid int 10 0
comparisons.cid FK_options_cid
Comparison id
qid int 10 0
questions.id FK_options_qid
Question id

Analyzed at Tue Aug 24 23:21 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name
sid + cid Performance Asc/Asc IDX_options_cid
qid Performance Asc IDX_options_qid

Close relationships  within of separation: