Layout with Tools

U LimeSurvey 5.4 database schema @ DbSchema Read the schema comments as mouse-over tooltips. Zoom using CTRL + mouse wheel, pan by dragging with the right-mouse button. Templates Survey participants lime_plugin_settings Global settings Label sets Survey groups Tutorials Survey menus Central participant database Users Surveys Fk fk_lime_answer_l10ns_lime_answers lime_answer_l10ns ref lime_answers ( aid ) Fk fk_lime_answer_l10ns_lime_answers lime_answer_l10ns ref lime_answers ( aid ) aid Fk fk_lime_archived_table_settings_lime_users lime_archived_table_settings ref lime_users ( user_id -> uid ) Fk fk_lime_archived_table_settings_lime_users lime_archived_table_settings ref lime_users ( user_id -> uid ) user_id Fk fk_lime_defaultvalue_l10ns_lime_defaultvalues lime_defaultvalue_l10ns ref lime_defaultvalues ( dvid ) Fk fk_lime_defaultvalue_l10ns_lime_defaultvalues lime_defaultvalue_l10ns ref lime_defaultvalues ( dvid ) dvid Fk fk_lime_defaultvalues_lime_questions lime_defaultvalues ref lime_questions ( qid ) Fk fk_lime_defaultvalues_lime_questions lime_defaultvalues ref lime_questions ( qid ) qid Fk fk_lime_defaultvalues_lime_questions_0 lime_defaultvalues ref lime_questions ( sqid -> qid ) Fk fk_lime_defaultvalues_lime_questions_0 lime_defaultvalues ref lime_questions ( sqid -> qid ) sqid Fk fk_lime_expression_errors_lime_surveys lime_expression_errors ref lime_surveys ( sid ) Fk fk_lime_expression_errors_lime_surveys lime_expression_errors ref lime_surveys ( sid ) sid Fk fk_lime_expression_errors_lime_groups lime_expression_errors ref lime_groups ( gid ) Fk fk_lime_expression_errors_lime_groups lime_expression_errors ref lime_groups ( gid ) gid Fk fk_lime_expression_errors_lime_questions lime_expression_errors ref lime_questions ( qid ) Fk fk_lime_expression_errors_lime_questions lime_expression_errors ref lime_questions ( qid ) qid Fk fk_lime_failed_emails_lime_surveys lime_failed_emails ref lime_surveys ( surveyid -> sid ) sid Fk fk_lime_failed_emails_lime_surveys lime_failed_emails ref lime_surveys ( surveyid -> sid ) sid surveyid Fk fk_lime_group_l10ns_lime_groups lime_group_l10ns ref lime_groups ( gid ) Fk fk_lime_group_l10ns_lime_groups lime_group_l10ns ref lime_groups ( gid ) gid Fk fk_lime_label_l10ns_lime_labels lime_label_l10ns ref lime_labels ( label_id -> id ) Fk fk_lime_label_l10ns_lime_labels lime_label_l10ns ref lime_labels ( label_id -> id ) label_id Fk fk_lime_labels_lime_labelsets lime_labels ref lime_labelsets ( lid ) Fk fk_lime_labels_lime_labelsets lime_labels ref lime_labelsets ( lid ) lid Fk fk_lime_map_tutorial_users_lime_tutorials lime_map_tutorial_users ref lime_tutorials ( tid ) Fk fk_lime_map_tutorial_users_lime_tutorials lime_map_tutorial_users ref lime_tutorials ( tid ) tid Fk fk_lime_participant_attribute_lime_participants lime_participant_attribute ref lime_participants ( participant_id ) Fk fk_lime_participant_attribute_lime_participants lime_participant_attribute ref lime_participants ( participant_id ) participant_id Fk fk_lime_participant_attribute_names_lime_participant_attribute lime_participant_attribute_names ref lime_participant_attribute ( attribute_id ) Fk fk_lime_participant_attribute_names_lime_participant_attribute lime_participant_attribute_names ref lime_participant_attribute ( attribute_id ) attribute_id Fk fk_lime_participant_attribute_names_lang_lime_participant_attribute lime_participant_attribute_names_lang ref lime_participant_attribute ( attribute_id ) Fk fk_lime_participant_attribute_names_lang_lime_participant_attribute lime_participant_attribute_names_lang ref lime_participant_attribute ( attribute_id ) attribute_id Fk fk_lime_participant_attribute_values_lime_participant_attribute lime_participant_attribute_values ref lime_participant_attribute ( attribute_id ) Fk fk_lime_participant_attribute_values_lime_participant_attribute lime_participant_attribute_values ref lime_participant_attribute ( attribute_id ) attribute_id Fk fk_lime_participant_shares_lime_participants lime_participant_shares ref lime_participants ( participant_id ) Fk fk_lime_participant_shares_lime_participants lime_participant_shares ref lime_participants ( participant_id ) participant_id Fk fk_lime_participants_lime_users lime_participants ref lime_users ( owner_uid -> uid ) Fk fk_lime_participants_lime_users lime_participants ref lime_users ( owner_uid -> uid ) owner_uid Fk fk_lime_participants_lime_users_0 lime_participants ref lime_users ( created_by -> uid ) Fk fk_lime_participants_lime_users_0 lime_participants ref lime_users ( created_by -> uid ) created_by Fk fk_lime_permissions_lime_users lime_permissions ref lime_users ( uid ) Fk fk_lime_permissions_lime_users lime_permissions ref lime_users ( uid ) uid Fk fk_lime_permissiontemplates_lime_users lime_permissiontemplates ref lime_users ( created_by -> uid ) Fk fk_lime_permissiontemplates_lime_users lime_permissiontemplates ref lime_users ( created_by -> uid ) created_by Fk fk_lime_plugin_settings_lime_plugins lime_plugin_settings ref lime_plugins ( plugin_id -> id ) Fk fk_lime_plugin_settings_lime_plugins lime_plugin_settings ref lime_plugins ( plugin_id -> id ) plugin_id Fk fk_lime_question_themes_lime_users lime_question_themes ref lime_users ( owner_id -> uid ) Fk fk_lime_question_themes_lime_users lime_question_themes ref lime_users ( owner_id -> uid ) owner_id Fk fk_lime_questions_lime_conditions lime_questions ref lime_conditions ( qid ) Fk fk_lime_questions_lime_conditions lime_questions ref lime_conditions ( qid ) qid Fk fk_lime_questions_lime_questions lime_questions ref lime_questions ( parent_qid ) Fk fk_lime_questions_lime_questions lime_questions ref lime_questions ( parent_qid ) parent_qid Fk fk_lime_questions_lime_quota_members lime_questions ref lime_quota_members ( qid ) Fk fk_lime_questions_lime_quota_members lime_questions ref lime_quota_members ( qid ) qid Fk fk_lime_questions_lime_question_attributes lime_questions ref lime_question_attributes ( qid ) Fk fk_lime_questions_lime_question_attributes lime_questions ref lime_question_attributes ( qid ) qid Fk fk_lime_questions_lime_answers lime_questions ref lime_answers ( qid ) Fk fk_lime_questions_lime_answers lime_questions ref lime_answers ( qid ) qid Fk fk_lime_questions_lime_question_l10ns lime_questions ref lime_question_l10ns ( qid ) Fk fk_lime_questions_lime_question_l10ns lime_questions ref lime_question_l10ns ( qid ) qid Fk fk_lime_questions_lime_surveys lime_questions ref lime_surveys ( sid ) Fk fk_lime_questions_lime_surveys lime_questions ref lime_surveys ( sid ) sid Fk fk_lime_questions_lime_groups lime_questions ref lime_groups ( gid ) Fk fk_lime_questions_lime_groups lime_questions ref lime_groups ( gid ) gid Fk fk_lime_quota_lime_surveys lime_quota ref lime_surveys ( sid ) Fk fk_lime_quota_lime_surveys lime_quota ref lime_surveys ( sid ) sid Fk fk_lime_quota_languagesettings_lime_quota lime_quota_languagesettings ref lime_quota ( quotals_quota_id -> id ) Fk fk_lime_quota_languagesettings_lime_quota lime_quota_languagesettings ref lime_quota ( quotals_quota_id -> id ) quotals_quota_id Fk fk_lime_quota_members_lime_quota lime_quota_members ref lime_quota ( quota_id -> id ) Fk fk_lime_quota_members_lime_quota lime_quota_members ref lime_quota ( quota_id -> id ) quota_id Fk fk_lime_saved_control_lime_surveys lime_saved_control ref lime_surveys ( sid ) Fk fk_lime_saved_control_lime_surveys lime_saved_control ref lime_surveys ( sid ) sid Fk fk_lime_settings_user_lime_users lime_settings_user ref lime_users ( uid ) Fk fk_lime_settings_user_lime_users lime_settings_user ref lime_users ( uid ) uid Fk fk_lime_survey_links_lime_surveys lime_survey_links ref lime_surveys ( survey_id -> sid ) Fk fk_lime_survey_links_lime_surveys lime_survey_links ref lime_surveys ( survey_id -> sid ) survey_id Fk fk_lime_survey_url_parameters_lime_questions lime_survey_url_parameters ref lime_questions ( targetqid -> qid ) Fk fk_lime_survey_url_parameters_lime_questions lime_survey_url_parameters ref lime_questions ( targetqid -> qid ) targetqid Fk fk_lime_survey_url_parameters_lime_questions_0 lime_survey_url_parameters ref lime_questions ( targetsqid -> qid ) Fk fk_lime_survey_url_parameters_lime_questions_0 lime_survey_url_parameters ref lime_questions ( targetsqid -> qid ) targetsqid Fk fk_lime_surveymenu_lime_users lime_surveymenu ref lime_users ( created_by -> uid ) Fk fk_lime_surveymenu_lime_users lime_surveymenu ref lime_users ( created_by -> uid ) created_by Fk fk_lime_surveymenu_lime_users_0 lime_surveymenu ref lime_users ( changed_by -> uid ) Fk fk_lime_surveymenu_lime_users_0 lime_surveymenu ref lime_users ( changed_by -> uid ) changed_by Fk fk_lime_surveymenu_lime_surveys lime_surveymenu ref lime_surveys ( survey_id -> sid ) Fk fk_lime_surveymenu_lime_surveys lime_surveymenu ref lime_surveys ( survey_id -> sid ) survey_id Fk fk_lime_surveymenu_lime_users_1 lime_surveymenu ref lime_users ( user_id -> uid ) Fk fk_lime_surveymenu_lime_users_1 lime_surveymenu ref lime_users ( user_id -> uid ) user_id Fk fk_lime_surveymenu_entries_lime_surveymenu lime_surveymenu_entries ref lime_surveymenu ( menu_id -> id ) Fk fk_lime_surveymenu_entries_lime_surveymenu lime_surveymenu_entries ref lime_surveymenu ( menu_id -> id ) menu_id Fk fk_lime_surveymenu_entries lime_surveymenu_entries ref lime_users ( user_id -> uid ) Fk fk_lime_surveymenu_entries lime_surveymenu_entries ref lime_users ( user_id -> uid ) user_id Fk fk_lime_surveymenu_entries_lime_users lime_surveymenu_entries ref lime_users ( changed_by -> uid ) Fk fk_lime_surveymenu_entries_lime_users lime_surveymenu_entries ref lime_users ( changed_by -> uid ) changed_by Fk fk_lime_surveymenu_entries_lime_users_0 lime_surveymenu_entries ref lime_users ( created_by -> uid ) Fk fk_lime_surveymenu_entries_lime_users_0 lime_surveymenu_entries ref lime_users ( created_by -> uid ) created_by Fk fk_lime_surveys_lime_surveys_languagesettings lime_surveys ref lime_surveys_languagesettings ( sid -> surveyls_survey_id ) Fk fk_lime_surveys_lime_surveys_languagesettings lime_surveys ref lime_surveys_languagesettings ( sid -> surveyls_survey_id ) sid Fk fk_lime_surveys_lime_archived_table_settings lime_surveys ref lime_archived_table_settings ( sid -> survey_id ) Fk fk_lime_surveys_lime_archived_table_settings lime_surveys ref lime_archived_table_settings ( sid -> survey_id ) sid Fk fk_lime_surveys_lime_assessments lime_surveys ref lime_assessments ( sid ) Fk fk_lime_surveys_lime_assessments lime_surveys ref lime_assessments ( sid ) sid Fk fk_lime_surveys_lime_groups lime_surveys ref lime_groups ( sid ) Fk fk_lime_surveys_lime_groups lime_surveys ref lime_groups ( sid ) sid Fk fk_lime_surveys_lime_survey_url_parameters lime_surveys ref lime_survey_url_parameters ( sid ) Fk fk_lime_surveys_lime_survey_url_parameters lime_surveys ref lime_survey_url_parameters ( sid ) sid Fk fk_lime_surveys_lime_quota_members lime_surveys ref lime_quota_members ( sid ) Fk fk_lime_surveys_lime_quota_members lime_surveys ref lime_quota_members ( sid ) sid Fk fk_lime_surveys_groups_lime_users lime_surveys_groups ref lime_users ( created_by -> uid ) Fk fk_lime_surveys_groups_lime_users lime_surveys_groups ref lime_users ( created_by -> uid ) created_by Fk fk_lime_surveys_groups_lime_users_0 lime_surveys_groups ref lime_users ( owner_id -> uid ) Fk fk_lime_surveys_groups_lime_users_0 lime_surveys_groups ref lime_users ( owner_id -> uid ) owner_id Fk fk_lime_surveys_groups_lime_surveys_groups lime_surveys_groups ref lime_surveys_groups ( parent_id -> gsid ) Fk fk_lime_surveys_groups_lime_surveys_groups lime_surveys_groups ref lime_surveys_groups ( parent_id -> gsid ) parent_id Fk fk_lime_surveys_groupsettings_lime_users lime_surveys_groupsettings ref lime_users ( owner_id -> uid ) Fk fk_lime_surveys_groupsettings_lime_users lime_surveys_groupsettings ref lime_users ( owner_id -> uid ) owner_id Fk fk_lime_tutorial_entry_relation_lime_tutorial_entries lime_tutorial_entry_relation ref lime_tutorial_entries ( teid ) Fk fk_lime_tutorial_entry_relation_lime_tutorial_entries lime_tutorial_entry_relation ref lime_tutorial_entries ( teid ) teid Fk fk_lime_tutorial_entry_relation_lime_tutorials lime_tutorial_entry_relation ref lime_tutorials ( tid ) Fk fk_lime_tutorial_entry_relation_lime_tutorials lime_tutorial_entry_relation ref lime_tutorials ( tid ) tid Fk fk_lime_tutorial_entry_relation_lime_users lime_tutorial_entry_relation ref lime_users ( uid ) Fk fk_lime_tutorial_entry_relation_lime_users lime_tutorial_entry_relation ref lime_users ( uid ) uid Fk fk_lime_tutorial_entry_relation_lime_surveys lime_tutorial_entry_relation ref lime_surveys ( sid ) Fk fk_lime_tutorial_entry_relation_lime_surveys lime_tutorial_entry_relation ref lime_surveys ( sid ) sid Fk fk_lime_user_groups_lime_users lime_user_groups ref lime_users ( owner_id -> uid ) Fk fk_lime_user_groups_lime_users lime_user_groups ref lime_users ( owner_id -> uid ) owner_id Fk fk_lime_user_in_groups_lime_user_groups lime_user_in_groups ref lime_user_groups ( ugid ) Fk fk_lime_user_in_groups_lime_user_groups lime_user_in_groups ref lime_user_groups ( ugid ) ugid Fk fk_lime_user_in_permissionrole_lime_permissiontemplates lime_user_in_permissionrole ref lime_permissiontemplates ( ptid ) Fk fk_lime_user_in_permissionrole_lime_permissiontemplates lime_user_in_permissionrole ref lime_permissiontemplates ( ptid ) ptid Fk fk_lime_users_lime_user_in_groups lime_users ref lime_user_in_groups ( uid ) Fk fk_lime_users_lime_user_in_groups lime_users ref lime_user_in_groups ( uid ) uid Fk fk_lime_users_lime_map_tutorial_users lime_users ref lime_map_tutorial_users ( uid ) Fk fk_lime_users_lime_map_tutorial_users lime_users ref lime_map_tutorial_users ( uid ) uid Fk fk_lime_users_lime_user_in_permissionrole lime_users ref lime_user_in_permissionrole ( uid ) Fk fk_lime_users_lime_user_in_permissionrole lime_users ref lime_user_in_permissionrole ( uid ) uid Fk fk_lime_users_lime_users lime_users ref lime_users ( parent_id -> uid ) Fk fk_lime_users_lime_users lime_users ref lime_users ( parent_id -> uid ) parent_id lime_answer_l10nsTable limesurvey4000.lime_answer_l10ns Pk pk_lime_answer_l10ns ( id ) idid * int INT Unq lime_answer_l10ns_idx ( aid, language ) aidaid * int INTReferences lime_answers ( aid ) answeranswer * mediumtext MEDIUMTEXT Unq lime_answer_l10ns_idx ( aid, language ) languagelanguage * varchar(20) VARCHAR(20) lime_answersTable limesurvey4000.lime_answers Pk pk_lime_answers ( aid ) aidaid * int INTReferred by lime_answer_l10ns ( aid ) Unq lime_answers_idx ( qid, code, scale_id ) Unq unq_lime_answers_qid ( qid ) qidqid * int INTReferred by lime_questions ( qid ) Unq lime_answers_idx ( qid, code, scale_id ) codecode * varchar(5) VARCHAR(5) lime_answers_idx2 ( sortorder ) sortordersortorder * int INT assessment_valueassessment_value * int default 0 INT Unq lime_answers_idx ( qid, code, scale_id ) scale_idscale_id * int default 0 INT lime_archived_table_settingsTable limesurvey4000.lime_archived_table_settings Pk pk_lime_archived_table_settings ( id ) idid * int INT survey_idsurvey_id * int INTReferred by lime_surveys ( sid -> survey_id ) user_iduser_id * int INTReferences lime_users ( user_id -> uid ) tbl_nametbl_name * varchar(255) VARCHAR(255) tbl_typetbl_type * varchar(10) VARCHAR(10) createdcreated * datetime DATETIME propertiesproperties * text TEXT attributesattributes text TEXT lime_assessmentsTable limesurvey4000.lime_assessments Pk pk_lime_assessments ( id, language ) idid * int INT Pk pk_lime_assessments ( id, language ) languagelanguage * varchar(20) default 'en' VARCHAR(20) lime_assessments_idx2 ( sid ) sidsid * int default 0 INTReferred by lime_surveys ( sid ) scopescope * varchar(5) VARCHAR(5) lime_assessments_idx3 ( gid ) gidgid * int default 0 INT namename * text TEXT minimumminimum * varchar(50) VARCHAR(50) maximummaximum * varchar(50) VARCHAR(50) messagemessage * mediumtext MEDIUMTEXT lime_asset_versionTable limesurvey4000.lime_asset_version Pk pk_lime_asset_version ( id ) idid * int INT pathpath * text TEXT versionversion * int INT lime_boxesTable limesurvey4000.lime_boxes Pk pk_lime_boxes ( id ) idid * int INT positionposition int INT urlurl * text TEXT titletitle * text TEXT icoico varchar(255) VARCHAR(255) descdesc * text TEXT pagepage * text TEXT usergroupusergroup * int INT lime_conditionsTable limesurvey4000.lime_conditions Pk pk_lime_conditions ( cid ) cidcid * int INT lime_conditions_idx ( qid ) qidqid * int default 0 INTReferred by lime_questions ( qid ) lime_conditions_idx3 ( cqid ) cqidcqid * int default 0 INT cfieldnamecfieldname * varchar(50) default '' VARCHAR(50) methodmethod * varchar(5) default '' VARCHAR(5) valuevalue * varchar(255) default '' VARCHAR(255) scenarioscenario * int default 1 INT lime_defaultvalue_l10nsTable limesurvey4000.lime_defaultvalue_l10ns Pk pk_lime_defaultvalue_l10ns ( id ) idid * int INT lime_idx1_defaultvalue_ls ( dvid, language ) dviddvid * int default 0 INTReferences lime_defaultvalues ( dvid ) lime_idx1_defaultvalue_ls ( dvid, language ) languagelanguage * varchar(20) VARCHAR(20) defaultvaluedefaultvalue text TEXT lime_defaultvaluesTable limesurvey4000.lime_defaultvalues Pk pk_lime_defaultvalues ( dvid ) dviddvid * int INTReferred by lime_defaultvalue_l10ns ( dvid ) lime_idx1_defaultvalue ( qid, scale_id, sqid, specialtype ) qidqid * int default 0 INTReferences lime_questions ( qid ) lime_idx1_defaultvalue ( qid, scale_id, sqid, specialtype ) scale_idscale_id * int default 0 INT lime_idx1_defaultvalue ( qid, scale_id, sqid, specialtype ) sqidsqid * int default 0 INTReferences lime_questions ( sqid -> qid ) lime_idx1_defaultvalue ( qid, scale_id, sqid, specialtype ) specialtypespecialtype * varchar(20) default '' VARCHAR(20) lime_expression_errorsTable limesurvey4000.lime_expression_errors Pk pk_lime_expression_errors ( id ) idid * int INT errortimeerrortime varchar(50) VARCHAR(50) sidsid int INTReferences lime_surveys ( sid ) gidgid int INTReferences lime_groups ( gid ) qidqid int INTReferences lime_questions ( qid ) gseqgseq int INT qseqqseq int INT typetype varchar(50) VARCHAR(50) eqneqn text TEXT prettyprintprettyprint text TEXT lime_failed_emailsTable limesurvey4000.lime_failed_emails Pk pk_lime_failed_emails ( id ) idid * int INT surveyidsurveyid * int INTReferences lime_surveys ( surveyid -> sid ) responseidresponseid * int INT email_typeemail_type * varchar(200) VARCHAR(200) recipientrecipient * varchar(320) VARCHAR(320) languagelanguage * varchar(20) default 'en' VARCHAR(20) error_messageerror_message text TEXT createdcreated * datetime DATETIME statusstatus varchar(20) default 'SEND FAILED' VARCHAR(20) updatedupdated datetime DATETIME resend_varsresend_vars * text TEXT lime_failed_login_attemptsTable limesurvey4000.lime_failed_login_attempts Pk pk_lime_failed_login_attempts ( id ) idid * int INT ipip * varchar(40) VARCHAR(40) last_attemptlast_attempt * varchar(20) VARCHAR(20) number_attemptsnumber_attempts * int INT is_frontendis_frontend * boolean BOOLEAN lime_group_l10nsTable limesurvey4000.lime_group_l10ns Pk pk_lime_group_l10ns ( id ) idid * int INT Unq lime_idx1_group_ls ( gid, language ) gidgid * int INTReferences lime_groups ( gid ) group_namegroup_name * text TEXT descriptiondescription mediumtext MEDIUMTEXT Unq lime_idx1_group_ls ( gid, language ) languagelanguage * varchar(20) VARCHAR(20) lime_groupsTable limesurvey4000.lime_groups Pk pk_lime_groups ( gid ) gidgid * int INTReferred by lime_expression_errors ( gid ) Referred by lime_group_l10ns ( gid ) Referred by lime_questions ( gid ) lime_idx1_groups ( sid ) sidsid * int default 0 INTReferred by lime_surveys ( sid ) group_ordergroup_order * int default 0 INT randomization_grouprandomization_group * varchar(20) default '' VARCHAR(20) grelevancegrelevance text TEXT lime_label_l10nsTable limesurvey4000.lime_label_l10ns Pk pk_lime_label_l10ns ( id ) idid * int INT label_idlabel_id * int INTReferences lime_labels ( label_id -> id ) titletitle text TEXT languagelanguage * varchar(20) default 'en' VARCHAR(20) lime_labelsTable limesurvey4000.lime_labels Pk pk_lime_labels ( id ) idid * int INTReferred by lime_label_l10ns ( label_id -> id ) lime_idx4_labels ( lid, sortorder ) lidlid * int default 0 INTReferences lime_labelsets ( lid ) lime_idx1_labels ( code ) codecode * varchar(20) default '' VARCHAR(20) lime_idx2_labels ( sortorder ) lime_idx4_labels ( lid, sortorder ) sortordersortorder * int INT assessment_valueassessment_value * int default 0 INT lime_labelsetsTable limesurvey4000.lime_labelsets Pk pk_lime_labelsets ( lid ) lidlid * int INTReferred by lime_labels ( lid ) label_namelabel_name * varchar(100) default '' VARCHAR(100) languageslanguages * varchar(255) VARCHAR(255) lime_map_tutorial_usersTable limesurvey4000.lime_map_tutorial_users Pk pk_lime_map_tutorial_users ( uid, tid ) uiduid * int INTReferred by lime_users ( uid ) Pk pk_lime_map_tutorial_users ( uid, tid ) tidtid * int INTReferences lime_tutorials ( tid ) takentaken int default 1 INT lime_messageTable limesurvey4000.lime_message Pk pk_lime_message ( id, language ) idid * int INT Pk pk_lime_message ( id, language ) languagelanguage * varchar(50) default '' VARCHAR(50) translationtranslation text TEXT lime_notificationsTable limesurvey4000.lime_notifications Pk pk_lime_notifications ( id ) idid * int INT lime_notifications_pk ( entity, entity_id, status ) entityentity * varchar(15) VARCHAR(15) lime_notifications_pk ( entity, entity_id, status ) entity_identity_id * int INT titletitle * varchar(255) VARCHAR(255) messagemessage * mediumtext MEDIUMTEXT lime_notifications_pk ( entity, entity_id, status ) statusstatus * varchar(15) default 'new' VARCHAR(15) importanceimportance * int default 1 INT display_classdisplay_class varchar(31) default 'default' VARCHAR(31) lime_idx1_notifications ( hash ) hashhash varchar(64) VARCHAR(64) createdcreated datetime DATETIME first_readfirst_read datetime DATETIME lime_participant_attributeTable limesurvey4000.lime_participant_attribute Pk pk_lime_participant_attribute ( participant_id, attribute_id ) participant_idparticipant_id * varchar(50) VARCHAR(50)References lime_participants ( participant_id ) Pk pk_lime_participant_attribute ( participant_id, attribute_id ) attribute_idattribute_id * int INTReferred by lime_participant_attribute_names ( attribute_id ) Referred by lime_participant_attribute_names_lang ( attribute_id ) Referred by lime_participant_attribute_values ( attribute_id ) valuevalue * text TEXT lime_participant_attribute_namesTable limesurvey4000.lime_participant_attribute_names Pk pk_lime_participant_attribute_names ( attribute_id, attribute_type ) attribute_idattribute_id * int INTReferences lime_participant_attribute ( attribute_id ) Pk pk_lime_participant_attribute_names ( attribute_id, attribute_type ) attribute_typeattribute_type * varchar(4) VARCHAR(4) defaultnamedefaultname * varchar(255) VARCHAR(255) visiblevisible * varchar(5) VARCHAR(5) encryptedencrypted * varchar(5) VARCHAR(5) core_attributecore_attribute * varchar(5) VARCHAR(5) lime_participant_attribute_names_langTable limesurvey4000.lime_participant_attribute_names_lang Pk pk_lime_participant_attribute_names_lang ( attribute_id, lang ) attribute_idattribute_id * int INTReferences lime_participant_attribute ( attribute_id ) Pk pk_lime_participant_attribute_names_lang ( attribute_id, lang ) langlang * varchar(20) VARCHAR(20) attribute_nameattribute_name * varchar(255) VARCHAR(255) lime_participant_attribute_valuesTable limesurvey4000.lime_participant_attribute_values Pk pk_lime_participant_attribute_values ( value_id ) value_idvalue_id * int INT attribute_idattribute_id * int INTReferences lime_participant_attribute ( attribute_id ) valuevalue * mediumtext MEDIUMTEXT lime_participant_sharesTable limesurvey4000.lime_participant_shares Pk pk_lime_participant_shares ( participant_id, share_uid ) participant_idparticipant_id * varchar(50) VARCHAR(50)References lime_participants ( participant_id ) Pk pk_lime_participant_shares ( participant_id, share_uid ) share_uidshare_uid * int INT date_addeddate_added * datetime DATETIME can_editcan_edit * varchar(5) VARCHAR(5) lime_participantsTable limesurvey4000.lime_participants Pk pk_lime_participants ( participant_id ) participant_idparticipant_id * varchar(50) VARCHAR(50)Referred by lime_participant_attribute ( participant_id ) Referred by lime_participant_shares ( participant_id ) firstnamefirstname text TEXT lastnamelastname text TEXT emailemail text TEXT lime_idx3_participants ( language ) languagelanguage varchar(40) VARCHAR(40) blacklistedblacklisted * varchar(1) VARCHAR(1) owner_uidowner_uid * int INTReferences lime_users ( owner_uid -> uid ) created_bycreated_by * int INTReferences lime_users ( created_by -> uid ) createdcreated datetime DATETIME modifiedmodified datetime DATETIME lime_permissionsTable limesurvey4000.lime_permissions Pk pk_lime_permissions ( id ) idid * int INT Unq lime_idx1_permissions ( entity_id, entity, permission, uid ) entityentity * varchar(50) VARCHAR(50) Unq lime_idx1_permissions ( entity_id, entity, permission, uid ) entity_identity_id * int INT Unq lime_idx1_permissions ( entity_id, entity, permission, uid ) uiduid * int INTReferences lime_users ( uid ) Unq lime_idx1_permissions ( entity_id, entity, permission, uid ) permissionpermission * varchar(100) VARCHAR(100) create_pcreate_p * int default 0 INT read_pread_p * int default 0 INT update_pupdate_p * int default 0 INT delete_pdelete_p * int default 0 INT import_pimport_p * int default 0 INT export_pexport_p * int default 0 INT lime_permissiontemplatesTable limesurvey4000.lime_permissiontemplates Pk pk_lime_permissiontemplates ( ptid ) ptidptid * int INTReferred by lime_user_in_permissionrole ( ptid ) Unq lime_idx1_name ( name ) namename * varchar(127) VARCHAR(127) descriptiondescription text TEXT renewed_lastrenewed_last datetime DATETIME created_atcreated_at * datetime DATETIME created_bycreated_by * int INTReferences lime_users ( created_by -> uid ) lime_plugin_settingsTable limesurvey4000.lime_plugin_settings Pk pk_lime_plugin_settings ( id ) idid * int INT plugin_idplugin_id * int INTReferences lime_plugins ( plugin_id -> id ) modelmodel varchar(50) VARCHAR(50) model_idmodel_id int INT keykey * varchar(50) VARCHAR(50) valuevalue mediumtext MEDIUMTEXT lime_pluginsTable limesurvey4000.lime_plugins Pk pk_lime_plugins ( id ) idid * int INTReferred by lime_plugin_settings ( plugin_id -> id ) namename * varchar(50) VARCHAR(50) plugin_typeplugin_type varchar(6) default 'user' VARCHAR(6) activeactive * int default 0 INT prioritypriority * int default 0 INT versionversion varchar(32) VARCHAR(32) load_errorload_error int default 0 INT load_error_messageload_error_message text TEXT lime_question_attributesTable limesurvey4000.lime_question_attributes Pk pk_lime_question_attributes ( qaid ) qaidqaid * int INT lime_idx1_question_attributes ( qid ) qidqid * int default 0 INTReferred by lime_questions ( qid ) lime_idx2_question_attributes ( attribute ) attributeattribute varchar(50) VARCHAR(50) valuevalue mediumtext MEDIUMTEXT languagelanguage varchar(20) VARCHAR(20) lime_question_l10nsTable limesurvey4000.lime_question_l10ns Pk pk_lime_question_l10ns ( id ) idid * int INT Unq lime_idx1_question_ls ( qid, language ) qidqid * int INTReferred by lime_questions ( qid ) questionquestion * mediumtext MEDIUMTEXT helphelp mediumtext MEDIUMTEXT scriptscript text TEXT Unq lime_idx1_question_ls ( qid, language ) languagelanguage * varchar(20) VARCHAR(20) lime_question_themesTable limesurvey4000.lime_question_themes Pk pk_lime_question_themes ( id ) idid * int INT lime_idx1_question_themes ( name ) namename * varchar(150) VARCHAR(150) visiblevisible varchar(1) VARCHAR(1) xml_pathxml_path varchar(255) VARCHAR(255) image_pathimage_path varchar(255) VARCHAR(255) titletitle * varchar(100) VARCHAR(100) creation_datecreation_date datetime DATETIME authorauthor varchar(150) VARCHAR(150) author_emailauthor_email varchar(255) VARCHAR(255) author_urlauthor_url varchar(255) VARCHAR(255) copyrightcopyright text TEXT licenselicense text TEXT versionversion varchar(45) VARCHAR(45) api_versionapi_version * varchar(45) VARCHAR(45) descriptiondescription text TEXT last_updatelast_update datetime DATETIME owner_idowner_id int INTReferences lime_users ( owner_id -> uid ) theme_typetheme_type varchar(150) VARCHAR(150) question_typequestion_type * varchar(150) VARCHAR(150) core_themecore_theme boolean BOOLEAN extendsextends varchar(150) VARCHAR(150) groupgroup varchar(150) VARCHAR(150) settingssettings text TEXT lime_questionsTable limesurvey4000.lime_questions Pk pk_lime_questions ( qid ) qidqid * int INTReferences lime_conditions ( qid ) References lime_quota_members ( qid ) References lime_question_attributes ( qid ) References lime_answers ( qid ) References lime_question_l10ns ( qid ) Referred by lime_defaultvalues ( qid ) Referred by lime_defaultvalues ( sqid -> qid ) Referred by lime_expression_errors ( qid ) Referred by lime_survey_url_parameters ( targetqid -> qid ) Referred by lime_survey_url_parameters ( targetsqid -> qid ) lime_idx5_questions ( parent_qid ) parent_qidparent_qid * int default 0 INTReferences lime_questions ( parent_qid ) Referred by lime_questions ( parent_qid ) lime_idx1_questions ( sid ) sidsid * int default 0 INTReferences lime_surveys ( sid ) lime_idx2_questions ( gid ) gidgid * int default 0 INTReferences lime_groups ( gid ) lime_idx3_questions ( type ) typetype * varchar(30) default 'T' VARCHAR(30) lime_idx4_questions ( title ) titletitle * varchar(20) default '' VARCHAR(20) pregpreg text TEXT otherother * varchar(1) default 'N' VARCHAR(1) mandatorymandatory varchar(1) VARCHAR(1) encryptedencrypted varchar(1) default 'N' VARCHAR(1) question_orderquestion_order * int INT scale_idscale_id * int default 0 INT same_defaultsame_default * int default 0 INT relevancerelevance text TEXT modulenamemodulename varchar(255) VARCHAR(255) question_theme_namequestion_theme_name varchar(150) VARCHAR(150) same_scriptsame_script * int default 0 INT lime_quotaTable limesurvey4000.lime_quota Pk pk_lime_quota ( id ) idid * int INTReferred by lime_quota_languagesettings ( quotals_quota_id -> id ) Referred by lime_quota_members ( quota_id -> id ) lime_idx1_quota ( sid ) sidsid int INTReferences lime_surveys ( sid ) namename varchar(255) VARCHAR(255) qlimitqlimit int INT actionaction int INT activeactive * int default 1 INT autoload_urlautoload_url * int default 0 INT lime_quota_languagesettingsTable limesurvey4000.lime_quota_languagesettings Pk pk_lime_quota_languagesettings ( quotals_id ) quotals_idquotals_id * int INT quotals_quota_idquotals_quota_id * int default 0 INTReferences lime_quota ( quotals_quota_id -> id ) quotals_languagequotals_language * varchar(45) default 'en' VARCHAR(45) quotals_namequotals_name varchar(255) VARCHAR(255) quotals_messagequotals_message * mediumtext MEDIUMTEXT quotals_urlquotals_url varchar(255) VARCHAR(255) quotals_urldescripquotals_urldescrip varchar(255) VARCHAR(255) lime_quota_membersTable limesurvey4000.lime_quota_members Pk pk_lime_quota_members ( id ) idid * int INT Unq lime_idx1_quota_members ( sid, qid, quota_id, code ) sidsid int INTReferred by lime_surveys ( sid ) Unq lime_idx1_quota_members ( sid, qid, quota_id, code ) qidqid int INTReferred by lime_questions ( qid ) Unq lime_idx1_quota_members ( sid, qid, quota_id, code ) quota_idquota_id int INTReferences lime_quota ( quota_id -> id ) Unq lime_idx1_quota_members ( sid, qid, quota_id, code ) codecode varchar(11) VARCHAR(11) lime_saved_controlTable limesurvey4000.lime_saved_control Pk pk_lime_saved_control ( scid ) scidscid * int INT lime_idx1_saved_control ( sid ) sidsid * int default 0 INTReferences lime_surveys ( sid ) lime_idx2_saved_control ( srid ) sridsrid * int default 0 INT identifieridentifier * text TEXT access_codeaccess_code * text TEXT emailemail varchar(192) VARCHAR(192) ipip * text TEXT saved_thisstepsaved_thisstep * text TEXT statusstatus * varchar(1) default '' VARCHAR(1) saved_datesaved_date * datetime DATETIME refurlrefurl text TEXT lime_sessionsTable limesurvey4000.lime_sessions Pk pk_lime_sessions ( id ) idid * varchar(32) VARCHAR(32) sess_expire ( expire ) expireexpire int INT datadata longblob LONGBLOB lime_settings_globalTable limesurvey4000.lime_settings_global Pk pk_lime_settings_global ( stg_name ) stg_namestg_name * varchar(50) default '' VARCHAR(50) stg_valuestg_value * mediumtext MEDIUMTEXT lime_settings_userTable limesurvey4000.lime_settings_user Pk pk_lime_settings_user ( id ) idid * int INT lime_idx1_settings_user ( uid ) uiduid * int INTReferences lime_users ( uid ) lime_idx2_settings_user ( entity ) entityentity varchar(15) VARCHAR(15) lime_idx3_settings_user ( entity_id ) entity_identity_id varchar(31) VARCHAR(31) lime_idx4_settings_user ( stg_name ) stg_namestg_name * varchar(63) VARCHAR(63) stg_valuestg_value mediumtext MEDIUMTEXT lime_source_messageTable limesurvey4000.lime_source_message Pk pk_lime_source_message ( id ) idid * int INT categorycategory varchar(35) VARCHAR(35) messagemessage text TEXT lime_survey_linksTable limesurvey4000.lime_survey_links Pk pk_lime_survey_links ( participant_id, token_id, survey_id ) participant_idparticipant_id * varchar(50) VARCHAR(50) Pk pk_lime_survey_links ( participant_id, token_id, survey_id ) token_idtoken_id * int INT Pk pk_lime_survey_links ( participant_id, token_id, survey_id ) survey_idsurvey_id * int INTReferences lime_surveys ( survey_id -> sid ) date_createddate_created datetime DATETIME date_inviteddate_invited datetime DATETIME date_completeddate_completed datetime DATETIME lime_survey_url_parametersTable limesurvey4000.lime_survey_url_parameters Pk pk_lime_survey_url_parameters ( id ) idid * int INT sidsid * int INTReferred by lime_surveys ( sid ) parameterparameter * varchar(50) VARCHAR(50) targetqidtargetqid int INTReferences lime_questions ( targetqid -> qid ) targetsqidtargetsqid int INTReferences lime_questions ( targetsqid -> qid ) lime_surveymenuTable limesurvey4000.lime_surveymenu Pk pk_lime_surveymenu ( id ) idid * int INTReferred by lime_surveymenu_entries ( menu_id -> id ) parent_idparent_id int INT survey_idsurvey_id int INTReferences lime_surveys ( survey_id -> sid ) user_iduser_id int INTReferences lime_users ( user_id -> uid ) Unq lime_surveymenu_name ( name ) namename varchar(128) VARCHAR(128) orderingordering int default 0 INT levellevel int default 0 INT lime_idx2_surveymenu ( title ) titletitle * varchar(168) default '' VARCHAR(168) positionposition * varchar(192) default 'side' VARCHAR(192) descriptiondescription text TEXT showincollapseshowincollapse int default 0 INT activeactive * int default 0 INT changed_atchanged_at datetime DATETIME changed_bychanged_by * int default 0 INTReferences lime_users ( changed_by -> uid ) created_atcreated_at datetime DATETIME created_bycreated_by * int default 0 INTReferences lime_users ( created_by -> uid ) lime_surveymenu_entriesTable limesurvey4000.lime_surveymenu_entries Pk pk_lime_surveymenu_entries ( id ) idid * int INT lime_idx1_surveymenu_entries ( menu_id ) menu_idmenu_id int INTReferences lime_surveymenu ( menu_id -> id ) user_iduser_id int INTReferences lime_users ( user_id -> uid ) orderingordering int default 0 INT Unq lime_surveymenu_entries_name ( name ) namename varchar(168) default '' VARCHAR(168) titletitle * varchar(168) default '' VARCHAR(168) lime_idx5_surveymenu_entries ( menu_title ) menu_titlemenu_title * varchar(168) default '' VARCHAR(168) menu_descriptionmenu_description text TEXT menu_iconmenu_icon * varchar(192) default '' VARCHAR(192) menu_icon_typemenu_icon_type * varchar(192) default '' VARCHAR(192) menu_classmenu_class * varchar(192) default '' VARCHAR(192) menu_linkmenu_link * varchar(192) default '' VARCHAR(192) actionaction * varchar(192) default '' VARCHAR(192) templatetemplate * varchar(192) default '' VARCHAR(192) partialpartial * varchar(192) default '' VARCHAR(192) classesclasses * varchar(192) default '' VARCHAR(192) permissionpermission * varchar(192) default '' VARCHAR(192) permission_gradepermission_grade varchar(192) VARCHAR(192) datadata mediumtext MEDIUMTEXT getdatamethodgetdatamethod * varchar(192) default '' VARCHAR(192) languagelanguage * varchar(32) default 'en-GB' VARCHAR(32) showincollapseshowincollapse int default 0 INT activeactive * int default 0 INT changed_atchanged_at datetime DATETIME changed_bychanged_by * int default 0 INTReferences lime_users ( changed_by -> uid ) created_atcreated_at datetime DATETIME created_bycreated_by * int default 0 INTReferences lime_users ( created_by -> uid ) lime_surveysTable limesurvey4000.lime_surveys Pk pk_lime_surveys ( sid ) sidsid * int INTReferences lime_surveys_languagesettings ( sid -> surveyls_survey_id ) References lime_archived_table_settings ( sid -> survey_id ) References lime_assessments ( sid ) References lime_groups ( sid ) References lime_survey_url_parameters ( sid ) References lime_quota_members ( sid ) Referred by lime_expression_errors ( sid ) Referred by lime_questions ( sid ) Referred by lime_quota ( sid ) Referred by lime_saved_control ( sid ) Referred by lime_survey_links ( survey_id -> sid ) Referred by lime_surveymenu ( survey_id -> sid ) Referred by lime_tutorial_entry_relation ( sid ) Referred by lime_failed_emails ( surveyid -> sid ) Referred by lime_failed_emails ( surveyid -> sid ) Referred by lime_failed_emails ( surveyid -> sid ) lime_idx1_surveys ( owner_id ) owner_idowner_id * int INT lime_idx2_surveys ( gsid ) gsidgsid int default 1 INT adminadmin varchar(50) VARCHAR(50) activeactive * varchar(1) default 'N' VARCHAR(1) expiresexpires datetime DATETIME startdatestartdate datetime DATETIME adminemailadminemail varchar(254) VARCHAR(254) anonymizedanonymized * varchar(1) default 'N' VARCHAR(1) formatformat varchar(1) VARCHAR(1)--more-- lime_surveys_groupsTable limesurvey4000.lime_surveys_groups Pk pk_lime_surveys_groups ( gsid ) gsidgsid * int INTReferred by lime_surveys_groups ( parent_id -> gsid ) lime_idx1_surveys_groups ( name ) namename * varchar(45) VARCHAR(45) lime_idx2_surveys_groups ( title ) titletitle varchar(100) VARCHAR(100) templatetemplate varchar(128) default 'default' VARCHAR(128) descriptiondescription text TEXT sortordersortorder * int INT owner_idowner_id int INTReferences lime_users ( owner_id -> uid ) parent_idparent_id int INTReferences lime_surveys_groups ( parent_id -> gsid ) alwaysavailablealwaysavailable boolean BOOLEAN createdcreated datetime DATETIME modifiedmodified datetime DATETIME created_bycreated_by * int INTReferences lime_users ( created_by -> uid ) lime_surveys_groupsettingsTable limesurvey4000.lime_surveys_groupsettings Pk pk_lime_surveys_groupsettings ( gsid ) gsidgsid * int INT owner_idowner_id int INTReferences lime_users ( owner_id -> uid ) adminadmin varchar(50) VARCHAR(50) adminemailadminemail varchar(254) VARCHAR(254) anonymizedanonymized * varchar(1) default 'N' VARCHAR(1) formatformat varchar(1) VARCHAR(1) savetimingssavetimings * varchar(1) default 'N' VARCHAR(1) templatetemplate varchar(100) default 'default' VARCHAR(100) datestampdatestamp * varchar(1) default 'N' VARCHAR(1) usecookieusecookie * varchar(1) default 'N' VARCHAR(1) allowregisterallowregister * varchar(1) default 'N' VARCHAR(1) allowsaveallowsave * varchar(1) default 'Y' VARCHAR(1) autonumber_startautonumber_start int default 0 INT autoredirectautoredirect * varchar(1) default 'N' VARCHAR(1) allowprevallowprev * varchar(1) default 'N' VARCHAR(1) printanswersprintanswers * varchar(1) default 'N' VARCHAR(1) ipaddripaddr * varchar(1) default 'N' VARCHAR(1) ipanonymizeipanonymize * varchar(1) default 'N' VARCHAR(1) refurlrefurl * varchar(1) default 'N' VARCHAR(1) showsurveypolicynoticeshowsurveypolicynotice int default 0 INT publicstatisticspublicstatistics * varchar(1) default 'N' VARCHAR(1) publicgraphspublicgraphs * varchar(1) default 'N' VARCHAR(1) listpubliclistpublic * varchar(1) default 'N' VARCHAR(1) htmlemailhtmlemail * varchar(1) default 'Y' VARCHAR(1) sendconfirmationsendconfirmation * varchar(1) default 'Y' VARCHAR(1) tokenanswerspersistencetokenanswerspersistence * varchar(1) default 'N' VARCHAR(1) assessmentsassessments * varchar(1) default 'N' VARCHAR(1) usecaptchausecaptcha * varchar(1) default 'N' VARCHAR(1) bounce_emailbounce_email varchar(254) VARCHAR(254) attributedescriptionsattributedescriptions text TEXT emailresponsetoemailresponseto text TEXT emailnotificationtoemailnotificationto text TEXT tokenlengthtokenlength int default 15 INT showxquestionsshowxquestions varchar(1) default 'Y' VARCHAR(1) showgroupinfoshowgroupinfo varchar(1) default 'B' VARCHAR(1) shownoanswershownoanswer varchar(1) default 'Y' VARCHAR(1) showqnumcodeshowqnumcode varchar(1) default 'X' VARCHAR(1) showwelcomeshowwelcome varchar(1) default 'Y' VARCHAR(1) showprogressshowprogress varchar(1) default 'Y' VARCHAR(1) questionindexquestionindex int default 0 INT navigationdelaynavigationdelay int default 0 INT nokeyboardnokeyboard varchar(1) default 'N' VARCHAR(1) alloweditaftercompletionalloweditaftercompletion varchar(1) default 'N' VARCHAR(1) lime_surveys_languagesettingsTable limesurvey4000.lime_surveys_languagesettings Pk pk_lime_surveys_languagesettings ( surveyls_survey_id, surveyls_language ) surveyls_survey_idsurveyls_survey_id * int INTReferred by lime_surveys ( sid -> surveyls_survey_id ) Pk pk_lime_surveys_languagesettings ( surveyls_survey_id, surveyls_language ) surveyls_languagesurveyls_language * varchar(45) default 'en' VARCHAR(45) lime_idx1_surveys_languagesettings ( surveyls_title ) surveyls_titlesurveyls_title * varchar(200) VARCHAR(200) surveyls_descriptionsurveyls_description mediumtext MEDIUMTEXT surveyls_welcometextsurveyls_welcometext mediumtext MEDIUMTEXT surveyls_endtextsurveyls_endtext mediumtext MEDIUMTEXT surveyls_policy_noticesurveyls_policy_notice mediumtext MEDIUMTEXT surveyls_policy_errorsurveyls_policy_error text TEXT surveyls_policy_notice_labelsurveyls_policy_notice_label varchar(192) VARCHAR(192) surveyls_urlsurveyls_url text TEXT surveyls_urldescriptionsurveyls_urldescription varchar(255) VARCHAR(255) surveyls_email_invite_subjsurveyls_email_invite_subj varchar(255) VARCHAR(255) surveyls_email_invitesurveyls_email_invite mediumtext MEDIUMTEXT surveyls_email_remind_subjsurveyls_email_remind_subj varchar(255) VARCHAR(255) surveyls_email_remindsurveyls_email_remind mediumtext MEDIUMTEXT surveyls_email_register_subjsurveyls_email_register_subj varchar(255) VARCHAR(255) surveyls_email_registersurveyls_email_register mediumtext MEDIUMTEXT surveyls_email_confirm_subjsurveyls_email_confirm_subj varchar(255) VARCHAR(255) surveyls_email_confirmsurveyls_email_confirm mediumtext MEDIUMTEXT surveyls_dateformatsurveyls_dateformat * int default 1 INT surveyls_attributecaptionssurveyls_attributecaptions text TEXT email_admin_notification_subjemail_admin_notification_subj varchar(255) VARCHAR(255) email_admin_notificationemail_admin_notification mediumtext MEDIUMTEXT email_admin_responses_subjemail_admin_responses_subj varchar(255) VARCHAR(255) email_admin_responsesemail_admin_responses mediumtext MEDIUMTEXT surveyls_numberformatsurveyls_numberformat * int default 0 INT attachmentsattachments text TEXT lime_template_configurationTable limesurvey4000.lime_template_configuration Pk pk_lime_template_configuration ( id ) idid * int INT lime_idx1_template_configuration ( template_name ) template_nametemplate_name * varchar(150) VARCHAR(150) lime_idx2_template_configuration ( sid ) sidsid int INT lime_idx3_template_configuration ( gsid ) gsidgsid int INT lime_idx4_template_configuration ( uid ) uiduid int INT files_cssfiles_css text TEXT files_jsfiles_js text TEXT files_print_cssfiles_print_css text TEXT optionsoptions text TEXT cssframework_namecssframework_name varchar(45) VARCHAR(45) cssframework_csscssframework_css mediumtext MEDIUMTEXT cssframework_jscssframework_js mediumtext MEDIUMTEXT packages_to_loadpackages_to_load text TEXT packages_ltrpackages_ltr text TEXT packages_rtlpackages_rtl text TEXT lime_templatesTable limesurvey4000.lime_templates Pk pk_lime_templates ( id ) idid * int INT lime_idx1_templates ( name ) namename * varchar(150) VARCHAR(150) folderfolder varchar(45) VARCHAR(45) lime_idx2_templates ( title ) titletitle * varchar(100) VARCHAR(100) creation_datecreation_date datetime DATETIME authorauthor varchar(150) VARCHAR(150) author_emailauthor_email varchar(255) VARCHAR(255) author_urlauthor_url varchar(255) VARCHAR(255) copyrightcopyright text TEXT licenselicense mediumtext MEDIUMTEXT versionversion varchar(45) VARCHAR(45) api_versionapi_version * varchar(45) VARCHAR(45) view_folderview_folder * varchar(45) VARCHAR(45) files_folderfiles_folder * varchar(45) VARCHAR(45) descriptiondescription mediumtext MEDIUMTEXT last_updatelast_update datetime DATETIME lime_idx3_templates ( owner_id ) owner_idowner_id int INT lime_idx4_templates ( extends ) extendsextends varchar(150) VARCHAR(150) lime_tutorial_entriesTable limesurvey4000.lime_tutorial_entries Pk pk_lime_tutorial_entries ( teid ) teidteid * int INTReferred by lime_tutorial_entry_relation ( teid ) orderingordering int INT titletitle text TEXT contentcontent mediumtext MEDIUMTEXT settingssettings mediumtext MEDIUMTEXT lime_tutorial_entry_relationTable limesurvey4000.lime_tutorial_entry_relation Pk pk_lime_tutorial_entry_relation ( teid, tid ) teidteid * int INTReferences lime_tutorial_entries ( teid ) Pk pk_lime_tutorial_entry_relation ( teid, tid ) tidtid * int INTReferences lime_tutorials ( tid ) lime_idx1_tutorial_entry_relation ( uid ) uiduid int INTReferences lime_users ( uid ) lime_idx2_tutorial_entry_relation ( sid ) sidsid int INTReferences lime_surveys ( sid ) lime_tutorialsTable limesurvey4000.lime_tutorials Pk pk_lime_tutorials ( tid ) tidtid * int INTReferred by lime_map_tutorial_users ( tid ) Referred by lime_tutorial_entry_relation ( tid ) Unq lime_idx1_tutorials ( name ) namename varchar(128) VARCHAR(128) titletitle varchar(192) VARCHAR(192) iconicon varchar(64) VARCHAR(64) descriptiondescription text TEXT activeactive int default 0 INT settingssettings mediumtext MEDIUMTEXT permissionpermission * varchar(128) VARCHAR(128) permission_gradepermission_grade * varchar(128) VARCHAR(128) lime_twofactorusersTable limesurvey4000.lime_twofactorusers uiduid * int INT secretKeysecretKey * varchar(255) VARCHAR(255) authTypeauthType * varchar(255) VARCHAR(255) firstLoginfirstLogin int default 1 INT forceNewFirstLoginforceNewFirstLogin int default 0 INT lime_user_groupsTable limesurvey4000.lime_user_groups Pk pk_lime_user_groups ( ugid ) ugidugid * int INTReferred by lime_user_in_groups ( ugid ) Unq lime_idx1_user_groups ( name ) namename * varchar(20) VARCHAR(20) descriptiondescription * text TEXT owner_idowner_id * int INTReferences lime_users ( owner_id -> uid ) lime_user_in_groupsTable limesurvey4000.lime_user_in_groups Pk pk_lime_user_in_groups ( ugid, uid ) ugidugid * int INTReferences lime_user_groups ( ugid ) Pk pk_lime_user_in_groups ( ugid, uid ) uiduid * int INTReferred by lime_users ( uid ) lime_user_in_permissionroleTable limesurvey4000.lime_user_in_permissionrole Pk pk_lime_user_in_permissionrole ( ptid, uid ) ptidptid * int INTReferences lime_permissiontemplates ( ptid ) Pk pk_lime_user_in_permissionrole ( ptid, uid ) uiduid * int INTReferred by lime_users ( uid ) lime_usersTable limesurvey4000.lime_users Pk pk_lime_users ( uid ) uiduid * int INTReferences lime_user_in_groups ( uid ) References lime_map_tutorial_users ( uid ) References lime_user_in_permissionrole ( uid ) Referred by lime_archived_table_settings ( user_id -> uid ) Referred by lime_participants ( owner_uid -> uid ) Referred by lime_participants ( created_by -> uid ) Referred by lime_permissions ( uid ) Referred by lime_permissiontemplates ( created_by -> uid ) Referred by lime_question_themes ( owner_id -> uid ) Referred by lime_settings_user ( uid ) Referred by lime_surveymenu ( created_by -> uid ) Referred by lime_surveymenu ( changed_by -> uid ) Referred by lime_surveymenu ( user_id -> uid ) Referred by lime_surveymenu_entries ( user_id -> uid ) Referred by lime_surveymenu_entries ( changed_by -> uid ) Referred by lime_surveymenu_entries ( created_by -> uid ) Referred by lime_surveys_groups ( created_by -> uid ) Referred by lime_surveys_groups ( owner_id -> uid ) Referred by lime_surveys_groupsettings ( owner_id -> uid ) Referred by lime_tutorial_entry_relation ( uid ) Referred by lime_user_groups ( owner_id -> uid ) Referred by lime_users ( parent_id -> uid ) Unq lime_idx1_users ( users_name ) users_nameusers_name * varchar(64) default '' VARCHAR(64) passwordpassword * text TEXT full_namefull_name * varchar(50) VARCHAR(50) langlang varchar(20) VARCHAR(20) parent_idparent_id * int INTReferences lime_users ( parent_id -> uid ) lime_idx2_users ( email ) emailemail varchar(192) VARCHAR(192) htmleditormodehtmleditormode varchar(7) default 'default' VARCHAR(7) templateeditormodetemplateeditormode * varchar(7) default 'default' VARCHAR(7) questionselectormodequestionselectormode * varchar(7) default 'default' VARCHAR(7) one_time_pwone_time_pw text TEXT dateformatdateformat * int default 1 INT last_loginlast_login datetime DATETIME createdcreated datetime DATETIME modifiedmodified datetime DATETIME validation_keyvalidation_key varchar(38) VARCHAR(38) validation_key_expirationvalidation_key_expiration datetime DATETIME last_forgot_email_passwordlast_forgot_email_password datetime DATETIME


