ㅇㅇㅇ

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