| 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) | |