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 stores settings for sending email and SMS reminders about invitations. It includes subject, body content, sending intervals, and WhatsApp template support.

==== Table Structure ====
^ **Name**                          ^ **Type**       ^ **Comments**                                                 ^
| **id**                            | Primary       | Unique ID of the record (auto-incremented).                 |
| **invemailsettingsid**            | Index        | ID linking to `fw_invemailsettings`.                        |
| **sendreminderafter**             | int          | Number of days after which the reminder should be sent.     |
| **sendreminderassms**             | int          | Whether to send reminder as SMS (0 = No, 1 = Yes).          |
| **remindersubject**               | text         | Subject of the reminder email.                              |
| **reminderbody**                  | text         | Body content of the reminder email.                         |
| **reminderassmsbody**             | text         | Alternative body content if the reminder is sent as SMS.    |
| **smsremindertext**               | text         | SMS reminder message content.                               |
| **reminderwhatsapptemplateid**     | int          | ID referencing a WhatsApp reminder template (default = 0).  |
| **status**                        | int          | Status of the reminder (0 = Inactive, 1 = Active).          |

==== Example Data ====
^ **id** ^ **invemailsettingsid** ^ **sendreminderafter** ^ **sendreminderassms** ^ **remindersubject** ^ **reminderbody** ^ **smsremindertext** ^ **reminderwhatsapptemplateid** ^ **status** ^
| 1      | 1                     | 2                      | 0                     | Herinnering: Employee Engagement meting | <div>Beste //^Naam^//, het is tijd voor de Employee Engagement meting!</div> | [SMS Content] | 0 | 1 |