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.