Report Builder Schedule Table Schema (report_builder_schedule)


Description

Storing details of scheduled reports

report_builder_schedule table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
report_builder_schedule_email_audience.scheduleid repobuilscheemaiaudi_sch2_fk R
report_builder_schedule_email_external.scheduleid repobuilscheemaiexte_sch2_fk R
report_builder_schedule_email_systemuser.scheduleid repobuilscheemaisyst_sch2_fk R
reportid BIGINT 19 null
report_builder.id repobuilsche_rep2_fk R
userid BIGINT 19 null
user.id repobuilsche_use3_fk R
savedsearchid BIGINT 19 null
report_builder_saved.id repobuilsche_sav2_fk R
format VARCHAR 50
frequency BIGINT 19 null
exporttofilesystem BIGINT 19 0
schedule BIGINT 19 null
nextreport BIGINT 19 √ null
usermodified BIGINT 19 0
user.id repobuilsche_use4_fk R

user who last modified the scheduled report settings
lastmodified BIGINT 19 0

Timestamp when the scheduled report settings was last modified

Table contained -1 rows

report_builder_schedule table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilsche_rep_ix Performance Asc reportid
repobuilsche_sav_ix Performance Asc savedsearchid
repobuilsche_use2_ix Performance Asc usermodified
repobuilsche_use_ix Performance Asc userid

report_builder_schedule table relationships

Close relationships within degrees of separation