Datenbank (Struktur)

Informationen zur Datenbank.

Tabellen

Abkürzungen

In SQL-Abfragen werden Abkürzungen verwendet. Damit diese lesbarer werden, sind sie standardisiert.

Tabelle

Abkürzung

Zugehörigkeit

seit Version/Commit

accept_terms

ac

core

badges

ba

core

block

bl

core

block_instances

bi

core

book

bo

core

bulletinBoard

bb

core

capabilitites

ca

core

certificate

ct

core

comment

cm

core

config

cf

core

config_blocks

ck

core

config_curriculum

cc

core

config_plugin

cl

core

content

ct

core

content_subscriptions

cts

core

context

co

core

countries

cs

core

course_book

cb

core

cronjobs

cr

core

curriculum

cu

core

curriculum_enrolments

ce

core

curriculum_niveaus

cn

core

enablingObjectives

eo

core

enrolment_keys

ek

core

event

ev

core

event_subscriptions

es

core

file_context

fc

core

file_license

fl

core

file_subscriptions

fs

core

file_token

ft

core

files

fi

core

grade

gr

core

groups

gp

core

groups_enrolments

ge

core

help

he

core

institution

ins

core

institution_enrolments

ie

core

log

lo

core

message

me

core

navigator

na

core

navigator_block

nb

core

navigator_view

nv

core

oauth_access_tokens

oat

plugin, oauth2

oauth_authorization_codes

oac

plugin, oauth2

oauth_clients

oc

plugin, oauth2

oauth_jwt

oj

plugin, oauth2

oauth_refresh_tokens

ort

plugin, oauth2

oauth_scopes

os

plugin, oauth2

oauth_users

ou

plugin, oauth2

objective_type

ot

core

parental_authority

pa

core

plugin_repo

pr

core

quiz_answers

qa

core

quiz_question

qq

core

quote

qu

core

quote_subscription

qus

core

reference

re

core

repeat_interval

ri

core

role_capabilities

rc

core

roles

ro

core

schedule

sd

core

schooltype

sc

core

semester

se

core

state

st

core

statistics

sa

core

subjects

su

core

task

ta

core

task_enrolments

te

core

terminalObjectives

ter

core

update

ud

core

user_absence

ub

core

user_accomplished

ua

core

user_list

ul

core

users

us

core

wallet

wa

core

wallet_content

wc

core

wallet_objectives

wo

core

wallet_sharing

ws

core