Analytics Used Analysables Table Schema (analytics_used_analysables)


Description

List of analysables used by each model

analytics_used_analysables table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
modelid BIGINT 19 null
analytics_models.id analusedanal_mod2_fk R
action VARCHAR 50
analysableid BIGINT 19 null
firstanalysis BIGINT 19 null
timeanalysed BIGINT 19 null

Table contained -1 rows

analytics_used_analysables table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analusedanal_ana_ix Performance Asc analysableid
analusedanal_mod_ix Performance Asc modelid
analusedanal_modact_ix Performance Asc/Asc modelid + action

analytics_used_analysables table relationships

Close relationships within degrees of separation