Moodle LMS 3.9 Database schema / Zoola Analytics

Columns

Search:

Table	Type	Column	Type	Size	Nulls	Default	Comments
mnet_sso_access_control	Table	accessctrl	VARCHAR	20		allow	Whether or not this user/host can login
competency_evidence	Table	action	TINYINT	3		null
block_recent_activity	Table	action	BIT	1		null	0 created, 1 updated, 2 deleted
logstore_standard_log	Table	action	VARCHAR	100
scorm_seq_rolluprule	Table	action	VARCHAR	15
grade_outcomes_history	Table	action	BIGINT	19		0	created/modified/deleted constants
log_display	Table	action	VARCHAR	40
mnet_log	Table	action	VARCHAR	40
message_conversation_actions	Table	action	BIGINT	19		null
analytics_used_files	Table	action	VARCHAR	50
enrol_flatfile	Table	action	VARCHAR	30
grade_categories_history	Table	action	BIGINT	19		0	created/modified/deleted constants
grade_grades_history	Table	action	BIGINT	19		0	created/modified/deleted constants
scorm_seq_ruleconds	Table	action	VARCHAR	25
log	Table	action	VARCHAR	40
scale_history	Table	action	BIGINT	19		0	created/modified/deleted constants
grade_items_history	Table	action	BIGINT	19		0	created/modified/deleted constants
message_user_actions	Table	action	BIGINT	19		null
analytics_used_analysables	Table	action	VARCHAR	50
analytics_prediction_actions	Table	actionname	VARCHAR	255
competency_evidence	Table	actionuserid	BIGINT	19	√	null
quizaccess_seb_quizsettings	Table	activateurlfiltering	BIT	1	√	null	Bool whether URLs will be filtered.
filter_active	Table	active	SMALLINT	5		null	Whether this filter is active in this context. +1 = On, -1 = Off, no row with this contextid = inherit. As a special case, when contextid points to the system context, -9999 means this filter is completely disabled.
grading_areas	Table	activemethod	VARCHAR	100	√	null	The default grading method (plugin) that should be used for this area
lesson	Table	activitylink	BIGINT	19		0
course_modules	Table	added	BIGINT	19		0
h5pactivity_attempts_results	Table	additionals	LONGTEXT	2147483647	√	null	Extra subcontent information in JSON format
messageinbound_messagelist	Table	address	LONGTEXT	2147483647		null	The Inbound Message address that the message was originally sent to
user	Table	address	VARCHAR	255
data	Table	addtemplate	LONGTEXT	2147483647	√	null
h5p_libraries	Table	addto	LONGTEXT	2147483647	√	null	Plugin configuration data
local_ld_import_logs_status	Table	adhoctaskid	BIGINT	19	√	null	Import logs task id
grade_categories	Table	aggregateonlygraded	BIT	1		0	aggregate only graded activities
grade_categories_history	Table	aggregateonlygraded	BIT	1		0	aggregate only graded items
grade_categories	Table	aggregateoutcomes	BIT	1		0	Aggregate outcomes
grade_categories_history	Table	aggregateoutcomes	BIT	1		0	Aggregate outcomes
grade_categories_history	Table	aggregatesubcats	BIT	1		0	This setting was removed from grade_categories. It is kept here only to preserve history.
grade_categories	Table	aggregation	BIGINT	19		0	A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)
grade_categories_history	Table	aggregation	BIGINT	19		0	A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)
grade_items_history	Table	aggregationcoef	DECIMAL	10		0.00000	Aggregation coefficient used for category weights or other aggregation types
grade_items	Table	aggregationcoef	DECIMAL	10		0.00000	Aggregation coefficient used for category weights or other aggregation types
grade_items	Table	aggregationcoef2	DECIMAL	10		0.00000	Aggregation coefficient used for weights in aggregation types with both extra credit and weight
grade_items_history	Table	aggregationcoef2	DECIMAL	10		0.00000	Aggregation coefficient used for category weights or other aggregation types
grade_grades	Table	aggregationstatus	VARCHAR	10		unknown	One of several values describing how this grade_grade was used when calculating the aggregation. Possible values are "unknown", "dropped", "novalue", "used"
grade_grades	Table	aggregationweight	DECIMAL	10	√	null	If the aggregationstatus == 'included', then this is the percent this item contributed to the aggregation.
tool_policy_versions	Table	agreementstyle	SMALLINT	5		0	How this agreement should flow: 0 - on the consent page, 1 - on a separate page before reaching the consent page.
question_response_analysis	Table	aid	VARCHAR	100	√	null
user	Table	aim	VARCHAR	50
glossary_alias	Table	alias	VARCHAR	255
quiz_statistics	Table	allattemptsavg	DECIMAL	15	√	null

Showing 1 to 50 of 4,147 entries