studip30 contains 1318 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
stm_abstract_types	abbrev	varchar	5				Abkuerzung
his_abschl	abint	char	2
his_abstgv	abschl	char	2
stm_abstract_assign	abschl	char	3				ID eines Studienabschlusses
abschluss	abschluss_id	char	32
log_actions	action_id	varchar	32
log_events	action_id	varchar	32
banner_ads	ad_id	varchar	32
voteanswers	answer	varchar	255
voteanswers	answer_id	varchar	32
voteanswers_user	answer_id	varchar	32
webservice_access_rules	api_key	varchar	100
archiv	archiv_file_id	varchar	32
resources_assign	assign_id	varchar	32
resources_temporary_events	assign_id	char	32
news	author	varchar	255
eval	author_id	varchar	32
themen	author_id	varchar	32
vote	author_id	varchar	32
dokumente	author_name	varchar	255
dokumente	autor_host	varchar	20
calendar_events	autor_id	varchar	32
ex_termine	autor_id	varchar	32
message	autor_id	varchar	32
termine	autor_id	varchar	32
personal_notifications	avatar	varchar	256
banner_ads	banner_path	varchar	255
lit_catalog	catalog_id	varchar	32
lit_list_content	catalog_id	varchar	32
resources_categories	category_id	varchar	32
resources_categories_properties	category_id	varchar	32
resources_objects	category_id	varchar	32
resources_requests	category_id	varchar	32
news	chdate_uid	varchar	32
seminar_user	comment	varchar	255
comments	comment_id	varchar	32
config	config_id	varchar	32
extern_config	config_id	varchar	32
api_consumer_permissions	consumer_id	char	32
api_consumers	consumer_id	char	32
api_user_permissions	consumer_id	char	32
contact	contact_id	varchar	32
contact_userinfo	contact_id	varchar	32
ex_termine	content	varchar	255
termine	content	varchar	255
datafields	datafield_id	varchar	32
datafields_entries	datafield_id	varchar	32
lit_catalog	dc_creator	varchar	255
lit_catalog	dc_title	varchar	255
config	description	varchar	255
seminar_cycle_dates	description	varchar	255
dokumente	dokument_id	varchar	32
schema_version	domain	varchar	255
auto_insert_sem	domain_id	varchar	45
archiv	dozenten	varchar	255
stm_abstract_elements	element_id	varchar	32				ID eines abstrakten Modulbestandzeiles
stm_instances_elements	element_id	varchar	32				ID des abstrakten Modulbestandteils
stm_abstract_elements	element_type_id	varchar	32				um welche Art von Element handelt es sich
stm_element_types	element_type_id	varchar	32				ID des Modulbestandteils
Institute	email	varchar	255
eval	eval_id	varchar	32
eval_range	eval_id	varchar	32
eval_templates_eval	eval_id	varchar	32
eval_templates_user	eval_id	varchar	32
eval_user	eval_id	varchar	32
evalanswer	evalanswer_id	varchar	32
evalanswer_user	evalanswer_id	varchar	32
eval_group_template	evalgroup_id	varchar	32
evalgroup	evalgroup_id	varchar	32
evalquestion	evalquestion_id	varchar	32
calendar_events	event_id	varchar	32
log_events	event_id	varchar	32
resources_temporary_events	event_id	char	32
auth_extern	external_user_category	varchar	32
auth_extern	external_user_id	varchar	32
auth_extern	external_user_name	varchar	64
auth_extern	external_user_password	varchar	32
auth_extern	external_user_system_type	varchar	32
archiv	fakultaet	varchar	255
Institute	fakultaets_id	varchar	32
Institute	fax	varchar	32
user_inst	Fax	varchar	32
rss_feeds	feed_id	varchar	32
config	field	varchar	255
user_config	field	varchar	255
dokumente	filename	varchar	255
object_user	flag	varchar	32
folder	folder_id	varchar	32
lit_list	format	varchar	255
wiki_links	from_keyword	char	128
archiv	heimat_inst_id	varchar	32
user_info	hobby	varchar	255
semester_holiday	holiday_id	varchar	32
user_info	Home	varchar	200
personal_notifications	html_id	varchar	64
Institute	Institut_id	varchar	32
resources_objects	institut_id	varchar	32
roles_user	institut_id	char	32
seminar_inst	institut_id	varchar	32
archiv	institute	varchar	255
plugins_default_activations	institutid	varchar	32
webservice_access_rules	ip_range	varchar	200
themen	issue_id	varchar	32
themen_termine	issue_id	varchar	32
range_tree	item_id	varchar	32
kategorien	kategorie_id	varchar	32
wiki	keyword	varchar	128
wiki_locks	keyword	varchar	128
his_abstgv	kzfa	char	1
seminar_user	label	varchar	128
stm_abstract_text	lang_id	varchar	32				ID der verwendeten Sprache
stm_abstract_types	lang_id	varchar	32				ID der verwendeten Sprache
stm_element_types	lang_id	varchar	32				ID der verwendeten Sprache
stm_instances	lang_id	varchar	32				ID der Sprache in der das Modul angeboten wird
stm_instances_text	lang_id	varchar	32				ID der verwendeten Sprache
lit_list_content	list_element_id	varchar	32
lit_list	list_id	varchar	32
lit_list_content	list_id	varchar	32
user_factorlist	list_id	varchar	32
aux_lock_rules	lock_id	varchar	32
lock_rules	lock_id	varchar	32
resources_locks	lock_id	varchar	32
Institute	lock_rule	varchar	32
user_info	lock_rule	varchar	32
cronjobs_logs	log_id	char	32
message	message_id	varchar	32
message_user	message_id	char	32
config	message_template	varchar	255
resources_requests	metadate_id	varchar	32
webservice_access_rules	method	varchar	100
object_contentmodules	module_id	varchar	255
object_contentmodules	module_type	varchar	32
user_info	motto	varchar	255
abschluss	name	varchar	255
archiv	name	varchar	255
aux_lock_rules	name	varchar	255
contact_userinfo	name	varchar	255
eval_templates	name	varchar	255
extern_config	name	varchar	255
folder	name	varchar	255
Institute	Name	varchar	255
kategorien	name	varchar	255
lit_list	name	varchar	255
lock_rules	name	varchar	255
log_actions	name	varchar	128
range_tree	name	varchar	255
resources_categories	name	varchar	255
resources_objects	name	varchar	255
resources_properties	name	varchar	255
rss_feeds	name	varchar	255
sem_tree	name	varchar	255
semester_data	name	varchar	255
semester_holiday	name	varchar	255
seminare	Name	varchar	255
statusgruppen	name	varchar	255
stm_abstract_types	name	varchar	25				vollstaendige Bezeichnung
stm_element_types	name	varchar	50				Name
userdomains	name	varchar	255
news	news_id	varchar	32
news_range	news_id	varchar	32
comments	object_id	varchar	32
object_contentmodules	object_id	varchar	32
object_rate	object_id	varchar	32
object_user	object_id	varchar	32
object_user_visits	object_id	char	32
object_views	object_id	varchar	32
oauth_consumer_token	oct_name	varchar	64
oauth_server_token	ost_referrer_host	varchar	128
contact	owner_id	varchar	32
resources_objects	owner_id	varchar	32
blubber	parent_id	varchar	32
config	parent_id	varchar	32
evalanswer	parent_id	varchar	32
evalgroup	parent_id	varchar	32
evalquestion	parent_id	varchar	32
px_topics	parent_id	varchar	32
range_tree	parent_id	varchar	32
resources_objects	parent_id	varchar	32
sem_tree	parent_id	varchar	32
auth_user_md5	password	varbinary	64
roles_studipperms	permname	varchar	255
resources_user_resources	perms	varchar	10
plugins	pluginclassname	varchar	255
plugins	pluginname	varchar	45
plugins	pluginpath	varchar	255
Institute	Plz	varchar	255
plugins_activated	poiid	varchar	36
user_info	privadr	varchar	64
user_info	privatcell	varchar	32
user_info	privatnr	varchar	32
resources_categories_properties	property_id	varchar	32
resources_objects_properties	property_id	varchar	32
resources_properties	property_id	varchar	32
resources_requests_properties	property_id	varchar	32
stm_abstract_assign	pversion	varchar	8				Version der Pr
calendar_events	range_id	varchar	32
datafields_entries	range_id	varchar	32
dokumente	range_id	varchar	32
eval_range	range_id	varchar	32
ex_termine	range_id	varchar	32
extern_config	range_id	varchar	32
folder	range_id	varchar	32
kategorien	range_id	varchar	32
lit_list	range_id	varchar	32
news_range	range_id	varchar	32
news_rss_range	range_id	char	32
scm	range_id	varchar	32
statusgruppen	range_id	varchar	32
termine	range_id	varchar	32
vote	range_id	varchar	32
wiki	range_id	varchar	32
wiki_links	range_id	char	32
wiki_locks	range_id	varchar	32
user_inst	raum	varchar	200
resources_requests	request_id	varchar	32
resources_requests_properties	request_id	varchar	32
ex_termine	resource_id	varchar	32
resources_assign	resource_id	varchar	32
resources_objects	resource_id	varchar	32
resources_objects_properties	resource_id	varchar	32
resources_requests	resource_id	varchar	32
resources_temporary_events	resource_id	char	32
resources_user_resources	resource_id	varchar	32
roles	rolename	varchar	80
blubber	root_id	varchar	32
px_topics	root_id	varchar	32
resources_objects	root_id	varchar	32
news_rss_range	rss_id	char	32
participantrestrictedadmissions	rule_id	varchar	32
cronjobs_logs	schedule_id	char	32
cronjobs_schedules	schedule_id	char	32
scm	scm_id	varchar	32
datafields_entries	sec_range_id	varchar	32
config	section	varchar	255
stm_instances_elements	sem_id	varchar	32				ID der konkreten Veranstaltung
sem_tree	sem_tree_id	varchar	32
seminar_sem_tree	sem_tree_id	varchar	32
archiv	semester	varchar	16
semester_data	semester_id	varchar	32
semester_holiday	semester_id	varchar	32
stm_instances	semester_id	varchar	32				ID des ersten Semesters in dem die Instanz stattfindet
semester_data	semester_token	varchar	10
admission_seminar_user	seminar_id	varchar	32
archiv	seminar_id	varchar	32
archiv_user	seminar_id	varchar	32
blubber	Seminar_id	varchar	32
px_topics	Seminar_id	varchar	32
resources_requests	seminar_id	varchar	32
seminar_inst	seminar_id	varchar	32
seminar_sem_tree	seminar_id	varchar	32
seminar_user	Seminar_id	varchar	32
seminar_userdomains	seminar_id	varchar	32
themen	seminar_id	varchar	32
smiley	short_name	varchar	50
session_data	sid	varchar	32
user_info	smiley_favorite	varchar	255
smiley	smiley_name	varchar	50
user_info	smsforward_rec	varchar	32
user_inst	sprechzeiten	varchar	200
admission_seminar_user	status	varchar	16
statusgruppe_user	statusgruppe_id	varchar	32
statusgruppen	statusgruppe_id	varchar	32
his_abstgv	stg	char	3
his_stg	stg	char	3
stm_abstract_assign	stg	char	3				ID eines Studienprogramms/-fachs
stm_abstract	stm_abstr_id	varchar	32
stm_abstract_assign	stm_abstr_id	varchar	32
stm_abstract_elements	stm_abstr_id	varchar	32				ID eines abstrakten Studienmodules
stm_abstract_text	stm_abstr_id	varchar	32				ID des abstrakten Studienmodules
stm_instances	stm_abstr_id	varchar	32				ID eines abstrakten Studienmodules
stm_instances	stm_instance_id	varchar	32				ID eines konkreten Studienmodules
stm_instances_elements	stm_instance_id	varchar	32				ID eines konkreten Studienmodules
stm_instances_text	stm_instance_id	varchar	32				ID eines konkreten Studienmodules
stm_abstract_assign	stm_type_id	varchar	32				ID eines Modultyps
stm_abstract_types	stm_type_id	varchar	32				ID eines Modultyps
Institute	Strasse	varchar	255
studiengaenge	studiengang_id	varchar	32
user_studiengang	studiengang_id	varchar	32
his_abstgv	studip_studiengang	varchar	32
auth_extern	studip_user_id	varchar	32
message	subject	varchar	255
calendar_events	summary	varchar	255
object_contentmodules	system_type	varchar	32
banner_ads	target	varchar	255
cronjobs_schedules	task_id	char	32
cronjobs_tasks	task_id	char	32
Institute	telefon	varchar	32
user_inst	Telefon	varchar	32
eval_templates	template_id	varchar	32
eval_templates_eval	template_id	varchar	32
eval_templates_user	template_id	varchar	32
evalgroup	template_id	varchar	32
ex_termine	termin_id	varchar	32
resources_requests	termin_id	varchar	32
termine	termin_id	varchar	32
themen_termine	termin_id	varchar	32
eval	title	varchar	255
evalgroup	title	varchar	255
stm_abstract_text	title	varchar	155				Allgemeiner Modultitel (Name des Moduls)
stm_instances_text	title	varchar	155				Allgemeiner Modultitel
themen	title	varchar	255
vote	title	varchar	100
user_info	title_front	varchar	64
user_info	title_rear	varchar	64
wiki_links	to_keyword	char	128
news	topic	varchar	255
blubber	topic_id	varchar	32
px_topics	topic_id	varchar	32
resources_locks	type	varchar	15
calendar_events	uid	varchar	255
archiv	untertitel	varchar	255
dokumente	url	varchar	255
personal_notifications	url	varchar	512
admission_seminar_user	user_id	varchar	32
api_oauth_user_mapping	user_id	char	32
api_user_permissions	user_id	char	32
archiv_user	user_id	varchar	32
auth_user_md5	user_id	varchar	32
blubber	user_id	varchar	32
comments	user_id	varchar	32
contact	user_id	varchar	32
dokumente	user_id	varchar	32
eval_group_template	user_id	varchar	32
eval_templates_user	user_id	varchar	32
eval_user	user_id	varchar	32
evalanswer_user	user_id	varchar	32
folder	user_id	varchar	32
lit_catalog	user_id	varchar	32
lit_list	user_id	varchar	32
lit_list_content	user_id	varchar	32
lock_rules	user_id	varchar	32
log_events	user_id	varchar	32
message_user	user_id	char	32
news	user_id	varchar	32
object_user	user_id	varchar	32
object_user_visits	user_id	char	32
px_topics	user_id	varchar	32
resources_requests	user_id	varchar	32
resources_user_resources	user_id	varchar	32
rss_feeds	user_id	varchar	32
scm	user_id	varchar	32
seminar_user	user_id	varchar	32
statusgruppe_user	user_id	varchar	32
user_config	user_id	varchar	32
user_factorlist	user_id	varchar	32
user_info	user_id	varchar	32
user_studiengang	user_id	varchar	32
user_userdomains	user_id	varchar	32
user_visibility_settings	user_id	varchar	32
vote_user	user_id	varchar	32
voteanswers_user	user_id	varchar	32
wiki_locks	user_id	varchar	32
user_config	userconfig_id	varchar	32
seminar_userdomains	userdomain_id	varchar	32
user_userdomains	userdomain_id	varchar	32
userdomains	userdomain_id	varchar	32
roles_user	userid	char	32
contact_userinfo	userinfo_id	varchar	32
auth_user_md5	username	varchar	64
auth_user_md5	validation_key	varchar	10
archiv	VeranstaltungsNummer	varchar	32
vote	vote_id	varchar	32
vote_user	vote_id	varchar	32
voteanswers	vote_id	varchar	32
user_studiengang	abschluss_id	char	32			0
admissionrules	active	bit	0			0
api_consumers	active	bit	0			0
cronjobs_schedules	active	bit	0			0
cronjobs_tasks	active	bit	0			0
seminare	admission_disable_waitlist	tinyint unsigned	3			0
seminare	admission_disable_waitlist_move	tinyint unsigned	3			0
seminare	admission_prelim	tinyint unsigned	3			0
sem_classes	admission_prelim_default	tinyint	3			0
sem_classes	admission_type_default	tinyint	3			0
seminare	admission_waitlist_max	int unsigned	10			0
coursesets	algorithm_run	bit	0			0
news	allow_comments	bit	0			0
forum_entries	anonymous	tinyint	3			0
px_topics	anonymous	tinyint	3			0
message_user	answered	bit	0			0
forum_entries	area	tinyint	3			0
cronjobs_tasks	assigned_count	int unsigned	10			0
seminare	aux_lock_rule_forced	tinyint	3			0
resources_assign	begin	int	10			0
resources_temporary_events	begin	int	10			0
statusgruppen	calendar_group	tinyint unsigned	3			0
calendar_events	category_intern	tinyint unsigned	3			0
vote	changeable	bit	0			0
admissionfactor	chdate	int	10			0
banner_ads	chdate	int	10			0
blubber	chdate	int	10			0
calendar_events	chdate	int unsigned	10			0
comments	chdate	int	10			0
conditionaladmissions	chdate	int	10			0
config	chdate	int	10			0
coursesets	chdate	int	10			0
dokumente	chdate	int	10			0
eval	chdate	int	10			0
ex_termine	chdate	int	10			0
extern_config	chdate	int	10			0
folder	chdate	int	10			0
Institute	chdate	int	10			0
kategorien	chdate	int	10			0
limitedadmissions	chdate	int	10			0
lit_catalog	chdate	int	10			0
lit_list	chdate	int	10			0
lit_list_content	chdate	int	10			0
lockedadmissions	chdate	int	10			0
news	chdate	int unsigned	10			0
object_contentmodules	chdate	int	10			0
object_views	chdate	int	10			0
participantrestrictedadmissions	chdate	int	10			0
passwordadmissions	chdate	int	10			0
priorities	chdate	int	10			0
px_topics	chdate	int	10			0
resources_assign	chdate	int	10			0
resources_objects	chdate	int	10			0
rss_feeds	chdate	int	10			0
scm	chdate	int	10			0
seminare	chdate	int	10			0
statusgruppen	chdate	int	10			0
studiengaenge	chdate	int	10			0
termine	chdate	int	10			0
themen	chdate	int unsigned	10			0
timedadmissions	chdate	int	10			0
user_config	chdate	int	10			0
user_info	chdate	int	10			0
userfilter	chdate	int	10			0
userfilter_fields	chdate	int	10			0
vote	chdate	int	10			0
wiki_locks	chdate	int	10			0
banner_ads	clicks	int	10			0
forum_entries	closed	bit	0			0
stm_instances	complete	bit	0			0	Erfassung komplett (0=FALSE)
conditionaladmissions	conditions_stopped	bit	0			0
extern_config	config_type	int	10			0
message_user	confirmed_read	bit	0			0
calendar_events	count	smallint	5	√		0
evalanswer	counter	int	10			0
voteanswers	counter	int	10			0
seminar_cycle_dates	cycle	tinyint unsigned	3			0
ex_termine	date	int	10			0
news	date	int	10			0
termine	date	int	10			0
ex_termine	date_typ	tinyint	3			0
termine	date_typ	tinyint	3			0
user_visibility	default_homepage_visibility	int	10			0
blubber_streams	defaultstream	tinyint	3			0
message_user	deleted	bit	0			0
participantrestrictedadmissions	distribution_time	int	10			0
dokumente	downloads	int	10			0
calendar_events	duration	smallint unsigned	5			0
deputies	edit_about	bit	0			0
stm_abstract_elements	elementgroup	tinyint	3			0	Kombinationsvariante
user_info	email_forward	tinyint	3			0
calendar_events	end	int unsigned	10			0
resources_assign	end	int	10			0
resources_temporary_events	end	int	10			0
conditionaladmissions	end_time	int	10			0
ex_termine	end_time	int	10			0
limitedadmissions	end_time	int	10			0
passwordadmissions	end_time	int	10			0
termine	end_time	int	10			0
timedadmissions	end_time	int	10			0
banner_ads	enddate	int	10			0
semester_holiday	ende	int unsigned	10			0
cronjobs_schedules	execution_count	bigint unsigned	20			0
cronjobs_tasks	execution_count	bigint unsigned	20			0
calendar_events	expire	int unsigned	10			0
news	expire	int	10			0
log_actions	expires	int	10			0
blubber	external_contact	tinyint	3			0
blubber_mentions	external_contact	tinyint	3			0
blubber_reshares	external_contact	tinyint	3			0
auth_extern	external_user_type	smallint	5			0
user_inst	externdefault	tinyint unsigned	3			0
smiley	fav_counter	int unsigned	10			0
rss_feeds	fetch_title	tinyint unsigned	3			0
dokumente	filesize	int	10			0
message_user	folder	tinyint	3			0
user_info	geschlecht	tinyint	3			0
api_consumer_permissions	granted	bit	0			0
api_user_permissions	granted	bit	0			0
deputies	gruppe	tinyint	3			0
seminar_user	gruppe	tinyint	3			0
user_info	guestbook	tinyint	3			0
rss_feeds	hidden	tinyint	3			0
calendar_events	importdate	int	10			0
seminare	Institut_id	varchar	32			0
user_inst	Institut_id	varchar	32			0
config	is_default	tinyint	3			0
datafields	is_required	tinyint	3			0
resources_categories	is_room	tinyint	3			0
extern_config	is_standard	int	10			0
mail_queue_entries	last_try	int	10			0
object_user_visits	last_visitdate	int	10			0
seminare	Lesezugriff	tinyint	3			0
range_tree	level	int	10			0
auth_user_md5	locked	bit	0			0
evalgroup	mandatory	bit	0			0
limitedadmissions	maxnumber	int	10			0
admission_condition	mkdate	int	10			0
admission_seminar_user	mkdate	int	10			0
admissionfactor	mkdate	int	10			0
admissionrule_inst	mkdate	int	10			0
admissionrules	mkdate	int	10			0
archiv	mkdate	int	10			0
auto_insert_user	mkdate	int unsigned	10			0
banner_ads	mkdate	int	10			0
blubber	mkdate	int	10			0
calendar_events	mkdate	int unsigned	10			0
comments	mkdate	int	10			0
conditionaladmissions	mkdate	int	10			0
config	mkdate	int	10			0
courseset_factorlist	mkdate	int	10			0
coursesets	mkdate	int	10			0
dokumente	mkdate	int	10			0
eval	mkdate	int	10			0
ex_termine	mkdate	int	10			0
extern_config	mkdate	int	10			0
folder	mkdate	int	10			0
Institute	mkdate	int	10			0
kategorien	mkdate	int	10			0
limitedadmissions	mkdate	int	10			0
lit_catalog	mkdate	int	10			0
lit_list	mkdate	int	10			0
lit_list_content	mkdate	int	10			0
lockedadmissions	mkdate	int	10			0
log_events	mkdate	int	10			0
message	mkdate	int	10			0
message_user	mkdate	int unsigned	10			0
news	mkdate	int unsigned	10			0
object_contentmodules	mkdate	int	10			0
object_rate	mkdate	int	10			0
object_user	mkdate	int	10			0
participantrestrictedadmissions	mkdate	int	10			0
passwordadmissions	mkdate	int	10			0
personal_notifications	mkdate	int unsigned	10			0
priorities	mkdate	int	10			0
px_topics	mkdate	int	10			0
resources_assign	mkdate	int	10			0
resources_objects	mkdate	int	10			0
resources_temporary_events	mkdate	int	10			0
rss_feeds	mkdate	int	10			0
scm	mkdate	int	10			0
seminar_courseset	mkdate	int	10			0
seminar_user	mkdate	int	10			0
seminare	mkdate	int	10			0
statusgruppen	mkdate	int	10			0
studiengaenge	mkdate	int	10			0
termine	mkdate	int	10			0
themen	mkdate	int unsigned	10			0
timedadmissions	mkdate	int	10			0
user_config	mkdate	int	10			0
user_info	mkdate	int	10			0
user_visibility	mkdate	int	10			0
userfilter	mkdate	int	10			0
userfilter_fields	mkdate	int	10			0
vote	mkdate	int	10			0
evalquestion	multiplechoice	bit	0			0
vote	multiplechoice	bit	0			0
vote	namesvisibility	bit	0			0
plugins	navigationpos	int unsigned	10			0
cronjobs_schedules	next_execution	int unsigned	10			0
deputies	notification	int	10			0
seminar_user	notification	int	10			0
oauth_server_registry	osr_application_commercial	bit	0			0
oauth_server_token	ost_authorized	bit	0			0
plugins_activated	pluginid	int unsigned	10			0
plugins_default_activations	pluginid	int unsigned	10			0
roles_plugins	pluginid	int unsigned	10			0
forum_categories	pos	int	10			0
forum_categories_entries	pos	int	10			0
config	position	int	10			0
evalanswer	position	int	10			0
evalgroup	position	int	10			0
evalquestion	position	int	10			0
scm	position	int unsigned	10			0
seminar_user	position	int	10			0
statusgruppe_user	position	int	10			0
statusgruppen	position	int	10			0
stm_abstract_elements	position	tinyint	3			0	Reihenfolge
voteanswers	position	int	10			0
api_consumers	priority	int unsigned	10			0
banner_ads	priority	int	10			0
calendar_events	priority	tinyint unsigned	3			0
contact_userinfo	priority	int	10			0
datafields	priority	tinyint unsigned	3			0
dokumente	priority	smallint unsigned	5			0
folder	priority	smallint unsigned	5			0
kategorien	priority	int	10			0
lit_list	priority	smallint	5			0
lit_list_content	priority	smallint	5			0
priorities	priority	int	10			0
range_tree	priority	int	10			0
rss_feeds	priority	int	10			0
sem_tree	priority	tinyint	3			0
themen	priority	smallint unsigned	5			0
user_inst	priority	tinyint unsigned	3			0
coursesets	private	bit	0			0
dokumente	protected	tinyint	3			0
his_pvers	pvers	smallint	5			0
his_abstgv	pversion	int	10			0
object_rate	rate	int	10			0
message	readed	bit	0			0
message_user	readed	bit	0			0
message	reading_confirmation	bit	0			0
resources_categories_properties	requestable	tinyint	3			0
evalanswer	residual	bit	0			0
roles_plugins	roleid	int unsigned	10			0
roles_studipperms	roleid	int unsigned	10			0
roles_user	roleid	int unsigned	10			0
evalanswer	rows	tinyint	3			0
seminare	Schreibzugriff	tinyint	3			0
user_info	score	int unsigned	10			0
personal_notifications_user	seen	bit	0			0
statusgruppen	selfassign	tinyint	3			0
user_studiengang	semester	tinyint	3	√		0
dokumente	seminar_id	varchar	32			0
seminare	Seminar_id	varchar	32			0
eval	shared	bit	0			0
smiley	short_counter	int unsigned	10			0
seminare	showscore	tinyint	3	√		0
statusgruppen	size	int	10			0
smiley	smiley_counter	int unsigned	10			0
smiley	smiley_height	int	10			0
smiley	smiley_width	int	10			0
seminar_cycle_dates	sorter	tinyint unsigned	3			0
Institute	srienabled	tinyint	3			0
calendar_events	start	int unsigned	10			0
archiv	start_time	int	10			0
conditionaladmissions	start_time	int	10			0
limitedadmissions	start_time	int	10			0
passwordadmissions	start_time	int	10			0
seminare	start_time	int	10	√		0
timedadmissions	start_time	int	10			0
banner_ads	startdate	int	10			0
forum_entries	sticky	int	10			0
stm_abstract_elements	sws	tinyint	3			0	Semesterwochenstunden f
api_consumers	system	bit	0			0
resources_categories	system	tinyint	3			0
resources_categories_properties	system	tinyint	3			0
resources_properties	system	tinyint	3			0
calendar_events	ts	int unsigned	10			0
Institute	type	tinyint unsigned	3			0
user_inst	user_id	varchar	32			0
evalanswer	value	int	10			0
schema_version	version	int	10			0
wiki	version	int	10			0
banner_ads	views	int	10			0
object_views	views	int	10			0
lit_list	visibility	tinyint	3			0
object_user_visits	visitdate	int	10			0
seminar_cycle_dates	week_offset	tinyint unsigned	3			0
stm_abstract_elements	workload	int	10			0
seminar_cycle_dates	sws	decimal	2,1			0.0
media_cache	expires	timestamp	19			0000-00-00 00:00:00
log_actions	active	bit	0			1
eval	anonymous	bit	0			1
vote	anonymous	bit	0			1
seminar_user	bind_calendar	bit	0			1
contact	buddy	tinyint	3			1
contact	calpermission	tinyint unsigned	3			1
user_visibility	email	bit	0			1
resources_categories	iconnr	int	10	√		1
statusgruppe_user	inherit	tinyint	3			1
user_visibility	online	bit	0			1
oauth_server_registry	osr_enabled	bit	0			1
user_visibility	search	bit	0			1
eval_templates	show_graphics	bit	0			1
eval_templates	show_group_headline	bit	0			1
eval_templates	show_questionblock_headline	bit	0			1
eval_templates	show_questions	bit	0			1
eval_templates	show_total_stats	bit	0			1
user_info	smsforward_copy	bit	0			1
seminare	status	tinyint unsigned	3			1
eval	visible	bit	0			1
schedule_seminare	visible	bit	0			1
seminare	visible	tinyint unsigned	3			1
statusgruppe_user	visible	tinyint	3			1
user_inst	visible	tinyint unsigned	3			1
admissionfactor	factor	decimal	5,2			1.00
folder	permission	tinyint unsigned	3			7
oauth_consumer_token	oct_token_ttl	datetime	19			9999-12-31 00:00:00
oauth_server_token	ost_token_ttl	datetime	19			9999-12-31 00:00:00
blubber_streams	sort	enum	9			age
webservice_access_rules	type	enum	6			allow
blubber_external_contact	contact_type	varchar	16			anonymous
auto_insert_sem	status	enum	6			autor
eval_templates	likertscale_gfx_type	varchar	255			bars
eval_templates	mchoice_scale_gfx_type	varchar	255			bars
eval_templates	polscale_gfx_type	varchar	255			bars
resources_properties	type	set	20			bool
config	type	enum	8			boolean
session_data	changed	timestamp	19			CURRENT_TIMESTAMP
media_cache	chdate	timestamp	19			CURRENT_TIMESTAMP
oauth_consumer_registry	ocr_timestamp	timestamp	19			CURRENT_TIMESTAMP
oauth_consumer_token	oct_timestamp	timestamp	19			CURRENT_TIMESTAMP
oauth_log	olg_timestamp	timestamp	19			CURRENT_TIMESTAMP
oauth_server_registry	osr_timestamp	timestamp	19			CURRENT_TIMESTAMP
oauth_server_token	ost_timestamp	timestamp	19			CURRENT_TIMESTAMP
lock_rules	permission	enum	6			dozent
evalgroup	child_type	enum	18			EvaluationGroup
vote	resultvisibility	enum	8			ever
config	range	enum	7			global
oauth_consumer_registry	ocr_signature_methods	varchar	128			HMAC-SHA1,PLAINTEXT
Institute	url	varchar	255			http://www.studip.de
scm	tab_name	varchar	20			Info
evalquestion	type	enum	14			multiplechoice
roles	system	enum	2			n
vote	state	enum	9			new
plugins	enabled	enum	4			no
eval_group_template	group_type	varchar	250			normal
cronjobs_schedules	priority	enum	6			normal
message	priority	enum	7			normal
stm_element_types	abbrev	varchar	5	√		null	Kurzname
lit_catalog	accession_number	varchar	100	√		null
sem_classes	admin	varchar	64	√		null
seminare	admission_binding	tinyint	3	√		null
seminare	admission_prelim_txt	text	65535	√		null
seminare	admission_turnout	int	10	√		null
log_events	affected_range_id	varchar	32	√		null
his_abschl	aikz	char	1	√		null
his_pvers	aikz	char	1	√		null
stm_abstract_text	aims	text	65535				Lernziele
coursesets	algorithm	varchar	255
banner_ads	alttext	varchar	255	√		null
his_abschl	anzstg	smallint	5	√		null
his_abschl	anzstgmin	smallint	5	√		null
seminare	art	varchar	255	√		null
resources_assign	assign_user_id	varchar	32	√		null
his_abschl	astat	char	2	√		null
aux_lock_rules	attributes	text	65535
lock_rules	attributes	text	65535
api_consumers	auth_key	varchar	64	√		null
api_consumers	auth_secret	varchar	64	√		null
forum_entries	author	varchar	255
px_topics	author	varchar	255	√		null
blubber	author_host	varchar	255	√		null
forum_entries	author_host	varchar	255
px_topics	author_host	varchar	255	√		null
seminare	aux_lock_rule	varchar	32	√		null
semester_data	beginn	int unsigned	10	√		null
semester_holiday	beginn	int unsigned	10	√		null
sem_classes	bereiche	tinyint	3
abschluss	beschreibung	text	65535	√		null
archiv	beschreibung	text	65535
seminare	Beschreibung	text	65535
studiengaenge	beschreibung	text	65535	√		null
news	body	text	65535
wiki	body	text	65535	√		null
sem_classes	calendar	varchar	64	√		null
api_consumers	callback	varchar	255	√		null
calendar_events	categories	tinytext	255	√		null
user_visibility_settings	category	varchar	128
forum_categories	category_id	varchar	32
forum_categories_entries	category_id	varchar	32
message	chat_id	varchar	32	√		null
abschluss	chdate	int	10	√		null
api_consumers	chdate	int unsigned	10
api_user_permissions	chdate	int unsigned	10
blubber_external_contact	chdate	bigint	19
blubber_reshares	chdate	int	10
blubber_streams	chdate	bigint	19
courseset_institute	chdate	int	10	√		null
cronjobs_schedules	chdate	int unsigned	10
datafields	chdate	int unsigned	10	√		null
datafields_entries	chdate	int unsigned	10	√		null
forum_entries	chdate	int	10
mail_queue_entries	chdate	bigint	19
opengraphdata	chdate	bigint	19
resources_requests	chdate	int unsigned	10	√		null
resources_requests_properties	chdate	int unsigned	10	√		null
sem_classes	chdate	bigint	19
sem_types	chdate	bigint	19
seminar_cycle_dates	chdate	int unsigned	10
smiley	chdate	int unsigned	10	√		null
stm_abstract	chdate	int	10	√		null	Datum der letzten Aenderung
userlimits	chdate	int	10	√		null
wiki	chdate	int	10	√		null
cronjobs_tasks	class	varchar	255
log_actions	class	varchar	255	√		null
sem_types	class	int	10
resources_requests	closed	tinyint unsigned	3	√		null
vote	co_visibility	bit	0	√		null
log_events	coaffected_range_id	varchar	32	√		null
schedule	color	varchar	7				color, rgb in hex
schedule_seminare	color	varchar	7	√		null	color, rgb in hex
admission_seminar_user	comment	tinytext	255	√		null
config	comment	text	65535
resources_requests	comment	text	65535	√		null
user_config	comment	text	65535
resources_assign	comment_internal	text	65535	√		null
api_consumers	commercial	bit	0	√		null
sem_classes	compact_mode	tinyint	3
userfilter_fields	compare_op	varchar	255
extern_config	config	mediumtext	16777215
api_consumers	contact	varchar	255	√		null
comments	content	text	65535
contact_userinfo	content	text	65535
datafields_entries	content	text	65535	√		null
forum_entries	content	text	65535
kategorien	content	text	65535
schedule	content	varchar	255
scm	content	text	65535	√		null
siteinfo_details	content	text	65535
voteanswers	correct	bit	0	√		null
sem_classes	course_creation_forbidden	tinyint	3
sem_classes	create_description	text	65535
stm_instances	creator	varchar	32
stm_abstract	credits	tinyint unsigned	3	√		null	Anzahl der Leistungspunkte/Kreditpunkte
stm_abstract_elements	custom_name	varchar	50	√		null	selbstgew
blubber_external_contact	data	text	65535	√		null
opengraphdata	data	text	65535
calendar_events	day	tinyint unsigned	3	√		null
cronjobs_schedules	day	tinyint	3	√		null
schedule	day	tinyint	3				day of week, 0-6
cronjobs_schedules	day_of_week	bit	0	√		null
log_events	dbg_info	text	65535	√		null
lit_catalog	dc_contributor	varchar	255	√		null
lit_catalog	dc_coverage	varchar	255	√		null
lit_catalog	dc_date	date	10	√		null
lit_catalog	dc_description	text	65535	√		null
lit_catalog	dc_format	varchar	100	√		null
lit_catalog	dc_identifier	varchar	255	√		null
lit_catalog	dc_language	varchar	10	√		null
lit_catalog	dc_publisher	varchar	255	√		null
lit_catalog	dc_relation	varchar	255	√		null
lit_catalog	dc_rights	varchar	255	√		null
lit_catalog	dc_source	varchar	255	√		null
lit_catalog	dc_subject	varchar	255	√		null
lit_catalog	dc_type	varchar	100	√		null
sem_classes	default_read_level	int	10
sem_classes	default_write_level	int	10
plugins	dependentonid	int unsigned	10	√		null
forum_entries	depth	int	10
api_consumers	description	text	65535	√		null
aux_lock_rules	description	text	65535
banner_ads	description	varchar	255	√		null
blubber	description	text	65535	√		null
calendar_events	description	text	65535	√		null
cronjobs_schedules	description	varchar	4096	√		null
datafields	description	text	65535
dokumente	description	text	65535
ex_termine	description	text	65535	√		null
folder	description	text	65535	√		null
lock_rules	description	text	65535
log_actions	description	varchar	64	√		null
opengraphdata	description	text	65535	√		null
px_topics	description	text	65535	√		null
resources_categories	description	text	65535
resources_objects	description	text	65535
resources_properties	description	text	65535
sem_classes	description	text	65535
semester_data	description	text	65535
semester_holiday	description	text	65535
termine	description	text	65535	√		null
themen	description	text	65535
siteinfo_details	detail_id	smallint unsigned	5		√
sem_classes	documents	varchar	64	√		null
his_abschl	dtxt	char	25	√		null
his_abstgv	dtxt	varchar	50	√		null
his_pvers	dtxt	char	25	√		null
his_stg	dtxt	varchar	25	√		null
archiv	dump	mediumtext	16777215
cronjobs_logs	duration	float	12
stm_abstract	duration	varchar	155	√		null
seminare	duration_time	int	10	√		null
stm_abstract_assign	earliest	tinyint	3	√		null	fr
seminare	ects	varchar	32	√		null
datafields	edit_perms	enum	6	√		null
calendar_events	editor_id	varchar	32
his_abschl	efh	char	4	√		null
sem_classes	elearning_interface	varchar	64	√		null
api_consumers	email	varchar	255	√		null
auth_user_md5	Email	varchar	64	√		null
schedule	end	smallint	5				end hour and minutes
seminar_cycle_dates	end_time	time	8
semester_data	ende	int unsigned	10	√		null
forum_categories	entry_name	varchar	255
blubber_events_queue	event_type	varchar	32
cronjobs_logs	exception	text	65535	√		null
calendar_events	exceptions	text	65535	√		null
cronjobs_logs	executed	int unsigned	10
user_token	expiration	int	10
blubber_external_contact	external_contact_id	varchar	32
blubber_follower	external_contact_id	varchar	32
courseset_factorlist	factorlist_id	varchar	32
his_abstgv	fb	char	2	√		null
his_stg	fb	char	2	√		null
userfilter_fields	field_id	varchar	32
cronjobs_tasks	filename	varchar	255
log_actions	filename	varchar	255	√		null
blubber_streams	filter_courses	text	65535	√		null
blubber_streams	filter_groups	text	65535	√		null
blubber_streams	filter_hashtags	text	65535	√		null
admission_condition	filter_id	varchar	32
userfilter	filter_id	varchar	32
userfilter_fields	filter_id	varchar	32
blubber_streams	filter_nohashtags	text	65535	√		null
blubber_streams	filter_type	text	65535	√		null
blubber_streams	filter_users	text	65535	√		null
sem_classes	forum	varchar	64	√		null
archiv	forumdump	longtext	2147483647
stm_abstract_text	hints	text	65535	√		null
stm_instances_text	hints	text	65535	√		null
stm_abstract	homeinst	varchar	32	√		null
stm_instances	homeinst	varchar	32	√		null	ID des anbietenden Institutes
user_visibility	homepage	text	65535
cronjobs_schedules	hour	tinyint	3	√		null
his_abschl	hrst	char	10	√		null
admissionrules	id	int	10		√
media_cache	id	varchar	32
schedule	id	int	10		√
sem_classes	id	int	10		√
sem_types	id	int	10		√
webservice_access_rules	id	int	10		√
stm_abstract	id_number	varchar	10	√		null	alphanummerische Identifikationsnummer f
user_visibility_settings	identifier	varchar	64
opengraphdata	image	varchar	1024	√		null
log_events	info	text	65535	√		null
sem_tree	info	text	65535
log_actions	info_template	text	65535	√		null
coursesets	infotext	text	65535
admissionrule_inst	institute_id	varchar	32
courseset_institute	institute_id	varchar	32
eval_templates	institution_id	varchar	32	√		null
opengraphdata	is_opengraph	tinyint	3	√		null
forum_entries_issues	issue_id	varchar	32
blubber_events_queue	item_id	varchar	32
his_abschl	ktxt	char	10	√		null
his_abstgv	ktxt	varchar	50	√		null
his_pvers	ktxt	char	10	√		null
his_stg	ktxt	varchar	10	√		null
eval_templates	kurzbeschreibung	varchar	255	√		null
his_abschl	kzfaarray	char	10	√		null
his_abstgv	kzfaarray	char	3	√		null
cronjobs_schedules	last_execution	int unsigned	10	√		null
user_online	last_lifesign	int unsigned	10
cronjobs_schedules	last_result	text	65535	√		null
opengraphdata	last_update	bigint	19
forum_visits	last_visitdate	int	10
stm_abstract_assign	latest	tinyint	3	√		null	sp
forum_entries	latest_chdate	int	10	√		null
user_info	lebenslauf	text	65535	√		null
blubber_follower	left_follows_right	bit	0
seminare	leistungsnachweis	text	65535	√		null
seminare	lernorga	text	65535	√		null
resources_objects	level	int	10	√		null
forum_entries	lft	int	10
calendar_events	linterval	smallint unsigned	5	√		null
admissionfactor	list_id	varchar	32
Institute	lit_plugin_name	varchar	255	√		null
sem_classes	literature	varchar	64	√		null
calendar_events	location	tinytext	255	√		null
resources_locks	lock_begin	int unsigned	10	√		null
auth_user_md5	lock_comment	varchar	255	√		null
resources_locks	lock_end	int unsigned	10	√		null
seminare	lock_rule	varchar	32	√		null
resources_objects	lockable	tinyint	3	√		null
auth_user_md5	locked_by	varchar	32	√		null
his_abstgv	login_part	char	2	√		null
his_abschl	ltxt	char	100	√		null
his_abstgv	ltxt	varchar	100	√		null
his_pvers	ltxt	char	50	√		null
his_stg	ltxt	varchar	100	√		null
his_abschl	mag_laa	char	1	√		null
mail_queue_entries	mail	text	65535
blubber_external_contact	mail_identifier	varchar	256	√		null
mail_queue_entries	mail_queue_id	varchar	32
userlimits	maxnumber	int	10	√		null
conditionaladmissions	message	text	65535	√		null
limitedadmissions	message	text	65535
lockedadmissions	message	text	65535
message	message	text	65535
participantrestrictedadmissions	message	text	65535
passwordadmissions	message	text	65535	√		null
timedadmissions	message	text	65535
mail_queue_entries	message_id	varchar	32	√		null
ex_termine	metadate_id	varchar	32	√		null
schedule_seminare	metadate_id	varchar	32
seminar_cycle_dates	metadate_id	varchar	32
termine	metadate_id	varchar	32	√		null
api_consumer_permissions	method	char	6
cronjobs_schedules	minute	tinyint	3	√		null
abschluss	mkdate	int	10	√		null
api_consumers	mkdate	int unsigned	10
api_oauth_user_mapping	mkdate	int unsigned	10
api_user_permissions	mkdate	int unsigned	10
blubber_events_queue	mkdate	int	10
blubber_external_contact	mkdate	bigint	19
blubber_mentions	mkdate	int	10
blubber_streams	mkdate	bigint	19
courseset_institute	mkdate	int	10	√		null
courseset_rule	mkdate	int	10	√		null
cronjobs_schedules	mkdate	int unsigned	10
datafields	mkdate	int unsigned	10	√		null
datafields_entries	mkdate	int unsigned	10	√		null
forum_entries	mkdate	int	10
mail_queue_entries	mkdate	bigint	19
opengraphdata	mkdate	bigint	19
resources_requests	mkdate	int unsigned	10	√		null
resources_requests_properties	mkdate	int unsigned	10	√		null
sem_classes	mkdate	bigint	19
sem_types	mkdate	bigint	19
seminar_cycle_dates	mkdate	int unsigned	10
smiley	mkdate	int unsigned	10	√		null
stm_abstract	mkdate	int	10	√		null	Erstellungdatum
user_factorlist	mkdate	int	10	√		null
userlimits	mkdate	int	10	√		null
Institute	modules	int unsigned	10	√		null
sem_classes	modules	text	65535
seminare	modules	int unsigned	10	√		null
calendar_events	month	tinyint unsigned	3	√		null
cronjobs_schedules	month	tinyint	3	√		null
resources_objects	multiple_assign	tinyint	3	√		null
auth_user_md5	Nachname	varchar	64	√		null
admissionfactor	name	varchar	255
blubber	name	varchar	255	√		null
blubber_external_contact	name	varchar	256
blubber_streams	name	varchar	32
coursesets	name	varchar	255
datafields	name	varchar	255	√		null
dokumente	name	varchar	255	√		null
forum_entries	name	varchar	255
px_topics	name	varchar	255	√		null
sem_classes	name	varchar	64
sem_types	name	varchar	64
siteinfo_details	name	varchar	255
siteinfo_rubrics	name	varchar	255
studiengaenge	name	varchar	255	√		null
user_visibility_settings	name	varchar	128
statusgruppen	name_m	varchar	255	√		null
statusgruppen	name_w	varchar	255	√		null
lit_list_content	note	text	65535	√		null
api_consumers	notes	text	65535	√		null
api_oauth_user_mapping	oauth_id	int unsigned	10		√
datafields	object_class	varchar	10	√		null
datafields	object_type	enum	12	√		null
oauth_consumer_registry	ocr_access_token_uri	varchar	255
oauth_consumer_registry	ocr_authorize_uri	varchar	255
oauth_consumer_registry	ocr_consumer_key	varchar	128
oauth_consumer_registry	ocr_consumer_secret	varchar	128
oauth_consumer_registry	ocr_id	int	10		√
oauth_consumer_registry	ocr_request_token_uri	varchar	255
oauth_consumer_registry	ocr_server_uri	varchar	128
oauth_consumer_registry	ocr_server_uri_host	varchar	128
oauth_consumer_registry	ocr_server_uri_path	varchar	128
oauth_consumer_registry	ocr_usa_id_ref	int	10	√		null
oauth_consumer_token	oct_id	int	10		√
oauth_consumer_token	oct_ocr_id_ref	int	10
oauth_consumer_token	oct_token	varchar	128
oauth_consumer_token	oct_token_secret	varchar	128
oauth_consumer_token	oct_token_type	enum	10	√		null
oauth_consumer_token	oct_usa_id_ref	int	10
oauth_log	olg_base_string	text	65535
oauth_log	olg_id	int	10		√
oauth_log	olg_notes	text	65535
oauth_log	olg_ocr_consumer_key	varchar	64	√		null
oauth_log	olg_oct_token	varchar	64	√		null
oauth_log	olg_osr_consumer_key	varchar	64	√		null
oauth_log	olg_ost_token	varchar	64	√		null
oauth_log	olg_received	text	65535
oauth_log	olg_remote_ip	bigint	19
oauth_log	olg_sent	text	65535
oauth_log	olg_usa_id_ref	int	10	√		null
sem_classes	only_inst_user	tinyint	3
resources_properties	options	text	65535
seminare	Ort	varchar	255	√		null
oauth_server_nonce	osn_consumer_key	varchar	64
oauth_server_nonce	osn_id	int	10		√
oauth_server_nonce	osn_nonce	varchar	80
oauth_server_nonce	osn_timestamp	bigint	19
oauth_server_nonce	osn_token	varchar	64
oauth_server_registry	osr_application_descr	text	65535
oauth_server_registry	osr_application_notes	text	65535
oauth_server_registry	osr_application_title	varchar	80
oauth_server_registry	osr_application_type	varchar	20
oauth_server_registry	osr_application_uri	varchar	255
oauth_server_registry	osr_callback_uri	varchar	255
oauth_server_registry	osr_consumer_key	varchar	64
oauth_server_registry	osr_consumer_secret	varchar	64
oauth_server_registry	osr_id	int	10		√
oauth_server_registry	osr_issue_date	datetime	19
oauth_server_registry	osr_requester_email	varchar	64
oauth_server_registry	osr_requester_name	varchar	64
oauth_server_registry	osr_status	varchar	16
oauth_server_registry	osr_usa_id_ref	int	10	√		null
oauth_server_token	ost_callback_url	varchar	512	√		null
oauth_server_token	ost_id	int	10		√
oauth_server_token	ost_osr_id_ref	int	10
oauth_server_token	ost_token	varchar	64
oauth_server_token	ost_token_secret	varchar	64
oauth_server_token	ost_token_type	enum	8	√		null
oauth_server_token	ost_usa_id_ref	int	10
oauth_server_token	ost_verifier	char	10	√		null
cronjobs_logs	output	text	65535	√		null
sem_classes	overview	varchar	64	√		null
admissionfactor	owner_id	varchar	32
cronjobs_schedules	parameters	text	65535	√		null
user_config	parent_id	varchar	32	√		null
user_visibility_settings	parent_id	int	10
his_abschl	part	char	2	√		null
sem_classes	participants	varchar	64	√		null
passwordadmissions	password	varchar	255	√		null
personal_notifications	personal_notification_id	int	10		√
personal_notifications_user	personal_notification_id	int unsigned	10
user_visibility_settings	plugin	int	10	√		null
plugins	pluginid	int unsigned	10		√
plugins	plugintype	text	65535
blubber_streams	pool_courses	text	65535	√		null
blubber_streams	pool_groups	text	65535	√		null
blubber_streams	pool_hashtags	text	65535	√		null
admission_seminar_user	position	int	10	√		null
siteinfo_details	position	tinyint unsigned	3	√		null
siteinfo_rubrics	position	tinyint unsigned	3	√		null
user_info	preferred_language	varchar	20	√		null
user_info	publi	text	65535
vote	question	text	65535
deputies	range_id	varchar	32
termin_related_persons	range_id	varchar	32
ex_termine	raum	varchar	255	√		null
termine	raum	varchar	255	√		null
stm_abstract_assign	recommed	tinyint	3	√		null	empfohlener Zpkt.
his_abschl	refabint	char	2	√		null
his_pvers	refpvers	smallint	5	√		null
his_abstgv	regelstz	tinyint	3	√		null
resources_assign	repeat_day_of_month	int	10	√		null
resources_assign	repeat_day_of_week	int	10	√		null
resources_assign	repeat_end	int	10	√		null
resources_assign	repeat_interval	int	10	√		null
resources_assign	repeat_month_of_year	int	10	√		null
resources_assign	repeat_quantity	int	10	√		null
resources_assign	repeat_week_of_month	int	10	√		null
resources_requests	reply_comment	text	65535	√		null
sem_classes	resources	varchar	64	√		null
stm_instances	responsible	varchar	32	√		null	ID des Modulverantwortlichen Dozenten
forum_entries	rgt	int	10
roles	roleid	int unsigned	10		√
api_consumer_permissions	route_id	char	32
siteinfo_details	rubric_id	smallint unsigned	5
siteinfo_rubrics	rubric_id	smallint unsigned	5		√
admission_condition	rule_id	varchar	32
admissionrule_inst	rule_id	varchar	32
conditionaladmissions	rule_id	varchar	32
courseset_rule	rule_id	varchar	32
limitedadmissions	rule_id	varchar	32
lockedadmissions	rule_id	varchar	32
passwordadmissions	rule_id	varchar	32
timedadmissions	rule_id	varchar	32
userlimits	rule_id	varchar	32
admissionrules	ruletype	varchar	255
sem_classes	schedule	varchar	64	√		null
cronjobs_logs	scheduled	int unsigned	10
user_info	schwerp	text	65535
sem_classes	scm	varchar	64	√		null
stm_abstract_elements	semester	bit	0	√		null	Sommer od. Winter (Sommer = 1; Winter = 2)
auto_insert_sem	seminar_id	char	32
auto_insert_user	seminar_id	char	32
folder	seminar_id	varchar	32
forum_categories	seminar_id	varchar	32
forum_entries	seminar_id	varchar	32
forum_visits	seminar_id	varchar	32
priorities	seminar_id	varchar	32
schedule_seminare	seminar_id	varchar	32
seminar_courseset	seminar_id	varchar	32
seminar_cycle_dates	seminar_id	varchar	32
courseset_factorlist	set_id	varchar	32
courseset_institute	set_id	varchar	32
courseset_rule	set_id	varchar	32
coursesets	set_id	varchar	32
priorities	set_id	varchar	32
seminar_courseset	set_id	varchar	32
sem_classes	show_browse	tinyint	3
calendar_events	sinterval	smallint unsigned	5	√		null
smiley	smiley_id	int unsigned	10		√
seminare	Sonstiges	text	65535	√		null
aux_lock_rules	sorting	text	65535
his_abschl	sortkz1	char	2	√		null
his_abschl	sprache	char	3	√		null
his_pvers	sprache	char	3	√		null
schedule	start	smallint	5				start hour and minutes
seminar_cycle_dates	start_time	time	8
eval	startdate	int	10	√		null
vote	startdate	int	10	√		null
resources_objects_properties	state	text	65535
resources_requests_properties	state	text	65535	√		null
user_visibility_settings	state	int	10	√		null
termin_related_groups	statusgruppe_id	varchar	45
eval	stopdate	int	10	√		null
vote	stopdate	int	10	√		null
blubber_streams	stream_id	varchar	32
archiv	studienbereiche	text	65535
range_tree	studip_object	varchar	10	√		null
range_tree	studip_object_id	varchar	32	√		null
sem_tree	studip_object_id	varchar	32	√		null
blubber_follower	studip_user_id	varchar	32
sem_classes	studygroup_mode	tinyint	3
stm_abstract_text	subtitle	varchar	155	√		null	optionaler Untertitel
stm_instances_text	subtitle	varchar	155	√		null	optionaler Untertitel
blubber_tags	tag	varchar	128
seminare	teilnehmer	text	65535	√		null
termin_related_groups	termin_id	varchar	32
eval	text	text	65535
evalanswer	text	text	65535
evalgroup	text	text	65535
evalquestion	text	text	65535
personal_notifications	text	text	65535
eval	timespan	int	10	√		null
vote	timespan	int	10	√		null
api_consumers	title	varchar	128	√		null
cronjobs_schedules	title	varchar	255	√		null
opengraphdata	title	text	65535	√		null
schedule	title	varchar	255
sem_classes	title_autor	varchar	64	√		null
sem_classes	title_autor_plural	varchar	64	√		null
sem_classes	title_dozent	varchar	64	√		null
sem_classes	title_dozent_plural	varchar	64	√		null
sem_classes	title_tutor	varchar	64	√		null
sem_classes	title_tutor_plural	varchar	64	√		null
user_token	token	varchar	32
sem_classes	topic_create_autor	tinyint	3
blubber_mentions	topic_id	varchar	32
blubber_reshares	topic_id	varchar	32
blubber_tags	topic_id	varchar	32
ex_termine	topic_id	varchar	32	√		null
forum_abo_users	topic_id	varchar	32
forum_categories_entries	topic_id	varchar	32
forum_entries	topic_id	varchar	32
forum_entries_issues	topic_id	varchar	32
forum_favorites	topic_id	varchar	32
forum_likes	topic_id	varchar	32
termine	topic_id	varchar	32	√		null
stm_abstract_text	topics	text	65535				Inhalte (behandelte Themen etc.)
stm_instances_text	topics	text	65535				Inhalte
mail_queue_entries	tries	int	10
stm_abstract	turnus	bit	0	√		null	(optional) Angebotsturnus - Modulbeginn
sem_classes	turnus_default	int	10
courseset_rule	type	varchar	255	√		null
log_actions	type	enum	6	√		null
media_cache	type	varchar	64
opengraphdata	type	varchar	64	√		null
sem_tree	type	tinyint unsigned	3
userfilter_fields	type	varchar	255
datafields	typeparam	text	65535
seminare	Untertitel	varchar	255	√		null
api_consumers	url	varchar	255	√		null
opengraphdata	url	varchar	255
rss_feeds	url	text	65535
resources_assign	user_free_name	varchar	255	√		null
auto_insert_user	user_id	char	32
blubber_mentions	user_id	varchar	32
blubber_reshares	user_id	varchar	32
blubber_streams	user_id	varchar	32
coursesets	user_id	varchar	32
deputies	user_id	varchar	32
eval_templates	user_id	varchar	32	√		null
forum_abo_users	user_id	varchar	32
forum_entries	user_id	varchar	32
forum_favorites	user_id	varchar	32
forum_likes	user_id	varchar	32
forum_visits	user_id	varchar	32
mail_queue_entries	user_id	varchar	32	√		null
personal_notifications_user	user_id	binary	32
priorities	user_id	varchar	32
schedule	user_id	varchar	32
schedule_seminare	user_id	varchar	32
termin_related_persons	user_id	varchar	32
user_online	user_id	char	32
user_token	user_id	varchar	32
user_visibility	user_id	varchar	32
userlimits	user_id	varchar	32
wiki	user_id	varchar	32	√		null
session_data	val	mediumtext	16777215
config	value	text	65535
user_config	value	text	65535
userfilter_fields	value	varchar	255
seminare	VeranstaltungsNummer	varchar	100	√		null
datafields	view_perms	enum	6	√		null
user_visibility_settings	visibilityid	int	10		√
sem_classes	visible	tinyint	3
forum_visits	visitdate	int	10
semester_data	vorles_beginn	int unsigned	10	√		null
semester_data	vorles_ende	int unsigned	10	√		null
auth_user_md5	Vorname	varchar	64	√		null
seminare	vorrausetzungen	text	65535	√		null
vote_user	votedate	int	10	√		null
voteanswers_user	votedate	int	10	√		null
calendar_events	wdays	varchar	7	√		null
seminar_cycle_dates	weekday	tinyint unsigned	3
sem_classes	wiki	varchar	64	√		null
archiv	wikidump	longtext	2147483647	√		null
sem_classes	workgroup_mode	tinyint	3
stm_abstract	workload	smallint unsigned	5	√		null	Studentischer Arbeitsaufwand in Stunden
sem_classes	write_access_nobody	tinyint	3
plugins_activated	state	enum	3			on
cronjobs_schedules	type	enum	9			periodic
calendar_events	class	enum	12			PRIVATE
blubber	context_type	enum	7			public
message_user	snd_rec	enum	4			rec
lock_rules	object_type	enum	4			sem
calendar_events	rtype	enum	7			SINGLE
auth_user_md5	auth_plugin	varchar	64	√		standard
api_consumers	consumer_type	enum	6			studip
lit_catalog	lit_plugin	varchar	100			Studip
datafields	type	enum	9			textline
admission_seminar_user	visible	enum	7			unknown
auth_user_md5	visible	enum	7			unknown
seminar_user	visible	enum	7			unknown
banner_ads	target_type	enum	7			url
user_inst	inst_perms	enum	6			user
auth_user_md5	perms	enum	6			user
news_rss_range	range_type	enum	6			user
archiv_user	status	enum	6			user
seminar_user	status	enum	6			user
object_user_visits	type	enum	19			vote
vote	type	enum	5			vote
api_consumers	type	enum	8	√		website