mail_activity

-1 rows


Description

Activity

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_activity_id_seq'::regclass)
activity_attachment_rel.activity_id activity_attachment_rel_activity_id_fkey C
res_model_id int4 10 null
ir_model.id mail_activity_res_model_id_fkey C

Document Model
res_id int4 10 √ null

Related Document ID
activity_type_id int4 10 √ null
mail_activity_type.id mail_activity_activity_type_id_fkey R

Activity Type
user_id int4 10 null
res_users.id mail_activity_user_id_fkey C

Assigned to
request_partner_id int4 10 √ null
res_partner.id mail_activity_request_partner_id_fkey N

Requesting Partner
recommended_activity_type_id int4 10 √ null
mail_activity_type.id mail_activity_recommended_activity_type_id_fkey N

Recommended Activity Type
previous_activity_type_id int4 10 √ null
mail_activity_type.id mail_activity_previous_activity_type_id_fkey N

Previous Activity Type
create_uid int4 10 √ null
res_users.id mail_activity_create_uid_fkey N

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

Last Updated by
res_model varchar 2147483647 √ null

Related Document Model
res_name varchar 2147483647 √ null

Document Name
summary varchar 2147483647 √ null

Summary
date_deadline date 13 null

Due Date
date_done date 13 √ null

Done Date
note text 2147483647 √ null

Note
automated bool 1 √ null

Automated activity
active bool 1 √ null

Active
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_pkey Primary key Asc id
mail_activity__date_deadline_index Performance Asc date_deadline
mail_activity__res_id_index Performance Asc res_id
mail_activity__res_model_id_index Performance Asc res_model_id
mail_activity__res_model_index Performance Asc res_model
mail_activity__user_id_index Performance Asc user_id

Check Constraints

Constraint Name Constraint
mail_activity_check_res_id_is_set (((res_id IS NOT NULL) AND (res_id <> 0)))

Relationships

Close relationships within degrees of separation