====== Introduction: ======

This table outlines the detailed structure of the **questionnairedetailsLang** table, which stores language-specific text and media for questions in a survey. Each row represents different attributes of a question in various languages, ensuring multi-language support for surveys. This table is linked to the **QuestionnaireDetails** table via **qdetailid**. It also handles client sheet text, app labels, audio, and video files related to the questions.

Below is the list of fields in the **QuestionnaireDetailsLang** table along with their descriptions and data types.

^ **Sr. No.** ^ **Name**                     ^ **Type**          ^ **Comments**                                                                                             ^
| 1           | **id**                         | Primary           | ID of the record (auto-incremented).                                                                   |
| 2           | **qdetailid**                  | Index             | Unique identifier for the question.                                                                    |
| 3           | **language**                   | varchar(50)       | Stores the language code for the question text (e.g., English, NL).                                |
| 4           | **question**                   | text              | Contains the actual question text in the survey.                                                       |
| 5           | **clientsheetqtext**           | varchar(200)      | Stores the question text for the client sheet view.                                                     |
| 6           | **downloadqtext**              | varchar(200)      | Stores the question text for download/export formats.                                                   |
| 7           | **importqtext**                | varchar(250)      | Stores the import data question text.                                                                  |
| 8           | **reportqtext**                | text              | This column is used to show the question text on drill down by replacing `//^answerQ^//` formats with preferred text. |
| 9           | **appqtext**                   | varchar(200)      | Value in this column is used as the label in the mobile app case details screen.                        |
| 10          | **cscategory**                 | varchar(200)      | Saves the category name to differentiate sets of questions in the client sheet.                        |
| 11          | **basistext**                  | text              | Saves the basis text used to show in the Voorbeeld Vragenlist (example questionnaire).                  |
| 12          | **addedfrommodlangsettings**   | int               | Indicates whether the text is added from module language settings (1=Yes, 0=No).                        |
| 13          | **audiofile**                  | longblob          | Stores the audio file related to the question.                                                          |
| 14          | **videofile**                  | longblob          | Stores the video file related to the question.                                                          |