tbl_emailsmtpmaster

-1 rows


Description

Module: SMTP
Purpose: Stores SMTP configuration details for companies.
Data: One row per company SMTP configuration.
Process Usage:
- Used to send system-generated emails (HR notifications, offer letters, etc.).
- Contains credentials and server information for email dispatch.
Key Points:
- Supports multiple email accounts (e.g., HR account and offer email account).
- Tracks SMTP server, port, SSL, and authentication details.
Business Impact: Ensures reliable email delivery for HR and operational communication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
emailsmtpid serial 10 √ nextval('tbl_emailsmtpmaster_emailsmtpid_seq'::regclass)

Primary key
Format: SERIAL (auto-increment)
Used as: Unique identifier for each SMTP configuration record.
companyid int4 10 √ null
tbl_companymaster.companyid fk__tbl_email__compa__6693daab R

Company ID
Format: INT
Meaning: References the company associated with this SMTP configuration.
Usage: Links SMTP settings to a specific company.
FK: tbl_companymaster(companyid)
emailsmtp varchar 2147483647 null

SMTP Server
Format: VARCHAR
Meaning: Hostname or IP of the SMTP server used for sending emails.
Usage: Required for email dispatch.
emailports varchar 5 √ null

SMTP Port
Format: VARCHAR(5)
Meaning: Port number of the SMTP server.
Usage: Used to connect to the SMTP server.
emailusername varchar 2147483647 null

HR Email Username
Format: VARCHAR
Meaning: Username for authenticating with SMTP server.
Usage: Required to send emails.
emailpassword varchar 2147483647 null

HR Email Password
Format: VARCHAR
Meaning: Password for SMTP authentication.
Usage: Required to send emails securely.
emailssl bool 1 √ false

Use SSL
Format: BOOLEAN
Default: false
Meaning: Indicates whether SSL should be used for SMTP connection.
emailcreatedate timestamp 29,6 √ null

SMTP record creation date
Format: TIMESTAMP
Usage: Tracks when the SMTP configuration was created.
emailstatus bool 1 √ false

Status
Format: BOOLEAN
Default: false
Usage: Not used in current code.
noofrecipientallowed int4 10 √ null

Number of recipients allowed
Format: INT
Usage: Not used in current code.
emailsendto varchar 20 √ null

Send to email address
Format: VARCHAR(20)
Usage: Not used in current code.
staffmailidonly bool 1 √ false

Staff mail ID only flag
Format: BOOLEAN
Default: false
Usage: Not used in current code.
comm1 varchar 50 √ null

HR From Email
Format: VARCHAR(50)
Meaning: Email address used as the “from” address for HR emails.
comm2 varchar 50 √ null

Reserved Column
Usage: Not used in current code.
sameascompany bool 1 √ true

Use company email
Format: BOOLEAN
Default: true
Meaning: Indicates whether the email address is same as the company email.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
sbu bool 1 √ null

Reserved Column
Usage: Not used in current code.
servertype varchar 50 √ null

Email Provider Type
Format: VARCHAR(50)
Meaning: SMTP provider, e.g., Gmail, Yahoo.
offer_email_username varchar 10485760 √ null

Offer Email Username
Format: VARCHAR(MAX)
Meaning: Username for the SMTP account used to send offer emails.
offer_email_password varchar 10485760 √ null

Offer Email Password
Format: VARCHAR(MAX)
Meaning: Password for the SMTP account used to send offer emails.
offer_email_address varchar 10485760 √ null

Offer From Email
Format: VARCHAR(MAX)
Meaning: Email address used as the “from” for offer emails.

Indexes

Constraint Name Type Sort Column(s)
tbl_emailsmtpmaster_pk_tbl_emailsmtpmaster Primary key Asc emailsmtpid

Relationships

Close relationships within degrees of separation