Layers
(See Enquette Layers for further explanation)
|
| tab_id |
Unique Layer ID |
| tab_order |
Layer order number (zero based) |
| tab_header_id |
Optional Enquette Header reference to TabTexts worksheet |
| tab_footer_id |
Optional Enquette Footer reference to TabTexts worksheet |
| name |
Layer Title in admin's language |
| question |
(Multiple Criteria) Question column header in admin's language |
| tabType |
Layer Type: 0 for Registration, 1 for Enquette. |
| voluntary |
Voting: 0 for Mandatory, 1 for Voluntary. |
| singleCrit |
Criteria: 0 for Multiple, 1 for Single. |
| ordered |
Ordering: 0 for Random, 1 for By Order. |
| name:xx-yy |
Language versions of the Layer Name |
| question:xx-yy |
(Multiple Criteria) Language versions of the Question column header |
LayerTexts
|
| ttext_id |
Unique Text ID |
| text |
The content in admin's language |
| text:xx-yy |
Language versions of the Text |
Items
(See Layer Questions for further explanation)
|
| item_id |
Unique Item ID |
| tab_id |
Reference to Layers worksheet |
| schema_id |
On Single Criterion Layers, reference to MarkSchemata worksheet |
| item_order |
Item order number (zero based) |
| text |
Item Text in admin's language |
| type |
Required: 0 for Separator, 1 for Arbitrary, 2 for Mandatory.
|
| etype |
On Single Criterion Layers, Evaluation Control type. See Criteria worksheet for explanation. |
| text:xx-yy |
Language versions of the Question |
| condition |
Question Condition |
Criteria
|
| crit_id |
Unique Criterion ID |
| tab_id |
Reference to Layers worksheet |
| schema_id |
Reference to Schemata worksheet |
| crit_order |
Criterion order number (zero based) |
| name |
Criterion Name in admin's language |
| etype |
Evaluation Control type:
- 0: Dropdown
- 1: Checkbox
- 2: Multiselect Dropdown
- 3: Text field
- 4: Text Area
- 5: Radio Buttons
- 6: Numeric
- 7: Date
|
| name:xx-yy |
Language versions of the Criterion Name |
Schemata
(See Evaluation Schemata for further explanation)
|
| schema_id |
Unique Schema ID |
| name |
Schema Name in admin's language |
| module_id |
In this context, the field distinguishes just between a global Schema (empty) and an Enquette specific one (origin Enquette ID). |
| name:xx-yy |
Language versions of the Schema Name |
| options |
Schema options in json notation, like {"width":"40px","min":1,"max":100} |
SchemaValues
|
| mval_id |
Unique MarkValue ID |
| schema_id |
Reference to Schemata worksheet |
| mval_mark |
Numeric SchemaValue value |
| name |
MarkValue Name in admin's language |
| mval_name:xx-yy |
Language versions of the MarkValue Name |
Visitors
(See Manage Visitors for further explanation)
|
| visitor_id |
Unique Visitor ID |
| user_id |
Joomla! unique User ID, empty for unregistered Visitors. If uploaded to the origin site, the Visitor is looked for by this value. Otherwise, it will be emptied so that imported Visitors are not registered.. |
| visitor_name |
Visitor name |
| visitor_email |
Visitor mail |
| visitor_language |
Visitor Language |
| approved |
unused in current version |
Tcpip
|
| tcpip_id |
Unique TCPIP ID |
| visitor_id |
Reference to Visitors worksheet |
| tcpip_tcpip |
The Tcp/Ip address the Visitor was connected from |
| tcpip_last_access |
Last Visitor's Submit date / time from this address (not necessarily to this or any other Enquette) |
Marks
|
| mark_id |
Unique Mark ID |
| item_id |
Reference to Items worksheet |
| crit_id |
Reference to Criteria worksheet. On Single Criteria Layer, this is 0. |
| visitor_id |
Reference to Visitors worksheet |
| created |
Date / Time the Vote was last time submitted |
| mark_intval |
Vote integer or Date value |
| mark_stringval |
Vote textual value |
| value |
For schematiued votes, this is the verbal equivalend to mark_stringval |
Resources
|
| id |
Unique Resource ID |
| uri |
Resource relative URL. When uploaded, images will be copied to the same relative folder as on the origin site. |
| content |
Base64 coded file content |
