Database documentation

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

question_themes

Columns:

Name ! Type ! Null ! Key ! Default ! Extra ! Description
int(11) | NO | PRI | NULL | auto_increment |
varchar(150) | NO | MUL | NULL | |
varchar(1) | YES | | NULL | |
varchar(255) | YES | | NULL | |
varchar(255) | YES | | NULL | |
varchar(100) | NO | | NULL | |
datetime | YES | | NULL | |
varchar(150) | YES | | NULL | |
varchar(255) | YES | | NULL | |
varchar(255) | YES | | NULL | |
text | YES | | NULL | |
text | YES | | NULL | |
varchar(45) | YES | | NULL | |
varchar(45) | NO | | NULL | |
text | YES | | NULL | |
datetime | YES | | NULL | |
int(11) | YES | | NULL | |
varchar(150) | YES | | NULL | |
varchar(150) | NO | | NULL | |
tinyint(1) | YES | | NULL | |
varchar(150) | YES | | NULL | |
varchar(150) | YES | | NULL | |
text | YES | | NULL | |