mail_activity_plan_template

-1 rows


Description

Activity plan template

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_activity_plan_template_id_seq'::regclass)
plan_id int4 10 null
mail_activity_plan.id mail_activity_plan_template_plan_id_fkey C

Plan
sequence int4 10 √ null

Sequence
activity_type_id int4 10 null
mail_activity_type.id mail_activity_plan_template_activity_type_id_fkey R

Activity Type
responsible_id int4 10 √ null
res_users.id mail_activity_plan_template_responsible_id_fkey N

Assigned to
create_uid int4 10 √ null
res_users.id mail_activity_plan_template_create_uid_fkey N

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

Last Updated by
summary varchar 2147483647 √ null

Summary
responsible_type varchar 2147483647 null

Assignment
note text 2147483647 √ null

Note
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_plan_template_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation