Database documentation
From LimeSurvey Manual
This page contains documentation for all database tables and their functionality.
Without prefix, this is all tables, as of 2021-05-19:
answer_l10ns answers archived_table_settings assessments asset_version boxes conditions defaultvalue_l10ns defaultvalues expression_errors failed_login_attempts group_l10ns groups label_l10ns labels labelsets map_tutorial_users notifications old_survey_882234_20210512154558 old_tokens_882234_20210512154558 participant_attribute participant_attribute_names participant_attribute_names_lang participant_attribute_values participant_shares participants permissions permissiontemplates plugin_settings plugins question_attributes question_l10ns question_themes questions quota quota_languagesettings quota_members saved_control sessions settings_global settings_user survey_882234 survey_links survey_url_parameters surveymenu surveymenu_entries surveys surveys_groups surveys_groupsettings surveys_languagesettings template_configuration templates tutorial_entries tutorial_entry_relation tutorials user_groups user_in_groups user_in_permissionrole users
archived_table_settings
The table used to store the state of encryption set for the curently archived table that will be needed to restore them to the appropriate status.
Columns:
Name | Type | Null | Key | Default | Extra | Description |
---|---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment | |
survey_id | int(11) | NO | NULL | |||
user_id | int(11) | NO | NULL | |||
tbl_name | varchar(255) | NO | NULL | The table the setting belong to | ||
tbl_type | varchar(10) | NO | NULL | The type of the table | ||
created | datetime | NO | NULL | The date the entry was created | ||
properties | text | NO | NULL | The default settings for the current table as json (varies based on which type) e.a. tokenencryptionoptions.
The json can contain only 'unknown' which means the status of the encryption could not determined during implementation of the table. | ||
attributes | text | YES | NULL | NULL | custom settings that are not stored together with default settings like "attributedescriptions".
The json can contain only 'unknown' which means the status of the encryption could not determined during implementation of the table. |
question_themes
Also see https://manual.limesurvey.org/Question_themes.
Columns:
Name | Type | Null | Key | Default | Extra | Description |
---|---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment | |
name | varchar(150) | NO | MUL | NULL | ||
visible | varchar(1) | YES | NULL | |||
xml_path | varchar(255) | YES | NULL | Either relative to app root dir OR absolute path | ||
image_path | varchar(255) | YES | NULL | |||
title | varchar(100) | NO | NULL | |||
creation_date | datetime | YES | NULL | |||
author | varchar(150) | YES | NULL | |||
author_email | varchar(255) | YES | NULL | |||
author_url | varchar(255) | YES | NULL | |||
copyright | text | YES | NULL | |||
license | text | YES | NULL | |||
version | varchar(45) | YES | NULL | |||
api_version | varchar(45) | NO | NULL | |||
description | text | YES | NULL | |||
last_update | datetime | YES | NULL | |||
owner_id | int(11) | YES | NULL | User id of owner | ||
theme_type | varchar(150) | YES | NULL | Always "question_theme" right now; TODO: Delete? theme type is assumed from database table | ||
question_type | varchar(150) | NO | NULL | Single-letter question type | ||
core_theme | tinyint(1) | YES | NULL | Core theme = included in main git repository | ||
extends | varchar(150) | YES | NULL | If this theme extends another theme (can be both core and user uploaded theme) | ||
group | varchar(150) | YES | NULL | Question type group (array, single-choice, etc); used in the question type selector | ||
settings | text | YES | NULL | JSON string; copied from metadata, but only subquestions, answerscales, hasdefaultvalues, asssessable, class (CSS). TODO: Move these five settings to <settings> section in config.xml. |