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 1 √ 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

Close relationships within degrees of separation