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.