Performitor

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Introduction: ======

This table outlines the detailed structure of the Alerts & Actions table, which stores alert settings and action list configurations for questionnaires. Each row corresponds to a specific attribute of an alert or action item, including recipient roles, conditions, and display settings.

^ Name                   ^ Type      ^ Comments                                                                                           ^
| id                      | Primary   | ID of the questionnaire alerts table (auto-incremented).                                         |
| clientid                | Index     | ID of the client associated with the alert/action.                                              |
| branchid                | int       | ID of the branch related to the alert/action (references fw_branches).                        |
| moduleid                | Index     | ID of the module related to the alert/action.                                                   |
| type                    | varchar(200) | Defines the type of alert or action. Possible values: 'alert-positive', 'alert-negative', 'actionlist-positive', 'actionlist-negative'. |
| qdetailid               | Index     | ID referencing the questionnaire details.                                                       |
| optionids               | varchar(200) | Stores option IDs associated with the alert/action.                                            |
| role                    | Index     | Role of users who will receive emails related to this alert/action.                             |
| invemailfieldids        | varchar(250) | Stores invitation field IDs for email notifications (e.g., used for LAC fan mails).          |
| email                   | text      | Comma-separated email addresses to which alert/action emails are sent.                         |
| excludeanonymity        | int       | Defines if anonymous users should be excluded. 1=Exclude, 0=Do not exclude.                     |
| actioncolour            | varchar(100) | Stores the color associated with this action in the action list.                               |
| orderval                | int       | Stores the priority order of the case.                                                         |
| status                  | int       | Status of the alert/action. 0=Inactive, 1=Active.                                              |
| createdby               | int       | ID of the user who created the alert/action.                                                   |
| createdon               | datetime  | Timestamp when the alert/action was created.                                                   |
| modifiedby              | int       | ID of the user who last modified the alert/action.                                             |
| modifiedon              | datetime  | Timestamp when the alert/action was last modified.                                             |