fw_branchquestions
This is an old revision of the document!
Table of Contents
Introduction
This table links specific questionnaire details to branches. Each branch can have multiple associated questions.
Table Structure
| Name | Type | Comments |
|---|---|---|
| id | Primary | Unique ID of the record (auto-incremented). |
| branchid | Index | ID of the branch associated with the question. |
| qdetailid | Index | ID of the questionnaire detail linked to the branch. |
| status | int | Status of the entry (0 = Inactive, 1 = Active). |
| createdby | int | ID of the user who created the record. |
| createdon | datetime | Timestamp when the record was created. |
| modifiedby | int | ID of the user who last modified the record. |
| modifiedon | datetime | Timestamp of the last modification. |
Example Data
*A branch can have multiple associated questionnaire details. Below is an example dataset.*
| id | branchid | qdetailid | status (0=Inactive, 1=Active) | createdby | createdon | modifiedby | modifiedon |
|---|---|---|---|---|---|---|---|
| 1 | 3 | 12 | 1 | 1089 | 2024-01-15 10:30:00 | 1089 | 2024-02-01 14:00:00 |
| 2 | 4 | 15 | 0 | 1089 | 2024-01-20 11:45:00 | 1089 | 2024-02-05 09:15:00 |
fw_branchquestions.1741068438.txt.gz · Last modified: 2025/03/04 06:07 by gloria