Analytics Predictions table / analytics_predictions - Moodle LMS 3.9 Database schema / Zoola Analytics

analytics_predictions table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 11 of 11 entries

Table contained -1 rows

analytics_predictions table indexes

Search:

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

Showing 1 to 4 of 4 entries

Analytics Predictions Table Schema (analytics_predictions)

Description

analytics_predictions table columns

analytics_predictions table indexes

analytics_predictions table relationships

Close relationships within degrees of separation