SchemaSpy Analysis of survey - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Aug 24 23:21 EDT 2010
Legend:
Primary key columns
Columns with indexes
 

survey contains 56 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
datasets id int 10  √ 
experiments_judges.did FK_experiments_judges_did
results.did FK_results_did
Unique dataset identifier
images id int 10  √ 
datasets.imid FK_datasets_imid
image_attributes.imid FK_image_attributes_imid
Unique image identifier
questions id int 10  √ 
options.qid FK_options_qid
Unique question identifier
sessions id int 10  √ 
comparisons.sid FK_comparisons_sid
Unique session identifier
sessions age int 10 0 User age
sessions agent text 65535  √  null Client agent
image_attributes aid int 10 0
attributes.id FK_image_attributes_aid
Attribute id
questions aid int 10 0
attributes.id FK_questions_aid
Attribute id
sessions bkgrnd int 10 0 User background in image processing
comparisons cid int 10 0
options.cid FK_options_cid
Comparison id (within this session, 0 based)
options cid int 10 0
comparisons.cid FK_options_cid
Comparison id
sessions comment text 65535  √  null Any additional comment about this session
questions condition int 10  √  0 Ask question only if: 0=always, 1=only if size is reduced
comparisons ctime double 22  √  null The time it took the user to choose his preferred result (might be NULL in earlier versions)
comparisons did int 10 0
results.did FK_comparisons_res2
Dataset id
experiments_judges did int 10 0
datasets.id FK_experiments_judges_did
Dataset id
results did int 10 0
comparisons.did FK_comparisons_res2
datasets.id FK_results_did
Dataset id
datasets dim int 10 Resizing dimension (MATLAB notation: 1=height, 2=width)
attributes enabled bit 0 1 Do we use this attribute in practice?
sessions ended datetime 19  √  null The time this session ended (NULL for partially completed session)
experiments_judges expid int 10 0 Experiment id
sessions expid int 10  √  null Experiment id (if applicable)
sessions exptype int 10 0 Experiment type (0=reference, 1=blind)
results filename varchar 64 Result file name
datasets filter text 65535  √  null Results to filter (currently given as comma separated operator names)
sessions gender int 10 0 User gender
images height int 10 Image height
sessions host text 65535  √  null Client host (by reverse DNS lookup)
attributes id int 10 0
image_attributes.aid FK_image_attributes_aid
questions.aid FK_questions_aid
Unique attribute identifier
operators id int 10 0 Unique operator identifier
results id int 10 0
comparisons.res1 FK_comparisons_res1
comparisons.res2 FK_comparisons_res2
Result id (within the dataset)
datasets imid int 10 0
images.id FK_datasets_imid
Image id
image_attributes imid int 10 0
images.id FK_image_attributes_imid
Image id
sessions ip varchar 32  √  null Client ip
experiments_judges judgeid int 10 0 Judge id (a row in the design)
datasets mode int 10 0 Survey mode (0=random, 1=design)
sessions mode int 10  √  null Survey mode (0=random, 1=experiment)
attributes name varchar 255 Attribute name
images name varchar 64 Image name
operators name varchar 16 Operator name
results opid int 10 0 Operator id
comparisons options varchar 128  √  null The selected options in case the extra question was given (NULL o/w)
options qid int 10 0
questions.id FK_options_qid
Question id
comparisons qtime double 22  √  null The time it took the user to select his options
questions question text 65535 Question string
datasets r double 22 0 Resize ratio
comparisons res1 int 10 0
results.id FK_comparisons_res1
Left result id
comparisons res2 int 10 0
results.id FK_comparisons_res2
Right result id
comparisons selected int 10 0 Selected result id
comparisons sid int 10 0
options.sid FK_options_cid
sessions.id FK_comparisons_sid
Session id
options sid int 10 0
comparisons.sid FK_options_cid
Session id
sessions started datetime 19 0000-00-00 00:00:00 The time this session started
sessions user int 10 0 User type (0=normal, 1=mturk)
sessions uuid varchar 128 Session uuid generated by PHP
sessions version double 22 0 Survey version
images width int 10 Image width