analytics_predictions

0 rows


Description

Predictions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
analytics_prediction_actions.predictionid analpredacti_pre2_fkR
modelid BIGINT 19 null
analytics_models.id analpred_mod2_fkR
contextid BIGINT 19 null
context.id analpred_con2_fkR
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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analpred_con2_ix Performance Asc contextid
analpred_mod2_ix Performance Asc modelid
analpred_modcon2_ix Performance Asc/Asc modelid + contextid

Relationships