Performitor

This is an old revision of the document!

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>	[SMS Content]	0

Table of Contents

Introduction

Table Structure

Example Data