email_log

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single email transmission record.

The system module or user that initiated the email sending process.
Format: Varchar/Text or FK (User ID)
Example: Recruitment_Module, System_Cron, HR_User_ID: 123.

The sender’s email address as it appeared in the outgoing message.
Format: Varchar(255)
Example: noreply@company.com.

The primary recipient email address(es).
Format: Text (comma-separated list for multiple recipients)

The Carbon Copy recipient email address(es).
Format: Text (comma-separated list, nullable)

The Blind Carbon Copy recipient email address(es).
Format: Text (comma-separated list, nullable)

The subject line of the email sent.
Format: Varchar/Text

The full content/body of the email message.
Format: Text (potentially including HTML)

A record of file attachments included with the email.
Format: JSONB or Text (e.g., list of file paths/IDs, nullable)

Flag indicating the final delivery status of the email via the mail server.
Format: Boolean (True/False)
Logic: True if the mail server accepted the message for delivery.

Any error message returned by the mail server upon failure.
Format: Text
Usage: Null if successful, otherwise contains details like “Recipient address rejected”.

Timestamp of when the email was sent or transmitted to the mail server.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