mail_alias

-1 rows


Description

Email Aliases

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_alias_id_seq'::regclass)
account_journal.alias_id account_journal_alias_id_fkey R
alias_domain_id int4 10 √ null
mail_alias_domain.id mail_alias_alias_domain_id_fkey R

Alias Domain
alias_model_id int4 10 null
ir_model.id mail_alias_alias_model_id_fkey C

Aliased Model
alias_force_thread_id int4 10 √ null

Record Thread ID
alias_parent_model_id int4 10 √ null
ir_model.id mail_alias_alias_parent_model_id_fkey N

Parent Model
alias_parent_thread_id int4 10 √ null

Parent Record Thread ID
create_uid int4 10 √ null
res_users.id mail_alias_create_uid_fkey N

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

Last Updated by
alias_name varchar 2147483647 √ null

Alias Name
alias_full_name varchar 2147483647 √ null

Alias Email
alias_contact varchar 2147483647 null

Alias Contact Security
alias_status varchar 2147483647 √ null

Alias Status
alias_bounced_content jsonb 2147483647 √ null

Custom Bounced Message
alias_defaults text 2147483647 null

Default Values
alias_incoming_local bool 1 √ null

Local-part based incoming detection
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
mail_alias_pkey Primary key Asc id
mail_alias__alias_full_name_index Performance Asc alias_full_name
mail_alias_name_domain_unique Must be unique Asc alias_name

Relationships

Close relationships within degrees of separation