SchemaSpy Analysis of survey - Columns Generated by
Generated by SchemaSpy on Tue Aug 24 23:21 EDT 2010
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
results filename varchar 64 Result file name
attributes name varchar 255 Attribute name
images name varchar 64 Image name
operators name varchar 16 Operator name
sessions uuid varchar 128 Session uuid generated by PHP
sessions age int 10 0 User age
image_attributes aid int 10 0 FK_image_attributes_aid
Attribute id
questions aid int 10 0 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
questions condition int 10  √  0 Ask question only if: 0=always, 1=only if size is reduced
comparisons did int 10 0
results.did FK_comparisons_res2
Dataset id
experiments_judges did int 10 0 FK_experiments_judges_did
Dataset id
results did int 10 0
comparisons.did FK_comparisons_res2 FK_results_did
Dataset id
experiments_judges expid int 10 0 Experiment id
sessions exptype int 10 0 Experiment type (0=reference, 1=blind)
sessions gender int 10 0 User gender
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 FK_datasets_imid
Image id
image_attributes imid int 10 0 FK_image_attributes_imid
Image id
experiments_judges judgeid int 10 0 Judge id (a row in the design)
datasets mode int 10 0 Survey mode (0=random, 1=design)
results opid int 10 0 Operator id
options qid int 10 0 FK_options_qid
Question id
datasets r double 22 0 Resize ratio
comparisons res1 int 10 0 FK_comparisons_res1
Left result id
comparisons res2 int 10 0 FK_comparisons_res2
Right result id
comparisons selected int 10 0 Selected result id
comparisons sid int 10 0
options.sid FK_options_cid FK_comparisons_sid
Session id
options sid int 10 0
comparisons.sid FK_options_cid
Session id
sessions user int 10 0 User type (0=normal, 1=mturk)
sessions version double 22 0 Survey version
sessions started datetime 19 0000-00-00 00:00:00 The time this session started
attributes enabled bit 0 1 Do we use this attribute in practice?
sessions agent text 65535  √  null Client agent
sessions comment text 65535  √  null Any additional comment about this session
comparisons ctime double 22  √  null The time it took the user to choose his preferred result (might be NULL in earlier versions)
datasets dim int 10 Resizing dimension (MATLAB notation: 1=height, 2=width)
sessions ended datetime 19  √  null The time this session ended (NULL for partially completed session)
sessions expid int 10  √  null Experiment id (if applicable)
datasets filter text 65535  √  null Results to filter (currently given as comma separated operator names)
images height int 10 Image height
sessions host text 65535  √  null Client host (by reverse DNS lookup)
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 ip varchar 32  √  null Client ip
sessions mode int 10  √  null Survey mode (0=random, 1=experiment)
comparisons options varchar 128  √  null The selected options in case the extra question was given (NULL o/w)
comparisons qtime double 22  √  null The time it took the user to select his options
questions question text 65535 Question string
images width int 10 Image width