Analytics Indicator Calc Table Schema (analytics_indicator_calc)


Description

Stored indicator calculations

analytics_indicator_calc table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
starttime BIGINT 19 null
endtime BIGINT 19 null
contextid BIGINT 19 null
context.id analindicalc_con2_fk R
sampleorigin VARCHAR 255
sampleid BIGINT 19 null
indicator VARCHAR 255
value DECIMAL 10,2 √ null

The calculated value, it can be null.
timecreated BIGINT 19 null

Table contained -1 rows

analytics_indicator_calc table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analindicalc_con_ix Performance Asc contextid
analindicalc_staendcon_ix Performance Asc/Asc/Asc starttime + endtime + contextid

analytics_indicator_calc table relationships

Close relationships within degrees of separation