Recent
There are no recent tables.
Favorites
There are no favorite tables.
New
information_schema
moodle
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: moodle
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
userid
name
comments
site
author
moodleversion
moodlerelease
iscore
timecreated
timeimported
*
id
adminpresetid
userid
time
*
id
adminpresetapplyid
configlogid
*
id
adminpresetapplyid
configlogid
itemname
*
id
adminpresetapplyid
plugin
name
value
oldvalue
*
id
adminpresetid
plugin
name
value
*
id
itemid
name
value
*
id
adminpresetid
plugin
name
enabled
*
id
prompt
numberimages
quality
aspectratio
style
sourceurl
revisedprompt
*
id
prompt
responseid
fingerprint
generatedcontent
finishreason
prompttokens
completiontoken
*
id
actionname
actionid
success
userid
contextid
provider
errorcode
errormessage
timecreated
timecompleted
*
id
prompt
responseid
fingerprint
generatedcontent
finishreason
prompttokens
completiontoken
*
id
userid
contextid
timeaccepted
*
id
starttime
endtime
contextid
sampleorigin
sampleid
indicator
value
timecreated
*
id
enabled
trained
name
target
indicators
timesplitting
predictionsprocessor
version
contextids
timecreated
timemodified
usermodified
*
id
modelid
version
evaluationmode
target
indicators
timesplitting
score
info
dir
timecreated
usermodified
*
id
modelid
contextid
sampleid
rangeindex
prediction
predictionscore
calculations
timecreated
timestart
timeend
*
id
predictionid
userid
actionname
timecreated
*
id
modelid
analysableid
timesplitting
rangeindex
sampleids
timecreated
timemodified
*
id
modelid
analysableid
timesplitting
sampleids
timecreated
*
id
modelid
action
analysableid
firstanalysis
timeanalysed
*
id
modelid
fileid
action
time
*
id
course
name
intro
introformat
alwaysshowdescription
nosubmissions
submissiondrafts
sendnotifications
sendlatenotifications
duedate
allowsubmissionsfromdate
grade
timemodified
requiresubmissionstatement
completionsubmit
cutoffdate
gradingduedate
teamsubmission
requireallteammemberssubmit
teamsubmissiongroupingid
blindmarking
hidegrader
revealidentities
attemptreopenmethod
maxattempts
markingworkflow
markingallocation
markinganonymous
sendstudentnotifications
preventsubmissionnotingroup
activity
activityformat
timelimit
submissionattachments
*
id
assignment
grade
commenttext
commentformat
*
id
gradeid
pageno
x
y
endx
endy
path
type
colour
draft
*
id
gradeid
x
y
width
rawtext
pageno
colour
draft
*
id
userid
rawtext
width
colour
*
id
gradeid
pageno
pathnamehash
isrotated
degree
*
id
assignment
grade
numfiles
*
id
assignment
submission
numfiles
*
id
assignment
submission
onlinetext
onlineformat
*
id
assignment
userid
timecreated
timemodified
grader
grade
attemptnumber
*
id
assignid
groupid
userid
sortorder
allowsubmissionsfromdate
duedate
cutoffdate
timelimit
*
id
assignment
plugin
subtype
name
value
*
id
assignment
userid
timecreated
timemodified
timestarted
status
groupid
attemptnumber
latest
*
id
userid
assignment
locked
mailed
extensionduedate
workflowstate
allocatedmarker
*
id
assignment
userid
*
id
userid
issuer
issuer256
sub
sub256
timecreated
timemodified
*
id
timecreated
timemodified
usermodified
userid
issuerid
username
email
confirmtoken
confirmtokenexpires
*
id
backupid
operation
type
itemid
format
interactive
purpose
userid
status
execution
executiontime
checksum
timecreated
timemodified
progress
controller
*
id
courseid
laststarttime
lastendtime
laststatus
nextstarttime
*
id
backupid
loglevel
message
timecreated
*
id
name
description
timecreated
timemodified
usercreated
usermodified
issuername
issuerurl
issuercontact
expiredate
expireperiod
type
courseid
message
messagesubject
attachment
notification
status
nextcron
version
language
imageauthorname
imageauthoremail
imageauthorurl
imagecaption
*
id
badgeid
targetname
targeturl
targetdescription
targetframework
targetcode
*
id
userid
email
backpackuid
autosync
password
externalbackpackid
*
id
usermodified
timecreated
timemodified
userid
issuerid
externalbackpackid
token
refreshtoken
expires
scope
*
id
badgeid
criteriatype
method
description
descriptionformat
*
id
issuedid
critid
userid
datemet
*
id
critid
name
value
*
id
badgeid
issuername
issuerurl
issueremail
claimid
claimcomment
dateissued
*
id
backpackid
collectionid
entityid
assertion
*
id
backpackapiurl
backpackweburl
apiversion
sortorder
oauth2_issuerid
*
id
sitebackpackid
internalid
externalid
type
*
id
badgeid
userid
uniquehash
dateissued
dateexpire
visible
issuernotified
*
id
badgeid
recipientid
issuerid
issuerrole
datemet
*
id
badgeid
relatedbadgeid
*
id
type
course
name
intro
introformat
meetingid
moderatorpass
viewerpass
wait
record
recordallfromstart
recordhidebutton
welcome
voicebridge
openingtime
closingtime
timecreated
timemodified
presentation
participants
userlimit
recordings_html
recordings_deleted
recordings_imported
recordings_preview
clienttype
muteonstart
disablecam
disablemic
disableprivatechat
disablepublicchat
disablenote
hideuserlist
completionattendance
completionengagementchats
completionengagementtalks
completionengagementraisehand
completionengagementpollvotes
completionengagementemojis
guestallowed
mustapproveuser
guestlinkuid
guestpassword
showpresentation
*
id
courseid
bigbluebuttonbnid
userid
timecreated
meetingid
log
meta
*
id
courseid
bigbluebuttonbnid
groupid
recordingid
headless
imported
status
importeddata
timecreated
usermodified
timemodified
*
id
name
cron
lastcron
visible
*
id
blockname
parentcontextid
showinsubcontexts
requiredbytheme
pagetypepattern
subpagepattern
defaultregion
defaultweight
configdata
timecreated
timemodified
*
id
courseid
userid
progress
timecreated
timemodified
*
id
blockinstanceid
contextid
pagetype
subpage
visible
region
weight
*
id
courseid
cmid
userid
timeaccess
*
id
courseid
cmid
timecreated
userid
action
modname
*
id
userid
title
preferredtitle
description
shared
url
skiptime
skipuntil
*
id
courseid
userid
xp
lvl
*
id
courseid
enabled
levels
lastlogpurge
enablecheatguard
enableladder
enableinfos
levelsdata
enablelevelupnotif
enablecustomlevelbadges
maxactionspertime
timeformaxactions
timebetweensameactions
identitymode
rankmode
neighbours
defaultfilters
laddercols
instructions
instructions_format
blocktitle
blockdescription
blockrecentactivity
blockrankingsnapshot
*
id
courseid
category
ruledata
points
sortorder
*
id
courseid
userid
eventname
xp
time
*
id
contextid
childcontextid
points
type
filter
filtercourseid
filtercmid
filterint1
filterchar1
*
id
contextid
blogid
*
id
userid
name
description
url
filtertags
failedlastsync
timemodified
timefetched
*
id
course
name
intro
introformat
numbering
navstyle
customtitles
revision
timecreated
timemodified
*
id
bookid
pagenum
subchapter
title
content
contentformat
hidden
timecreated
timemodified
importsrc
*
id
filter
version
md5key
rawtext
timemodified
*
id
flagtype
name
timemodified
value
expiry
*
id
name
captype
contextlevel
component
riskbitmask
*
id
course
name
intro
introformat
keepdays
studentlogs
chattime
schedule
timemodified
*
id
chatid
userid
groupid
issystem
message
timestamp
*
id
chatid
userid
groupid
issystem
message
timestamp
*
id
chatid
userid
groupid
version
ip
firstping
lastping
lastmessageping
sid
course
lang
*
id
course
name
intro
introformat
publish
showresults
display
allowupdate
allowmultiple
showunanswered
includeinactive
limitanswers
timeopen
timeclose
showpreview
timemodified
completionsubmit
showavailable
*
id
choiceid
userid
optionid
timemodified
*
id
choiceid
text
maxanswers
timemodified
*
id
contextid
name
idnumber
description
descriptionformat
visible
component
timecreated
timemodified
theme
*
id
cohortid
userid
timeadded
*
id
contextid
component
commentarea
itemid
content
format
userid
timecreated
*
id
contextid
instanceid
component
instancetype
provider
roomname
avatarfilename
active
avatarsynced
*
id
commid
url
*
id
commid
userid
synced
deleted
*
id
shortname
description
descriptionformat
idnumber
competencyframeworkid
parentid
path
sortorder
ruletype
ruleoutcome
ruleconfig
scaleid
scaleconfiguration
timecreated
timemodified
usermodified
*
id
courseid
competencyid
ruleoutcome
timecreated
timemodified
usermodified
sortorder
*
id
courseid
pushratingstouserplans
timecreated
timemodified
usermodified
*
id
usercompetencyid
contextid
action
actionuserid
descidentifier
desccomponent
desca
url
grade
note
timecreated
timemodified
usermodified
*
id
shortname
contextid
idnumber
description
descriptionformat
scaleid
scaleconfiguration
visible
taxonomies
timecreated
timemodified
usermodified
*
id
cmid
timecreated
timemodified
usermodified
sortorder
competencyid
ruleoutcome
overridegrade
*
id
name
description
descriptionformat
userid
templateid
origtemplateid
status
duedate
reviewerid
timecreated
timemodified
usermodified
*
id
planid
competencyid
sortorder
timecreated
timemodified
usermodified
*
id
competencyid
relatedcompetencyid
timecreated
timemodified
usermodified
*
id
shortname
contextid
description
descriptionformat
visible
duedate
timecreated
timemodified
usermodified
*
id
templateid
cohortid
timecreated
timemodified
usermodified
*
id
templateid
competencyid
timecreated
timemodified
usermodified
sortorder
*
id
userid
competencyid
status
reviewerid
proficiency
grade
timecreated
timemodified
usermodified
*
id
userid
courseid
competencyid
proficiency
grade
timecreated
timemodified
usermodified
*
id
userid
competencyid
planid
proficiency
grade
sortorder
timecreated
timemodified
usermodified
*
id
userid
name
description
descriptionformat
url
timecreated
timemodified
usermodified
*
id
userevidenceid
competencyid
timecreated
timemodified
usermodified
*
id
name
value
*
id
userid
timemodified
plugin
name
value
oldvalue
*
id
plugin
name
value
*
id
name
contenttype
contextid
visibility
instanceid
configdata
usercreated
usermodified
timecreated
timemodified
*
id
contextlevel
instanceid
path
depth
locked
*
id
path
depth
locked
*
id
category
sortorder
fullname
shortname
idnumber
summary
summaryformat
format
showgrades
newsitems
startdate
enddate
relativedatesmode
marker
maxbytes
legacyfiles
showreports
visible
visibleold
downloadcontent
groupmode
groupmodeforce
defaultgroupingid
lang
calendartype
theme
timecreated
timemodified
requested
enablecompletion
completionnotify
cacherev
originalcourseid
showactivitydates
showcompletionconditions
pdfexportfont
*
id
name
idnumber
description
descriptionformat
parent
sortorder
coursecount
visible
visibleold
timemodified
depth
path
theme
*
id
userid
course
timeenrolled
timestarted
timecompleted
reaggregate
*
id
course
criteriatype
method
value
*
id
course
criteriatype
module
moduleinstance
courseinstance
enrolperiod
timeend
gradepass
role
*
id
userid
course
criteriaid
gradefinal
unenroled
timecompleted
*
id
course
module
completion
completionview
completionusegrade
completionpassgrade
completionexpected
customrules
*
id
courseid
format
sectionid
name
value
*
id
course
module
instance
section
idnumber
added
score
indent
visible
visibleoncoursepage
visibleold
groupmode
groupingid
completion
completiongradeitemnumber
completionview
completionexpected
completionpassgrade
showdescription
availability
deletioninprogress
downloadcontent
lang
*
id
coursemoduleid
userid
completionstate
overrideby
timemodified
*
id
coursemoduleid
userid
timecreated
*
id
huburl
courseid
timepublished
enrollable
hubcourseid
status
timechecked
*
id
fullname
shortname
summary
summaryformat
category
reason
requester
password
*
id
course
section
name
summary
summaryformat
sequence
visible
availability
component
itemid
timemodified
*
id
name
description
descriptionformat
sortorder
timecreated
timemodified
component
area
itemid
contextid
*
id
fieldid
instanceid
intvalue
decvalue
shortcharvalue
charvalue
value
valueformat
valuetrust
timecreated
timemodified
contextid
*
id
shortname
name
type
description
descriptionformat
sortorder
categoryid
configdata
timecreated
timemodified
*
id
course
name
intro
introformat
comments
timeavailablefrom
timeavailableto
timeviewfrom
timeviewto
requiredentries
requiredentriestoview
maxentries
rssarticles
singletemplate
listtemplate
listtemplateheader
listtemplatefooter
addtemplate
rsstemplate
rsstitletemplate
csstemplate
jstemplate
asearchtemplate
approval
manageapproved
scale
assessed
assesstimestart
assesstimefinish
defaultsort
defaultsortdir
editany
notification
timemodified
config
completionentries
*
id
fieldid
recordid
content
content1
content2
content3
content4
*
id
dataid
type
name
description
required
param1
param2
param3
param4
param5
param6
param7
param8
param9
param10
*
id
userid
groupid
dataid
timecreated
timemodified
approved
*
id
elementid
contextid
pagehash
userid
drafttext
draftid
pageinstance
timemodified
*
id
enrol
status
courseid
sortorder
name
enrolperiod
enrolstartdate
enrolenddate
expirynotify
expirythreshold
notifyall
password
cost
currency
roleid
customint1
customint2
customint3
customint4
customint5
customint6
customint7
customint8
customchar1
customchar2
customchar3
customdec1
customdec2
customtext1
customtext2
customtext3
customtext4
timecreated
timemodified
*
id
action
roleid
userid
courseid
timestart
timeend
timemodified
*
id
name
platformid
clientid
uniqueid
platformclienthash
platformuniqueidhash
authenticationrequesturl
jwksurl
accesstokenurl
status
timecreated
timemodified
*
id
contextid
ltideploymentid
type
timecreated
timemodified
*
id
name
deploymentid
platformid
legacyconsumerkey
timecreated
timemodified
*
id
name
consumerkey256
consumerkey
secret
ltiversion
consumername
consumerversion
consumerguid
profile
toolproxy
settings
protected
enabled
enablefrom
enableuntil
lastaccess
created
updated
*
id
consumerid
lticontextkey
type
settings
created
updated
*
id
consumerid
value
expires
*
id
contextid
consumerid
ltiresourcelinkkey
settings
primaryresourcelinkid
shareapproved
created
updated
*
id
sharekey
resourcelinkid
autoapprove
expires
*
id
toolproxykey
consumerid
toolproxy
created
updated
*
id
resourcelinkid
ltiuserkey
ltiresultsourcedid
created
updated
*
id
resourcelinkid
ltideploymentid
resourceid
lticontextid
lineitemsservice
lineitemservice
lineitemscope
resultscope
scorescope
contextmembershipsurl
nrpsserviceversions
timecreated
timemodified
*
id
enrolid
contextid
ltiversion
institution
lang
timezone
maxenrolled
maildisplay
city
country
gradesync
gradesynccompletion
membersync
membersyncmode
roleinstructor
rolelearner
secret
uuid
provisioningmodelearner
provisioningmodeinstructor
timecreated
timemodified
*
id
toolid
consumerid
*
id
userid
toolid
serviceurl
sourceid
ltideploymentid
consumerkey
consumersecret
membershipsurl
membershipsid
lastgrade
lastaccess
timecreated
*
id
ltiuserid
resourcelinkid
*
id
business
receiver_email
receiver_id
item_name
courseid
userid
instanceid
memo
tax
option_name1
option_selection1_x
option_name2
option_selection2_x
payment_status
pending_reason
reason_code
txn_id
parent_txn_id
payment_type
timeupdated
*
id
name
description
format
categoryid
courseid
groupid
userid
repeatid
component
modulename
instance
type
eventtype
timestart
timeduration
timesort
visible
uuid
sequence
timemodified
subscriptionid
priority
location
*
id
eventname
component
handlerfile
handlerfunction
schedule
status
internal
*
id
eventdata
stackdump
userid
timecreated
*
id
queuedeventid
handlerid
status
errormessage
timemodified
*
id
url
categoryid
courseid
groupid
userid
eventtype
pollinterval
lastupdated
name
*
id
name
classname
methodname
classpath
component
capabilities
services
*
id
name
enabled
requiredcapability
restrictedusers
component
timecreated
timemodified
shortname
downloadfiles
uploadfiles
*
id
externalserviceid
functionname
*
id
externalserviceid
userid
iprestriction
validuntil
timecreated
*
id
token
privatetoken
tokentype
userid
externalserviceid
sid
contextid
creatorid
iprestriction
validuntil
timecreated
lastaccess
name
*
id
component
itemtype
itemid
contextid
userid
ordering
timecreated
timemodified
*
id
course
name
intro
introformat
anonymous
email_notification
multiple_submit
autonumbering
site_after_submit
page_after_submit
page_after_submitformat
publish_stats
timeopen
timeclose
timemodified
completionsubmit
*
id
feedback
userid
timemodified
random_response
anonymous_response
courseid
*
id
feedback
userid
guestid
timemodified
random_response
anonymous_response
courseid
*
id
feedback
template
name
label
presentation
typ
hasvalue
position
required
dependitem
dependvalue
options
*
id
feedbackid
courseid
*
id
course
ispublic
name
*
id
course_id
item
completed
tmp_completed
value
*
id
course_id
item
completed
tmp_completed
value
*
id
contenthash
pathnamehash
contextid
component
filearea
itemid
filepath
filename
userid
filesize
mimetype
status
source
author
license
timecreated
timemodified
sortorder
referencefileid
*
id
repositoryid
lastsync
reference
referencehash
*
id
usermodified
timecreated
timemodified
sourcefileid
targetformat
status
statusmessage
converter
destfileid
data
*
id
filter
contextid
active
sortorder
*
id
filter
contextid
name
value
*
id
course
name
intro
introformat
revision
timemodified
display
showexpanded
showdownloadfolder
forcedownload
*
id
course
type
name
intro
introformat
duedate
cutoffdate
assessed
assesstimestart
assesstimefinish
scale
grade_forum
grade_forum_notify
maxbytes
maxattachments
forcesubscribe
trackingtype
rsstype
rssarticles
timemodified
warnafter
blockafter
blockperiod
completiondiscussions
completionreplies
completionposts
displaywordcount
lockdiscussionafter
*
id
userid
forum
maildigest
*
id
course
forum
name
firstpost
userid
groupid
assessed
timemodified
usermodified
timestart
timeend
pinned
timelocked
*
id
forum
userid
discussion
preference
*
id
forum
itemnumber
userid
grade
timecreated
timemodified
*
id
discussion
parent
userid
created
modified
mailed
subject
message
messageformat
messagetrust
attachment
totalscore
mailnow
deleted
privatereplyto
wordcount
charcount
*
id
userid
discussionid
postid
timemodified
*
id
userid
forumid
discussionid
postid
firstread
lastread
*
id
userid
forum
*
id
userid
forumid
*
id
course
name
intro
introformat
allowduplicatedentries
displayformat
mainglossary
showspecial
showalphabet
showall
allowcomments
allowprintview
usedynalink
defaultapproval
approvaldisplayformat
globalglossary
entbypage
editalways
rsstype
rssarticles
assessed
assesstimestart
assesstimefinish
scale
timecreated
timemodified
completionentries
*
id
entryid
alias
*
id
glossaryid
name
usedynalink
*
id
glossaryid
userid
concept
definition
definitionformat
definitiontrust
attachment
timecreated
timemodified
teacherentry
sourceglossaryid
usedynalink
casesensitive
fullmatch
approved
*
id
categoryid
entryid
*
id
name
popupformatname
visible
showgroup
showtabs
defaultmode
defaulthook
sortkey
sortorder
*
id
courseid
parent
depth
path
fullname
aggregation
keephigh
droplow
aggregateonlygraded
aggregateoutcomes
timecreated
timemodified
hidden
*
id
action
oldid
source
timemodified
loggeduser
courseid
parent
depth
path
fullname
aggregation
keephigh
droplow
aggregateonlygraded
aggregateoutcomes
aggregatesubcats
hidden
*
id
itemid
userid
rawgrade
rawgrademax
rawgrademin
rawscaleid
usermodified
finalgrade
hidden
locked
locktime
exported
overridden
excluded
feedback
feedbackformat
information
informationformat
timecreated
timemodified
aggregationstatus
aggregationweight
*
id
action
oldid
source
timemodified
loggeduser
itemid
userid
rawgrade
rawgrademax
rawgrademin
rawscaleid
usermodified
finalgrade
hidden
locked
locktime
exported
overridden
excluded
feedback
feedbackformat
information
informationformat
*
id
itemname
importcode
importer
*
id
itemid
newgradeitem
userid
finalgrade
feedback
importcode
importer
importonlyfeedback
*
id
courseid
categoryid
itemname
itemtype
itemmodule
iteminstance
itemnumber
iteminfo
idnumber
calculation
gradetype
grademax
grademin
scaleid
outcomeid
gradepass
multfactor
plusfactor
aggregationcoef
aggregationcoef2
sortorder
display
decimals
hidden
locked
locktime
needsupdate
weightoverride
timecreated
timemodified
*
id
action
oldid
source
timemodified
loggeduser
courseid
categoryid
itemname
itemtype
itemmodule
iteminstance
itemnumber
iteminfo
idnumber
calculation
gradetype
grademax
grademin
scaleid
outcomeid
gradepass
multfactor
plusfactor
aggregationcoef
aggregationcoef2
sortorder
hidden
locked
locktime
needsupdate
display
decimals
weightoverride
*
id
contextid
lowerboundary
letter
*
id
courseid
shortname
fullname
scaleid
description
descriptionformat
timecreated
timemodified
usermodified
*
id
courseid
outcomeid
*
id
action
oldid
source
timemodified
loggeduser
courseid
shortname
fullname
scaleid
description
descriptionformat
*
id
courseid
name
value
*
id
definitionid
sortorder
description
descriptionformat
*
id
definitionid
sortorder
shortname
description
descriptionformat
descriptionmarkers
descriptionmarkersformat
maxscore
*
id
instanceid
criterionid
remark
remarkformat
score
*
id
definitionid
sortorder
description
descriptionformat
*
id
instanceid
criterionid
levelid
remark
remarkformat
*
id
criterionid
score
definition
definitionformat
*
id
contextid
component
areaname
activemethod
*
id
areaid
method
name
description
descriptionformat
status
copiedfromid
timecreated
usercreated
timemodified
usermodified
timecopied
options
*
id
definitionid
raterid
itemid
rawgrade
status
feedback
feedbackformat
timemodified
*
id
courseid
name
idnumber
description
descriptionformat
configdata
timecreated
timemodified
*
id
groupingid
groupid
timeadded
*
id
courseid
idnumber
name
description
descriptionformat
enrolmentkey
picture
visibility
participation
timecreated
timemodified
*
id
groupid
userid
timeadded
component
itemid
*
id
jsoncontent
mainlibraryid
displayoptions
pathnamehash
contenthash
filtered
timecreated
timemodified
*
id
course
name
timecreated
timemodified
intro
introformat
grade
displayoptions
enabletracking
grademethod
reviewmode
*
id
h5pactivityid
userid
timecreated
timemodified
attempt
rawscore
maxscore
scaled
duration
completion
success
*
id
attemptid
subcontent
timecreated
interactiontype
description
correctpattern
response
additionals
rawscore
maxscore
duration
completion
success
*
id
h5pid
libraryid
dependencytype
dropcss
weight
*
id
machinename
title
majorversion
minorversion
patchversion
runnable
fullscreen
embedtypes
preloadedjs
preloadedcss
droplibrarycss
semantics
addto
coremajor
coreminor
metadatasettings
tutorial
example
enabled
*
id
libraryid
hash
*
id
libraryid
requiredlibraryid
dependencytype
*
id
course
name
intro
introformat
json_content
embed_type
disable
main_library_id
content_type
authors
source
year_from
year_to
license
license_version
changes
license_extras
author_comments
default_language
filtered
slug
timecreated
timemodified
completionpass
shared
synced
hub_id
a11y_title
*
id
user_id
created_at
secret
*
id
hvp_id
library_id
dependency_type
drop_css
weight
*
id
language
json
last_checked
*
id
user_id
hvp_id
sub_content_id
data_id
data
preloaded
delete_on_content_change
*
id
type
library_name
library_version
num
*
id
user_id
created_at
type
sub_type
content_id
content_title
library_name
library_version
*
id
machine_name
title
major_version
minor_version
patch_version
runnable
fullscreen
embed_types
preloaded_js
preloaded_css
drop_library_css
semantics
restricted
tutorial_url
has_icon
add_to
metadata_settings
*
id
library_id
hash
*
id
machine_name
major_version
minor_version
patch_version
h5p_major_version
h5p_minor_version
title
summary
description
icon
created_at
updated_at
is_recommended
popularity
screenshots
license
example
tutorial
keywords
categories
owner
*
id
library_id
language_code
language_json
*
id
library_id
required_library_id
dependency_type
*
id
*
id
content_id
user_id
parent_id
interaction_type
description
correct_responses_pattern
response
additionals
raw_score
max_score
*
id
course
name
intro
introformat
revision
keepold
structure
timemodified
*
id
filename
quarantinedfile
userid
reason
timecreated
*
id
course
name
intro
introformat
timemodified
*
id
course
name
intro
introformat
practice
modattempts
usepassword
password
dependency
conditions
grade
custom
ongoing
usemaxgrade
maxanswers
maxattempts
review
nextpagedefault
feedback
minquestions
maxpages
timelimit
retake
activitylink
mediafile
mediaheight
mediawidth
mediaclose
slideshow
width
height
bgcolor
displayleft
displayleftif
progressbar
available
deadline
timemodified
completionendreached
completiontimespent
allowofflineattempts
*
id
lessonid
pageid
jumpto
grade
score
flags
timecreated
timemodified
answer
answerformat
response
responseformat
*
id
lessonid
pageid
userid
answerid
retry
correct
useranswer
timeseen
*
id
lessonid
userid
pageid
retry
flag
timeseen
nextpageid
*
id
lessonid
userid
grade
late
completed
*
id
lessonid
groupid
userid
available
deadline
timelimit
review
maxattempts
retake
password
*
id
lessonid
prevpageid
nextpageid
qtype
qoption
layout
display
timecreated
timemodified
title
contents
contentsformat
*
id
lessonid
userid
starttime
lessontime
completed
timemodifiedoffline
*
id
shortname
fullname
source
enabled
version
custom
sortorder
*
id
resourcekey
expires
owner
*
id
time
userid
ip
course
module
cmid
action
url
info
*
id
eventname
component
action
target
objecttable
objectid
crud
edulevel
contextid
contextlevel
contextinstanceid
userid
courseid
relateduserid
anonymous
other
timecreated
origin
ip
realuserid
*
id
module
action
mtable
field
component
*
id
qtype
sqltext
sqlparams
error
info
backtrace
exectime
timelogged
*
id
course
name
intro
introformat
timecreated
timemodified
typeid
toolurl
securetoolurl
instructorchoicesendname
instructorchoicesendemailaddr
instructorchoiceallowroster
instructorchoiceallowsetting
instructorcustomparameters
instructorchoiceacceptgrades
grade
launchcontainer
resourcekey
password
debuglaunch
showtitlelaunch
showdescriptionlaunch
servicesalt
icon
secureicon
*
id
gradeitemid
courseid
toolproxyid
typeid
baseurl
ltilinkid
resourceid
tag
subreviewurl
subreviewparams
*
id
typeid
scope
token
validuntil
timecreated
lastaccess
*
id
typeid
courseid
coursevisible
*
id
ltiid
userid
datesubmitted
dateupdated
gradepercent
originalgrade
launchid
state
*
id
name
regurl
state
guid
secret
vendorcode
capabilityoffered
serviceoffered
toolproxy
createdby
timecreated
timemodified
*
id
toolproxyid
typeid
course
coursemoduleid
settings
timecreated
timemodified
*
id
name
baseurl
tooldomain
state
course
coursevisible
ltiversion
clientid
toolproxyid
enabledcapability
parameter
icon
secureicon
createdby
timecreated
timemodified
description
*
id
typeid
categoryid
*
id
typeid
name
value
*
id
commid
roomid
topic
*
id
useridfrom
useridto
subject
fullmessage
fullmessageformat
fullmessagehtml
smallmessage
notification
contexturl
contexturlname
timecreated
timeuserfromdeleted
timeusertodeleted
component
eventtype
customdata
*
id
handler
datavalue
datakey
timecreated
expires
*
id
component
classname
defaultexpiration
validateaddress
enabled
*
id
messageid
userid
address
timecreated
*
id
useridfrom
conversationid
subject
fullmessage
fullmessageformat
fullmessagehtml
smallmessage
timecreated
fullmessagetrust
customdata
*
id
userdeviceid
enable
*
id
userid
contactid
timecreated
*
id
userid
requesteduserid
timecreated
*
id
type
name
convhash
component
itemtype
itemid
contextid
enabled
timecreated
timemodified
*
id
userid
conversationid
action
timecreated
*
id
conversationid
userid
timecreated
*
id
useridto
conversationid
messageid
*
id
messageid
isread
*
id
notificationid
*
id
name
enabled
*
id
name
component
capability
*
id
useridfrom
useridto
subject
fullmessage
fullmessageformat
fullmessagehtml
smallmessage
notification
contexturl
contexturlname
timecreated
timeread
timeuserfromdeleted
timeusertodeleted
component
eventtype
*
id
userid
blockeduserid
timecreated
*
id
userid
messageid
action
timecreated
*
id
hostid
remoteid
categoryid
categoryname
sortorder
fullname
shortname
idnumber
summary
summaryformat
startdate
roleid
rolename
*
id
hostid
userid
remotecourseid
rolename
enroltime
enroltype
*
id
name
display_name
xmlrpc_server_url
sso_land_url
sso_jump_url
*
id
deleted
wwwroot
ip_address
name
public_key
public_key_expires
transport
portno
last_connect_time
last_log_id
force_theme
theme
applicationid
sslverification
*
id
hostid
serviceid
publish
subscribe
*
id
hostid
remoteid
time
userid
ip
course
coursename
module
cmid
action
url
info
*
id
functionname
xmlrpcpath
plugintype
pluginname
enabled
*
id
serviceid
rpcid
*
id
functionname
xmlrpcpath
plugintype
pluginname
enabled
help
profile
filename
classname
static
*
id
name
description
apiversion
offer
*
id
serviceid
rpcid
*
id
userid
username
token
mnethostid
useragent
confirm_timeout
session_id
expires
*
id
username
mnet_host_id
accessctrl
*
id
name
cron
lastcron
search
visible
*
id
type
courseid
cmid
userid
timecreated
resourceurl
status
*
id
userid
name
private
sortorder
*
id
useridfrom
useridto
subject
fullmessage
fullmessageformat
fullmessagehtml
smallmessage
component
eventtype
contexturl
contexturlname
timeread
timecreated
customdata
*
id
timecreated
timemodified
usermodified
issuerid
token
expires
scope
*
id
timecreated
timemodified
usermodified
name
url
issuerid
*
id
timecreated
timemodified
usermodified
name
image
baseurl
clientid
clientsecret
loginscopes
loginscopesoffline
loginparams
loginparamsoffline
alloweddomains
scopessupported
enabled
showonloginpage
basicauth
sortorder
requireconfirmation
servicetype
loginpagename
systememail
*
id
timecreated
timemodified
userid
issuerid
token
scopehash
*
id
timecreated
timemodified
usermodified
issuerid
refreshtoken
grantedscopes
email
username
*
id
timemodified
timecreated
usermodified
issuerid
externalfield
internalfield
*
id
course
name
intro
introformat
content
contentformat
legacyfiles
legacyfileslast
display
displayoptions
revision
timemodified
*
id
paymentid
pp_orderid
*
id
component
paymentarea
itemid
userid
amount
currency
accountid
gateway
timecreated
timemodified
*
id
name
idnumber
contextid
enabled
archived
timecreated
timemodified
*
id
accountid
gateway
enabled
config
timecreated
timemodified
*
id
plugin
name
visible
*
id
instance
name
value
*
id
instance
userid
name
value
*
id
userid
time
portfolio
caller_class
caller_file
caller_component
caller_sha1
tempdataid
returnurl
continueurl
*
id
transferid
token
*
id
data
expirytime
userid
instance
queued
*
id
module
userid
courseid
groupid
moduleid
coursemoduleid
subject
summary
content
uniquehash
rating
format
summaryformat
attachment
publishstate
lastmodified
created
usermodified
*
id
runid
url
data
totalexecutiontime
totalcputime
totalcalls
totalmemory
runreference
runcomment
timecreated
*
id
questionid
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
shownumcorrect
*
id
questionid
no
draggroup
infinite
label
*
id
questionid
no
xleft
ytop
choice
label
*
id
questionid
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
shownumcorrect
showmisplaced
*
id
questionid
no
label
infinite
noofdrags
*
id
questionid
no
shape
coords
choice
*
id
questionid
responseformat
responserequired
responsefieldlines
minwordlimit
maxwordlimit
attachments
attachmentsrequired
graderinfo
graderinfoformat
responsetemplate
responsetemplateformat
maxbytes
filetypeslist
*
id
questionid
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
shownumcorrect
*
id
questionid
questiontext
questiontextformat
answertext
*
id
questionid
layout
single
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
answernumbering
shownumcorrect
showstandardinstruction
*
id
questionid
layouttype
selecttype
selectcount
gradingtype
showgrading
numberingstyle
correctfeedback
correctfeedbackformat
incorrectfeedback
incorrectfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
shownumcorrect
*
id
questionid
choose
subcats
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
shownumcorrect
*
id
questionid
usecase
*
id
parent
name
questiontext
questiontextformat
generalfeedback
generalfeedbackformat
defaultmark
penalty
qtype
length
stamp
timecreated
timemodified
createdby
modifiedby
*
id
question
answer
answerformat
fraction
feedback
feedbackformat
*
id
questionusageid
slot
behaviour
questionid
variant
maxmark
minfraction
maxfraction
flagged
questionsummary
rightanswer
responsesummary
timemodified
*
id
questionattemptid
sequencenumber
state
fraction
timecreated
userid
*
id
attemptstepid
name
value
*
id
questioncategoryid
idnumber
ownerid
*
id
question
answer
tolerance
tolerancetype
correctanswerlength
correctanswerformat
*
id
question
synchronize
single
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
answernumbering
shownumcorrect
*
id
name
contextid
info
infoformat
stamp
parent
sortorder
idnumber
*
id
question
datasetdefinition
*
id
category
name
type
options
itemcount
*
id
definition
itemnumber
value
*
id
questionid
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
shownumcorrect
*
id
questionid
shuffleanswers
correctfeedback
correctfeedbackformat
partiallycorrectfeedback
partiallycorrectfeedbackformat
incorrectfeedback
incorrectfeedbackformat
shownumcorrect
*
id
questionid
hint
hintformat
shownumcorrect
clearwrong
options
*
id
question
sequence
*
id
question
answer
tolerance
*
id
question
showunits
unitsleft
unitgradingtype
unitpenalty
*
id
question
multiplier
unit
*
id
usingcontextid
component
questionarea
itemid
questionbankentryid
version
*
id
hashcode
whichtries
timemodified
questionid
variant
subqid
aid
response
credit
*
id
analysisid
try
rcount
*
id
usingcontextid
component
questionarea
itemid
questionscontextid
filtercondition
*
id
hashcode
timemodified
questionid
slot
subquestion
variant
s
effectiveweight
negcovar
discriminationindex
discriminativeefficiency
sd
facility
subquestions
maxmark
positions
randomguessscore
*
id
question
trueanswer
falseanswer
showstandardinstruction
*
id
contextid
component
preferredbehaviour
*
id
questionbankentryid
version
questionid
status
*
id
course
name
intro
introformat
timeopen
timeclose
timelimit
overduehandling
graceperiod
preferredbehaviour
canredoquestions
attempts
attemptonlast
grademethod
decimalpoints
questiondecimalpoints
reviewattempt
reviewcorrectness
reviewmaxmarks
reviewmarks
reviewspecificfeedback
reviewgeneralfeedback
reviewrightanswer
reviewoverallfeedback
questionsperpage
navmethod
shuffleanswers
sumgrades
grade
timecreated
timemodified
password
subnet
browsersecurity
delay1
delay2
showuserpicture
showblocks
completionattemptsexhausted
completionminattempts
allowofflineattempts
*
id
quizid
cmid
templateid
requiresafeexambrowser
showsebtaskbar
showwificontrol
showreloadbutton
showtime
showkeyboardlayout
allowuserquitseb
quitpassword
linkquitseb
userconfirmquit
enableaudiocontrol
muteonstartup
allowcapturecamera
allowcapturemicrophone
allowspellchecking
allowreloadinexam
activateurlfiltering
filterembeddedcontent
expressionsallowed
regexallowed
expressionsblocked
regexblocked
allowedbrowserexamkeys
showsebdownloadlink
usermodified
timecreated
timemodified
*
id
name
description
content
enabled
sortorder
usermodified
timecreated
timemodified
*
id
quiz
userid
attempt
uniqueid
layout
currentpage
preview
state
timestart
timefinish
timemodified
timemodifiedoffline
timecheckstate
sumgrades
gradednotificationsenttime
*
id
quizid
feedbacktext
feedbacktextformat
mingrade
maxgrade
*
id
quiz
userid
grade
timemodified
*
id
quizid
sortorder
name
*
id
quiz
groupid
userid
timeopen
timeclose
timelimit
attempts
password
*
id
questionusageid
slot
newfraction
oldfraction
regraded
timemodified
*
id
name
displayorder
capability
*
id
quizid
firstslot
heading
shufflequestions
*
id
slot
quizid
page
displaynumber
requireprevious
maxmark
quizgradeitemid
*
id
hashcode
whichattempts
timemodified
firstattemptscount
highestattemptscount
lastattemptscount
allattemptscount
firstattemptsavg
highestattemptsavg
lastattemptsavg
allattemptsavg
median
standarddeviation
skewness
kurtosis
cic
errorratio
standarderror
*
id
contextid
component
ratingarea
itemid
scaleid
rating
userid
timecreated
timemodified
*
id
token
hubname
huburl
confirmed
secret
timemodified
*
id
reportid
heading
classname
configdata
usercreated
usermodified
timecreated
timemodified
*
id
reportid
uniqueidentifier
aggregation
heading
columnorder
sortenabled
sortdirection
sortorder
usercreated
usermodified
timecreated
timemodified
*
id
reportid
uniqueidentifier
heading
iscondition
filterorder
usercreated
usermodified
timecreated
timemodified
*
id
name
source
type
uniquerows
conditiondata
settingsdata
contextid
component
area
itemid
usercreated
usermodified
timecreated
timemodified
*
id
reportid
name
enabled
audiences
format
subject
message
messageformat
userviewas
timescheduled
recurrence
reportempty
timelastsent
timenextsend
usercreated
usermodified
timecreated
timemodified
*
id
type
visible
sortorder
*
id
name
typeid
userid
contextid
username
password
timecreated
timemodified
readonly
*
id
instanceid
name
value
*
id
timemodified
timecreated
usermodified
permissionid
itemid
*
id
course
name
intro
introformat
tobemigrated
legacyfiles
legacyfileslast
display
displayoptions
filterfiles
revision
timemodified
*
id
course
name
type
reference
intro
introformat
alltext
popup
options
timemodified
oldid
cmid
newmodule
newid
migrated
*
id
name
shortname
description
sortorder
archetype
*
id
roleid
allowassign
*
id
roleid
allowoverride
*
id
roleid
allowswitch
*
id
roleid
allowview
*
id
roleid
contextid
userid
timemodified
modifierid
component
itemid
sortorder
*
id
contextid
roleid
capability
permission
timemodified
modifierid
*
id
roleid
contextlevel
*
id
roleid
contextid
name
*
id
courseid
userid
name
scale
description
descriptionformat
timemodified
*
id
action
oldid
source
timemodified
loggeduser
courseid
userid
name
scale
description
*
id
course
name
scormtype
reference
intro
introformat
version
maxgrade
grademethod
whatgrade
maxattempt
forcecompleted
forcenewattempt
lastattemptlock
masteryoverride
displayattemptstatus
displaycoursestructure
updatefreq
sha1hash
md5hash
revision
launch
skipview
hidebrowse
hidetoc
nav
navpositionleft
navpositiontop
auto
popup
options
width
height
timeopen
timeclose
timemodified
completionstatusrequired
completionscorerequired
completionstatusallscos
autocommit
*
id
userid
scormid
hacpsession
scoid
scormmode
scormstatus
attempt
lessonstatus
sessiontime
timecreated
timemodified
*
id
userid
scormid
attempt
*
id
element
*
id
scorm
manifest
organization
parent
identifier
launch
scormtype
title
sortorder
*
id
scoid
name
value
*
id
scoid
attemptid
elementid
value
timemodified
*
id
scoid
objectiveid
targetobjectiveid
readsatisfiedstatus
readnormalizedmeasure
writesatisfiedstatus
writenormalizedmeasure
*
id
scoid
primaryobj
objectiveid
satisfiedbymeasure
minnormalizedmeasure
*
id
scoid
childactivityset
minimumcount
minimumpercent
conditioncombination
action
*
id
scoid
rollupruleid
operator
cond
*
id
scoid
ruleconditionsid
refrencedobjective
measurethreshold
operator
cond
*
id
scoid
conditioncombination
ruletype
action
*
id
contextid
searcharea
timerequested
partialarea
partialtime
indexpriority
*
id
docid
itemid
title
content
contextid
areaid
type
courseid
owneruserid
modified
userid
description1
description2
*
id
state
sid
userid
sessdata
timecreated
timemodified
firstip
lastip
*
id
name
gateway
enabled
config
*
id
recipientnumber
content
component
messagetype
recipientuserid
issensitive
gatewayid
status
timecreated
*
id
courseid
timeend
roleid
stattype
stat1
stat2
*
id
courseid
timeend
roleid
stattype
stat1
stat2
*
id
courseid
userid
roleid
timeend
statsreads
statswrites
stattype
*
id
courseid
userid
roleid
timeend
statsreads
statswrites
stattype
*
id
courseid
userid
roleid
timeend
statsreads
statswrites
stattype
*
id
courseid
timeend
roleid
stattype
stat1
stat2
*
id
idnumber
timestart
lastupdate
percentcompleted
message
haserrored
*
id
course
name
timemodified
*
id
course
template
days
timecreated
timemodified
name
intro
introformat
questions
completionsubmit
*
id
survey
userid
notes
*
id
userid
survey
question
time
answer1
answer2
*
id
text
shorttext
multi
intro
type
options
*
id
userid
tagcollid
name
rawname
isstandard
description
descriptionformat
flag
timemodified
*
id
component
itemtype
enabled
tagcollid
callback
callbackfile
showstandard
multiplecontexts
*
id
name
isdefault
component
sortorder
searchable
customurl
*
id
tagid
correlatedtags
*
id
tagid
component
itemtype
itemid
contextid
tiuserid
ordering
timecreated
timemodified
*
id
component
classname
nextruntime
faildelay
customdata
userid
timecreated
timestarted
hostname
pid
attemptsavailable
firststartingtime
*
id
type
component
classname
userid
timestart
timeend
dbreads
dbwrites
result
output
hostname
pid
*
id
component
classname
lastruntime
nextruntime
minute
hour
day
month
dayofweek
faildelay
customised
disabled
timestarted
hostname
pid
*
id
elementid
contextid
pagehash
userid
drafttext
draftid
pageinstance
timemodified
*
id
type
contextid
component
tablename
fieldorarea
itemid
filename
reftable
refid
cmid
courseid
categoryid
*
id
courseid
status
component
totalactivities
failedactivities
passedactivities
errorcount
*
id
courseid
status
checkid
checkcount
errorcount
*
id
checktype
shortname
checkgroup
status
severity
*
id
areaid
contenthash
iscurrent
status
timecreated
timechecked
*
id
resultid
linenumber
errordata
htmlcode
*
id
courseid
item
contextid
innercontextid
timecreated
timecompleted
*
id
contentid
checkid
errorcount
*
id
contextlevel
instanceid
contextid
status
timeanalyzed
timemodified
*
id
courseid
status
activities
activitiespassed
activitiesfailed
errorschecktype1
errorschecktype2
errorschecktype3
errorschecktype4
errorschecktype5
errorschecktype6
errorschecktype7
failedchecktype1
failedchecktype2
failedchecktype3
failedchecktype4
failedchecktype5
failedchecktype6
failedchecktype7
percentchecktype1
percentchecktype2
percentchecktype3
percentchecktype4
percentchecktype5
percentchecktype6
percentchecktype7
*
id
cohortid
roleid
userid
timecreated
timemodified
usermodified
*
id
lang
componentid
stringid
original
master
local
timemodified
timecustomized
outdated
modified
*
id
name
version
*
id
name
description
descriptionformat
usermodified
timecreated
timemodified
*
id
component
timecreated
timemodified
*
id
contextid
unexpiredroles
expiredroles
defaultexpired
status
usermodified
timecreated
timemodified
*
id
contextid
purposeid
categoryid
usermodified
timecreated
timemodified
*
id
contextlevel
purposeid
categoryid
usermodified
timecreated
timemodified
*
id
contextid
contextlistid
status
timecreated
timemodified
*
id
name
description
descriptionformat
lawfulbases
sensitivedatareasons
retentionperiod
protected
usermodified
timecreated
timemodified
*
id
purposeid
roleid
lawfulbases
sensitivedatareasons
retentionperiod
protected
usermodified
timecreated
timemodified
*
id
type
comments
commentsformat
userid
requestedby
status
dpo
dpocomment
dpocommentformat
systemapproved
usermodified
timecreated
timemodified
creationmethod
*
id
requestid
contextlistid
*
id
userid
factor
secret
label
timecreated
createdfromip
timemodified
lastverified
revoked
lockcounter
*
id
userid
lastverified
*
id
userid
factor
secret
timecreated
expiry
revoked
sessionid
*
id
eventname
contextid
contextlevel
contextinstanceid
link
courseid
timecreated
*
id
sid
userid
timesent
*
id
description
descriptionformat
name
userid
courseid
plugin
eventname
template
templateformat
frequency
timewindow
timemodified
timecreated
*
id
courseid
ruleid
cmid
userid
timecreated
lastnotificationsent
inactivedate
*
id
sortorder
currentversionid
*
id
policyversionid
userid
status
lang
usermodified
timecreated
timemodified
note
*
id
name
type
audience
archived
usermodified
timecreated
timemodified
policyid
agreementstyle
optional
revision
summary
summaryformat
content
contentformat
*
id
categoryid
shortname
fullname
timecreated
*
id
courseid
section
module
name
timecreated
*
id
tourid
title
content
contentformat
targettype
targetvalue
sortorder
configdata
*
id
name
description
pathmatch
enabled
sortorder
endtourlabel
configdata
displaystepnumbers
*
id
type
plugin
version
targetversion
info
details
backtrace
userid
timemodified
*
id
course
name
intro
introformat
externalurl
display
displayoptions
parameters
timemodified
*
id
auth
confirmed
policyagreed
deleted
suspended
mnethostid
username
password
idnumber
firstname
lastname
email
emailstop
phone1
phone2
institution
department
address
city
country
lang
calendartype
theme
timezone
firstaccess
lastaccess
lastlogin
currentlogin
lastip
secret
picture
description
descriptionformat
mailformat
maildigest
maildisplay
autosubscribe
trackforums
timecreated
timemodified
trustbitmask
imagealt
lastnamephonetic
firstnamephonetic
middlename
alternatename
moodlenetprofile
*
id
userid
appid
name
model
platform
version
pushid
uuid
publickey
timecreated
timemodified
*
id
status
enrolid
userid
timestart
timeend
modifierid
timecreated
timemodified
*
id
name
sortorder
*
id
userid
fieldid
data
dataformat
*
id
shortname
name
datatype
description
descriptionformat
categoryid
sortorder
required
locked
visible
forceunique
signup
defaultdata
defaultdataformat
param1
param2
param3
param4
param5
*
id
userid
courseid
timeaccess
*
id
userid
hash
timecreated
*
id
userid
timerequested
timererequested
token
*
id
userid
name
value
*
id
script
value
userid
instance
iprestriction
validuntil
timecreated
*
id
course
name
intro
introformat
timecreated
timemodified
firstpagetitle
wikimode
defaultformat
forceformat
editbegin
editend
*
id
subwikiid
frompageid
topageid
tomissingpage
*
id
pageid
sectionname
userid
lockedat
*
id
subwikiid
title
cachedcontent
timecreated
timemodified
timerendered
userid
pageviews
readonly
*
id
wikiid
groupid
userid
*
id
subwikiid
pageid
pagesynonym
*
id
pageid
content
contentformat
version
timecreated
userid
*
id
course
name
intro
introformat
instructauthors
instructauthorsformat
instructreviewers
instructreviewersformat
timemodified
phase
useexamples
usepeerassessment
useselfassessment
grade
gradinggrade
strategy
evaluation
gradedecimals
submissiontypetext
submissiontypefile
nattachments
submissionfiletypes
latesubmissions
maxbytes
examplesmode
submissionstart
submissionend
assessmentstart
assessmentend
phaseswitchassessment
conclusion
conclusionformat
overallfeedbackmode
overallfeedbackfiles
overallfeedbackfiletypes
overallfeedbackmaxbytes
*
id
workshopid
enabled
submissionend
timeallocated
settings
resultstatus
resultmessage
resultlog
*
id
workshopid
comparison
*
id
workshopid
sort
description
descriptionformat
grade
weight
*
id
workshopid
sort
description
descriptionformat
*
id
workshopid
sort
description
descriptionformat
descriptiontrust
grade0
grade1
weight
*
id
workshopid
nonegative
grade
*
id
workshopid
sort
description
descriptionformat
*
id
workshopid
layout
*
id
dimensionid
grade
definition
definitionformat
*
id
workshopid
userid
gradinggrade
timegraded
*
id
submissionid
reviewerid
weight
timecreated
timemodified
grade
gradinggrade
gradinggradeover
gradinggradeoverby
feedbackauthor
feedbackauthorformat
feedbackauthorattachment
feedbackreviewer
feedbackreviewerformat
*
id
assessmentid
strategy
dimensionid
grade
peercomment
peercommentformat
*
id
workshopid
example
authorid
timecreated
timemodified
title
content
contentformat
contenttrust
attachment
grade
gradeover
gradeoverby
feedbackauthor
feedbackauthorformat
timegraded
published
late
*
id
component
userid
itemid
stateid
statedata
registration
timecreated
timemodified
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
mdl_adminpresets
mdl_adminpresets_app
mdl_adminpresets_app_it
mdl_adminpresets_app_it_a
mdl_adminpresets_app_plug
mdl_adminpresets_it
mdl_adminpresets_it_a
mdl_adminpresets_plug
mdl_ai_action_generate_image
mdl_ai_action_generate_text
mdl_ai_action_register
mdl_ai_action_summarise_text
mdl_ai_policy_register
mdl_analytics_indicator_calc
mdl_analytics_models
mdl_analytics_models_log
mdl_analytics_predictions
mdl_analytics_prediction_actions
mdl_analytics_predict_samples
mdl_analytics_train_samples
mdl_analytics_used_analysables
mdl_analytics_used_files
mdl_assign
mdl_assignfeedback_comments
mdl_assignfeedback_editpdf_annot
mdl_assignfeedback_editpdf_cmnt
mdl_assignfeedback_editpdf_quick
mdl_assignfeedback_editpdf_rot
mdl_assignfeedback_file
mdl_assignsubmission_file
mdl_assignsubmission_onlinetext
mdl_assign_grades
mdl_assign_overrides
mdl_assign_plugin_config
mdl_assign_submission
mdl_assign_user_flags
mdl_assign_user_mapping
mdl_auth_lti_linked_login
mdl_auth_oauth2_linked_login
mdl_backup_controllers
mdl_backup_courses
mdl_backup_logs
mdl_badge
mdl_badge_alignment
mdl_badge_backpack
mdl_badge_backpack_oauth2
mdl_badge_criteria
mdl_badge_criteria_met
mdl_badge_criteria_param
mdl_badge_endorsement
mdl_badge_external
mdl_badge_external_backpack
mdl_badge_external_identifier
mdl_badge_issued
mdl_badge_manual_award
mdl_badge_related
mdl_bigbluebuttonbn
mdl_bigbluebuttonbn_logs
mdl_bigbluebuttonbn_recordings
mdl_block
mdl_block_instances
mdl_block_myprogress_course
mdl_block_positions
mdl_block_recentlyaccesseditems
mdl_block_recent_activity
mdl_block_rss_client
mdl_block_xp
mdl_block_xp_config
mdl_block_xp_filters
mdl_block_xp_log
mdl_block_xp_rule
mdl_blog_association
mdl_blog_external
mdl_book
mdl_book_chapters
mdl_cache_filters
mdl_cache_flags
mdl_capabilities
mdl_chat
mdl_chat_messages
mdl_chat_messages_current
mdl_chat_users
mdl_choice
mdl_choice_answers
mdl_choice_options
mdl_cohort
mdl_cohort_members
mdl_comments
mdl_communication
mdl_communication_customlink
mdl_communication_user
mdl_competency
mdl_competency_coursecomp
mdl_competency_coursecompsetting
mdl_competency_evidence
mdl_competency_framework
mdl_competency_modulecomp
mdl_competency_plan
mdl_competency_plancomp
mdl_competency_relatedcomp
mdl_competency_template
mdl_competency_templatecohort
mdl_competency_templatecomp
mdl_competency_usercomp
mdl_competency_usercompcourse
mdl_competency_usercompplan
mdl_competency_userevidence
mdl_competency_userevidencecomp
mdl_config
mdl_config_log
mdl_config_plugins
mdl_contentbank_content
mdl_context
mdl_context_temp
mdl_course
mdl_course_categories
mdl_course_completions
mdl_course_completion_aggr_methd
mdl_course_completion_criteria
mdl_course_completion_crit_compl
mdl_course_completion_defaults
mdl_course_format_options
mdl_course_modules
mdl_course_modules_completion
mdl_course_modules_viewed
mdl_course_published
mdl_course_request
mdl_course_sections
mdl_customfield_category
mdl_customfield_data
mdl_customfield_field
mdl_data
mdl_data_content
mdl_data_fields
mdl_data_records
mdl_editor_atto_autosave
mdl_enrol
mdl_enrol_flatfile
mdl_enrol_lti_app_registration
mdl_enrol_lti_context
mdl_enrol_lti_deployment
mdl_enrol_lti_lti2_consumer
mdl_enrol_lti_lti2_context
mdl_enrol_lti_lti2_nonce
mdl_enrol_lti_lti2_resource_link
mdl_enrol_lti_lti2_share_key
mdl_enrol_lti_lti2_tool_proxy
mdl_enrol_lti_lti2_user_result
mdl_enrol_lti_resource_link
mdl_enrol_lti_tools
mdl_enrol_lti_tool_consumer_map
mdl_enrol_lti_users
mdl_enrol_lti_user_resource_link
mdl_enrol_paypal
mdl_event
mdl_events_handlers
mdl_events_queue
mdl_events_queue_handlers
mdl_event_subscriptions
mdl_external_functions
mdl_external_services
mdl_external_services_functions
mdl_external_services_users
mdl_external_tokens
mdl_favourite
mdl_feedback
mdl_feedback_completed
mdl_feedback_completedtmp
mdl_feedback_item
mdl_feedback_sitecourse_map
mdl_feedback_template
mdl_feedback_value
mdl_feedback_valuetmp
mdl_files
mdl_files_reference
mdl_file_conversion
mdl_filter_active
mdl_filter_config
mdl_folder
mdl_forum
mdl_forum_digests
mdl_forum_discussions
mdl_forum_discussion_subs
mdl_forum_grades
mdl_forum_posts
mdl_forum_queue
mdl_forum_read
mdl_forum_subscriptions
mdl_forum_track_prefs
mdl_glossary
mdl_glossary_alias
mdl_glossary_categories
mdl_glossary_entries
mdl_glossary_entries_categories
mdl_glossary_formats
mdl_grade_categories
mdl_grade_categories_history
mdl_grade_grades
mdl_grade_grades_history
mdl_grade_import_newitem
mdl_grade_import_values
mdl_grade_items
mdl_grade_items_history
mdl_grade_letters
mdl_grade_outcomes
mdl_grade_outcomes_courses
mdl_grade_outcomes_history
mdl_grade_settings
mdl_gradingform_guide_comments
mdl_gradingform_guide_criteria
mdl_gradingform_guide_fillings
mdl_gradingform_rubric_criteria
mdl_gradingform_rubric_fillings
mdl_gradingform_rubric_levels
mdl_grading_areas
mdl_grading_definitions
mdl_grading_instances
mdl_groupings
mdl_groupings_groups
mdl_groups
mdl_groups_members
mdl_h5p
mdl_h5pactivity
mdl_h5pactivity_attempts
mdl_h5pactivity_attempts_results
mdl_h5p_contents_libraries
mdl_h5p_libraries
mdl_h5p_libraries_cachedassets
mdl_h5p_library_dependencies
mdl_hvp
mdl_hvp_auth
mdl_hvp_contents_libraries
mdl_hvp_content_hub_cache
mdl_hvp_content_user_data
mdl_hvp_counters
mdl_hvp_events
mdl_hvp_libraries
mdl_hvp_libraries_cachedassets
mdl_hvp_libraries_hub_cache
mdl_hvp_libraries_languages
mdl_hvp_libraries_libraries
mdl_hvp_tmpfiles
mdl_hvp_xapi_results
mdl_imscp
mdl_infected_files
mdl_label
mdl_lesson
mdl_lesson_answers
mdl_lesson_attempts
mdl_lesson_branch
mdl_lesson_grades
mdl_lesson_overrides
mdl_lesson_pages
mdl_lesson_timer
mdl_license
mdl_lock_db
mdl_log
mdl_logstore_standard_log
mdl_log_display
mdl_log_queries
mdl_lti
mdl_ltiservice_gradebookservices
mdl_lti_access_tokens
mdl_lti_coursevisible
mdl_lti_submission
mdl_lti_tool_proxies
mdl_lti_tool_settings
mdl_lti_types
mdl_lti_types_categories
mdl_lti_types_config
mdl_matrix_room
mdl_message
mdl_messageinbound_datakeys
mdl_messageinbound_handlers
mdl_messageinbound_messagelist
mdl_messages
mdl_message_airnotifier_devices
mdl_message_contacts
mdl_message_contact_requests
mdl_message_conversations
mdl_message_conversation_actions
mdl_message_conversation_members
mdl_message_email_messages
mdl_message_popup
mdl_message_popup_notifications
mdl_message_processors
mdl_message_providers
mdl_message_read
mdl_message_users_blocked
mdl_message_user_actions
mdl_mnetservice_enrol_courses
mdl_mnetservice_enrol_enrolments
mdl_mnet_application
mdl_mnet_host
mdl_mnet_host2service
mdl_mnet_log
mdl_mnet_remote_rpc
mdl_mnet_remote_service2rpc
mdl_mnet_rpc
mdl_mnet_service
mdl_mnet_service2rpc
mdl_mnet_session
mdl_mnet_sso_access_control
mdl_modules
mdl_moodlenet_share_progress
mdl_my_pages
mdl_notifications
mdl_oauth2_access_token
mdl_oauth2_endpoint
mdl_oauth2_issuer
mdl_oauth2_refresh_token
mdl_oauth2_system_account
mdl_oauth2_user_field_mapping
mdl_page
mdl_paygw_paypal
mdl_payments
mdl_payment_accounts
mdl_payment_gateways
mdl_portfolio_instance
mdl_portfolio_instance_config
mdl_portfolio_instance_user
mdl_portfolio_log
mdl_portfolio_mahara_queue
mdl_portfolio_tempdata
mdl_post
mdl_profiling
mdl_qtype_ddimageortext
mdl_qtype_ddimageortext_drags
mdl_qtype_ddimageortext_drops
mdl_qtype_ddmarker
mdl_qtype_ddmarker_drags
mdl_qtype_ddmarker_drops
mdl_qtype_essay_options
mdl_qtype_match_options
mdl_qtype_match_subquestions
mdl_qtype_multichoice_options
mdl_qtype_ordering_options
mdl_qtype_randomsamatch_options
mdl_qtype_shortanswer_options
mdl_question
mdl_question_answers
mdl_question_attempts
mdl_question_attempt_steps
mdl_question_attempt_step_data
mdl_question_bank_entries
mdl_question_calculated
mdl_question_calculated_options
mdl_question_categories
mdl_question_datasets
mdl_question_dataset_definitions
mdl_question_dataset_items
mdl_question_ddwtos
mdl_question_gapselect
mdl_question_hints
mdl_question_multianswer
mdl_question_numerical
mdl_question_numerical_options
mdl_question_numerical_units
mdl_question_references
mdl_question_response_analysis
mdl_question_response_count
mdl_question_set_references
mdl_question_statistics
mdl_question_truefalse
mdl_question_usages
mdl_question_versions
mdl_quiz
mdl_quizaccess_seb_quizsettings
mdl_quizaccess_seb_template
mdl_quiz_attempts
mdl_quiz_feedback
mdl_quiz_grades
mdl_quiz_grade_items
mdl_quiz_overrides
mdl_quiz_overview_regrades
mdl_quiz_reports
mdl_quiz_sections
mdl_quiz_slots
mdl_quiz_statistics
mdl_rating
mdl_registration_hubs
mdl_reportbuilder_audience
mdl_reportbuilder_column
mdl_reportbuilder_filter
mdl_reportbuilder_report
mdl_reportbuilder_schedule
mdl_repository
mdl_repository_instances
mdl_repository_instance_config
mdl_repository_onedrive_access
mdl_resource
mdl_resource_old
mdl_role
mdl_role_allow_assign
mdl_role_allow_override
mdl_role_allow_switch
mdl_role_allow_view
mdl_role_assignments
mdl_role_capabilities
mdl_role_context_levels
mdl_role_names
mdl_scale
mdl_scale_history
mdl_scorm
mdl_scorm_aicc_session
mdl_scorm_attempt
mdl_scorm_element
mdl_scorm_scoes
mdl_scorm_scoes_data
mdl_scorm_scoes_value
mdl_scorm_seq_mapinfo
mdl_scorm_seq_objective
mdl_scorm_seq_rolluprule
mdl_scorm_seq_rolluprulecond
mdl_scorm_seq_rulecond
mdl_scorm_seq_ruleconds
mdl_search_index_requests
mdl_search_simpledb_index
mdl_sessions
mdl_sms_gateways
mdl_sms_messages
mdl_stats_daily
mdl_stats_monthly
mdl_stats_user_daily
mdl_stats_user_monthly
mdl_stats_user_weekly
mdl_stats_weekly
mdl_stored_progress
mdl_subsection
mdl_survey
mdl_survey_analysis
mdl_survey_answers
mdl_survey_questions
mdl_tag
mdl_tag_area
mdl_tag_coll
mdl_tag_correlation
mdl_tag_instance
mdl_task_adhoc
mdl_task_log
mdl_task_scheduled
mdl_tiny_autosave
mdl_tool_brickfield_areas
mdl_tool_brickfield_cache_acts
mdl_tool_brickfield_cache_check
mdl_tool_brickfield_checks
mdl_tool_brickfield_content
mdl_tool_brickfield_errors
mdl_tool_brickfield_process
mdl_tool_brickfield_results
mdl_tool_brickfield_schedule
mdl_tool_brickfield_summary
mdl_tool_cohortroles
mdl_tool_customlang
mdl_tool_customlang_components
mdl_tool_dataprivacy_category
mdl_tool_dataprivacy_contextlist
mdl_tool_dataprivacy_ctxexpired
mdl_tool_dataprivacy_ctxinstance
mdl_tool_dataprivacy_ctxlevel
mdl_tool_dataprivacy_ctxlst_ctx
mdl_tool_dataprivacy_purpose
mdl_tool_dataprivacy_purposerole
mdl_tool_dataprivacy_request
mdl_tool_dataprivacy_rqst_ctxlst
mdl_tool_mfa
mdl_tool_mfa_auth
mdl_tool_mfa_secrets
mdl_tool_monitor_events
mdl_tool_monitor_history
mdl_tool_monitor_rules
mdl_tool_monitor_subscriptions
mdl_tool_policy
mdl_tool_policy_acceptances
mdl_tool_policy_versions
mdl_tool_recyclebin_category
mdl_tool_recyclebin_course
mdl_tool_usertours_steps
mdl_tool_usertours_tours
mdl_upgrade_log
mdl_url
mdl_user
mdl_user_devices
mdl_user_enrolments
mdl_user_info_category
mdl_user_info_data
mdl_user_info_field
mdl_user_lastaccess
mdl_user_password_history
mdl_user_password_resets
mdl_user_preferences
mdl_user_private_key
mdl_wiki
mdl_wiki_links
mdl_wiki_locks
mdl_wiki_pages
mdl_wiki_subwikis
mdl_wiki_synonyms
mdl_wiki_versions
mdl_workshop
mdl_workshopallocation_scheduled
mdl_workshopeval_best_settings
mdl_workshopform_accumulative
mdl_workshopform_comments
mdl_workshopform_numerrors
mdl_workshopform_numerrors_map
mdl_workshopform_rubric
mdl_workshopform_rubric_config
mdl_workshopform_rubric_levels
mdl_workshop_aggregations
mdl_workshop_assessments
mdl_workshop_grades
mdl_workshop_submissions
mdl_xapi_states
.
select column