questionnairedetailslang
This is an old revision of the document!
| Name | Type | Comments | |||
|---|---|---|---|---|---|
| 1 | id | Primary | ID of the record (auto-incremented). | ||
| 2 | qdetailid | Index | Unique identifier for the question detail in the system. | ||
| 3 | language | varchar(50) | Stores the language code for the question text (e.g., English, French). | ||
| 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 if the text was added from module language settings. | ||
| 13 | audiofile | longblob | Stores the audio file related to the question. | ||
| 14 | videofile | longblob | Stores the video file related to the question. |
questionnairedetailslang.1738326710.txt.gz · Last modified: 2025/01/31 12:31 by gloria