moodle_401 Database

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Default	Comments
mnet_sso_access_control	Table	accessctrl	VARCHAR	20		allow	Whether or not this user/host can login
enrol_lti_app_registration	Table	accesstokenurl	LONGTEXT	2147483647	√	null
payments	Table	accountid	BIGINT	19		null
payment_gateways	Table	accountid	BIGINT	19		null
message_conversation_actions	Table	action	BIGINT	19		null
competency_evidence	Table	action	TINYINT	3		null
analytics_used_files	Table	action	VARCHAR	50
analytics_used_analysables	Table	action	VARCHAR	50
logstore_standard_log	Table	action	VARCHAR	100
grade_grades_history	Table	action	BIGINT	19		0	created/modified/deleted constants
scorm_seq_rolluprule	Table	action	VARCHAR	15
grade_items_history	Table	action	BIGINT	19		0	created/modified/deleted constants
scorm_seq_ruleconds	Table	action	VARCHAR	25
enrol_flatfile	Table	action	VARCHAR	30
mnet_log	Table	action	VARCHAR	40
grade_outcomes_history	Table	action	BIGINT	19		0	created/modified/deleted constants
log	Table	action	VARCHAR	40
block_recent_activity	Table	action	BIT	1		null	0 created, 1 updated, 2 deleted
message_user_actions	Table	action	BIGINT	19		null
log_display	Table	action	VARCHAR	40
scale_history	Table	action	BIGINT	19		0	created/modified/deleted constants
grade_categories_history	Table	action	BIGINT	19		0	created/modified/deleted constants
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
tool_brickfield_summary	Table	activities	BIGINT	19	√	null
tool_brickfield_summary	Table	activitiesfailed	BIGINT	19	√	null
tool_brickfield_summary	Table	activitiespassed	BIGINT	19	√	null
assign	Table	activity	LONGTEXT	2147483647	√	null
assign	Table	activityformat	SMALLINT	5		0
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
user	Table	address	VARCHAR	255
messageinbound_messagelist	Table	address	LONGTEXT	2147483647		null	The Inbound Message address that the message was originally sent to
data	Table	addtemplate	LONGTEXT	2147483647	√	null
h5p_libraries	Table	addto	LONGTEXT	2147483647	√	null	Plugin configuration data
adminpresets_app_it_a	Table	adminpresetapplyid	BIGINT	19		null
adminpresets_app_it	Table	adminpresetapplyid	BIGINT	19		null
adminpresets_app_plug	Table	adminpresetapplyid	BIGINT	19		null
adminpresets_app	Table	adminpresetid	BIGINT	19		null
adminpresets_plug	Table	adminpresetid	BIGINT	19		null
adminpresets_it	Table	adminpresetid	BIGINT	19		null
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_history	Table	aggregateoutcomes	BIT	1		0	Aggregate outcomes
grade_categories	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.

Showing 1 to 50 of 4,333 entries