Schema limesurvey4000
Table lime_answer_l10ns
IdxField NameData 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


Table lime_answers
IdxField NameData 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


Table lime_archived_table_settings
IdxField NameData 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)


Table lime_assessments
IdxField NameData 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


Table lime_asset_version
IdxField NameData Type
* id INT AUTO_INCREMENT
* path TEXT
* version INT
Indexes
pk_lime_asset_version ON id


Table lime_boxes
IdxField NameData Type
* id INT AUTO_INCREMENT
  position INT
* url TEXT
* title TEXT
  ico VARCHAR(255)
* desc TEXT
* page TEXT
* usergroup INT
Indexes
pk_lime_boxes ON id


Table lime_conditions
IdxField NameData 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


Table lime_defaultvalue_l10ns
IdxField NameData 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


Table lime_defaultvalues
IdxField NameData 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


Table lime_expression_errors
IdxField NameData 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


Table lime_failed_emails
IdxField NameData TypeDescription
* 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


Table lime_failed_login_attempts
IdxField NameData 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


Table lime_group_l10ns
IdxField NameData 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


Table lime_groups
IdxField NameData 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


Table lime_label_l10ns
IdxField NameData 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)


Table lime_labels
IdxField NameData 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)


Table lime_labelsets
IdxField NameData 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


