Report Builder Preproc Track Table Schema (report_builder_preproc_track)


Description

Stores which items have been preprocessed and when, to avoid processing unchanged items

report_builder_preproc_track table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
groupid BIGINT 19 null
report_builder_group.id repobuilpreptrac_gro2_fk R

ID of the group the item belongs to
itemid VARCHAR 255

ID of the item that has been processed
lastchecked BIGINT 19 null

Timestamp of when the item was last checked
disabled SMALLINT 5 0

If none zero, the item is disabled, so will no longer be processed. This is used to prevent repeatedly attempting to process items which have a problem.

Table contained -1 rows

report_builder_preproc_track table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilpreptrac_gro_ix Performance Asc groupid
repobuilpreptrac_groite_uix Must be unique Asc/Asc groupid + itemid

report_builder_preproc_track table relationships

Close relationships within degrees of separation