fw_invremindersettings

Table of Contents

Introduction
Table Structure
Example Data

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