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