Actions

Database documentation: Difference between revisions

From LimeSurvey Manual

Line 84: Line 84:
| created      || datetime || NO  ||    || NULL    ||                ||The date the entry was created
| 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.  
| 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.
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".  
| 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.
The json can contain only 'unknown' which means the status of the encryption could not determined during implementation of the table.
|}
|}



Revision as of 13:43, 6 August 2021

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.