Analytics Models Table Schema (analytics_models)


Description

Analytic models.

analytics_models table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
analytics_models_log.modelid analmodelog_mod2_fk R
analytics_predict_samples.modelid analpredsamp_mod2_fk R
analytics_predictions.modelid analpred_mod2_fk R
analytics_train_samples.modelid analtraisamp_mod2_fk R
analytics_used_analysables.modelid analusedanal_mod2_fk R
analytics_used_files.modelid analusedfile_mod2_fk R
enabled BIT 1 0
trained BIT 1 0
name VARCHAR 1333 √ null

Explicit name of the model, the localised target name is used when left empty
target VARCHAR 255
indicators LONGTEXT 2147483647 null
timesplitting VARCHAR 255 √ null
predictionsprocessor VARCHAR 255 √ null
version BIGINT 19 null
contextids LONGTEXT 2147483647 √ null

The model will be restricted to this contexts
timecreated BIGINT 19 √ null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

analytics_models table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analmode_enatra_ix Performance Asc/Asc enabled + trained

analytics_models table relationships

Close relationships within degrees of separation