Analytics Models Table Schema (analytics_models)


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