====== Introduction: ======

This table outlines the detailed structure of the Alert Settings Advanced table, which stores advanced configurations for alerts, including variable types, recipients, and communication channels.

^ Name                   ^ Type      ^ Comments                                                                                           ^
| id                      | Primary   | ID of the alert settings advanced table (auto-incremented).                                      |
| alertsettingid          | Index     | ID referencing the fw_alertsettings table.                                                    |
| variabletype            | varchar(100) | Defines the type of variable. Possible values: 'List of Values', 'Questions'.                 |
| variablevalue           | varchar(200) | Stores the chosen variable, such as fw_questionnairedetails ID or fw_orgstructure masterosid. |
| variableoption          | varchar(200) | Stores one of the options for the chosen variablevalue.                                       |
| role                    | varchar(200) | Role of the recipient for alert/fan email notifications.                                       |
| userids                 | varchar(500) | Stores user IDs of registered users who should receive alerts via email or SMS.               |
| email                   | text      | List of email addresses for recipients who are not registered users.                           |
| phone                   | text      | List of phone numbers for recipients who should receive SMS alerts.                           |
| ord                     | int       | Defines the order of the setting within the alertsettingid.                                  |
| status                  | int       | Status of the setting. 0=Inactive, 1=Active.                                                  |
| createdby               | int       | ID of the user who created the alert setting.                                                 |
| createdon               | datetime  | Timestamp when the alert setting was created.                                                 |
| modifiedby              | int       | ID of the user who last modified the alert setting.                                           |
| modifiedon              | datetime  | Timestamp when the alert setting was last modified.                                           |