Table lime_map_tutorial_users
IdxField NameData 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


Table lime_message
IdxField NameData 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


Table lime_notifications
IdxField NameData 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


Table lime_participant_attribute
IdxField NameData 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


Table lime_participant_attribute_names
IdxField NameData 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


Table lime_participant_attribute_names_lang
IdxField NameData 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


Table lime_participant_attribute_values
IdxField NameData 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


Table lime_participant_shares
IdxField NameData 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


Table lime_participants
IdxField NameData Type
* participant_id VARCHAR(50)
  firstname TEXT
  lastname TEXT
  email 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


Table lime_permissions
IdxField NameData 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


Table lime_permissiontemplates
IdxField NameData 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


Table lime_plugin_settings
IdxField NameData 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)


Table lime_plugins
IdxField NameData 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)


Table lime_question_attributes
IdxField NameData 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


Table lime_question_l10ns
IdxField NameData 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


Table lime_question_themes
IdxField NameData 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)


Table lime_questions
IdxField NameData 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)


Table lime_quota
IdxField NameData 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)


Table lime_quota_languagesettings
IdxField NameData 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)


Table lime_quota_members
IdxField NameData 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


Table lime_saved_control
IdxField NameData Type
* scid INT AUTO_INCREMENT
* sid INT DEFAULT 0
* srid INT DEFAULT 0
* identifier TEXT
* access_code TEXT
  email 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


