Report Builder Schedule Email Audience Table Schema (report_builder_schedule_email_audience)


Description

Storing audience to email in scheduled reports

report_builder_schedule_email_audience table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scheduleid BIGINT 19 null
report_builder_schedule.id repobuilscheemaiaudi_sch2_fk R
cohortid BIGINT 19 null
cohort.id repobuilscheemaiaudi_coh2_fk R

Table contained -1 rows

report_builder_schedule_email_audience table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilscheemaiaudi_coh_ix Performance Asc cohortid
repobuilscheemaiaudi_sch_ix Performance Asc scheduleid
repobuilscheemaiaudi_schco_uix Must be unique Asc/Asc scheduleid + cohortid

report_builder_schedule_email_audience table relationships

Close relationships within degrees of separation