NotificationTemplate Table

NotificationTemplate stores a list of email templates used to generate notification emails.

Table 1. Database columns for NotificationTemplate table

Database Column

Details
NotificationTemplateID

Type: integer. Key. Generated ID

A unique identifier for each NotificationTemplate. The default templates provided are:

  • -1 = Contract expiry notification template
  • -2 = Contract renewal notification template
  • -3 = Task due notification template
  • -4 = Task reminder notification template
  • -5 = Task escalation notification template.
FileName

Type: text (max 255 characters). Key

The template’s file name.
Content

Type: text. Nullable

The template content.