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 email invitations, including sender details, subject, body, and language preferences. It also supports SMS and WhatsApp message templates.

==== Table Structure ====
^ **Name**                   ^ **Type**        ^ **Comments**                                                              ^
| **id**                     | Primary        | Unique ID of the record (auto-incremented).                              |
| **clientbranchmoduleid**    | Index         | ID linking the setting to a specific client-branch module.                |
| **variablevalue**           | int           | Holds the variable value to uniquely identify settings.                   |
| **languageid**              | Index         | Language ID referencing `fw_languages`.                                   |
| **sendername**              | varchar(200)  | Name of the email sender.                                                 |
| **emailsender**             | varchar(200)  | Email address of the sender.                                              |
| **subject**                 | text          | Subject of the email.                                                     |
| **body**                    | text          | Body content of the email.                                                |
| **smstext**                 | text          | SMS message content.                                                      |
| **whatsapptemplateid**       | int           | ID referencing a WhatsApp message template (default = 0).                 |

==== Example Data ====
^ **id** ^ **clientbranchmoduleid** ^ **variablevalue** ^ **languageid** ^ **sendername** ^ **emailsender** ^ **subject** ^ **body** ^ **smstext** ^ **whatsapptemplateid** ^
| 1      | 1                        | 1                 | 1             | People Pulse | onderzoek@forumresearch.nl | Employee Engagement meting | <div>Beste **^Naam^**,</div><div>Het is tijd voor de Employee Engagement meting!</div> |  | 0 |