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.