digest_digest

-1 rows


Description

Digest

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('digest_digest_id_seq'::regclass)
digest_digest_res_users_rel.digest_digest_id digest_digest_res_users_rel_digest_digest_id_fkey C
res_config_settings.digest_id res_config_settings_digest_id_fkey N
company_id int4 10 √ null
res_company.id digest_digest_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id digest_digest_create_uid_fkey N

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

Last Updated by
periodicity varchar 2147483647 null

Periodicity
state varchar 2147483647 √ null

Status
next_run_date date 13 √ null

Next Mailing Date
name jsonb 2147483647 null

Name
kpi_res_users_connected bool 1 √ null

Connected Users
kpi_mail_message_total bool 1 √ null

Messages Sent
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
kpi_account_total_revenue bool 1 √ null

Revenue
kpi_all_sale_total bool 1 √ null

All Sales

Indexes

Constraint Name Type Sort Column(s)
digest_digest_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation