Differences

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

--- questionnaireheader [2025/01/31 11:46] – gloria
+++ questionnaireheader [2025/01/31 12:25] (current) – gloria
@@ Line 6: / Line 6: @@
 | **id**                      | Primary        | ID of the record (auto-incremented). This is the unique identifier for each record in the table.                 |
 | **moduleid**                | Index          | ID of the module associated with the record. This links the record to a specific module.                        |
-| **startdate**               | date           | The start date of the record or event. Defines when the questionnaire or event becomes active.                   |
+| **startdate**               | date           | Defines when the questionnaire active.                   |
-| **enddate**                 | date           | The end date of the record or event. Defines when the questionnaire or event becomes inactive.                   |
+| **enddate**                 | date           | Defines when the questionnaire becomes inactive.                   |
-| **lastqdetailid**           | varchar(200)   | Stores the ID of the last question detail answered. Used to track the last question that was interacted with.   |
+| **lastqdetailid**           | varchar(200)   | Stores the last qdetail Id of the questionnaire. Used to track the last question that was interacted with.   |
-| **lastoptionids**           | varchar(200)   | Stores the option IDs selected for the last question answered. Tracks user responses for the most recent question.|
+| **lastoptionids**           | varchar(200)   | Stores the last option ID if the questionnaire.|
 | **anonymousoptions**        | varchar(200)   | Stores the options considered anonymous. Typically used to identify responses that shouldn't be traceable to users.|
 | **anonymousinvcnt**         | int            | The number of anonymous invitations sent. This tracks how many anonymous invitations have been issued.          |