Table lime_sessions
IdxField NameData Type
* id VARCHAR(32)
expire INT
  data LONGBLOB
Indexes
pk_lime_sessions ON id
sess_expire ON expire


Table lime_settings_global
IdxField NameData Type
* stg_name VARCHAR(50) DEFAULT ''
* stg_value MEDIUMTEXT
Indexes
pk_lime_settings_global ON stg_name


Table lime_settings_user
IdxField NameData 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


Table lime_source_message
IdxField NameData 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


Table lime_survey_links
IdxField NameData 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)


Table lime_survey_url_parameters
IdxField NameData 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


Table lime_surveymenu
IdxField NameData 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)


Table lime_surveymenu_entries
IdxField NameData 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)


Table lime_surveys
IdxField NameData 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)


Table lime_surveys_groups
IdxField NameData 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)


Table lime_surveys_groupsettings
IdxField NameData 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)


Table lime_surveys_languagesettings
IdxField NameData 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)


Table lime_template_configuration
IdxField NameData 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


Table lime_templates
IdxField NameData 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


Table lime_tutorial_entries
IdxField NameData 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


Table lime_tutorial_entry_relation
IdxField NameData 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


Table lime_tutorials
IdxField NameData 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


Table lime_twofactorusers
IdxField NameData 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


Table lime_user_groups
IdxField NameData 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


Table lime_user_in_groups
IdxField NameData 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


Table lime_user_in_permissionrole
IdxField NameData 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


Table lime_users
IdxField NameData Type
* uid INT AUTO_INCREMENT
* users_name VARCHAR(64) DEFAULT ''
* password TEXT
* full_name VARCHAR(50)
  lang VARCHAR(20)
* parent_id INT
email 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)