| SchemaSpy Analysis of survey - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue Aug 24 23:21 EDT 2010 |
| |||||
|
| ||||||
survey contains 56 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sessions | age | int | 10 | 0 | User age | ||||||||
| sessions | agent | text | 65535 | √ | null | Client agent | |||||||
| image_attributes | aid | int | 10 | 0 |
|
Attribute id | |||||||
| questions | aid | int | 10 | 0 |
|
Attribute id | |||||||
| sessions | bkgrnd | int | 10 | 0 | User background in image processing | ||||||||
| comparisons | cid | int | 10 | 0 |
|
Comparison id (within this session, 0 based) | |||||||
| options | cid | int | 10 | 0 |
|
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 |
|
Dataset id | |||||||
| experiments_judges | did | int | 10 | 0 |
|
Dataset id | |||||||
| results | did | int | 10 | 0 |
|
|
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 |
|
Unique attribute identifier | |||||||
| datasets | id | int | 10 | √ |
|
Unique dataset identifier | |||||||
| images | id | int | 10 | √ |
|
Unique image identifier | |||||||
| operators | id | int | 10 | 0 | Unique operator identifier | ||||||||
| questions | id | int | 10 | √ |
|
Unique question identifier | |||||||
| results | id | int | 10 | 0 |
|
Result id (within the dataset) | |||||||
| sessions | id | int | 10 | √ |
|
Unique session identifier | |||||||
| datasets | imid | int | 10 | 0 |
|
Image id | |||||||
| image_attributes | imid | int | 10 | 0 |
|
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 |
|
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 |
|
Left result id | |||||||
| comparisons | res2 | int | 10 | 0 |
|
Right result id | |||||||
| comparisons | selected | int | 10 | 0 | Selected result id | ||||||||
| comparisons | sid | int | 10 | 0 |
|
|
Session id | ||||||
| options | sid | int | 10 | 0 |
|
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 |