Performitor

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Introduction: ======

The **QuestionOptionsLang** table is responsible for storing **multilingual text data** for the options (answer choices) associated with each question option in the survey. This table allows each option to have different text based on the language selected by the respondent.

It contains multiple versions of the option text, including:
  - **Graph Option Name**: Text used in graphical reports.
  - **Report Option Name**: Text shown in the downloadable reports.
  - **Import Option Name**: Text displayed when importing the survey data.
  - **Open Answer Name**: Text for open-ended responses associated with the option.

The table is linked to the **QuestionnaireDetailsOptions** table via the **optionid** column and supports multilingual data based on the **language** column.

Below is the detailed structure of the **QuestionOptionsLang** table along with descriptions.

^ **Sr. No.** ^ **Name**                         ^ **Type**       ^ **Description**                                                                                      ^
| 1           | **id**                            | int            | Unique identifier for each language record for the option. This is AUTO_INCREMENT.                  |
| 2           | **optionid**                      | int            | Foreign key referring to the **id** of the **fw_questionnaireoptions** table. This links the text to a specific option.        |
| 3           | **language**                      | varchar(20)    | Stores the language code for the option text. Example: 'EN', 'NL', 'FR', etc.                       |
| 4           | **optionname**                    | varchar(250)   | Contains the option text shown to the respondent in the survey. This text varies based on language. |
| 5           | **graphoptionname**               | varchar(250)   | Text used in **graphical reports** to represent the option. Often a shorter or summarized version.   |
| 6           | **reportoptionname**              | varchar(300)   | Text that appears in **downloadable reports** when this option is selected. It can differ from the survey text to make the report more clear. |
| 7           | **importoptionname**              | varchar(300)   | Text used during **data import** as the column header for the option in import files.               |
| 8           | **importopenansname**             | varchar(300)   | Text used in **data import files** for open text responses associated with the option. This appears as a separate column header. |
| 9           | **reportopenansname**             | varchar(300)   | Text shown in the **downloadable report** for open-ended responses. This ensures clear labeling of open text answers.         |
| 10          | **addedfrommodlangsettings**      | int            | Indicates if the option text was added automatically from **Module Language Settings**. **0** = Manually added, **1** = Automatically added. |