Report Builder Cache Table Schema (report_builder_cache)


Description

Storing details of scheduled reports caching

report_builder_cache table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
reportid BIGINT 19 null
report_builder.id repobuilcach_rep2_fk R
cachetable VARCHAR 255 null

Table name with cached data for report

frequency BIGINT 19 null
schedule BIGINT 19 null
lastreport BIGINT 19 null
nextreport BIGINT 19 null
queryhash VARCHAR 40 null
changed BIT 0 null
genstart BIGINT 19 null

Table contained -1 rows

report_builder_cache table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilcach_nex_ix Performance Asc nextreport
repobuilcach_rep_ix Performance Asc reportid

report_builder_cache table relationships