Store template information for emails
Data model
Fields
| Field | Type | Description |
|---|---|---|
| mate_body | NVARCHAR (MAX) | Formatting for the body of the email |
| mate_category_id | INT | Category identifier |
| mate_format* | INT | Template Format |
| mate_id* | INT | Template ID |
| mate_is_default* | INT | Determine if it’s the default template |
| mate_name* | NVARCHAR (100) | Template Name |
| mate_project_id | INT | Project ID |
| mate_sender | NVARCHAR (2000) | Sender’s email account |
| mate_sender_name | NVARCHAR (2000) | Sender’s Name |
| mate_subject | NVARCHAR (200) | Format for the email subject |
| modification_date | DATETIME | Date of last modification |
| modified_by | INT | Identifier of the last user who modified the record |
Primary Key
| PK_AFW_MAIL_TEMPLATE |
|---|
| mate_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| mate_category_id | dbo.AFW_APPLICATION_CATEGORY | apca_id | FK01_AFW_MAIL_TEMPLATE |