hr.smtp_settings

Schema: hr
English table: hr.smtp_settings
Italian original table: hr._smtp
Description: SMTP configuration settings used to send application emails per tenant.

Overview

• Columns: 14
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
smtp_setting_id	smtp_id	integer	NO		Logical SMTP setting identifier (unique per tenant).
smtp_server_host	smtp_server	character varying(200)	NO		SMTP server hostname or address.
smtp_description	smtp_desciption	character varying(200)	NO		Human-readable description of the SMTP configuration.
smtp_username	smtp_username	character varying(200)	NO		Username used for SMTP authentication.
smtp_password	smtp_password	character varying(200)	NO		Password used for SMTP authentication.
smtp_authenticate	smtp_authenticate	numeric(1,0)	NO		Authentication flag (stored as numeric(1,0)).
smtp_server_port	smtp_serverport	numeric(5,0)	NO		SMTP server port (stored as numeric(5,0)).
smtp_sendusing	smtp_sendusing	numeric(2,0)	NO		Delivery method code (stored as numeric(2,0)).
smtp_connection_timeout_seconds	smtp_connectiontimeout	numeric(3,0)	NO		Connection timeout in seconds (stored as numeric(3,0)).
smtp_reply_to_email	smtp_senduserreplyemailaddress	character varying(200)	NO		Reply-to email address used for outgoing messages.
smtp_from_email	smtp_sendemailaddress	character varying(200)	NO		From email address used for outgoing messages.
smtp_uses_ssl	smtp_usessl	boolean	NO		Indicates whether SSL/TLS is used for the SMTP connection.
tenant_id	tenant_id	integer	YES		Tenant identifier for row-level security and data partitioning.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_smtp_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_smtp_settings → id
• Unique: uk_smtp_setting_tenant → smtp_setting_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_smtp_tenant	NO	btree	tenant_id
idx_smtp_tenant_setting	NO	btree	tenant_id, smtp_setting_id

Navigation

• Back to main index
• [Back to hr index]../)