Report Builder Schedule Email Systemuser Table Schema (report_builder_schedule_email_systemuser)


Description

Storing system users to email in scheduled reports

report_builder_schedule_email_systemuser table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scheduleid BIGINT 19 null
report_builder_schedule.id repobuilscheemaisyst_sch2_fk R
userid BIGINT 19 null
user.id repobuilscheemaisyst_use2_fk R

Table contained -1 rows

report_builder_schedule_email_systemuser table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilscheemaisyst_sch_ix Performance Asc scheduleid
repobuilscheemaisyst_schus_uix Must be unique Asc/Asc scheduleid + userid
repobuilscheemaisyst_use_ix Performance Asc userid

report_builder_schedule_email_systemuser table relationships

Close relationships within degrees of separation