Analytics Predictions Table Schema (analytics_predictions)


Description

Predictions

analytics_predictions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
analytics_prediction_actions.predictionid analpredacti_pre2_fk R
modelid BIGINT 19 null
analytics_models.id analpred_mod2_fk R
contextid BIGINT 19 null
context.id analpred_con2_fk R
sampleid BIGINT 19 null
rangeindex MEDIUMINT 7 null
prediction DECIMAL 10,2 null
predictionscore DECIMAL 10,5 null
calculations LONGTEXT 2147483647 null
timecreated BIGINT 19 0
timestart BIGINT 19 √ null
timeend BIGINT 19 √ null

Table contained -1 rows

analytics_predictions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analpred_con_ix Performance Asc contextid
analpred_mod_ix Performance Asc modelid
analpred_modcon_ix Performance Asc/Asc modelid + contextid

analytics_predictions table relationships

Close relationships within degrees of separation