tbl_reminder_mails

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_reminder_mails_id_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single reminder mail record.
remindertype varchar 100 null

The type or category of the reminder.
Format: Varchar/Text or lookup key
Example: Leave Approval, Document Submission, Policy Reminder.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid (Presumed Foreign Key)
Meaning: The recipient employee associated with this reminder.
employeeemail varchar 500 null

The specific email address to which the reminder was sent.
Format: Varchar(255)
Logic: The actual delivery address, used by the mail server.
message text 2147483647 √ null

The main text content or body of the reminder email.
Format: Text
Logic: Stores the dynamic or static message sent to the recipient.
status varchar 100 √ null

The current delivery status of the reminder email.
Format: Varchar/Text or SmallInt
Meaning: E.g., Sent, Failed, Scheduled, Retrying.
createddate timestamp 29,6 √ null

Timestamp of when the reminder record was created (usually when the mail was queued).
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
createdby varchar 500 null

FK: public.tbl_userlogin.id or similar
Meaning: The user or system process that initiated the creation of this reminder.
modifieddate timestamp 29,6 √ null

Timestamp of when the reminder record was last modified (e.g., status update after sending).
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 500 null

FK: public.tbl_userlogin.id or similar
Meaning: The user or system process that last modified this reminder record.

Indexes

Constraint Name Type Sort Column(s)
pk__tbl__tbl_reminder_mails_id Primary key Asc id

Relationships

Close relationships within degrees of separation