studip23 contains 941 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
stm_element_types	abbrev	varchar	5	√		null	Kurzname
user_studiengang	abschluss_id	char	32	√		0
lit_catalog	accession_number	varchar	100	√		null
teilnehmer_view	active	tinyint	3	√		null
seminare	admission_binding	tinyint	3	√		null
seminare	admission_endtime	int	10	√		null
seminare	admission_group	varchar	32	√		null
seminare	admission_prelim_txt	text	65535	√		null
seminare	admission_selection_take_place	tinyint	3	√		0
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
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
auth_user_md5	auth_plugin	varchar	64	√		null
px_topics	author	varchar	255	√		null
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
abschluss	beschreibung	text	65535	√		null
studiengaenge	beschreibung	text	65535	√		null
wiki	body	text	65535	√		null
calendar_events	categories	tinytext	255	√		null
message	chat_id	varchar	32	√		null
abschluss	chdate	int	10	√		null
datafields	chdate	int unsigned	10	√		null
datafields_entries	chdate	int unsigned	10	√		null
resources_requests	chdate	int unsigned	10	√		null
resources_requests_properties	chdate	int unsigned	10	√		null
smiley	chdate	int unsigned	10	√		null
stm_abstract	chdate	int	10	√		null	Datum der letzten Aenderung
wiki	chdate	int	10	√		null
resources_requests	closed	tinyint unsigned	3	√		null
vote	co_visibility	bit	0	√		null
log_events	coaffected_range_id	varchar	32	√		null
schedule_seminare	color	varchar	7	√		null	color, rgb in hex
admission_seminar_user	comment	tinytext	255	√		null
resources_requests	comment	text	65535	√		null
datafields_entries	content	text	65535	√		null
scm	content	text	65535	√		null
voteanswers	correct	bit	0	√		null
calendar_events	count	smallint	5	√		0
stm_abstract	credits	tinyint unsigned	3	√		null	Anzahl der Leistungspunkte/Kreditpunkte
stm_abstract_elements	custom_name	varchar	50	√		null	selbstgew
calendar_events	day	tinyint unsigned	3	√		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
plugins	dependentonid	int unsigned	10	√		null
banner_ads	description	varchar	255	√		null
calendar_events	description	text	65535	√		null
ex_termine	description	text	65535	√		null
folder	description	text	65535	√		null
log_actions	description	varchar	64	√		null
px_topics	description	text	65535	√		null
termine	description	text	65535	√		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
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
his_abschl	efh	char	4	√		null
auth_user_md5	Email	varchar	64	√		null
semester_data	ende	int unsigned	10	√		null
calendar_events	exceptions	text	65535	√		null
his_abstgv	fb	char	2	√		null
his_stg	fb	char	2	√		null
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
his_abschl	hrst	char	10	√		null
resources_categories	iconnr	int	10	√		1
stm_abstract	id_number	varchar	10	√		null	alphanummerische Identifikationsnummer f
log_events	info	text	65535	√		null
log_actions	info_template	text	65535	√		null
eval_templates	institution_id	varchar	32	√		null
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
stm_abstract_assign	latest	tinyint	3	√		null	sp
user_info	lebenslauf	text	65535	√		null
seminare	leistungsnachweis	text	65535	√		null
seminare	lernorga	text	65535	√		null
resources_objects	level	int	10	√		null
calendar_events	linterval	smallint unsigned	5	√		null
Institute	lit_plugin_name	varchar	255	√		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
ex_termine	metadate_id	varchar	32	√		null
termine	metadate_id	varchar	32	√		null
abschluss	mkdate	int	10	√		null
datafields	mkdate	int unsigned	10	√		null
datafields_entries	mkdate	int unsigned	10	√		null
resources_requests	mkdate	int unsigned	10	√		null
resources_requests_properties	mkdate	int unsigned	10	√		null
smiley	mkdate	int unsigned	10	√		null
stm_abstract	mkdate	int	10	√		null	Erstellungdatum
Institute	modules	int unsigned	10	√		null
seminare	modules	int unsigned	10	√		null
calendar_events	month	tinyint unsigned	3	√		null
resources_objects	multiple_assign	tinyint	3	√		null
auth_user_md5	Nachname	varchar	64	√		null
datafields	name	varchar	255	√		null
dokumente	name	varchar	255	√		null
px_topics	name	varchar	255	√		null
studiengaenge	name	varchar	255	√		null
lit_list_content	note	text	65535	√		null
datafields	object_class	varchar	10	√		null
datafields	object_type	enum	12	√		null
seminare	Ort	varchar	255	√		null
user_config	parent_id	varchar	32	√		null
his_abschl	part	char	2	√		null
seminare	Passwort	varchar	32	√		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
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
stm_instances	responsible	varchar	32	√		null	ID des Modulverantwortlichen Dozenten
stm_abstract_elements	semester	bit	0	√		null	Sommer od. Winter (Sommer = 1; Winter = 2)
user_studiengang	semester	tinyint	3	√		0
seminare	showscore	tinyint	3	√		0
calendar_events	sinterval	smallint unsigned	5	√		null
seminare	Sonstiges	text	65535	√		null
his_abschl	sortkz1	char	2	√		null
his_abschl	sprache	char	3	√		null
his_pvers	sprache	char	3	√		null
seminare	start_time	int	10	√		0
eval	startdate	int	10	√		null
vote	startdate	int	10	√		null
resources_requests_properties	state	text	65535	√		null
eval	stopdate	int	10	√		null
vote	stopdate	int	10	√		null
range_tree	studip_object	varchar	10	√		null
range_tree	studip_object_id	varchar	32	√		null
sem_tree	studip_object_id	varchar	32	√		null
stm_abstract_text	subtitle	varchar	155	√		null	optionaler Untertitel
stm_instances_text	subtitle	varchar	155	√		null	optionaler Untertitel
seminare	teilnehmer	text	65535	√		null
eval	timespan	int	10	√		null
vote	timespan	int	10	√		null
ex_termine	topic_id	varchar	32	√		null
termine	topic_id	varchar	32	√		null
stm_abstract	turnus	bit	0	√		null	(optional) Angebotsturnus - Modulbeginn
seminare	Untertitel	varchar	255	√		null
resources_assign	user_free_name	varchar	255	√		null
eval_templates	user_id	varchar	32	√		null
wiki	user_id	varchar	32	√		null
seminare	VeranstaltungsNummer	varchar	100	√		null
datafields	view_perms	enum	6	√		null
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
archiv	wikidump	longtext	2147483647	√		null
stm_abstract	workload	smallint unsigned	5	√		null	Studentischer Arbeitsaufwand in Stunden
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
log_actions	active	bit	0			1
banner_ads	ad_id	varchar	32
seminare	admission_disable_waitlist	tinyint unsigned	3			0
seminare	admission_enable_quota	tinyint unsigned	3			0
seminare	admission_endtime_sem	int	10			-1
seminare	admission_prelim	tinyint unsigned	3			0
seminare	admission_starttime	int	10			-1
seminar_user	admission_studiengang_id	varchar	32
seminare	admission_type	int	10			0
stm_abstract_text	aims	text	65535				Lernziele
news	allow_comments	bit	0			0
eval	anonymous	bit	0			1
px_topics	anonymous	tinyint	3			0
vote	anonymous	bit	0			1
voteanswers	answer	varchar	255
voteanswers	answer_id	varchar	32
voteanswers_user	answer_id	varchar	32
message_user	answered	bit	0			0
webservice_access_rules	api_key	varchar	100
archiv	archiv_file_id	varchar	32
resources_assign	assign_id	varchar	32
resources_temporary_events	assign_id	varchar	32
aux_lock_rules	attributes	text	65535
lock_rules	attributes	text	65535
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
banner_ads	banner_path	varchar	255
resources_assign	begin	int	10			0
resources_temporary_events	begin	int	10			0
archiv	beschreibung	text	65535
seminare	Beschreibung	text	65535
seminar_user	bind_calendar	bit	0			1
news	body	text	65535
contact	buddy	tinyint	3			1
statusgruppen	calendar_group	tinyint unsigned	3			0
contact	calpermission	tinyint unsigned	3			1
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
calendar_events	category_intern	tinyint unsigned	3			0
vote	changeable	bit	0			0
session_data	changed	timestamp	19			CURRENT_TIMESTAMP
user_data	changed	timestamp	19			CURRENT_TIMESTAMP
user_visibility	chat	bit	0			1
admission_group	chdate	int unsigned	10
banner_ads	chdate	int	10			0
calendar_events	chdate	int unsigned	10			0
comments	chdate	int	10			0
config	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
lit_catalog	chdate	int	10			0
lit_list	chdate	int	10			0
lit_list_content	chdate	int	10			0
media_cache	chdate	timestamp	19			CURRENT_TIMESTAMP
news	chdate	int unsigned	10			0
object_contentmodules	chdate	int	10			0
object_views	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
seminar_cycle_dates	chdate	int unsigned	10
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
user_config	chdate	int	10			0
user_info	chdate	int	10			0
vote	chdate	int	10			0
wiki_locks	chdate	int	10			0
news	chdate_uid	varchar	32
evalgroup	child_type	enum	18			EvaluationGroup
calendar_events	class	enum	12			PRIVATE
banner_ads	clicks	int	10			0
schedule	color	varchar	7				color, rgb in hex
config	comment	text	65535
seminar_user	comment	varchar	255
user_config	comment	text	65535
comments	comment_id	varchar	32
stm_instances	complete	bit	0			0	Erfassung komplett (0=FALSE)
extern_config	config	mediumtext	16777215
config	config_id	varchar	32
extern_config	config_id	varchar	32
extern_config	config_type	int	10			0
message_user	confirmed_read	bit	0			0
contact	contact_id	varchar	32
contact_userinfo	contact_id	varchar	32
comments	content	text	65535
contact_userinfo	content	text	65535
ex_termine	content	varchar	255
guestbook	content	text	65535
kategorien	content	text	65535
schedule	content	varchar	255
siteinfo_details	content	text	65535
termine	content	varchar	255
evalanswer	counter	int	10			0
voteanswers	counter	int	10			0
stm_instances	creator	varchar	32
seminar_cycle_dates	cycle	tinyint unsigned	3			0
chat_data	data	mediumblob	16777215
datafields	datafield_id	varchar	32
datafields_entries	datafield_id	varchar	32
teilnehmer_view	datafield_id	varchar	40
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
schedule	day	tinyint	3				day of week, 0-6
lit_catalog	dc_creator	varchar	255
lit_catalog	dc_title	varchar	255
user_visibility	default_homepage_visibility	int	10			0
message_user	deleted	bit	0			0
aux_lock_rules	description	text	65535
config	description	varchar	255
dokumente	description	text	65535
lock_rules	description	text	65535
resources_categories	description	text	65535
resources_objects	description	text	65535
resources_properties	description	text	65535
semester_data	description	text	65535
semester_holiday	description	text	65535
seminar_cycle_dates	description	varchar	255
themen	description	text	65535
siteinfo_details	detail_id	smallint unsigned	5		√
dokumente	dokument_id	varchar	32
schema_version	domain	varchar	255
message_user	dont_delete	bit	0			0
dokumente	downloads	int	10			0
archiv	dozenten	varchar	255
archiv	dump	mediumtext	16777215
calendar_events	duration	smallint unsigned	5			0
deputies	edit_about	bit	0			0
calendar_events	editor_id	varchar	32
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
stm_abstract_elements	elementgroup	tinyint	3			0	Kombinationsvariante
Institute	email	varchar	255
user_visibility	email	bit	0			1
user_info	email_forward	tinyint	3			0
plugins	enabled	enum	4			no
calendar_events	end	int unsigned	10			0
resources_assign	end	int	10			0
resources_temporary_events	end	int	10			0
schedule	end	smallint	5				end hour and minutes
ex_termine	end_time	int	10			0
seminar_cycle_dates	end_time	time	8
termine	end_time	int	10			0
banner_ads	enddate	int	10			0
semester_holiday	ende	int unsigned	10			0
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	varchar	32
user_token	expiration	int	10
calendar_events	expire	int unsigned	10			0
news	expire	int	10			0
log_actions	expires	int	10			0
media_cache	expires	timestamp	19			0000-00-00 00:00:00
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
auth_extern	external_user_type	smallint	5			0
user_inst	externdefault	tinyint unsigned	3			0
archiv	fakultaet	varchar	255
Institute	fakultaets_id	varchar	32
smiley	fav_counter	int unsigned	10			0
Institute	fax	varchar	32
user_inst	Fax	varchar	32
rss_feeds	feed_id	varchar	32
rss_feeds	fetch_title	tinyint unsigned	3			0
config	field	varchar	255
user_config	field	varchar	255
dokumente	filename	varchar	255
dokumente	filesize	int	10			0
object_user	flag	varchar	32
message_user	folder	tinyint	3			0
folder	folder_id	varchar	32
lit_list	format	varchar	255
archiv	forumdump	longtext	2147483647
wiki_links	from_keyword	char	128
user_info	geschlecht	tinyint	3			0
admission_group	group_id	varchar	32
eval_group_template	group_type	varchar	250			normal
deputies	gruppe	tinyint	3			0
seminar_user	gruppe	tinyint	3			0
user_info	guestbook	tinyint	3			0
archiv	heimat_inst_id	varchar	32
rss_feeds	hidden	tinyint	3			0
user_info	hobby	varchar	255
semester_holiday	holiday_id	varchar	32
user_info	Home	varchar	200
user_visibility	homepage	text	65535
chat_data	id	int	10			0
media_cache	id	varchar	32
schedule	id	int	10		√
webservice_access_rules	id	int	10		√
calendar_events	importdate	int	10			0
sem_tree	info	text	65535
statusgruppe_user	inherit	tinyint	3			1
user_inst	inst_perms	enum	6			user
Institute	Institut_id	varchar	32
resources_objects	institut_id	varchar	32
seminar_inst	institut_id	varchar	32
seminare	Institut_id	varchar	32			0
user_inst	Institut_id	varchar	32			0
archiv	institute	varchar	255
plugins_default_activations	institutid	varchar	32
webservice_access_rules	ip_range	varchar	200
config	is_default	tinyint	3			0
resources_categories	is_room	tinyint	3			0
extern_config	is_standard	int	10			0
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
object_user_visits	last_visitdate	int	10			0
seminare	Lesezugriff	tinyint	3			0
range_tree	level	int	10			0
eval_templates	likertscale_gfx_type	varchar	255			bars
lit_list_content	list_element_id	varchar	32
lit_list	list_id	varchar	32
lit_list_content	list_id	varchar	32
lit_catalog	lit_plugin	varchar	100			Studip
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
auth_user_md5	locked	bit	0			0
evalgroup	mandatory	bit	0			0
eval_templates	mchoice_scale_gfx_type	varchar	255			bars
message	message	text	65535
message	message_id	varchar	32
message_user	message_id	char	32
config	message_template	varchar	255
resources_requests	metadate_id	varchar	32
schedule_seminare	metadate_id	varchar	32
seminar_cycle_dates	metadate_id	varchar	32
webservice_access_rules	method	varchar	100
admission_group	mkdate	int unsigned	10
admission_seminar_user	mkdate	int	10			0
archiv	mkdate	int	10			0
auto_insert_user	mkdate	int unsigned	10			0
banner_ads	mkdate	int	10			0
calendar_events	mkdate	int unsigned	10			0
comments	mkdate	int	10			0
config	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
guestbook	mkdate	int	10			0
Institute	mkdate	int	10			0
kategorien	mkdate	int	10			0
lit_catalog	mkdate	int	10			0
lit_list	mkdate	int	10			0
lit_list_content	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
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_cycle_dates	mkdate	int unsigned	10
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
user_config	mkdate	int	10			0
user_info	mkdate	int	10			0
user_visibility	mkdate	int	10			0
vote	mkdate	int	10			0
object_contentmodules	module_id	varchar	255
object_contentmodules	module_type	varchar	32
user_info	motto	varchar	255
evalquestion	multiplechoice	bit	0			0
vote	multiplechoice	bit	0			0
abschluss	name	varchar	255
admission_group	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
siteinfo_details	name	varchar	255
siteinfo_rubrics	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
vote	namesvisibility	bit	0			0
plugins	navigationpos	int unsigned	10			0
news	news_id	varchar	32
news_range	news_id	varchar	32
deputies	notification	int	10			0
seminar_user	notification	int	10			0
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
lock_rules	object_type	enum	4			sem
user_visibility	online	bit	0			1
resources_properties	options	text	65535
contact	owner_id	varchar	32
resources_objects	owner_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	varchar	32
folder	permission	tinyint unsigned	3			7
lock_rules	permission	enum	6			dozent
roles_studipperms	permname	varchar	255
auth_user_md5	perms	enum	6			user
resources_user_resources	perms	varchar	10
plugins	pluginclassname	varchar	255
plugins	pluginid	int unsigned	10		√
plugins_activated	pluginid	int unsigned	10			0
plugins_default_activations	pluginid	int unsigned	10			0
roles_plugins	pluginid	int unsigned	10			0
plugins	pluginname	varchar	45
plugins	pluginpath	varchar	255
plugins	plugintype	text	65535
Institute	Plz	varchar	255
plugins_activated	poiid	varchar	255
eval_templates	polscale_gfx_type	varchar	255			bars
config	position	int	10			0
evalanswer	position	int	10			0
evalgroup	position	int	10			0
evalquestion	position	int	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
guestbook	post_id	varchar	32
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
message	priority	enum	7			normal
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
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
dokumente	protected	tinyint	3			0
user_info	publi	text	65535
his_pvers	pvers	smallint	5			0
his_abstgv	pversion	int	10			0
stm_abstract_assign	pversion	varchar	8				Version der Pr
vote	question	text	65535
admission_seminar_studiengang	quota	int	10			0
config	range	enum	7			global
calendar_events	range_id	varchar	32
datafields_entries	range_id	varchar	32
deputies	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
guestbook	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
termin_related_persons	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
news_rss_range	range_type	enum	6			user
object_rate	rate	int	10			0
user_inst	raum	varchar	200
message	readed	bit	0			0
message_user	readed	bit	0			0
message	reading_confirmation	bit	0			0
resources_requests	request_id	varchar	32
resources_requests_properties	request_id	varchar	32
resources_categories_properties	requestable	tinyint	3			0
evalanswer	residual	bit	0			0
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	varchar	32
resources_user_resources	resource_id	varchar	32
vote	resultvisibility	enum	8			ever
roles	roleid	int unsigned	10		√
roles_plugins	roleid	int unsigned	10			0
roles_studipperms	roleid	int unsigned	10			0
roles_user	roleid	int unsigned	10			0
roles	rolename	varchar	80
px_topics	root_id	varchar	32
resources_objects	root_id	varchar	32
evalanswer	rows	tinyint	3			0
news_rss_range	rss_id	char	32
calendar_events	rtype	enum	7			SINGLE
siteinfo_details	rubric_id	smallint unsigned	5
siteinfo_rubrics	rubric_id	smallint unsigned	5		√
seminare	Schreibzugriff	tinyint	3			0
user_info	schwerp	text	65535
scm	scm_id	varchar	32
user_info	score	int unsigned	10			0
user_visibility	search	bit	0			1
datafields_entries	sec_range_id	varchar	32
config	section	varchar	255
statusgruppen	selfassign	tinyint	3			0
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_studiengang	seminar_id	varchar	32
admission_seminar_user	seminar_id	varchar	32
archiv	seminar_id	varchar	32
archiv_user	seminar_id	varchar	32
auto_insert_sem	seminar_id	char	32
auto_insert_user	seminar_id	char	32
dokumente	seminar_id	varchar	32			0
px_topics	Seminar_id	varchar	32
resources_requests	seminar_id	varchar	32
resources_temporary_events	seminar_id	varchar	32
schedule_seminare	seminar_id	varchar	32
seminar_cycle_dates	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
seminare	Seminar_id	varchar	32			0
teilnehmer_view	seminar_id	varchar	40
themen	seminar_id	varchar	32
eval	shared	bit	0			0
smiley	short_counter	int unsigned	10			0
smiley	short_name	varchar	50
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
session_data	sid	varchar	32
user_data	sid	varchar	32
statusgruppen	size	int	10			0
smiley	smiley_counter	int unsigned	10			0
user_info	smiley_favorite	varchar	255
smiley	smiley_height	int	10			0
smiley	smiley_id	int unsigned	10		√
smiley	smiley_name	varchar	50
smiley	smiley_width	int	10			0
user_info	smsforward_copy	bit	0			1
user_info	smsforward_rec	varchar	32
message_user	snd_rec	enum	4			rec
seminar_cycle_dates	sorter	tinyint unsigned	3			0
aux_lock_rules	sorting	text	65535
user_inst	sprechzeiten	varchar	200
Institute	srienabled	tinyint	3			0
calendar_events	start	int unsigned	10			0
schedule	start	smallint	5				start hour and minutes
archiv	start_time	int	10			0
seminar_cycle_dates	start_time	time	8
banner_ads	startdate	int	10			0
plugins_activated	state	enum	3			on
resources_objects_properties	state	text	65535
vote	state	enum	9			new
admission_group	status	tinyint unsigned	3
admission_seminar_user	status	varchar	16
archiv_user	status	enum	6			user
auto_insert_sem	status	enum	6			autor
seminar_user	status	enum	6			user
seminare	status	tinyint unsigned	3			1
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
archiv	studienbereiche	text	65535
admission_seminar_studiengang	studiengang_id	varchar	32
admission_seminar_user	studiengang_id	varchar	32
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
seminar_cycle_dates	sws	decimal	2,1			0.0
stm_abstract_elements	sws	tinyint	3			0	Semesterwochenstunden f
resources_categories	system	tinyint	3			0
resources_categories_properties	system	tinyint	3			0
resources_properties	system	tinyint	3			0
roles	system	enum	2			n
object_contentmodules	system_type	varchar	32
scm	tab_name	varchar	20			Info
banner_ads	target	varchar	255
banner_ads	target_type	enum	7			url
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
resources_temporary_events	termin_id	varchar	32
termine	termin_id	varchar	32
themen_termine	termin_id	varchar	32
eval	text	text	65535
evalanswer	text	text	65535
evalgroup	text	text	65535
evalquestion	text	text	65535
eval	title	varchar	255
evalgroup	title	varchar	255
schedule	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
user_token	token	varchar	32
news	topic	varchar	255
px_topics	topic_id	varchar	32
stm_abstract_text	topics	text	65535				Inhalte (behandelte Themen etc.)
stm_instances_text	topics	text	65535				Inhalte
calendar_events	ts	int unsigned	10			0
chat_data	tstamp	timestamp	19			CURRENT_TIMESTAMP
config	type	enum	8			boolean
datafields	type	enum	9			textline
evalquestion	type	enum	14			multiplechoice
Institute	type	tinyint unsigned	3			0
media_cache	type	varchar	64
object_user_visits	type	enum	19			vote
resources_locks	type	varchar	15
resources_properties	type	set	20			bool
resources_temporary_events	type	varchar	15
sem_tree	type	tinyint unsigned	3
vote	type	enum	5			vote
webservice_access_rules	type	enum	6			allow
datafields	typeparam	text	65535
calendar_events	uid	varchar	255
archiv	untertitel	varchar	255
dokumente	url	varchar	255
Institute	url	varchar	255			http://www.studip.de
rss_feeds	url	text	65535
admission_seminar_user	user_id	varchar	32
archiv_user	user_id	varchar	32
auth_user_md5	user_id	varchar	32
auto_insert_user	user_id	char	32
comments	user_id	varchar	32
contact	user_id	varchar	32
deputies	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
guestbook	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
schedule	user_id	varchar	32
schedule_seminare	user_id	varchar	32
scm	user_id	varchar	32
seminar_user	user_id	varchar	32
statusgruppe_user	user_id	varchar	32
termin_related_persons	user_id	varchar	32
user_config	user_id	varchar	32
user_info	user_id	varchar	32
user_inst	user_id	varchar	32			0
user_studiengang	user_id	varchar	32
user_token	user_id	varchar	32
user_userdomains	user_id	varchar	32
user_visibility	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
session_data	val	mediumtext	16777215
user_data	val	mediumtext	16777215
auth_user_md5	validation_key	varchar	10
config	value	text	65535
evalanswer	value	int	10			0
user_config	value	text	65535
archiv	VeranstaltungsNummer	varchar	32
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
admission_seminar_user	visible	enum	7			unknown
auth_user_md5	visible	enum	7			unknown
eval	visible	bit	0			1
schedule_seminare	visible	bit	0			1
seminar_user	visible	enum	7			unknown
seminare	visible	tinyint unsigned	3			1
statusgruppe_user	visible	tinyint	3			1
user_inst	visible	tinyint unsigned	3			1
object_user_visits	visitdate	int	10			0
vote	vote_id	varchar	32
vote_user	vote_id	varchar	32
voteanswers	vote_id	varchar	32
seminar_cycle_dates	week_offset	tinyint unsigned	3			0
seminar_cycle_dates	weekday	tinyint unsigned	3
stm_abstract_elements	workload	int	10			0