tbl_composeemail

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single composed email entry, typically saved as a draft or a template.
subject varchar 200 null

The subject line of the composed email.
Format: Varchar/Text
emailbody varchar 2147483647 null

The full content/body of the email message.
Format: Text (potentially including HTML)
Logic: Stores the message content, possibly with dynamic placeholders.
emailrecipients varchar 10 null

The intended recipients of the email.
Format: Text or JSONB (e.g., list of email addresses, user IDs, or role IDs)
Logic: Defines who the email is to be sent to.
employeeid varchar 2147483647 null

FK: public.tbl_employee.employeeid (Presumed Foreign Key)
Meaning: The Employee ID associated with the context of the email.
Example: The employee for whom a new offer letter is being composed.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who created or saved this email composition/template.
createddate timestamp 29,6 √ null

Timestamp of when the email composition was created.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this email composition.
modifieddate timestamp 29,6 √ null

Timestamp of when the email composition was last modified.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ

Indexes

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

Relationships

Close relationships within degrees of separation