ㅇㅇㅇ
Tables (150)
backup_controllers
- id — BIGINT(10) — Primary key — NOT NULL
- backupid — VARCHAR(32) — NOT NULL
- operation — VARCHAR(20) — NOT NULL
- type — VARCHAR(10) — NOT NULL
- itemid — BIGINT(10) — NOT NULL
- format — VARCHAR(20) — NOT NULL
- interactive — SMALLINT(4) — NOT NULL
- purpose — SMALLINT(4) — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- status — SMALLINT(4) — NOT NULL
- execution — SMALLINT(4) — NOT NULL
- executiontime — BIGINT(10) — NOT NULL
- checksum — VARCHAR(32) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- controller — LONGTEXT — NOT NULL
- INDEX — `backcont_typite2_ix`
- INDEX — `backcont_use4_ix`
backup_courses
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key — NOT NULL
- laststarttime — BIGINT(10) — NOT NULL
- lastendtime — BIGINT(10) — NOT NULL
- laststatus — VARCHAR(1) — NOT NULL
- nextstarttime — BIGINT(10) — NOT NULL
backup_logs
- id — BIGINT(10) — Primary key — NOT NULL
- backupid — VARCHAR(32) — Foreign key → backup_controllers.backupid — NOT NULL
- loglevel — SMALLINT(4) — NOT NULL
- message — LONGTEXT — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- INDEX — `backlogs_bac4_ix`
badge
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- usercreated — BIGINT(10) — Foreign key — NOT NULL
- usermodified — BIGINT(10) — Foreign key — NOT NULL
- issuername — VARCHAR(255) — NOT NULL
- issuerurl — VARCHAR(255) — NOT NULL
- issuercontact — VARCHAR(255)
- expiredate — BIGINT(10)
- expireperiod — BIGINT(10)
- type — TINYINT(1) — NOT NULL
- courseid — BIGINT(10) — Foreign key
- message — LONGTEXT — NOT NULL
- messagesubject — LONGTEXT — NOT NULL
- attachment — TINYINT(1) — NOT NULL
- notification — TINYINT(1) — NOT NULL
- status — TINYINT(1) — NOT NULL
- nextcron — BIGINT(10)
- INDEX — `badg_typ2_ix`
- INDEX — `badg_cou4_ix`
- INDEX — `badg_use6_ix`
- INDEX — `badg_use8_ix`
badge_criteria
- id — BIGINT(10) — Primary key — NOT NULL
- badgeid — BIGINT(10) — Foreign key → badge.id — NOT NULL
- criteriatype — BIGINT(10)
- method — TINYINT(1) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- INDEX — `badgcrit_cri2_ix`
- INDEX — `badgcrit_bad4_ix`
badge_criteria_param
- id — BIGINT(10) — Primary key — NOT NULL
- critid — BIGINT(10) — Foreign key → badge_criteria.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — VARCHAR(255)
- INDEX — `badgcritpara_cri4_ix`
badge_issued
- id — BIGINT(10) — Primary key — NOT NULL
- badgeid — BIGINT(10) — Foreign key → badge.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- uniquehash — LONGTEXT — NOT NULL
- dateissued — BIGINT(10) — NOT NULL
- dateexpire — BIGINT(10)
- visible — TINYINT(1) — NOT NULL
- issuernotified — BIGINT(10)
- INDEX — `badgissu_bad4_ix`
- INDEX — `badgissu_use4_ix`
block
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(40) — NOT NULL
- cron — BIGINT(10) — NOT NULL
- lastcron — BIGINT(10) — NOT NULL
- visible — TINYINT(1) — NOT NULL
block_instances
- id — BIGINT(10) — Primary key — NOT NULL
- blockname — VARCHAR(40) — Foreign key → block.name — NOT NULL
- parentcontextid — BIGINT(10) — Foreign key — NOT NULL
- showinsubcontexts — SMALLINT(4) — NOT NULL
- requiredbytheme — SMALLINT(4) — NOT NULL
- pagetypepattern — VARCHAR(64) — NOT NULL
- subpagepattern — VARCHAR(16)
- defaultregion — VARCHAR(16) — NOT NULL
- defaultweight — BIGINT(10) — NOT NULL
- configdata — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `blocinst_parshopagsub2_ix`
- INDEX — `blocinst_tim2_ix`
- INDEX — `blocinst_par4_ix`
- INDEX — `block_instances_erd_block_name`
block_positions
- id — BIGINT(10) — Primary key — NOT NULL
- blockinstanceid — BIGINT(10) — Foreign key → block_instances.id — NOT NULL
- contextid — BIGINT(10) — Foreign key — NOT NULL
- pagetype — VARCHAR(64) — NOT NULL
- subpage — VARCHAR(16) — NOT NULL
- visible — SMALLINT(4) — NOT NULL
- region — VARCHAR(16) — NOT NULL
- weight — BIGINT(10) — NOT NULL
- INDEX — `blocposi_blo4_ix`
- INDEX — `blocposi_con4_ix`
blog_association
- id — BIGINT(10) — Primary key — NOT NULL
- contextid — BIGINT(10) — Foreign key — NOT NULL
- blogid — BIGINT(10) — Foreign key — NOT NULL
- INDEX — `blogasso_con4_ix`
- INDEX — `blogasso_blo4_ix`
blog_external
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — LONGTEXT
- url — LONGTEXT — NOT NULL
- filtertags — VARCHAR(255)
- failedlastsync — TINYINT(1) — NOT NULL
- timemodified — BIGINT(10)
- timefetched — BIGINT(10) — NOT NULL
- INDEX — `blogexte_use4_ix`
cache_filters
- id — BIGINT(10) — Primary key — NOT NULL
- filter — VARCHAR(32) — NOT NULL
- version — BIGINT(10) — NOT NULL
- md5key — VARCHAR(32) — NOT NULL
- rawtext — LONGTEXT — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `cachfilt_filmd52_ix`
cache_flags
- id — BIGINT(10) — Primary key — NOT NULL
- flagtype — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- value — LONGTEXT — NOT NULL
- expiry — BIGINT(10) — NOT NULL
- INDEX — `cachflag_fla2_ix`
- INDEX — `cachflag_nam2_ix`
capabilities
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- captype — VARCHAR(50) — NOT NULL
- contextlevel — BIGINT(10) — NOT NULL
- component — VARCHAR(100) — NOT NULL
- riskbitmask — BIGINT(10) — NOT NULL
cohort
- id — BIGINT(10) — Primary key — NOT NULL
- contextid — BIGINT(10) — Foreign key — NOT NULL
- name — VARCHAR(254) — NOT NULL
- idnumber — VARCHAR(100)
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- component — VARCHAR(100) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `coho_con4_ix`
cohort_members
- id — BIGINT(10) — Primary key — NOT NULL
- cohortid — BIGINT(10) — Foreign key → cohort.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- timeadded — BIGINT(10) — NOT NULL
- INDEX — `cohomemb_coh4_ix`
- INDEX — `cohomemb_use4_ix`
comments
- id — BIGINT(10) — Primary key — NOT NULL
- contextid — BIGINT(10) — NOT NULL
- component — VARCHAR(255)
- commentarea — VARCHAR(255) — NOT NULL
- itemid — BIGINT(10) — NOT NULL
- content — LONGTEXT — NOT NULL
- format — TINYINT(2) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
config
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — LONGTEXT — NOT NULL
config_log
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- plugin — VARCHAR(100)
- name — VARCHAR(100) — NOT NULL
- value — LONGTEXT
- oldvalue — LONGTEXT
- INDEX — `conflog_tim2_ix`
- INDEX — `conflog_use4_ix`
config_plugins
- id — BIGINT(10) — Primary key — NOT NULL
- plugin — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- value — LONGTEXT — NOT NULL
context
- id — BIGINT(10) — Primary key — NOT NULL
- contextlevel — BIGINT(10) — NOT NULL
- instanceid — BIGINT(10) — NOT NULL
- path — VARCHAR(255)
- depth — TINYINT(2) — NOT NULL
- INDEX — `cont_ins2_ix`
- INDEX — `cont_pat2_ix`
context_temp
- id — BIGINT(10) — Primary key — NOT NULL
- path — VARCHAR(255) — NOT NULL
- depth — TINYINT(2) — NOT NULL
course
- id — BIGINT(10) — Primary key — NOT NULL
- category — BIGINT(10) — Foreign key → course_categories.id — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- fullname — VARCHAR(254) — NOT NULL
- shortname — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- summary — LONGTEXT
- summaryformat — TINYINT(2) — NOT NULL
- format — VARCHAR(21) — NOT NULL
- showgrades — TINYINT(2) — NOT NULL
- newsitems — MEDIUMINT(5) — NOT NULL
- startdate — BIGINT(10) — NOT NULL
- enddate — BIGINT(10) — NOT NULL
- marker — BIGINT(10) — NOT NULL
- maxbytes — BIGINT(10) — NOT NULL
- legacyfiles — SMALLINT(4) — NOT NULL
- showreports — SMALLINT(4) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- groupmode — SMALLINT(4) — NOT NULL
- groupmodeforce — SMALLINT(4) — NOT NULL
- defaultgroupingid — BIGINT(10) — NOT NULL
- lang — VARCHAR(30) — NOT NULL
- calendartype — VARCHAR(30) — NOT NULL
- theme — VARCHAR(50) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- requested — TINYINT(1) — NOT NULL
- enablecompletion — TINYINT(1) — NOT NULL
- completionnotify — TINYINT(1) — NOT NULL
- cacherev — BIGINT(10) — NOT NULL
- INDEX — `cour_cat2_ix`
- INDEX — `cour_idn2_ix`
- INDEX — `cour_sho2_ix`
- INDEX — `cour_sor2_ix`
course_categories
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100)
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- parent — BIGINT(10) — Foreign key → course_categories.id — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- coursecount — BIGINT(10) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- depth — BIGINT(10) — NOT NULL
- path — VARCHAR(255) — NOT NULL
- theme — VARCHAR(50)
- INDEX — `courcate_par4_ix`
course_completion_aggr_methd
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- criteriatype — BIGINT(10)
- method — TINYINT(1) — NOT NULL
- value — DECIMAL(10, 5)
- INDEX — `courcompaggrmeth_cou2_ix`
- INDEX — `courcompaggrmeth_cri2_ix`
course_completion_crit_compl
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — NOT NULL
- course — BIGINT(10) — NOT NULL
- criteriaid — BIGINT(10) — NOT NULL
- gradefinal — DECIMAL(10, 5)
- unenroled — BIGINT(10)
- timecompleted — BIGINT(10)
- INDEX — `courcompcritcomp_use2_ix`
- INDEX — `courcompcritcomp_cou2_ix`
- INDEX — `courcompcritcomp_cri2_ix`
- INDEX — `courcompcritcomp_tim2_ix`
course_completion_criteria
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- criteriatype — BIGINT(10) — NOT NULL
- module — VARCHAR(100)
- moduleinstance — BIGINT(10)
- courseinstance — BIGINT(10)
- enrolperiod — BIGINT(10)
- timeend — BIGINT(10)
- gradepass — DECIMAL(10, 5)
- role — BIGINT(10)
- INDEX — `courcompcrit_cou2_ix`
course_completions
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- timeenrolled — BIGINT(10) — NOT NULL
- timestarted — BIGINT(10) — NOT NULL
- timecompleted — BIGINT(10)
- reaggregate — BIGINT(10) — NOT NULL
- INDEX — `courcomp_use2_ix`
- INDEX — `courcomp_cou2_ix`
- INDEX — `courcomp_tim2_ix`
course_format_options
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- format — VARCHAR(21) — NOT NULL
- sectionid — BIGINT(10) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- value — LONGTEXT
- INDEX — `courformopti_cou4_ix`
course_modules
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- module — BIGINT(10) — NOT NULL
- instance — BIGINT(10) — NOT NULL
- section — BIGINT(10) — NOT NULL
- idnumber — VARCHAR(100)
- added — BIGINT(10) — NOT NULL
- score — SMALLINT(4) — NOT NULL
- indent — MEDIUMINT(5) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleoncoursepage — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- groupmode — SMALLINT(4) — NOT NULL
- groupingid — BIGINT(10) — Foreign key → groupings.id — NOT NULL
- completion — TINYINT(1) — NOT NULL
- completiongradeitemnumber — BIGINT(10)
- completionview — TINYINT(1) — NOT NULL
- completionexpected — BIGINT(10) — NOT NULL
- showdescription — TINYINT(1) — NOT NULL
- availability — LONGTEXT
- deletioninprogress — TINYINT(1) — NOT NULL
- INDEX — `courmodu_vis2_ix`
- INDEX — `courmodu_cou2_ix`
- INDEX — `courmodu_mod2_ix`
- INDEX — `courmodu_ins2_ix`
- INDEX — `courmodu_idncou2_ix`
- INDEX — `courmodu_gro4_ix`
course_modules_completion
- id — BIGINT(10) — Primary key — NOT NULL
- coursemoduleid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- completionstate — TINYINT(1) — NOT NULL
- viewed — TINYINT(1)
- overrideby — BIGINT(10)
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `courmoducomp_cou2_ix`
course_published
- id — BIGINT(10) — Primary key — NOT NULL
- huburl — VARCHAR(255)
- courseid — BIGINT(10) — NOT NULL
- timepublished — BIGINT(10) — NOT NULL
- enrollable — TINYINT(1) — NOT NULL
- hubcourseid — BIGINT(10) — NOT NULL
- status — TINYINT(1)
- timechecked — BIGINT(10)
course_request
- id — BIGINT(10) — Primary key — NOT NULL
- fullname — VARCHAR(254) — NOT NULL
- shortname — VARCHAR(100) — NOT NULL
- summary — LONGTEXT — NOT NULL
- summaryformat — TINYINT(2) — NOT NULL
- category — BIGINT(10) — NOT NULL
- reason — LONGTEXT — NOT NULL
- requester — BIGINT(10) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- INDEX — `courrequ_sho2_ix`
course_sections
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- section — BIGINT(10) — NOT NULL
- name — VARCHAR(255)
- summary — LONGTEXT
- summaryformat — TINYINT(2) — NOT NULL
- sequence — LONGTEXT
- visible — TINYINT(1) — NOT NULL
- availability — LONGTEXT
- timemodified — BIGINT(10) — NOT NULL
enrol
- id — BIGINT(10) — Primary key — NOT NULL
- enrol — VARCHAR(20) — NOT NULL
- status — BIGINT(10) — NOT NULL
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- name — VARCHAR(255)
- enrolperiod — BIGINT(10)
- enrolstartdate — BIGINT(10)
- enrolenddate — BIGINT(10)
- expirynotify — TINYINT(1)
- expirythreshold — BIGINT(10)
- notifyall — TINYINT(1)
- password — VARCHAR(50)
- cost — VARCHAR(20)
- currency — VARCHAR(3)
- roleid — BIGINT(10)
- customint1 — BIGINT(10)
- customint2 — BIGINT(10)
- customint3 — BIGINT(10)
- customint4 — BIGINT(10)
- customint5 — BIGINT(10)
- customint6 — BIGINT(10)
- customint7 — BIGINT(10)
- customint8 — BIGINT(10)
- customchar1 — VARCHAR(255)
- customchar2 — VARCHAR(255)
- customchar3 — VARCHAR(1333)
- customdec1 — DECIMAL(12, 7)
- customdec2 — DECIMAL(12, 7)
- customtext1 — LONGTEXT
- customtext2 — LONGTEXT
- customtext3 — LONGTEXT
- customtext4 — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `enro_enr2_ix`
- INDEX — `enro_cou4_ix`
event
- id — BIGINT(10) — Primary key — NOT NULL
- name — LONGTEXT — NOT NULL
- description — LONGTEXT — NOT NULL
- format — SMALLINT(4) — NOT NULL
- categoryid — BIGINT(10) — Foreign key → course_categories.id — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- groupid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- repeatid — BIGINT(10) — NOT NULL
- modulename — VARCHAR(20) — NOT NULL
- instance — BIGINT(10) — NOT NULL
- type — SMALLINT(4) — NOT NULL
- eventtype — VARCHAR(20) — NOT NULL
- timestart — BIGINT(10) — NOT NULL
- timeduration — BIGINT(10) — NOT NULL
- timesort — BIGINT(10)
- visible — SMALLINT(4) — NOT NULL
- uuid — VARCHAR(255) — NOT NULL
- sequence — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- subscriptionid — BIGINT(10)
- priority — BIGINT(10)
- INDEX — `even_cou2_ix`
- INDEX — `even_use2_ix`
- INDEX — `even_tim3_ix`
- INDEX — `even_tim4_ix`
- INDEX — `even_typtim2_ix`
- INDEX — `even_grocoucatvisuse2_ix`
- INDEX — `even_cat4_ix`
event_subscriptions
- id — BIGINT(10) — Primary key — NOT NULL
- url — VARCHAR(255) — NOT NULL
- categoryid — BIGINT(10) — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- groupid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- eventtype — VARCHAR(20) — NOT NULL
- pollinterval — BIGINT(10) — NOT NULL
- lastupdated — BIGINT(10)
- name — VARCHAR(255) — NOT NULL
events_handlers
- id — BIGINT(10) — Primary key — NOT NULL
- eventname — VARCHAR(166) — NOT NULL
- component — VARCHAR(166) — NOT NULL
- handlerfile — VARCHAR(255) — NOT NULL
- handlerfunction — LONGTEXT
- schedule — VARCHAR(255)
- status — BIGINT(10) — NOT NULL
- internal — TINYINT(2) — NOT NULL
events_queue
- id — BIGINT(10) — Primary key — NOT NULL
- eventdata — LONGTEXT — NOT NULL
- stackdump — LONGTEXT
- userid — BIGINT(10) — Foreign key
- timecreated — BIGINT(10) — NOT NULL
- INDEX — `evenqueu_use4_ix`
events_queue_handlers
- id — BIGINT(10) — Primary key — NOT NULL
- queuedeventid — BIGINT(10) — Foreign key → events_queue.id — NOT NULL
- handlerid — BIGINT(10) — Foreign key → events_handlers.id — NOT NULL
- status — BIGINT(10)
- errormessage — LONGTEXT
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `evenqueuhand_que4_ix`
- INDEX — `evenqueuhand_han4_ix`
external_functions
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- classname — VARCHAR(100) — NOT NULL
- methodname — VARCHAR(100) — NOT NULL
- classpath — VARCHAR(255)
- component — VARCHAR(100) — NOT NULL
- capabilities — VARCHAR(255)
- services — VARCHAR(1333)
external_services
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- requiredcapability — VARCHAR(150)
- restrictedusers — TINYINT(1) — NOT NULL
- component — VARCHAR(100)
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10)
- shortname — VARCHAR(255)
- downloadfiles — TINYINT(1) — NOT NULL
- uploadfiles — TINYINT(1) — NOT NULL
external_services_functions
- id — BIGINT(10) — Primary key — NOT NULL
- externalserviceid — BIGINT(10) — Foreign key → external_services.id — NOT NULL
- functionname — VARCHAR(200) — NOT NULL
- INDEX — `exteservfunc_ext4_ix`
external_services_users
- id — BIGINT(10) — Primary key — NOT NULL
- externalserviceid — BIGINT(10) — Foreign key → external_services.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- iprestriction — VARCHAR(255)
- validuntil — BIGINT(10)
- timecreated — BIGINT(10)
- INDEX — `exteservuser_ext4_ix`
- INDEX — `exteservuser_use4_ix`
external_tokens
- id — BIGINT(10) — Primary key — NOT NULL
- token — VARCHAR(128) — NOT NULL
- privatetoken — VARCHAR(64)
- tokentype — SMALLINT(4) — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- externalserviceid — BIGINT(10) — Foreign key → external_services.id — NOT NULL
- sid — VARCHAR(128)
- contextid — BIGINT(10) — Foreign key — NOT NULL
- creatorid — BIGINT(10) — Foreign key — NOT NULL
- iprestriction — VARCHAR(255)
- validuntil — BIGINT(10)
- timecreated — BIGINT(10) — NOT NULL
- lastaccess — BIGINT(10)
- INDEX — `extetoke_use4_ix`
- INDEX — `extetoke_ext4_ix`
- INDEX — `extetoke_con4_ix`
- INDEX — `extetoke_cre4_ix`
file_conversion
- id — BIGINT(10) — Primary key — NOT NULL
- usermodified — BIGINT(10) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- sourcefileid — BIGINT(10) — Foreign key → files.id — NOT NULL
- targetformat — VARCHAR(100) — NOT NULL
- status — BIGINT(10)
- statusmessage — LONGTEXT
- converter — VARCHAR(255)
- destfileid — BIGINT(10) — Foreign key → files.id
- data — LONGTEXT
- INDEX — `fileconv_sou4_ix`
- INDEX — `fileconv_des4_ix`
files
- id — BIGINT(10) — Primary key — NOT NULL
- contenthash — VARCHAR(40) — NOT NULL
- pathnamehash — VARCHAR(40) — NOT NULL
- contextid — BIGINT(10) — Foreign key — NOT NULL
- component — VARCHAR(100) — NOT NULL
- filearea — VARCHAR(50) — NOT NULL
- itemid — BIGINT(10) — NOT NULL
- filepath — VARCHAR(255) — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- userid — BIGINT(10) — Foreign key
- filesize — BIGINT(10) — NOT NULL
- mimetype — VARCHAR(100)
- status — BIGINT(10) — NOT NULL
- source — LONGTEXT
- author — VARCHAR(255)
- license — VARCHAR(255)
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- referencefileid — BIGINT(10) — Foreign key → files_reference.id
- INDEX — `file_comfilconite2_ix`
- INDEX — `file_con3_ix`
- INDEX — `file_con5_ix`
- INDEX — `file_use4_ix`
- INDEX — `file_ref4_ix`
files_reference
- id — BIGINT(10) — Primary key — NOT NULL
- repositoryid — BIGINT(10) — Foreign key — NOT NULL
- lastsync — BIGINT(10)
- reference — LONGTEXT
- referencehash — VARCHAR(40) — NOT NULL
- INDEX — `filerefe_rep4_ix`
filter_active
- id — BIGINT(10) — Primary key — NOT NULL
- filter — VARCHAR(32) — NOT NULL
- contextid — BIGINT(10) — Foreign key → context.id — NOT NULL
- active — SMALLINT(4) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- INDEX — `filtacti_con4_ix`
filter_config
- id — BIGINT(10) — Primary key — NOT NULL
- filter — VARCHAR(32) — NOT NULL
- contextid — BIGINT(10) — Foreign key → context.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — LONGTEXT
- INDEX — `filtconf_con4_ix`
grade_categories
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key — NOT NULL
- parent — BIGINT(10) — Foreign key → grade_categories.id
- depth — BIGINT(10) — NOT NULL
- path — VARCHAR(255)
- fullname — VARCHAR(255) — NOT NULL
- aggregation — BIGINT(10) — NOT NULL
- keephigh — BIGINT(10) — NOT NULL
- droplow — BIGINT(10) — NOT NULL
- aggregateonlygraded — TINYINT(1) — NOT NULL
- aggregateoutcomes — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- hidden — TINYINT(1) — NOT NULL
- INDEX — `gradcate_cou4_ix`
- INDEX — `gradcate_par4_ix`
grade_categories_history
- id — BIGINT(10) — Primary key — NOT NULL
- action — BIGINT(10) — NOT NULL
- oldid — BIGINT(10) — Foreign key → grade_categories.id — NOT NULL
- source — VARCHAR(255)
- timemodified — BIGINT(10)
- loggeduser — BIGINT(10) — Foreign key
- courseid — BIGINT(10) — Foreign key — NOT NULL
- parent — BIGINT(10) — Foreign key → grade_categories.id
- depth — BIGINT(10) — NOT NULL
- path — VARCHAR(255)
- fullname — VARCHAR(255) — NOT NULL
- aggregation — BIGINT(10) — NOT NULL
- keephigh — BIGINT(10) — NOT NULL
- droplow — BIGINT(10) — NOT NULL
- aggregateonlygraded — TINYINT(1) — NOT NULL
- aggregateoutcomes — TINYINT(1) — NOT NULL
- aggregatesubcats — TINYINT(1) — NOT NULL
- hidden — TINYINT(1) — NOT NULL
- INDEX — `gradcatehist_act2_ix`
- INDEX — `gradcatehist_tim2_ix`
- INDEX — `gradcatehist_old4_ix`
- INDEX — `gradcatehist_cou4_ix`
- INDEX — `gradcatehist_par4_ix`
- INDEX — `gradcatehist_log4_ix`
grade_grades
- id — BIGINT(10) — Primary key — NOT NULL
- itemid — BIGINT(10) — Foreign key → grade_items.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- rawgrade — DECIMAL(10, 5)
- rawgrademax — DECIMAL(10, 5) — NOT NULL
- rawgrademin — DECIMAL(10, 5) — NOT NULL
- rawscaleid — BIGINT(10) — Foreign key
- usermodified — BIGINT(10) — Foreign key
- finalgrade — DECIMAL(10, 5)
- hidden — BIGINT(10) — NOT NULL
- locked — BIGINT(10) — NOT NULL
- locktime — BIGINT(10) — NOT NULL
- exported — BIGINT(10) — NOT NULL
- overridden — BIGINT(10) — NOT NULL
- excluded — BIGINT(10) — NOT NULL
- feedback — LONGTEXT
- feedbackformat — BIGINT(10) — NOT NULL
- information — LONGTEXT
- informationformat — BIGINT(10) — NOT NULL
- timecreated — BIGINT(10)
- timemodified — BIGINT(10)
- aggregationstatus — VARCHAR(10) — NOT NULL
- aggregationweight — DECIMAL(10, 5)
- INDEX — `gradgrad_locloc2_ix`
- INDEX — `gradgrad_ite4_ix`
- INDEX — `gradgrad_use6_ix`
- INDEX — `gradgrad_raw4_ix`
- INDEX — `gradgrad_use8_ix`
grade_grades_history
- id — BIGINT(10) — Primary key — NOT NULL
- action — BIGINT(10) — NOT NULL
- oldid — BIGINT(10) — Foreign key → grade_grades.id — NOT NULL
- source — VARCHAR(255)
- timemodified — BIGINT(10)
- loggeduser — BIGINT(10) — Foreign key
- itemid — BIGINT(10) — Foreign key → grade_items.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- rawgrade — DECIMAL(10, 5)
- rawgrademax — DECIMAL(10, 5) — NOT NULL
- rawgrademin — DECIMAL(10, 5) — NOT NULL
- rawscaleid — BIGINT(10) — Foreign key
- usermodified — BIGINT(10) — Foreign key
- finalgrade — DECIMAL(10, 5)
- hidden — BIGINT(10) — NOT NULL
- locked — BIGINT(10) — NOT NULL
- locktime — BIGINT(10) — NOT NULL
- exported — BIGINT(10) — NOT NULL
- overridden — BIGINT(10) — NOT NULL
- excluded — BIGINT(10) — NOT NULL
- feedback — LONGTEXT
- feedbackformat — BIGINT(10) — NOT NULL
- information — LONGTEXT
- informationformat — BIGINT(10) — NOT NULL
- INDEX — `gradgradhist_act2_ix`
- INDEX — `gradgradhist_tim2_ix`
- INDEX — `gradgradhist_useitetim2_ix`
- INDEX — `gradgradhist_old4_ix`
- INDEX — `gradgradhist_ite4_ix`
- INDEX — `gradgradhist_use6_ix`
- INDEX — `gradgradhist_raw4_ix`
- INDEX — `gradgradhist_use8_ix`
- INDEX — `gradgradhist_log4_ix`
grade_import_newitem
- id — BIGINT(10) — Primary key — NOT NULL
- itemname — VARCHAR(255) — NOT NULL
- importcode — BIGINT(10) — NOT NULL
- importer — BIGINT(10) — Foreign key — NOT NULL
- INDEX — `gradimponewi_imp4_ix`
grade_import_values
- id — BIGINT(10) — Primary key — NOT NULL
- itemid — BIGINT(10) — Foreign key → grade_items.id
- newgradeitem — BIGINT(10) — Foreign key → grade_import_newitem.id
- userid — BIGINT(10) — NOT NULL
- finalgrade — DECIMAL(10, 5)
- feedback — LONGTEXT
- importcode — BIGINT(10) — NOT NULL
- importer — BIGINT(10) — Foreign key
- importonlyfeedback — TINYINT(1)
- INDEX — `gradimpovalu_ite4_ix`
- INDEX — `gradimpovalu_new4_ix`
- INDEX — `gradimpovalu_imp4_ix`
grade_items
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key
- categoryid — BIGINT(10) — Foreign key → grade_categories.id
- itemname — VARCHAR(255)
- itemtype — VARCHAR(30) — NOT NULL
- itemmodule — VARCHAR(30)
- iteminstance — BIGINT(10)
- itemnumber — BIGINT(10)
- iteminfo — LONGTEXT
- idnumber — VARCHAR(255)
- calculation — LONGTEXT
- gradetype — SMALLINT(4) — NOT NULL
- grademax — DECIMAL(10, 5) — NOT NULL
- grademin — DECIMAL(10, 5) — NOT NULL
- scaleid — BIGINT(10) — Foreign key
- outcomeid — BIGINT(10) — Foreign key → grade_outcomes.id
- gradepass — DECIMAL(10, 5) — NOT NULL
- multfactor — DECIMAL(10, 5) — NOT NULL
- plusfactor — DECIMAL(10, 5) — NOT NULL
- aggregationcoef — DECIMAL(10, 5) — NOT NULL
- aggregationcoef2 — DECIMAL(10, 5) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- display — BIGINT(10) — NOT NULL
- decimals — TINYINT(1)
- hidden — BIGINT(10) — NOT NULL
- locked — BIGINT(10) — NOT NULL
- locktime — BIGINT(10) — NOT NULL
- needsupdate — BIGINT(10) — NOT NULL
- weightoverride — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10)
- timemodified — BIGINT(10)
- INDEX — `graditem_locloc2_ix`
- INDEX — `graditem_itenee2_ix`
- INDEX — `graditem_gra2_ix`
- INDEX — `graditem_idncou2_ix`
- INDEX — `graditem_cou4_ix`
- INDEX — `graditem_cat4_ix`
- INDEX — `graditem_sca4_ix`
- INDEX — `graditem_out4_ix`
grade_items_history
- id — BIGINT(10) — Primary key — NOT NULL
- action — BIGINT(10) — NOT NULL
- oldid — BIGINT(10) — Foreign key → grade_items.id — NOT NULL
- source — VARCHAR(255)
- timemodified — BIGINT(10)
- loggeduser — BIGINT(10) — Foreign key
- courseid — BIGINT(10) — Foreign key
- categoryid — BIGINT(10) — Foreign key → grade_categories.id
- itemname — VARCHAR(255)
- itemtype — VARCHAR(30) — NOT NULL
- itemmodule — VARCHAR(30)
- iteminstance — BIGINT(10)
- itemnumber — BIGINT(10)
- iteminfo — LONGTEXT
- idnumber — VARCHAR(255)
- calculation — LONGTEXT
- gradetype — SMALLINT(4) — NOT NULL
- grademax — DECIMAL(10, 5) — NOT NULL
- grademin — DECIMAL(10, 5) — NOT NULL
- scaleid — BIGINT(10) — Foreign key
- outcomeid — BIGINT(10) — Foreign key → grade_outcomes.id
- gradepass — DECIMAL(10, 5) — NOT NULL
- multfactor — DECIMAL(10, 5) — NOT NULL
- plusfactor — DECIMAL(10, 5) — NOT NULL
- aggregationcoef — DECIMAL(10, 5) — NOT NULL
- aggregationcoef2 — DECIMAL(10, 5) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- hidden — BIGINT(10) — NOT NULL
- locked — BIGINT(10) — NOT NULL
- locktime — BIGINT(10) — NOT NULL
- needsupdate — BIGINT(10) — NOT NULL
- display — BIGINT(10) — NOT NULL
- decimals — TINYINT(1)
- weightoverride — TINYINT(1) — NOT NULL
- INDEX — `graditemhist_act2_ix`
- INDEX — `graditemhist_tim2_ix`
- INDEX — `graditemhist_old4_ix`
- INDEX — `graditemhist_cou4_ix`
- INDEX — `graditemhist_cat4_ix`
- INDEX — `graditemhist_sca4_ix`
- INDEX — `graditemhist_out4_ix`
- INDEX — `graditemhist_log4_ix`
grade_letters
- id — BIGINT(10) — Primary key — NOT NULL
- contextid — BIGINT(10) — NOT NULL
- lowerboundary — DECIMAL(10, 5) — NOT NULL
- letter — VARCHAR(255) — NOT NULL
grade_outcomes
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key
- shortname — VARCHAR(255) — NOT NULL
- fullname — LONGTEXT — NOT NULL
- scaleid — BIGINT(10) — Foreign key
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- timecreated — BIGINT(10)
- timemodified — BIGINT(10)
- usermodified — BIGINT(10) — Foreign key
- INDEX — `gradoutc_cou4_ix`
- INDEX — `gradoutc_sca4_ix`
- INDEX — `gradoutc_use4_ix`
grade_outcomes_courses
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key — NOT NULL
- outcomeid — BIGINT(10) — Foreign key → grade_outcomes.id — NOT NULL
- INDEX — `gradoutccour_cou4_ix`
- INDEX — `gradoutccour_out4_ix`
grade_outcomes_history
- id — BIGINT(10) — Primary key — NOT NULL
- action — BIGINT(10) — NOT NULL
- oldid — BIGINT(10) — Foreign key → grade_outcomes.id — NOT NULL
- source — VARCHAR(255)
- timemodified — BIGINT(10)
- loggeduser — BIGINT(10) — Foreign key
- courseid — BIGINT(10) — Foreign key
- shortname — VARCHAR(255) — NOT NULL
- fullname — LONGTEXT — NOT NULL
- scaleid — BIGINT(10) — Foreign key
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- INDEX — `gradoutchist_act2_ix`
- INDEX — `gradoutchist_tim2_ix`
- INDEX — `gradoutchist_old4_ix`
- INDEX — `gradoutchist_cou4_ix`
- INDEX — `gradoutchist_sca4_ix`
- INDEX — `gradoutchist_log4_ix`
grade_settings
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — LONGTEXT
- INDEX — `gradsett_cou4_ix`
grading_areas
- id — BIGINT(10) — Primary key — NOT NULL
- contextid — BIGINT(10) — Foreign key — NOT NULL
- component — VARCHAR(100) — NOT NULL
- areaname — VARCHAR(100) — NOT NULL
- activemethod — VARCHAR(100)
- INDEX — `gradarea_con4_ix`
grading_definitions
- id — BIGINT(10) — Primary key — NOT NULL
- areaid — BIGINT(10) — Foreign key → grading_areas.id — NOT NULL
- method — VARCHAR(100) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2)
- status — BIGINT(10) — NOT NULL
- copiedfromid — BIGINT(10)
- timecreated — BIGINT(10) — NOT NULL
- usercreated — BIGINT(10) — Foreign key — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- usermodified — BIGINT(10) — Foreign key — NOT NULL
- timecopied — BIGINT(10)
- options — LONGTEXT
- INDEX — `graddefi_are4_ix`
- INDEX — `graddefi_use6_ix`
- INDEX — `graddefi_use8_ix`
grading_instances
- id — BIGINT(10) — Primary key — NOT NULL
- definitionid — BIGINT(10) — Foreign key → grading_definitions.id — NOT NULL
- raterid — BIGINT(10) — Foreign key — NOT NULL
- itemid — BIGINT(10)
- rawgrade — DECIMAL(10, 5)
- status — BIGINT(10) — NOT NULL
- feedback — LONGTEXT
- feedbackformat — TINYINT(2)
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `gradinst_def4_ix`
- INDEX — `gradinst_rat4_ix`
groupings
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- configdata — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `grou_idn3_ix`
- INDEX — `grou_cou8_ix`
groupings_groups
- id — BIGINT(10) — Primary key — NOT NULL
- groupingid — BIGINT(10) — Foreign key — NOT NULL
- groupid — BIGINT(10) — Foreign key → groups.id — NOT NULL
- timeadded — BIGINT(10) — NOT NULL
- INDEX — `grougrou_gro6_ix`
- INDEX — `grougrou_gro8_ix`
groups
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- name — VARCHAR(254) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- enrolmentkey — VARCHAR(50)
- picture — BIGINT(10) — NOT NULL
- hidepicture — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `grou_idn2_ix`
- INDEX — `grou_cou5_ix`
groups_members
- id — BIGINT(10) — Primary key — NOT NULL
- groupid — BIGINT(10) — Foreign key → groups.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- timeadded — BIGINT(10) — NOT NULL
- component — VARCHAR(100) — NOT NULL
- itemid — BIGINT(10) — NOT NULL
- INDEX — `groumemb_gro4_ix`
- INDEX — `groumemb_use4_ix`
license
- id — BIGINT(10) — Primary key — NOT NULL
- shortname — VARCHAR(255)
- fullname — LONGTEXT
- source — VARCHAR(255)
- enabled — TINYINT(1) — NOT NULL
- version — BIGINT(10) — NOT NULL
log
- id — BIGINT(10) — Primary key — NOT NULL
- time — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- ip — VARCHAR(45) — NOT NULL
- course — BIGINT(10) — NOT NULL
- module — VARCHAR(20) — NOT NULL
- cmid — BIGINT(10) — NOT NULL
- action — VARCHAR(40) — NOT NULL
- url — VARCHAR(100) — NOT NULL
- info — VARCHAR(255) — NOT NULL
- INDEX — `log_coumodact2_ix`
- INDEX — `log_tim2_ix`
- INDEX — `log_act2_ix`
- INDEX — `log_usecou2_ix`
- INDEX — `log_cmi2_ix`
log_display
- id — BIGINT(10) — Primary key — NOT NULL
- module — VARCHAR(20) — NOT NULL
- action — VARCHAR(40) — NOT NULL
- mtable — VARCHAR(30) — NOT NULL
- field — VARCHAR(200) — NOT NULL
- component — VARCHAR(100) — NOT NULL
log_queries
- id — BIGINT(10) — Primary key — NOT NULL
- qtype — MEDIUMINT(5) — NOT NULL
- sqltext — LONGTEXT — NOT NULL
- sqlparams — LONGTEXT
- error — MEDIUMINT(5) — NOT NULL
- info — LONGTEXT
- backtrace — LONGTEXT
- exectime — DECIMAL(10, 5) — NOT NULL
- timelogged — BIGINT(10) — NOT NULL
message
- id — BIGINT(10) — Primary key — NOT NULL
- useridfrom — BIGINT(10) — NOT NULL
- useridto — BIGINT(10) — NOT NULL
- subject — LONGTEXT
- fullmessage — LONGTEXT
- fullmessageformat — SMALLINT(4)
- fullmessagehtml — LONGTEXT
- smallmessage — LONGTEXT
- notification — TINYINT(1)
- contexturl — LONGTEXT
- contexturlname — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timeuserfromdeleted — BIGINT(10) — NOT NULL
- timeusertodeleted — BIGINT(10) — NOT NULL
- component — VARCHAR(100)
- eventtype — VARCHAR(100)
- INDEX — `mess_useusetimtim2_ix`
- INDEX — `mess_usetimnot3_ix`
- INDEX — `mess_usetimnot4_ix`
message_contacts
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- contactid — BIGINT(10) — NOT NULL
- blocked — TINYINT(1) — NOT NULL
message_processors
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(166) — NOT NULL
- enabled — TINYINT(1) — NOT NULL
message_providers
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- component — VARCHAR(200) — NOT NULL
- capability — VARCHAR(255)
message_read
- id — BIGINT(10) — Primary key — NOT NULL
- useridfrom — BIGINT(10) — Foreign key — NOT NULL
- useridto — BIGINT(10) — Foreign key — NOT NULL
- subject — LONGTEXT
- fullmessage — LONGTEXT
- fullmessageformat — SMALLINT(4)
- fullmessagehtml — LONGTEXT
- smallmessage — LONGTEXT
- notification — TINYINT(1)
- contexturl — LONGTEXT
- contexturlname — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timeread — BIGINT(10) — NOT NULL
- timeuserfromdeleted — BIGINT(10) — NOT NULL
- timeusertodeleted — BIGINT(10) — NOT NULL
- component — VARCHAR(100)
- eventtype — VARCHAR(100)
- INDEX — `messread_useusetimtim2_ix`
- INDEX — `messread_nottim2_ix`
- INDEX — `messread_usetimnot3_ix`
- INDEX — `messread_usetimnot4_ix`
and 70 more tables