mail_canned_response


Description

Canned Response

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_canned_response_id_seq'::regclass)
mail_canned_response_res_groups_rel.mail_canned_response_id mail_canned_response_res_groups_re_mail_canned_response_id_fkey C
create_uid int4 10 √ null
res_users.id mail_canned_response_create_uid_fkey N

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

Last Updated by
source varchar 2147483647 null

Shortcut
description varchar 2147483647 √ null

Description
substitution text 2147483647 null

Substitution
is_shared bool 1 √ null

Determines if the canned_response is currently shared with other users
last_used timestamp 29,6 √ null

Last Used
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_canned_response_pkey Primary key Asc id
mail_canned_response__source_index Performance Asc source

Relationships

Close relationships within degrees of separation