Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | aid | INT |
* | answer | MEDIUMTEXT |
* | language | VARCHAR(20) |
Indexes | ||
pk_lime_answer_l10ns | ON id | |
lime_answer_l10ns_idx | ON aid, language | |
Foreign Keys | ||
fk_lime_answer_l10ns_lime_answers | (aid) → lime_answers |
Idx | Field Name | Data Type |
---|---|---|
* | aid | INT AUTO_INCREMENT |
* | qid | INT |
* | code | VARCHAR(5) |
* | sortorder | INT |
* | assessment_value | INT DEFAULT 0 |
* | scale_id | INT DEFAULT 0 |
Indexes | ||
pk_lime_answers | ON aid | |
lime_answers_idx | ON qid, code, scale_id | |
lime_answers_idx2 | ON sortorder | |
unq_lime_answers_qid | ON qid | |
Referring Foreign Keys | ||
fk_lime_answer_l10ns_lime_answers | (aid) ← lime_answer_l10ns | |
fk_lime_questions_lime_answers | (qid) ← lime_questions |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | survey_id | INT |
* | user_id | INT |
* | tbl_name | VARCHAR(255) |
* | tbl_type | VARCHAR(10) |
* | created | DATETIME |
* | properties | TEXT |
attributes | TEXT COLLATE utf8mb4_unicode_ci | |
Indexes | ||
pk_lime_archived_table_settings | ON id | |
Foreign Keys | ||
fk_lime_archived_table_settings_lime_users | (user_id) → lime_users(uid) | |
Referring Foreign Keys | ||
fk_lime_surveys_lime_archived_table_settings | (survey_id) ← lime_surveys(sid) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | language | VARCHAR(20) DEFAULT 'en' |
* | sid | INT DEFAULT 0 |
* | scope | VARCHAR(5) |
* | gid | INT DEFAULT 0 |
* | name | TEXT |
* | minimum | VARCHAR(50) |
* | maximum | VARCHAR(50) |
* | message | MEDIUMTEXT |
Indexes | ||
pk_lime_assessments | ON id, language | |
lime_assessments_idx2 | ON sid | |
lime_assessments_idx3 | ON gid | |
Referring Foreign Keys | ||
fk_lime_surveys_lime_assessments | (sid) ← lime_surveys |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | path | TEXT |
* | version | INT |
Indexes | ||
pk_lime_asset_version | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | cid | INT AUTO_INCREMENT |
* | qid | INT DEFAULT 0 |
* | cqid | INT DEFAULT 0 |
* | cfieldname | VARCHAR(50) DEFAULT '' |
* | method | VARCHAR(5) DEFAULT '' |
* | value | VARCHAR(255) DEFAULT '' |
* | scenario | INT DEFAULT 1 |
Indexes | ||
pk_lime_conditions | ON cid | |
lime_conditions_idx | ON qid | |
lime_conditions_idx3 | ON cqid | |
Referring Foreign Keys | ||
fk_lime_questions_lime_conditions | (qid) ← lime_questions |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | dvid | INT DEFAULT 0 |
* | language | VARCHAR(20) |
defaultvalue | TEXT | |
Indexes | ||
pk_lime_defaultvalue_l10ns | ON id | |
lime_idx1_defaultvalue_ls | ON dvid, language | |
Foreign Keys | ||
fk_lime_defaultvalue_l10ns_lime_defaultvalues | (dvid) → lime_defaultvalues |
Idx | Field Name | Data Type |
---|---|---|
* | dvid | INT AUTO_INCREMENT |
* | qid | INT DEFAULT 0 |
* | scale_id | INT DEFAULT 0 |
* | sqid | INT DEFAULT 0 |
* | specialtype | VARCHAR(20) DEFAULT '' |
Indexes | ||
pk_lime_defaultvalues | ON dvid | |
lime_idx1_defaultvalue | ON qid, scale_id, sqid, specialtype | |
Foreign Keys | ||
fk_lime_defaultvalues_lime_questions | (qid) → lime_questions | |
fk_lime_defaultvalues_lime_questions_0 | (sqid) → lime_questions(qid) | |
Referring Foreign Keys | ||
fk_lime_defaultvalue_l10ns_lime_defaultvalues | (dvid) ← lime_defaultvalue_l10ns |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
errortime | VARCHAR(50) | |
sid | INT | |
gid | INT | |
qid | INT | |
gseq | INT | |
qseq | INT | |
type | VARCHAR(50) | |
eqn | TEXT | |
prettyprint | TEXT | |
Indexes | ||
pk_lime_expression_errors | ON id | |
Foreign Keys | ||
fk_lime_expression_errors_lime_surveys | (sid) → lime_surveys | |
fk_lime_expression_errors_lime_groups | (gid) → lime_groups | |
fk_lime_expression_errors_lime_questions | (qid) → lime_questions |
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | id | INT AUTO_INCREMENT | |
* | surveyid | INT | |
* | responseid | INT | |
* | email_type | VARCHAR(200) COLLATE utf8mb4_unicode_ci | |
* | recipient | VARCHAR(320) COLLATE utf8mb4_unicode_ci | |
* | language | VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT 'en' | |
error_message | TEXT COLLATE utf8mb4_unicode_ci | ||
* | created | DATETIME | |
status | VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT 'SEND FAILED' | ||
updated | DATETIME | ||
* | resend_vars | TEXT COLLATE utf8mb4_unicode_ci | |
Indexes | |||
pk_lime_failed_emails | ON id | ||
Foreign Keys | |||
fk_lime_failed_emails_lime_surveys | (surveyid) → lime_surveys(sid) | sid | |
Options | |||
ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | ip | VARCHAR(40) |
* | last_attempt | VARCHAR(20) |
* | number_attempts | INT |
* | is_frontend | BOOLEAN |
Indexes | ||
pk_lime_failed_login_attempts | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | gid | INT |
* | group_name | TEXT |
description | MEDIUMTEXT | |
* | language | VARCHAR(20) |
Indexes | ||
pk_lime_group_l10ns | ON id | |
lime_idx1_group_ls | ON gid, language | |
Foreign Keys | ||
fk_lime_group_l10ns_lime_groups | (gid) → lime_groups |
Idx | Field Name | Data Type |
---|---|---|
* | gid | INT AUTO_INCREMENT |
* | sid | INT DEFAULT 0 |
* | group_order | INT DEFAULT 0 |
* | randomization_group | VARCHAR(20) DEFAULT '' |
grelevance | TEXT | |
Indexes | ||
pk_lime_groups | ON gid | |
lime_idx1_groups | ON sid | |
Referring Foreign Keys | ||
fk_lime_expression_errors_lime_groups | (gid) ← lime_expression_errors | |
fk_lime_group_l10ns_lime_groups | (gid) ← lime_group_l10ns | |
fk_lime_questions_lime_groups | (gid) ← lime_questions | |
fk_lime_surveys_lime_groups | (sid) ← lime_surveys |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | label_id | INT |
title | TEXT | |
* | language | VARCHAR(20) DEFAULT 'en' |
Indexes | ||
pk_lime_label_l10ns | ON id | |
Foreign Keys | ||
fk_lime_label_l10ns_lime_labels | (label_id) → lime_labels(id) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | lid | INT DEFAULT 0 |
* | code | VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT '' |
* | sortorder | INT |
* | assessment_value | INT DEFAULT 0 |
Indexes | ||
pk_lime_labels | ON id | |
lime_idx1_labels | ON code | |
lime_idx2_labels | ON sortorder | |
lime_idx4_labels | ON lid, sortorder | |
Foreign Keys | ||
fk_lime_labels_lime_labelsets | (lid) → lime_labelsets | |
Referring Foreign Keys | ||
fk_lime_label_l10ns_lime_labels | (id) ← lime_label_l10ns(label_id) |
Idx | Field Name | Data Type |
---|---|---|
* | lid | INT AUTO_INCREMENT |
* | label_name | VARCHAR(100) DEFAULT '' |
* | languages | VARCHAR(255) |
Indexes | ||
pk_lime_labelsets | ON lid | |
Referring Foreign Keys | ||
fk_lime_labels_lime_labelsets | (lid) ← lime_labels |
Idx | Field Name | Data Type |
---|---|---|
* | uid | INT |
* | tid | INT |
taken | INT DEFAULT 1 | |
Indexes | ||
pk_lime_map_tutorial_users | ON uid, tid | |
Foreign Keys | ||
fk_lime_map_tutorial_users_lime_tutorials | (tid) → lime_tutorials | |
Referring Foreign Keys | ||
fk_lime_users_lime_map_tutorial_users | (uid) ← lime_users |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT |
* | language | VARCHAR(50) COLLATE utf8mb4_unicode_ci DEFAULT '' |
translation | TEXT COLLATE utf8mb4_unicode_ci | |
Indexes | ||
pk_lime_message | ON id, language | |
Options | ||
ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | entity | VARCHAR(15) |
* | entity_id | INT |
* | title | VARCHAR(255) |
* | message | MEDIUMTEXT |
* | status | VARCHAR(15) DEFAULT 'new' |
* | importance | INT DEFAULT 1 |
display_class | VARCHAR(31) DEFAULT 'default' | |
hash | VARCHAR(64) | |
created | DATETIME | |
first_read | DATETIME | |
Indexes | ||
pk_lime_notifications | ON id | |
lime_idx1_notifications | ON hash | |
lime_notifications_pk | ON entity, entity_id, status |
Idx | Field Name | Data Type |
---|---|---|
* | participant_id | VARCHAR(50) |
* | attribute_id | INT |
* | value | TEXT |
Indexes | ||
pk_lime_participant_attribute | ON participant_id, attribute_id | |
Foreign Keys | ||
fk_lime_participant_attribute_lime_participants | (participant_id) → lime_participants | |
Referring Foreign Keys | ||
fk_lime_participant_attribute_names_lime_participant_attribute | (attribute_id) ← lime_participant_attribute_names | |
fk_lime_participant_attribute_names_lang_lime_participant_attribute | (attribute_id) ← lime_participant_attribute_names_lang | |
fk_lime_participant_attribute_values_lime_participant_attribute | (attribute_id) ← lime_participant_attribute_values |
Idx | Field Name | Data Type |
---|---|---|
* | attribute_id | INT AUTO_INCREMENT |
* | attribute_type | VARCHAR(4) |
* | defaultname | VARCHAR(255) |
* | visible | VARCHAR(5) |
* | encrypted | VARCHAR(5) |
* | core_attribute | VARCHAR(5) |
Indexes | ||
pk_lime_participant_attribute_names | ON attribute_id, attribute_type | |
Foreign Keys | ||
fk_lime_participant_attribute_names_lime_participant_attribute | (attribute_id) → lime_participant_attribute |
Idx | Field Name | Data Type |
---|---|---|
* | attribute_id | INT |
* | lang | VARCHAR(20) |
* | attribute_name | VARCHAR(255) |
Indexes | ||
pk_lime_participant_attribute_names_lang | ON attribute_id, lang | |
Foreign Keys | ||
fk_lime_participant_attribute_names_lang_lime_participant_attribute | (attribute_id) → lime_participant_attribute |
Idx | Field Name | Data Type |
---|---|---|
* | value_id | INT AUTO_INCREMENT |
* | attribute_id | INT |
* | value | MEDIUMTEXT |
Indexes | ||
pk_lime_participant_attribute_values | ON value_id | |
Foreign Keys | ||
fk_lime_participant_attribute_values_lime_participant_attribute | (attribute_id) → lime_participant_attribute |
Idx | Field Name | Data Type |
---|---|---|
* | participant_id | VARCHAR(50) |
* | share_uid | INT |
* | date_added | DATETIME |
* | can_edit | VARCHAR(5) |
Indexes | ||
pk_lime_participant_shares | ON participant_id, share_uid | |
Foreign Keys | ||
fk_lime_participant_shares_lime_participants | (participant_id) → lime_participants |
Idx | Field Name | Data Type |
---|---|---|
* | participant_id | VARCHAR(50) |
firstname | TEXT | |
lastname | TEXT | |
TEXT | ||
language | VARCHAR(40) | |
* | blacklisted | VARCHAR(1) |
* | owner_uid | INT |
* | created_by | INT |
created | DATETIME | |
modified | DATETIME | |
Indexes | ||
pk_lime_participants | ON participant_id | |
lime_idx3_participants | ON language | |
Foreign Keys | ||
fk_lime_participants_lime_users | (owner_uid) → lime_users(uid) | |
fk_lime_participants_lime_users_0 | (created_by) → lime_users(uid) | |
Referring Foreign Keys | ||
fk_lime_participant_attribute_lime_participants | (participant_id) ← lime_participant_attribute | |
fk_lime_participant_shares_lime_participants | (participant_id) ← lime_participant_shares |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | entity | VARCHAR(50) |
* | entity_id | INT |
* | uid | INT |
* | permission | VARCHAR(100) |
* | create_p | INT DEFAULT 0 |
* | read_p | INT DEFAULT 0 |
* | update_p | INT DEFAULT 0 |
* | delete_p | INT DEFAULT 0 |
* | import_p | INT DEFAULT 0 |
* | export_p | INT DEFAULT 0 |
Indexes | ||
pk_lime_permissions | ON id | |
lime_idx1_permissions | ON entity_id, entity, permission, uid | |
Foreign Keys | ||
fk_lime_permissions_lime_users | (uid) → lime_users |
Idx | Field Name | Data Type |
---|---|---|
* | ptid | INT AUTO_INCREMENT |
* | name | VARCHAR(127) |
description | TEXT | |
renewed_last | DATETIME | |
* | created_at | DATETIME |
* | created_by | INT |
Indexes | ||
pk_lime_permissiontemplates | ON ptid | |
lime_idx1_name | ON name | |
Foreign Keys | ||
fk_lime_permissiontemplates_lime_users | (created_by) → lime_users(uid) | |
Referring Foreign Keys | ||
fk_lime_user_in_permissionrole_lime_permissiontemplates | (ptid) ← lime_user_in_permissionrole |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | plugin_id | INT |
model | VARCHAR(50) | |
model_id | INT | |
* | key | VARCHAR(50) |
value | MEDIUMTEXT | |
Indexes | ||
pk_lime_plugin_settings | ON id | |
Foreign Keys | ||
fk_lime_plugin_settings_lime_plugins | (plugin_id) → lime_plugins(id) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | name | VARCHAR(50) |
plugin_type | VARCHAR(6) DEFAULT 'user' | |
* | active | INT DEFAULT 0 |
* | priority | INT DEFAULT 0 |
version | VARCHAR(32) | |
load_error | INT DEFAULT 0 | |
load_error_message | TEXT | |
Indexes | ||
pk_lime_plugins | ON id | |
Referring Foreign Keys | ||
fk_lime_plugin_settings_lime_plugins | (id) ← lime_plugin_settings(plugin_id) |
Idx | Field Name | Data Type |
---|---|---|
* | qaid | INT AUTO_INCREMENT |
* | qid | INT DEFAULT 0 |
attribute | VARCHAR(50) | |
value | MEDIUMTEXT | |
language | VARCHAR(20) | |
Indexes | ||
pk_lime_question_attributes | ON qaid | |
lime_idx1_question_attributes | ON qid | |
lime_idx2_question_attributes | ON attribute | |
Referring Foreign Keys | ||
fk_lime_questions_lime_question_attributes | (qid) ← lime_questions |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | qid | INT |
* | question | MEDIUMTEXT |
help | MEDIUMTEXT | |
script | TEXT | |
* | language | VARCHAR(20) |
Indexes | ||
pk_lime_question_l10ns | ON id | |
lime_idx1_question_ls | ON qid, language | |
Referring Foreign Keys | ||
fk_lime_questions_lime_question_l10ns | (qid) ← lime_questions |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | name | VARCHAR(150) |
visible | VARCHAR(1) | |
xml_path | VARCHAR(255) | |
image_path | VARCHAR(255) | |
* | title | VARCHAR(100) |
creation_date | DATETIME | |
author | VARCHAR(150) | |
author_email | VARCHAR(255) | |
author_url | VARCHAR(255) | |
copyright | TEXT | |
license | TEXT | |
version | VARCHAR(45) | |
* | api_version | VARCHAR(45) |
description | TEXT | |
last_update | DATETIME | |
owner_id | INT | |
theme_type | VARCHAR(150) | |
* | question_type | VARCHAR(150) |
core_theme | BOOLEAN | |
extends | VARCHAR(150) | |
group | VARCHAR(150) | |
settings | TEXT | |
Indexes | ||
pk_lime_question_themes | ON id | |
lime_idx1_question_themes | ON name | |
Foreign Keys | ||
fk_lime_question_themes_lime_users | (owner_id) → lime_users(uid) |
Idx | Field Name | Data Type |
---|---|---|
* | qid | INT AUTO_INCREMENT |
* | parent_qid | INT DEFAULT 0 |
* | sid | INT DEFAULT 0 |
* | gid | INT DEFAULT 0 |
* | type | VARCHAR(30) DEFAULT 'T' |
* | title | VARCHAR(20) DEFAULT '' |
preg | TEXT | |
* | other | VARCHAR(1) DEFAULT 'N' |
mandatory | VARCHAR(1) | |
encrypted | VARCHAR(1) DEFAULT 'N' | |
* | question_order | INT |
* | scale_id | INT DEFAULT 0 |
* | same_default | INT DEFAULT 0 |
relevance | TEXT | |
modulename | VARCHAR(255) | |
question_theme_name | VARCHAR(150) COLLATE utf8mb4_unicode_ci | |
* | same_script | INT DEFAULT 0 |
Indexes | ||
pk_lime_questions | ON qid | |
lime_idx1_questions | ON sid | |
lime_idx2_questions | ON gid | |
lime_idx3_questions | ON type | |
lime_idx4_questions | ON title | |
lime_idx5_questions | ON parent_qid | |
Foreign Keys | ||
fk_lime_questions_lime_conditions | (qid) → lime_conditions | |
fk_lime_questions_lime_questions | (parent_qid) → lime_questions | |
fk_lime_questions_lime_quota_members | (qid) → lime_quota_members | |
fk_lime_questions_lime_question_attributes | (qid) → lime_question_attributes | |
fk_lime_questions_lime_answers | (qid) → lime_answers | |
fk_lime_questions_lime_question_l10ns | (qid) → lime_question_l10ns | |
fk_lime_questions_lime_surveys | (sid) → lime_surveys | |
fk_lime_questions_lime_groups | (gid) → lime_groups | |
Referring Foreign Keys | ||
fk_lime_defaultvalues_lime_questions | (qid) ← lime_defaultvalues | |
fk_lime_defaultvalues_lime_questions_0 | (qid) ← lime_defaultvalues(sqid) | |
fk_lime_expression_errors_lime_questions | (qid) ← lime_expression_errors | |
fk_lime_questions_lime_questions | (parent_qid) ← lime_questions | |
fk_lime_survey_url_parameters_lime_questions | (qid) ← lime_survey_url_parameters(targetqid) | |
fk_lime_survey_url_parameters_lime_questions_0 | (qid) ← lime_survey_url_parameters(targetsqid) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
sid | INT | |
name | VARCHAR(255) | |
qlimit | INT | |
action | INT | |
* | active | INT DEFAULT 1 |
* | autoload_url | INT DEFAULT 0 |
Indexes | ||
pk_lime_quota | ON id | |
lime_idx1_quota | ON sid | |
Foreign Keys | ||
fk_lime_quota_lime_surveys | (sid) → lime_surveys | |
Referring Foreign Keys | ||
fk_lime_quota_languagesettings_lime_quota | (id) ← lime_quota_languagesettings(quotals_quota_id) | |
fk_lime_quota_members_lime_quota | (id) ← lime_quota_members(quota_id) |
Idx | Field Name | Data Type |
---|---|---|
* | quotals_id | INT AUTO_INCREMENT |
* | quotals_quota_id | INT DEFAULT 0 |
* | quotals_language | VARCHAR(45) DEFAULT 'en' |
quotals_name | VARCHAR(255) | |
* | quotals_message | MEDIUMTEXT |
quotals_url | VARCHAR(255) | |
quotals_urldescrip | VARCHAR(255) | |
Indexes | ||
pk_lime_quota_languagesettings | ON quotals_id | |
Foreign Keys | ||
fk_lime_quota_languagesettings_lime_quota | (quotals_quota_id) → lime_quota(id) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
sid | INT | |
qid | INT | |
quota_id | INT | |
code | VARCHAR(11) | |
Indexes | ||
pk_lime_quota_members | ON id | |
lime_idx1_quota_members | ON sid, qid, quota_id, code | |
Foreign Keys | ||
fk_lime_quota_members_lime_quota | (quota_id) → lime_quota(id) | |
Referring Foreign Keys | ||
fk_lime_questions_lime_quota_members | (qid) ← lime_questions | |
fk_lime_surveys_lime_quota_members | (sid) ← lime_surveys |
Idx | Field Name | Data Type |
---|---|---|
* | scid | INT AUTO_INCREMENT |
* | sid | INT DEFAULT 0 |
* | srid | INT DEFAULT 0 |
* | identifier | TEXT |
* | access_code | TEXT |
VARCHAR(192) | ||
* | ip | TEXT |
* | saved_thisstep | TEXT |
* | status | VARCHAR(1) DEFAULT '' |
* | saved_date | DATETIME |
refurl | TEXT | |
Indexes | ||
pk_lime_saved_control | ON scid | |
lime_idx1_saved_control | ON sid | |
lime_idx2_saved_control | ON srid | |
Foreign Keys | ||
fk_lime_saved_control_lime_surveys | (sid) → lime_surveys |
Idx | Field Name | Data Type |
---|---|---|
* | id | VARCHAR(32) |
expire | INT | |
data | LONGBLOB | |
Indexes | ||
pk_lime_sessions | ON id | |
sess_expire | ON expire |
Idx | Field Name | Data Type |
---|---|---|
* | stg_name | VARCHAR(50) DEFAULT '' |
* | stg_value | MEDIUMTEXT |
Indexes | ||
pk_lime_settings_global | ON stg_name |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | uid | INT |
entity | VARCHAR(15) | |
entity_id | VARCHAR(31) | |
* | stg_name | VARCHAR(63) |
stg_value | MEDIUMTEXT | |
Indexes | ||
pk_lime_settings_user | ON id | |
lime_idx1_settings_user | ON uid | |
lime_idx2_settings_user | ON entity | |
lime_idx3_settings_user | ON entity_id | |
lime_idx4_settings_user | ON stg_name | |
Foreign Keys | ||
fk_lime_settings_user_lime_users | (uid) → lime_users |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
category | VARCHAR(35) COLLATE utf8mb4_unicode_ci | |
message | TEXT COLLATE utf8mb4_unicode_ci | |
Indexes | ||
pk_lime_source_message | ON id | |
Options | ||
ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
Idx | Field Name | Data Type |
---|---|---|
* | participant_id | VARCHAR(50) |
* | token_id | INT |
* | survey_id | INT |
date_created | DATETIME | |
date_invited | DATETIME | |
date_completed | DATETIME | |
Indexes | ||
pk_lime_survey_links | ON participant_id, token_id, survey_id | |
Foreign Keys | ||
fk_lime_survey_links_lime_surveys | (survey_id) → lime_surveys(sid) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | sid | INT |
* | parameter | VARCHAR(50) |
targetqid | INT | |
targetsqid | INT | |
Indexes | ||
pk_lime_survey_url_parameters | ON id | |
Foreign Keys | ||
fk_lime_survey_url_parameters_lime_questions | (targetqid) → lime_questions(qid) | |
fk_lime_survey_url_parameters_lime_questions_0 | (targetsqid) → lime_questions(qid) | |
Referring Foreign Keys | ||
fk_lime_surveys_lime_survey_url_parameters | (sid) ← lime_surveys |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
parent_id | INT | |
survey_id | INT | |
user_id | INT | |
name | VARCHAR(128) | |
ordering | INT DEFAULT 0 | |
level | INT DEFAULT 0 | |
* | title | VARCHAR(168) DEFAULT '' |
* | position | VARCHAR(192) DEFAULT 'side' |
description | TEXT | |
showincollapse | INT DEFAULT 0 | |
* | active | INT DEFAULT 0 |
changed_at | DATETIME | |
* | changed_by | INT DEFAULT 0 |
created_at | DATETIME | |
* | created_by | INT DEFAULT 0 |
Indexes | ||
pk_lime_surveymenu | ON id | |
lime_surveymenu_name | ON name | |
lime_idx2_surveymenu | ON title | |
Foreign Keys | ||
fk_lime_surveymenu_lime_users | (created_by) → lime_users(uid) | |
fk_lime_surveymenu_lime_users_0 | (changed_by) → lime_users(uid) | |
fk_lime_surveymenu_lime_surveys | (survey_id) → lime_surveys(sid) | |
fk_lime_surveymenu_lime_users_1 | (user_id) → lime_users(uid) | |
Referring Foreign Keys | ||
fk_lime_surveymenu_entries_lime_surveymenu | (id) ← lime_surveymenu_entries(menu_id) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
menu_id | INT | |
user_id | INT | |
ordering | INT DEFAULT 0 | |
name | VARCHAR(168) DEFAULT '' | |
* | title | VARCHAR(168) DEFAULT '' |
* | menu_title | VARCHAR(168) DEFAULT '' |
menu_description | TEXT | |
* | menu_icon | VARCHAR(192) DEFAULT '' |
* | menu_icon_type | VARCHAR(192) DEFAULT '' |
* | menu_class | VARCHAR(192) DEFAULT '' |
* | menu_link | VARCHAR(192) DEFAULT '' |
* | action | VARCHAR(192) DEFAULT '' |
* | template | VARCHAR(192) DEFAULT '' |
* | partial | VARCHAR(192) DEFAULT '' |
* | classes | VARCHAR(192) DEFAULT '' |
* | permission | VARCHAR(192) DEFAULT '' |
permission_grade | VARCHAR(192) | |
data | MEDIUMTEXT | |
* | getdatamethod | VARCHAR(192) DEFAULT '' |
* | language | VARCHAR(32) DEFAULT 'en-GB' |
showincollapse | INT DEFAULT 0 | |
* | active | INT DEFAULT 0 |
changed_at | DATETIME | |
* | changed_by | INT DEFAULT 0 |
created_at | DATETIME | |
* | created_by | INT DEFAULT 0 |
Indexes | ||
pk_lime_surveymenu_entries | ON id | |
lime_surveymenu_entries_name | ON name | |
lime_idx1_surveymenu_entries | ON menu_id | |
lime_idx5_surveymenu_entries | ON menu_title | |
Foreign Keys | ||
fk_lime_surveymenu_entries_lime_surveymenu | (menu_id) → lime_surveymenu(id) | |
fk_lime_surveymenu_entries | (user_id) → lime_users(uid) | |
fk_lime_surveymenu_entries_lime_users | (changed_by) → lime_users(uid) | |
fk_lime_surveymenu_entries_lime_users_0 | (created_by) → lime_users(uid) |
Idx | Field Name | Data Type |
---|---|---|
* | sid | INT |
* | owner_id | INT |
gsid | INT DEFAULT 1 | |
admin | VARCHAR(50) | |
* | active | VARCHAR(1) DEFAULT 'N' |
expires | DATETIME | |
startdate | DATETIME | |
adminemail | VARCHAR(254) | |
* | anonymized | VARCHAR(1) DEFAULT 'N' |
format | VARCHAR(1) | |
* | savetimings | VARCHAR(1) DEFAULT 'N' |
template | VARCHAR(100) DEFAULT 'default' | |
language | VARCHAR(50) | |
additional_languages | TEXT | |
* | datestamp | VARCHAR(1) DEFAULT 'N' |
* | usecookie | VARCHAR(1) DEFAULT 'N' |
* | allowregister | VARCHAR(1) DEFAULT 'N' |
* | allowsave | VARCHAR(1) DEFAULT 'Y' |
* | autonumber_start | INT DEFAULT 0 |
* | autoredirect | VARCHAR(1) DEFAULT 'N' |
* | allowprev | VARCHAR(1) DEFAULT 'N' |
* | printanswers | VARCHAR(1) DEFAULT 'N' |
* | ipaddr | VARCHAR(1) DEFAULT 'N' |
* | ipanonymize | VARCHAR(1) DEFAULT 'N' |
* | refurl | VARCHAR(1) DEFAULT 'N' |
datecreated | DATETIME | |
showsurveypolicynotice | INT DEFAULT 0 | |
* | publicstatistics | VARCHAR(1) DEFAULT 'N' |
* | publicgraphs | VARCHAR(1) DEFAULT 'N' |
* | listpublic | VARCHAR(1) DEFAULT 'N' |
* | htmlemail | VARCHAR(1) DEFAULT 'Y' |
* | sendconfirmation | VARCHAR(1) DEFAULT 'Y' |
* | tokenanswerspersistence | VARCHAR(1) DEFAULT 'N' |
* | assessments | VARCHAR(1) DEFAULT 'N' |
* | usecaptcha | VARCHAR(1) DEFAULT 'N' |
* | usetokens | VARCHAR(1) DEFAULT 'N' |
bounce_email | VARCHAR(254) | |
attributedescriptions | MEDIUMTEXT | |
emailresponseto | TEXT | |
emailnotificationto | TEXT | |
* | tokenlength | INT DEFAULT 15 |
showxquestions | VARCHAR(1) DEFAULT 'Y' | |
showgroupinfo | VARCHAR(1) DEFAULT 'B' | |
shownoanswer | VARCHAR(1) DEFAULT 'Y' | |
showqnumcode | VARCHAR(1) DEFAULT 'X' | |
bouncetime | INT | |
bounceprocessing | VARCHAR(1) DEFAULT 'N' | |
bounceaccounttype | VARCHAR(4) | |
bounceaccounthost | VARCHAR(200) | |
bounceaccountpass | TEXT | |
bounceaccountencryption | VARCHAR(3) | |
bounceaccountuser | VARCHAR(200) | |
showwelcome | VARCHAR(1) DEFAULT 'Y' | |
showprogress | VARCHAR(1) DEFAULT 'Y' | |
* | questionindex | INT DEFAULT 0 |
* | navigationdelay | INT DEFAULT 0 |
nokeyboard | VARCHAR(1) DEFAULT 'N' | |
alloweditaftercompletion | VARCHAR(1) DEFAULT 'N' | |
googleanalyticsstyle | VARCHAR(1) | |
googleanalyticsapikey | VARCHAR(25) | |
tokenencryptionoptions | TEXT | |
Indexes | ||
pk_lime_surveys | ON sid | |
lime_idx1_surveys | ON owner_id | |
lime_idx2_surveys | ON gsid | |
Foreign Keys | ||
fk_lime_surveys_lime_surveys_languagesettings | (sid) → lime_surveys_languagesettings(surveyls_survey_id) | |
fk_lime_surveys_lime_archived_table_settings | (sid) → lime_archived_table_settings(survey_id) | |
fk_lime_surveys_lime_assessments | (sid) → lime_assessments | |
fk_lime_surveys_lime_groups | (sid) → lime_groups | |
fk_lime_surveys_lime_survey_url_parameters | (sid) → lime_survey_url_parameters | |
fk_lime_surveys_lime_quota_members | (sid) → lime_quota_members | |
Referring Foreign Keys | ||
fk_lime_expression_errors_lime_surveys | (sid) ← lime_expression_errors | |
fk_lime_questions_lime_surveys | (sid) ← lime_questions | |
fk_lime_quota_lime_surveys | (sid) ← lime_quota | |
fk_lime_saved_control_lime_surveys | (sid) ← lime_saved_control | |
fk_lime_survey_links_lime_surveys | (sid) ← lime_survey_links(survey_id) | |
fk_lime_surveymenu_lime_surveys | (sid) ← lime_surveymenu(survey_id) | |
fk_lime_tutorial_entry_relation_lime_surveys | (sid) ← lime_tutorial_entry_relation | |
fk_lime_failed_emails_lime_surveys | (sid) ← lime_failed_emails(surveyid) | |
fk_lime_failed_emails_lime_surveys | (sid) ← lime_failed_emails(surveyid) | |
fk_lime_failed_emails_lime_surveys | (sid) ← lime_failed_emails(surveyid) |
Idx | Field Name | Data Type |
---|---|---|
* | gsid | INT AUTO_INCREMENT |
* | name | VARCHAR(45) |
title | VARCHAR(100) | |
template | VARCHAR(128) DEFAULT 'default' | |
description | TEXT | |
* | sortorder | INT |
owner_id | INT | |
parent_id | INT | |
alwaysavailable | BOOLEAN | |
created | DATETIME | |
modified | DATETIME | |
* | created_by | INT |
Indexes | ||
pk_lime_surveys_groups | ON gsid | |
lime_idx1_surveys_groups | ON name | |
lime_idx2_surveys_groups | ON title | |
Foreign Keys | ||
fk_lime_surveys_groups_lime_users | (created_by) → lime_users(uid) | |
fk_lime_surveys_groups_lime_users_0 | (owner_id) → lime_users(uid) | |
fk_lime_surveys_groups_lime_surveys_groups | (parent_id) → lime_surveys_groups(gsid) | |
Referring Foreign Keys | ||
fk_lime_surveys_groups_lime_surveys_groups | (gsid) ← lime_surveys_groups(parent_id) |
Idx | Field Name | Data Type |
---|---|---|
* | gsid | INT |
owner_id | INT | |
admin | VARCHAR(50) | |
adminemail | VARCHAR(254) | |
* | anonymized | VARCHAR(1) DEFAULT 'N' |
format | VARCHAR(1) | |
* | savetimings | VARCHAR(1) DEFAULT 'N' |
template | VARCHAR(100) DEFAULT 'default' | |
* | datestamp | VARCHAR(1) DEFAULT 'N' |
* | usecookie | VARCHAR(1) DEFAULT 'N' |
* | allowregister | VARCHAR(1) DEFAULT 'N' |
* | allowsave | VARCHAR(1) DEFAULT 'Y' |
autonumber_start | INT DEFAULT 0 | |
* | autoredirect | VARCHAR(1) DEFAULT 'N' |
* | allowprev | VARCHAR(1) DEFAULT 'N' |
* | printanswers | VARCHAR(1) DEFAULT 'N' |
* | ipaddr | VARCHAR(1) DEFAULT 'N' |
* | ipanonymize | VARCHAR(1) DEFAULT 'N' |
* | refurl | VARCHAR(1) DEFAULT 'N' |
showsurveypolicynotice | INT DEFAULT 0 | |
* | publicstatistics | VARCHAR(1) DEFAULT 'N' |
* | publicgraphs | VARCHAR(1) DEFAULT 'N' |
* | listpublic | VARCHAR(1) DEFAULT 'N' |
* | htmlemail | VARCHAR(1) DEFAULT 'Y' |
* | sendconfirmation | VARCHAR(1) DEFAULT 'Y' |
* | tokenanswerspersistence | VARCHAR(1) DEFAULT 'N' |
* | assessments | VARCHAR(1) DEFAULT 'N' |
* | usecaptcha | VARCHAR(1) DEFAULT 'N' |
bounce_email | VARCHAR(254) | |
attributedescriptions | TEXT | |
emailresponseto | TEXT | |
emailnotificationto | TEXT | |
tokenlength | INT DEFAULT 15 | |
showxquestions | VARCHAR(1) DEFAULT 'Y' | |
showgroupinfo | VARCHAR(1) DEFAULT 'B' | |
shownoanswer | VARCHAR(1) DEFAULT 'Y' | |
showqnumcode | VARCHAR(1) DEFAULT 'X' | |
showwelcome | VARCHAR(1) DEFAULT 'Y' | |
showprogress | VARCHAR(1) DEFAULT 'Y' | |
questionindex | INT DEFAULT 0 | |
navigationdelay | INT DEFAULT 0 | |
nokeyboard | VARCHAR(1) DEFAULT 'N' | |
alloweditaftercompletion | VARCHAR(1) DEFAULT 'N' | |
Indexes | ||
pk_lime_surveys_groupsettings | ON gsid | |
Foreign Keys | ||
fk_lime_surveys_groupsettings_lime_users | (owner_id) → lime_users(uid) |
Idx | Field Name | Data Type |
---|---|---|
* | surveyls_survey_id | INT |
* | surveyls_language | VARCHAR(45) DEFAULT 'en' |
* | surveyls_title | VARCHAR(200) |
surveyls_description | MEDIUMTEXT | |
surveyls_welcometext | MEDIUMTEXT | |
surveyls_endtext | MEDIUMTEXT | |
surveyls_policy_notice | MEDIUMTEXT | |
surveyls_policy_error | TEXT | |
surveyls_policy_notice_label | VARCHAR(192) | |
surveyls_url | TEXT | |
surveyls_urldescription | VARCHAR(255) | |
surveyls_email_invite_subj | VARCHAR(255) | |
surveyls_email_invite | MEDIUMTEXT | |
surveyls_email_remind_subj | VARCHAR(255) | |
surveyls_email_remind | MEDIUMTEXT | |
surveyls_email_register_subj | VARCHAR(255) | |
surveyls_email_register | MEDIUMTEXT | |
surveyls_email_confirm_subj | VARCHAR(255) | |
surveyls_email_confirm | MEDIUMTEXT | |
* | surveyls_dateformat | INT DEFAULT 1 |
surveyls_attributecaptions | TEXT | |
email_admin_notification_subj | VARCHAR(255) | |
email_admin_notification | MEDIUMTEXT | |
email_admin_responses_subj | VARCHAR(255) | |
email_admin_responses | MEDIUMTEXT | |
* | surveyls_numberformat | INT DEFAULT 0 |
attachments | TEXT | |
Indexes | ||
pk_lime_surveys_languagesettings | ON surveyls_survey_id, surveyls_language | |
lime_idx1_surveys_languagesettings | ON surveyls_title | |
Referring Foreign Keys | ||
fk_lime_surveys_lime_surveys_languagesettings | (surveyls_survey_id) ← lime_surveys(sid) |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | template_name | VARCHAR(150) |
sid | INT | |
gsid | INT | |
uid | INT | |
files_css | TEXT | |
files_js | TEXT | |
files_print_css | TEXT | |
options | TEXT | |
cssframework_name | VARCHAR(45) | |
cssframework_css | MEDIUMTEXT | |
cssframework_js | MEDIUMTEXT | |
packages_to_load | TEXT | |
packages_ltr | TEXT | |
packages_rtl | TEXT | |
Indexes | ||
pk_lime_template_configuration | ON id | |
lime_idx1_template_configuration | ON template_name | |
lime_idx2_template_configuration | ON sid | |
lime_idx3_template_configuration | ON gsid | |
lime_idx4_template_configuration | ON uid |
Idx | Field Name | Data Type |
---|---|---|
* | id | INT AUTO_INCREMENT |
* | name | VARCHAR(150) |
folder | VARCHAR(45) | |
* | title | VARCHAR(100) |
creation_date | DATETIME | |
author | VARCHAR(150) | |
author_email | VARCHAR(255) | |
author_url | VARCHAR(255) | |
copyright | TEXT | |
license | MEDIUMTEXT | |
version | VARCHAR(45) | |
* | api_version | VARCHAR(45) |
* | view_folder | VARCHAR(45) |
* | files_folder | VARCHAR(45) |
description | MEDIUMTEXT | |
last_update | DATETIME | |
owner_id | INT | |
extends | VARCHAR(150) | |
Indexes | ||
pk_lime_templates | ON id | |
lime_idx1_templates | ON name | |
lime_idx2_templates | ON title | |
lime_idx3_templates | ON owner_id | |
lime_idx4_templates | ON extends |
Idx | Field Name | Data Type |
---|---|---|
* | teid | INT AUTO_INCREMENT |
ordering | INT | |
title | TEXT | |
content | MEDIUMTEXT | |
settings | MEDIUMTEXT | |
Indexes | ||
pk_lime_tutorial_entries | ON teid | |
Referring Foreign Keys | ||
fk_lime_tutorial_entry_relation_lime_tutorial_entries | (teid) ← lime_tutorial_entry_relation |
Idx | Field Name | Data Type |
---|---|---|
* | teid | INT |
* | tid | INT |
uid | INT | |
sid | INT | |
Indexes | ||
pk_lime_tutorial_entry_relation | ON teid, tid | |
lime_idx1_tutorial_entry_relation | ON uid | |
lime_idx2_tutorial_entry_relation | ON sid | |
Foreign Keys | ||
fk_lime_tutorial_entry_relation_lime_tutorial_entries | (teid) → lime_tutorial_entries | |
fk_lime_tutorial_entry_relation_lime_tutorials | (tid) → lime_tutorials | |
fk_lime_tutorial_entry_relation_lime_users | (uid) → lime_users | |
fk_lime_tutorial_entry_relation_lime_surveys | (sid) → lime_surveys |
Idx | Field Name | Data Type |
---|---|---|
* | tid | INT AUTO_INCREMENT |
name | VARCHAR(128) | |
title | VARCHAR(192) | |
icon | VARCHAR(64) | |
description | TEXT | |
active | INT DEFAULT 0 | |
settings | MEDIUMTEXT | |
* | permission | VARCHAR(128) |
* | permission_grade | VARCHAR(128) |
Indexes | ||
pk_lime_tutorials | ON tid | |
lime_idx1_tutorials | ON name | |
Referring Foreign Keys | ||
fk_lime_map_tutorial_users_lime_tutorials | (tid) ← lime_map_tutorial_users | |
fk_lime_tutorial_entry_relation_lime_tutorials | (tid) ← lime_tutorial_entry_relation |
Idx | Field Name | Data Type |
---|---|---|
* | uid | INT |
* | secretKey | VARCHAR(255) COLLATE utf8mb4_unicode_ci |
* | authType | VARCHAR(255) COLLATE utf8mb4_unicode_ci |
firstLogin | INT DEFAULT 1 | |
forceNewFirstLogin | INT DEFAULT 0 | |
Options | ||
ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
Idx | Field Name | Data Type |
---|---|---|
* | ugid | INT AUTO_INCREMENT |
* | name | VARCHAR(20) |
* | description | TEXT |
* | owner_id | INT |
Indexes | ||
pk_lime_user_groups | ON ugid | |
lime_idx1_user_groups | ON name | |
Foreign Keys | ||
fk_lime_user_groups_lime_users | (owner_id) → lime_users(uid) | |
Referring Foreign Keys | ||
fk_lime_user_in_groups_lime_user_groups | (ugid) ← lime_user_in_groups |
Idx | Field Name | Data Type |
---|---|---|
* | ugid | INT |
* | uid | INT |
Indexes | ||
pk_lime_user_in_groups | ON ugid, uid | |
Foreign Keys | ||
fk_lime_user_in_groups_lime_user_groups | (ugid) → lime_user_groups | |
Referring Foreign Keys | ||
fk_lime_users_lime_user_in_groups | (uid) ← lime_users |
Idx | Field Name | Data Type |
---|---|---|
* | ptid | INT |
* | uid | INT |
Indexes | ||
pk_lime_user_in_permissionrole | ON ptid, uid | |
Foreign Keys | ||
fk_lime_user_in_permissionrole_lime_permissiontemplates | (ptid) → lime_permissiontemplates | |
Referring Foreign Keys | ||
fk_lime_users_lime_user_in_permissionrole | (uid) ← lime_users |
Idx | Field Name | Data Type |
---|---|---|
* | uid | INT AUTO_INCREMENT |
* | users_name | VARCHAR(64) DEFAULT '' |
* | password | TEXT |
* | full_name | VARCHAR(50) |
lang | VARCHAR(20) | |
* | parent_id | INT |
VARCHAR(192) | ||
htmleditormode | VARCHAR(7) DEFAULT 'default' | |
* | templateeditormode | VARCHAR(7) DEFAULT 'default' |
* | questionselectormode | VARCHAR(7) DEFAULT 'default' |
one_time_pw | TEXT | |
* | dateformat | INT DEFAULT 1 |
last_login | DATETIME | |
created | DATETIME | |
modified | DATETIME | |
validation_key | VARCHAR(38) | |
validation_key_expiration | DATETIME | |
last_forgot_email_password | DATETIME | |
Indexes | ||
pk_lime_users | ON uid | |
lime_idx1_users | ON users_name | |
lime_idx2_users | ON email | |
Foreign Keys | ||
fk_lime_users_lime_user_in_groups | (uid) → lime_user_in_groups | |
fk_lime_users_lime_map_tutorial_users | (uid) → lime_map_tutorial_users | |
fk_lime_users_lime_user_in_permissionrole | (uid) → lime_user_in_permissionrole | |
fk_lime_users_lime_users | (parent_id) → lime_users(uid) | |
Referring Foreign Keys | ||
fk_lime_archived_table_settings_lime_users | (uid) ← lime_archived_table_settings(user_id) | |
fk_lime_participants_lime_users | (uid) ← lime_participants(owner_uid) | |
fk_lime_participants_lime_users_0 | (uid) ← lime_participants(created_by) | |
fk_lime_permissions_lime_users | (uid) ← lime_permissions | |
fk_lime_permissiontemplates_lime_users | (uid) ← lime_permissiontemplates(created_by) | |
fk_lime_question_themes_lime_users | (uid) ← lime_question_themes(owner_id) | |
fk_lime_settings_user_lime_users | (uid) ← lime_settings_user | |
fk_lime_surveymenu_lime_users | (uid) ← lime_surveymenu(created_by) | |
fk_lime_surveymenu_lime_users_0 | (uid) ← lime_surveymenu(changed_by) | |
fk_lime_surveymenu_lime_users_1 | (uid) ← lime_surveymenu(user_id) | |
fk_lime_surveymenu_entries | (uid) ← lime_surveymenu_entries(user_id) | |
fk_lime_surveymenu_entries_lime_users | (uid) ← lime_surveymenu_entries(changed_by) | |
fk_lime_surveymenu_entries_lime_users_0 | (uid) ← lime_surveymenu_entries(created_by) | |
fk_lime_surveys_groups_lime_users | (uid) ← lime_surveys_groups(created_by) | |
fk_lime_surveys_groups_lime_users_0 | (uid) ← lime_surveys_groups(owner_id) | |
fk_lime_surveys_groupsettings_lime_users | (uid) ← lime_surveys_groupsettings(owner_id) | |
fk_lime_tutorial_entry_relation_lime_users | (uid) ← lime_tutorial_entry_relation | |
fk_lime_user_groups_lime_users | (uid) ← lime_user_groups(owner_id) | |
fk_lime_users_lime_users | (uid) ← lime_users(parent_id) |