Survey settings inheritance

General

This documentation will give you an overview how the inheritance process of survey settings works in Limesurvey software.

Database tables for inheritance

We have three tables that are relevant for the inheritance process.

1. Table surveys_groups There is one default group in table “survey groups” with the gsid=1 and name=”default”. This is the group from which a new created survey and a new created survey group inherit from. All other survey groups that could be created by the user are stored in this table too. The next screenshot shows the process of creating a new survey with "default group" selected. Every new created survey belongs to a group. When no special group is selected it belongs to the default group, inheriting all settings from that group. The next screenshot shows the default group from which a new created survey and a new created survey group inherit from.
2. Table surveys_groupsettings Here we save all group settings. There is a relation to table survey_groups (1:1). The table "survey_groupssettings" has two basic entries (inserted to DB on installation):
   1. gsid = 0: There is no entry in table surveys_group that is related to this. Example attribute: save ip address “ipaddr” = ‘N’. That are the values the software starts with.These values are the global survey settings.
   2. gsid: 1 “insert settings for default survey group” (save ip address “ipaddr” = ‘I’ ) ‘I’ means inherit the behaviour from gsid=0
3. Table surveys Every survey belongs to one group. The attribute “gsid” from this table is the relation to that group in table surveys_group.All settings are, in first step, inherited by this group and the attribute is set to “I”. All survey settings could be changed and will then not be part of inheritance (for the single attribute that has changed)anymore.