ir_mail_server

-1 rows


Description

Mail Server

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_mail_server_id_seq'::regclass)
mail_compose_message.mail_server_id mail_compose_message_mail_server_id_fkey N
mail_message.mail_server_id mail_message_mail_server_id_fkey N
mail_template.mail_server_id mail_template_mail_server_id_fkey N
smtp_port int4 10 √ null

SMTP Port
sequence int4 10 √ null

Priority
create_uid int4 10 √ null
res_users.id ir_mail_server_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id ir_mail_server_write_uid_fkey N

Last Updated by
name varchar 2147483647 null

Name
from_filter varchar 2147483647 √ null

FROM Filtering
smtp_host varchar 2147483647 √ null

SMTP Server
smtp_authentication varchar 2147483647 null

Authenticate with
smtp_user varchar 2147483647 √ null

Username
smtp_pass varchar 2147483647 √ null

Password
smtp_encryption varchar 2147483647 null

Connection Encryption
smtp_debug bool 1 √ null

Debugging
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
smtp_ssl_certificate bytea 2147483647 √ null

SSL Certificate
smtp_ssl_private_key bytea 2147483647 √ null

SSL Private Key
google_gmail_access_token_expiration int4 10 √ null

Access Token Expiration Timestamp
google_gmail_authorization_code varchar 2147483647 √ null

Authorization Code
google_gmail_refresh_token varchar 2147483647 √ null

Refresh Token
google_gmail_access_token varchar 2147483647 √ null

Access Token

Indexes

Constraint Name Type Sort Column(s)
ir_mail_server_pkey Primary key Asc id
ir_mail_server__name_index Performance Asc name

Relationships

Close relationships within degrees of separation