mail_activity_type


Description

Activity Type

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_activity_type_id_seq'::regclass)
ir_act_server.activity_type_id ir_act_server_activity_type_id_fkey R
mail_activity.activity_type_id mail_activity_activity_type_id_fkey R
mail_activity.previous_activity_type_id mail_activity_previous_activity_type_id_fkey N
mail_activity.recommended_activity_type_id mail_activity_recommended_activity_type_id_fkey N
mail_activity_plan_template.activity_type_id mail_activity_plan_template_activity_type_id_fkey R
mail_activity_rel.activity_id mail_activity_rel_activity_id_fkey C
mail_activity_rel.recommended_id mail_activity_rel_recommended_id_fkey C
mail_activity_schedule.activity_type_id mail_activity_schedule_activity_type_id_fkey N
mail_activity_type.triggered_next_type_id mail_activity_type_triggered_next_type_id_fkey R
mail_activity_type_mail_template_rel.mail_activity_type_id mail_activity_type_mail_template_rel_mail_activity_type_id_fkey C
mail_compose_message.mail_activity_type_id mail_compose_message_mail_activity_type_id_fkey N
mail_message.mail_activity_type_id mail_message_mail_activity_type_id_fkey N
sequence int4 10 √ null

Sequence
create_uid int4 10 √ null
res_users.id mail_activity_type_create_uid_fkey N

Create Uid
delay_count int4 10 √ null

Schedule
triggered_next_type_id int4 10 √ null
mail_activity_type.id mail_activity_type_triggered_next_type_id_fkey R

Trigger
default_user_id int4 10 √ null
res_users.id mail_activity_type_default_user_id_fkey N

Default User
write_uid int4 10 √ null
res_users.id mail_activity_type_write_uid_fkey N

Last Updated by
delay_unit varchar 2147483647 null

Delay units
delay_from varchar 2147483647 null

Delay Type
icon varchar 2147483647 √ null

Icon
decoration_type varchar 2147483647 √ null

Decoration Type
res_model varchar 2147483647 √ null

Model
chaining_type varchar 2147483647 null

Chaining Type
category varchar 2147483647 √ null

Action
name jsonb 2147483647 null

Name
summary jsonb 2147483647 √ null

Default Summary
default_note jsonb 2147483647 √ null

Default Note
active bool 1 √ null

Active
keep_done bool 1 √ null

Keep Done
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_activity_type_pkey Primary key Asc id
mail_activity_type__create_uid_index Performance Asc create_uid

Relationships

Close relationships within degrees of separation