Table survey.questions
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
id int 10  √ 
options.qid FK_options_qid
Unique question identifier
aid int 10 0
attributes.id FK_questions_aid
Attribute id
question text 65535 Question string
condition int 10  √  0 Ask question only if: 0=always, 1=only if size is reduced

Analyzed at Tue Aug 24 23:21 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
aid Performance Asc IDX_questions_aid

Close relationships  within of separation: