Differences

This shows you the differences between two versions of the page.

--- questionoptionslang [2025/02/04 11:44] – created gloria
+++ questionoptionslang [2025/03/10 06:34] (current) – gloria
@@ Line 1: / Line 1: @@
-^ #  ^ **Name**                         ^ Type       ^ Comments  ^
+====== Introduction: ======
-| 1  | **id**                            | int        | AUTO_INCREMENT |
-| 2  | **optionid**                      | int        |  |
+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.
-| 3  | **language**                      | varchar(20) |  |
-| 4  | **optionname**                    | varchar(250) |  |
+It contains multiple versions of the option text, including:
-| 5  | **graphoptionname**               | varchar(250) |  |
+  - **Graph Option Name**: Text used in graphical reports.
-| 6  | **reportoptionname**              | varchar(300) | stores the text that has to be shown in reports for this option. |
+  - **Report Option Name**: Text shown in the downloadable reports.
-| 7  | **importoptionname**              | varchar(300) | Stores import data column name |
+  - **Import Option Name**: Text displayed when importing the survey data.
-| 8  | **importopenansname**             | varchar(300) | Stores import data open answer column name |
+  - **Open Answer Name**: Text for open-ended responses associated with the option.
-| 9  | **reportopenansname**             | varchar(300) | Stores reports open answer column name |
-| 10 | **addedfrommodlangsettings**      | int        | 0 |
+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. |