tbl_milestone_mails

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single email notification record.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid or similar (Presumed Foreign Key)
Meaning: The ID of the employee the notification is about or sent to.
employeeemail varchar 500 null

The email address to which the notification was sent.
Format: Varchar/Text
Usage: Stored to track communication, especially if the employee ID is no longer active.
message text 2147483647 √ null

The content or subject line of the email sent.
Format: Text
Logic: May store the full email body or a key identifier for the email template.
status varchar 100 √ null

The delivery status of the email.
Format: Varchar/Lookup Key
Example: Sent, Failed, Scheduled, Delivered.
createddate timestamp 29,6 √ null

Timestamp of when the email notification record was created (i.e., when the mail was sent or queued).
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
createdby varchar 500 null

FK: public.tbl_userlogin.id or similar
Meaning: The user ID or system service that triggered the creation/sending of this email.
modifieddate timestamp 29,6 √ null

Timestamp of when the email record was last modified.
Usage: Often updated with the final delivery status.
modifiedby varchar 500 null

FK: public.tbl_userlogin.id or similar
Meaning: The last user or system process that updated the record (e.g., status update from mail server).

Indexes

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

Relationships

Close relationships within degrees of separation