studip23 contains 941 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
abschluss	abschluss_id	char	32
abschluss	beschreibung	text	65535	√		null
abschluss	chdate	int	10	√		null
abschluss	mkdate	int	10	√		null
abschluss	name	varchar	255
admission_group	chdate	int unsigned	10
admission_group	group_id	varchar	32
admission_group	mkdate	int unsigned	10
admission_group	name	varchar	255
admission_group	status	tinyint unsigned	3
admission_seminar_studiengang	quota	int	10			0
admission_seminar_studiengang	seminar_id	varchar	32
admission_seminar_studiengang	studiengang_id	varchar	32
admission_seminar_user	comment	tinytext	255	√		null
admission_seminar_user	mkdate	int	10			0
admission_seminar_user	position	int	10	√		null
admission_seminar_user	seminar_id	varchar	32
admission_seminar_user	status	varchar	16
admission_seminar_user	studiengang_id	varchar	32
admission_seminar_user	user_id	varchar	32
admission_seminar_user	visible	enum	7			unknown
archiv	archiv_file_id	varchar	32
archiv	beschreibung	text	65535
archiv	dozenten	varchar	255
archiv	dump	mediumtext	16777215
archiv	fakultaet	varchar	255
archiv	forumdump	longtext	2147483647
archiv	heimat_inst_id	varchar	32
archiv	institute	varchar	255
archiv	mkdate	int	10			0
archiv	name	varchar	255
archiv	semester	varchar	16
archiv	seminar_id	varchar	32
archiv	start_time	int	10			0
archiv	studienbereiche	text	65535
archiv	untertitel	varchar	255
archiv	VeranstaltungsNummer	varchar	32
archiv	wikidump	longtext	2147483647	√		null
archiv_user	seminar_id	varchar	32
archiv_user	status	enum	6			user
archiv_user	user_id	varchar	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
auth_extern	external_user_type	smallint	5			0
auth_extern	studip_user_id	varchar	32
auth_user_md5	auth_plugin	varchar	64	√		null
auth_user_md5	Email	varchar	64	√		null
auth_user_md5	lock_comment	varchar	255	√		null
auth_user_md5	locked	bit	0			0
auth_user_md5	locked_by	varchar	32	√		null
auth_user_md5	Nachname	varchar	64	√		null
auth_user_md5	password	varchar	32
auth_user_md5	perms	enum	6			user
auth_user_md5	user_id	varchar	32
auth_user_md5	username	varchar	64
auth_user_md5	validation_key	varchar	10
auth_user_md5	visible	enum	7			unknown
auth_user_md5	Vorname	varchar	64	√		null
auto_insert_sem	seminar_id	char	32
auto_insert_sem	status	enum	6			autor
auto_insert_user	mkdate	int unsigned	10			0
auto_insert_user	seminar_id	char	32
auto_insert_user	user_id	char	32
aux_lock_rules	attributes	text	65535
aux_lock_rules	description	text	65535
aux_lock_rules	lock_id	varchar	32
aux_lock_rules	name	varchar	255
aux_lock_rules	sorting	text	65535
banner_ads	ad_id	varchar	32
banner_ads	alttext	varchar	255	√		null
banner_ads	banner_path	varchar	255
banner_ads	chdate	int	10			0
banner_ads	clicks	int	10			0
banner_ads	description	varchar	255	√		null
banner_ads	enddate	int	10			0
banner_ads	mkdate	int	10			0
banner_ads	priority	int	10			0
banner_ads	startdate	int	10			0
banner_ads	target	varchar	255
banner_ads	target_type	enum	7			url
banner_ads	views	int	10			0
calendar_events	autor_id	varchar	32
calendar_events	categories	tinytext	255	√		null
calendar_events	category_intern	tinyint unsigned	3			0
calendar_events	chdate	int unsigned	10			0
calendar_events	class	enum	12			PRIVATE
calendar_events	count	smallint	5	√		0
calendar_events	day	tinyint unsigned	3	√		null
calendar_events	description	text	65535	√		null
calendar_events	duration	smallint unsigned	5			0
calendar_events	editor_id	varchar	32
calendar_events	end	int unsigned	10			0
calendar_events	event_id	varchar	32
calendar_events	exceptions	text	65535	√		null
calendar_events	expire	int unsigned	10			0
calendar_events	importdate	int	10			0
calendar_events	linterval	smallint unsigned	5	√		null
calendar_events	location	tinytext	255	√		null
calendar_events	mkdate	int unsigned	10			0
calendar_events	month	tinyint unsigned	3	√		null
calendar_events	priority	tinyint unsigned	3			0
calendar_events	range_id	varchar	32
calendar_events	rtype	enum	7			SINGLE
calendar_events	sinterval	smallint unsigned	5	√		null
calendar_events	start	int unsigned	10			0
calendar_events	summary	varchar	255
calendar_events	ts	int unsigned	10			0
calendar_events	uid	varchar	255
calendar_events	wdays	varchar	7	√		null
chat_data	data	mediumblob	16777215
chat_data	id	int	10			0
chat_data	tstamp	timestamp	19			CURRENT_TIMESTAMP
comments	chdate	int	10			0
comments	comment_id	varchar	32
comments	content	text	65535
comments	mkdate	int	10			0
comments	object_id	varchar	32
comments	user_id	varchar	32
config	chdate	int	10			0
config	comment	text	65535
config	config_id	varchar	32
config	description	varchar	255
config	field	varchar	255
config	is_default	tinyint	3			0
config	message_template	varchar	255
config	mkdate	int	10			0
config	parent_id	varchar	32
config	position	int	10			0
config	range	enum	7			global
config	section	varchar	255
config	type	enum	8			boolean
config	value	text	65535
contact	buddy	tinyint	3			1
contact	calpermission	tinyint unsigned	3			1
contact	contact_id	varchar	32
contact	owner_id	varchar	32
contact	user_id	varchar	32
contact_userinfo	contact_id	varchar	32
contact_userinfo	content	text	65535
contact_userinfo	name	varchar	255
contact_userinfo	priority	int	10			0
contact_userinfo	userinfo_id	varchar	32
datafields	chdate	int unsigned	10	√		null
datafields	datafield_id	varchar	32
datafields	edit_perms	enum	6	√		null
datafields	mkdate	int unsigned	10	√		null
datafields	name	varchar	255	√		null
datafields	object_class	varchar	10	√		null
datafields	object_type	enum	12	√		null
datafields	priority	tinyint unsigned	3			0
datafields	type	enum	9			textline
datafields	typeparam	text	65535
datafields	view_perms	enum	6	√		null
datafields_entries	chdate	int unsigned	10	√		null
datafields_entries	content	text	65535	√		null
datafields_entries	datafield_id	varchar	32
datafields_entries	mkdate	int unsigned	10	√		null
datafields_entries	range_id	varchar	32
datafields_entries	sec_range_id	varchar	32
deputies	edit_about	bit	0			0
deputies	gruppe	tinyint	3			0
deputies	notification	int	10			0
deputies	range_id	varchar	32
deputies	user_id	varchar	32
dokumente	author_name	varchar	255
dokumente	autor_host	varchar	20
dokumente	chdate	int	10			0
dokumente	description	text	65535
dokumente	dokument_id	varchar	32
dokumente	downloads	int	10			0
dokumente	filename	varchar	255
dokumente	filesize	int	10			0
dokumente	mkdate	int	10			0
dokumente	name	varchar	255	√		null
dokumente	priority	smallint unsigned	5			0
dokumente	protected	tinyint	3			0
dokumente	range_id	varchar	32
dokumente	seminar_id	varchar	32			0
dokumente	url	varchar	255
dokumente	user_id	varchar	32
eval	anonymous	bit	0			1
eval	author_id	varchar	32
eval	chdate	int	10			0
eval	eval_id	varchar	32
eval	mkdate	int	10			0
eval	shared	bit	0			0
eval	startdate	int	10	√		null
eval	stopdate	int	10	√		null
eval	text	text	65535
eval	timespan	int	10	√		null
eval	title	varchar	255
eval	visible	bit	0			1
eval_group_template	evalgroup_id	varchar	32
eval_group_template	group_type	varchar	250			normal
eval_group_template	user_id	varchar	32
eval_range	eval_id	varchar	32
eval_range	range_id	varchar	32
eval_templates	institution_id	varchar	32	√		null
eval_templates	kurzbeschreibung	varchar	255	√		null
eval_templates	likertscale_gfx_type	varchar	255			bars
eval_templates	mchoice_scale_gfx_type	varchar	255			bars
eval_templates	name	varchar	255
eval_templates	polscale_gfx_type	varchar	255			bars
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
eval_templates	template_id	varchar	32
eval_templates	user_id	varchar	32	√		null
eval_templates_eval	eval_id	varchar	32
eval_templates_eval	template_id	varchar	32
eval_templates_user	eval_id	varchar	32
eval_templates_user	template_id	varchar	32
eval_templates_user	user_id	varchar	32
eval_user	eval_id	varchar	32
eval_user	user_id	varchar	32
evalanswer	counter	int	10			0
evalanswer	evalanswer_id	varchar	32
evalanswer	parent_id	varchar	32
evalanswer	position	int	10			0
evalanswer	residual	bit	0			0
evalanswer	rows	tinyint	3			0
evalanswer	text	text	65535
evalanswer	value	int	10			0
evalanswer_user	evalanswer_id	varchar	32
evalanswer_user	user_id	varchar	32
evalgroup	child_type	enum	18			EvaluationGroup
evalgroup	evalgroup_id	varchar	32
evalgroup	mandatory	bit	0			0
evalgroup	parent_id	varchar	32
evalgroup	position	int	10			0
evalgroup	template_id	varchar	32
evalgroup	text	text	65535
evalgroup	title	varchar	255
evalquestion	evalquestion_id	varchar	32
evalquestion	multiplechoice	bit	0			0
evalquestion	parent_id	varchar	32
evalquestion	position	int	10			0
evalquestion	text	text	65535
evalquestion	type	enum	14			multiplechoice
ex_termine	autor_id	varchar	32
ex_termine	chdate	int	10			0
ex_termine	content	varchar	255
ex_termine	date	int	10			0
ex_termine	date_typ	tinyint	3			0
ex_termine	description	text	65535	√		null
ex_termine	end_time	int	10			0
ex_termine	metadate_id	varchar	32	√		null
ex_termine	mkdate	int	10			0
ex_termine	range_id	varchar	32
ex_termine	raum	varchar	255	√		null
ex_termine	resource_id	varchar	32
ex_termine	termin_id	varchar	32
ex_termine	topic_id	varchar	32	√		null
extern_config	chdate	int	10			0
extern_config	config	mediumtext	16777215
extern_config	config_id	varchar	32
extern_config	config_type	int	10			0
extern_config	is_standard	int	10			0
extern_config	mkdate	int	10			0
extern_config	name	varchar	255
extern_config	range_id	varchar	32
folder	chdate	int	10			0
folder	description	text	65535	√		null
folder	folder_id	varchar	32
folder	mkdate	int	10			0
folder	name	varchar	255
folder	permission	tinyint unsigned	3			7
folder	priority	smallint unsigned	5			0
folder	range_id	varchar	32
folder	user_id	varchar	32
guestbook	content	text	65535
guestbook	mkdate	int	10			0
guestbook	post_id	varchar	32
guestbook	range_id	varchar	32
guestbook	user_id	varchar	32
his_abschl	abint	char	2
his_abschl	aikz	char	1	√		null
his_abschl	anzstg	smallint	5	√		null
his_abschl	anzstgmin	smallint	5	√		null
his_abschl	astat	char	2	√		null
his_abschl	dtxt	char	25	√		null
his_abschl	efh	char	4	√		null
his_abschl	hrst	char	10	√		null
his_abschl	ktxt	char	10	√		null
his_abschl	kzfaarray	char	10	√		null
his_abschl	ltxt	char	100	√		null
his_abschl	mag_laa	char	1	√		null
his_abschl	part	char	2	√		null
his_abschl	refabint	char	2	√		null
his_abschl	sortkz1	char	2	√		null
his_abschl	sprache	char	3	√		null
his_abstgv	abschl	char	2
his_abstgv	dtxt	varchar	50	√		null
his_abstgv	fb	char	2	√		null
his_abstgv	ktxt	varchar	50	√		null
his_abstgv	kzfa	char	1
his_abstgv	kzfaarray	char	3	√		null
his_abstgv	login_part	char	2	√		null
his_abstgv	ltxt	varchar	100	√		null
his_abstgv	pversion	int	10			0
his_abstgv	regelstz	tinyint	3	√		null
his_abstgv	stg	char	3
his_abstgv	studip_studiengang	varchar	32
his_pvers	aikz	char	1	√		null
his_pvers	dtxt	char	25	√		null
his_pvers	ktxt	char	10	√		null
his_pvers	ltxt	char	50	√		null
his_pvers	pvers	smallint	5			0
his_pvers	refpvers	smallint	5	√		null
his_pvers	sprache	char	3	√		null
his_stg	dtxt	varchar	25	√		null
his_stg	fb	char	2	√		null
his_stg	ktxt	varchar	10	√		null
his_stg	ltxt	varchar	100	√		null
his_stg	stg	char	3
Institute	chdate	int	10			0
Institute	email	varchar	255
Institute	fakultaets_id	varchar	32
Institute	fax	varchar	32
Institute	Institut_id	varchar	32
Institute	lit_plugin_name	varchar	255	√		null
Institute	lock_rule	varchar	32
Institute	mkdate	int	10			0
Institute	modules	int unsigned	10	√		null
Institute	Name	varchar	255
Institute	Plz	varchar	255
Institute	srienabled	tinyint	3			0
Institute	Strasse	varchar	255
Institute	telefon	varchar	32
Institute	type	tinyint unsigned	3			0
Institute	url	varchar	255			http://www.studip.de
kategorien	chdate	int	10			0
kategorien	content	text	65535
kategorien	kategorie_id	varchar	32
kategorien	mkdate	int	10			0
kategorien	name	varchar	255
kategorien	priority	int	10			0
kategorien	range_id	varchar	32
lit_catalog	accession_number	varchar	100	√		null
lit_catalog	catalog_id	varchar	32
lit_catalog	chdate	int	10			0
lit_catalog	dc_contributor	varchar	255	√		null
lit_catalog	dc_coverage	varchar	255	√		null
lit_catalog	dc_creator	varchar	255
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_title	varchar	255
lit_catalog	dc_type	varchar	100	√		null
lit_catalog	lit_plugin	varchar	100			Studip
lit_catalog	mkdate	int	10			0
lit_catalog	user_id	varchar	32
lit_list	chdate	int	10			0
lit_list	format	varchar	255
lit_list	list_id	varchar	32
lit_list	mkdate	int	10			0
lit_list	name	varchar	255
lit_list	priority	smallint	5			0
lit_list	range_id	varchar	32
lit_list	user_id	varchar	32
lit_list	visibility	tinyint	3			0
lit_list_content	catalog_id	varchar	32
lit_list_content	chdate	int	10			0
lit_list_content	list_element_id	varchar	32
lit_list_content	list_id	varchar	32
lit_list_content	mkdate	int	10			0
lit_list_content	note	text	65535	√		null
lit_list_content	priority	smallint	5			0
lit_list_content	user_id	varchar	32
lock_rules	attributes	text	65535
lock_rules	description	text	65535
lock_rules	lock_id	varchar	32
lock_rules	name	varchar	255
lock_rules	object_type	enum	4			sem
lock_rules	permission	enum	6			dozent
lock_rules	user_id	varchar	32
log_actions	action_id	varchar	32
log_actions	active	bit	0			1
log_actions	description	varchar	64	√		null
log_actions	expires	int	10			0
log_actions	info_template	text	65535	√		null
log_actions	name	varchar	128
log_events	action_id	varchar	32
log_events	affected_range_id	varchar	32	√		null
log_events	coaffected_range_id	varchar	32	√		null
log_events	dbg_info	text	65535	√		null
log_events	event_id	varchar	32
log_events	info	text	65535	√		null
log_events	mkdate	int	10			0
log_events	user_id	varchar	32
media_cache	chdate	timestamp	19			CURRENT_TIMESTAMP
media_cache	expires	timestamp	19			0000-00-00 00:00:00
media_cache	id	varchar	32
media_cache	type	varchar	64
message	autor_id	varchar	32
message	chat_id	varchar	32	√		null
message	message	text	65535
message	message_id	varchar	32
message	mkdate	int	10			0
message	priority	enum	7			normal
message	readed	bit	0			0
message	reading_confirmation	bit	0			0
message	subject	varchar	255
message_user	answered	bit	0			0
message_user	confirmed_read	bit	0			0
message_user	deleted	bit	0			0
message_user	dont_delete	bit	0			0
message_user	folder	tinyint	3			0
message_user	message_id	char	32
message_user	mkdate	int unsigned	10			0
message_user	readed	bit	0			0
message_user	snd_rec	enum	4			rec
message_user	user_id	char	32
news	allow_comments	bit	0			0
news	author	varchar	255
news	body	text	65535
news	chdate	int unsigned	10			0
news	chdate_uid	varchar	32
news	date	int	10			0
news	expire	int	10			0
news	mkdate	int unsigned	10			0
news	news_id	varchar	32
news	topic	varchar	255
news	user_id	varchar	32
news_range	news_id	varchar	32
news_range	range_id	varchar	32
news_rss_range	range_id	char	32
news_rss_range	range_type	enum	6			user
news_rss_range	rss_id	char	32
object_contentmodules	chdate	int	10			0
object_contentmodules	mkdate	int	10			0
object_contentmodules	module_id	varchar	255
object_contentmodules	module_type	varchar	32
object_contentmodules	object_id	varchar	32
object_contentmodules	system_type	varchar	32
object_rate	mkdate	int	10			0
object_rate	object_id	varchar	32
object_rate	rate	int	10			0
object_user	flag	varchar	32
object_user	mkdate	int	10			0
object_user	object_id	varchar	32
object_user	user_id	varchar	32
object_user_visits	last_visitdate	int	10			0
object_user_visits	object_id	char	32
object_user_visits	type	enum	19			vote
object_user_visits	user_id	char	32
object_user_visits	visitdate	int	10			0
object_views	chdate	int	10			0
object_views	object_id	varchar	32
object_views	views	int	10			0
plugins	dependentonid	int unsigned	10	√		null
plugins	enabled	enum	4			no
plugins	navigationpos	int unsigned	10			0
plugins	pluginclassname	varchar	255
plugins	pluginid	int unsigned	10		√
plugins	pluginname	varchar	45
plugins	pluginpath	varchar	255
plugins	plugintype	text	65535
plugins_activated	pluginid	int unsigned	10			0
plugins_activated	poiid	varchar	255
plugins_activated	state	enum	3			on
plugins_default_activations	institutid	varchar	32
plugins_default_activations	pluginid	int unsigned	10			0
px_topics	anonymous	tinyint	3			0
px_topics	author	varchar	255	√		null
px_topics	author_host	varchar	255	√		null
px_topics	chdate	int	10			0
px_topics	description	text	65535	√		null
px_topics	mkdate	int	10			0
px_topics	name	varchar	255	√		null
px_topics	parent_id	varchar	32
px_topics	root_id	varchar	32
px_topics	Seminar_id	varchar	32
px_topics	topic_id	varchar	32
px_topics	user_id	varchar	32
range_tree	item_id	varchar	32
range_tree	level	int	10			0
range_tree	name	varchar	255
range_tree	parent_id	varchar	32
range_tree	priority	int	10			0
range_tree	studip_object	varchar	10	√		null
range_tree	studip_object_id	varchar	32	√		null
resources_assign	assign_id	varchar	32
resources_assign	assign_user_id	varchar	32	√		null
resources_assign	begin	int	10			0
resources_assign	chdate	int	10			0
resources_assign	end	int	10			0
resources_assign	mkdate	int	10			0
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_assign	resource_id	varchar	32
resources_assign	user_free_name	varchar	255	√		null
resources_categories	category_id	varchar	32
resources_categories	description	text	65535
resources_categories	iconnr	int	10	√		1
resources_categories	is_room	tinyint	3			0
resources_categories	name	varchar	255
resources_categories	system	tinyint	3			0
resources_categories_properties	category_id	varchar	32
resources_categories_properties	property_id	varchar	32
resources_categories_properties	requestable	tinyint	3			0
resources_categories_properties	system	tinyint	3			0
resources_locks	lock_begin	int unsigned	10	√		null
resources_locks	lock_end	int unsigned	10	√		null
resources_locks	lock_id	varchar	32
resources_locks	type	varchar	15
resources_objects	category_id	varchar	32
resources_objects	chdate	int	10			0
resources_objects	description	text	65535
resources_objects	institut_id	varchar	32
resources_objects	level	int	10	√		null
resources_objects	lockable	tinyint	3	√		null
resources_objects	mkdate	int	10			0
resources_objects	multiple_assign	tinyint	3	√		null
resources_objects	name	varchar	255
resources_objects	owner_id	varchar	32
resources_objects	parent_id	varchar	32
resources_objects	resource_id	varchar	32
resources_objects	root_id	varchar	32
resources_objects_properties	property_id	varchar	32
resources_objects_properties	resource_id	varchar	32
resources_objects_properties	state	text	65535
resources_properties	description	text	65535
resources_properties	name	varchar	255
resources_properties	options	text	65535
resources_properties	property_id	varchar	32
resources_properties	system	tinyint	3			0
resources_properties	type	set	20			bool
resources_requests	category_id	varchar	32
resources_requests	chdate	int unsigned	10	√		null
resources_requests	closed	tinyint unsigned	3	√		null
resources_requests	comment	text	65535	√		null
resources_requests	metadate_id	varchar	32
resources_requests	mkdate	int unsigned	10	√		null
resources_requests	reply_comment	text	65535	√		null
resources_requests	request_id	varchar	32
resources_requests	resource_id	varchar	32
resources_requests	seminar_id	varchar	32
resources_requests	termin_id	varchar	32
resources_requests	user_id	varchar	32
resources_requests_properties	chdate	int unsigned	10	√		null
resources_requests_properties	mkdate	int unsigned	10	√		null
resources_requests_properties	property_id	varchar	32
resources_requests_properties	request_id	varchar	32
resources_requests_properties	state	text	65535	√		null
resources_temporary_events	assign_id	varchar	32
resources_temporary_events	begin	int	10			0
resources_temporary_events	end	int	10			0
resources_temporary_events	event_id	varchar	32
resources_temporary_events	mkdate	int	10			0
resources_temporary_events	resource_id	varchar	32
resources_temporary_events	seminar_id	varchar	32
resources_temporary_events	termin_id	varchar	32
resources_temporary_events	type	varchar	15
resources_user_resources	perms	varchar	10
resources_user_resources	resource_id	varchar	32
resources_user_resources	user_id	varchar	32
roles	roleid	int unsigned	10		√
roles	rolename	varchar	80
roles	system	enum	2			n
roles_plugins	pluginid	int unsigned	10			0
roles_plugins	roleid	int unsigned	10			0
roles_studipperms	permname	varchar	255
roles_studipperms	roleid	int unsigned	10			0
roles_user	roleid	int unsigned	10			0
roles_user	userid	char	32
rss_feeds	chdate	int	10			0
rss_feeds	feed_id	varchar	32
rss_feeds	fetch_title	tinyint unsigned	3			0
rss_feeds	hidden	tinyint	3			0
rss_feeds	mkdate	int	10			0
rss_feeds	name	varchar	255
rss_feeds	priority	int	10			0
rss_feeds	url	text	65535
rss_feeds	user_id	varchar	32
schedule	color	varchar	7				color, rgb in hex
schedule	content	varchar	255
schedule	day	tinyint	3				day of week, 0-6
schedule	end	smallint	5				end hour and minutes
schedule	id	int	10		√
schedule	start	smallint	5				start hour and minutes
schedule	title	varchar	255
schedule	user_id	varchar	32
schedule_seminare	color	varchar	7	√		null	color, rgb in hex
schedule_seminare	metadate_id	varchar	32
schedule_seminare	seminar_id	varchar	32
schedule_seminare	user_id	varchar	32
schedule_seminare	visible	bit	0			1
schema_version	domain	varchar	255
schema_version	version	int	10			0
scm	chdate	int	10			0
scm	content	text	65535	√		null
scm	mkdate	int	10			0
scm	range_id	varchar	32
scm	scm_id	varchar	32
scm	tab_name	varchar	20			Info
scm	user_id	varchar	32
sem_tree	info	text	65535
sem_tree	name	varchar	255
sem_tree	parent_id	varchar	32
sem_tree	priority	tinyint	3			0
sem_tree	sem_tree_id	varchar	32
sem_tree	studip_object_id	varchar	32	√		null
sem_tree	type	tinyint unsigned	3
semester_data	beginn	int unsigned	10	√		null
semester_data	description	text	65535
semester_data	ende	int unsigned	10	√		null
semester_data	name	varchar	255
semester_data	semester_id	varchar	32
semester_data	semester_token	varchar	10
semester_data	vorles_beginn	int unsigned	10	√		null
semester_data	vorles_ende	int unsigned	10	√		null
semester_holiday	beginn	int unsigned	10	√		null
semester_holiday	description	text	65535
semester_holiday	ende	int unsigned	10			0
semester_holiday	holiday_id	varchar	32
semester_holiday	name	varchar	255
semester_holiday	semester_id	varchar	32
seminar_cycle_dates	chdate	int unsigned	10
seminar_cycle_dates	cycle	tinyint unsigned	3			0
seminar_cycle_dates	description	varchar	255
seminar_cycle_dates	end_time	time	8
seminar_cycle_dates	metadate_id	varchar	32
seminar_cycle_dates	mkdate	int unsigned	10
seminar_cycle_dates	seminar_id	varchar	32
seminar_cycle_dates	sorter	tinyint unsigned	3			0
seminar_cycle_dates	start_time	time	8
seminar_cycle_dates	sws	decimal	2,1			0.0
seminar_cycle_dates	week_offset	tinyint unsigned	3			0
seminar_cycle_dates	weekday	tinyint unsigned	3
seminar_inst	institut_id	varchar	32
seminar_inst	seminar_id	varchar	32
seminar_sem_tree	sem_tree_id	varchar	32
seminar_sem_tree	seminar_id	varchar	32
seminar_user	admission_studiengang_id	varchar	32
seminar_user	bind_calendar	bit	0			1
seminar_user	comment	varchar	255
seminar_user	gruppe	tinyint	3			0
seminar_user	label	varchar	128
seminar_user	mkdate	int	10			0
seminar_user	notification	int	10			0
seminar_user	position	int	10			0
seminar_user	Seminar_id	varchar	32
seminar_user	status	enum	6			user
seminar_user	user_id	varchar	32
seminar_user	visible	enum	7			unknown
seminar_userdomains	seminar_id	varchar	32
seminar_userdomains	userdomain_id	varchar	32
seminare	admission_binding	tinyint	3	√		null
seminare	admission_disable_waitlist	tinyint unsigned	3			0
seminare	admission_enable_quota	tinyint unsigned	3			0
seminare	admission_endtime	int	10	√		null
seminare	admission_endtime_sem	int	10			-1
seminare	admission_group	varchar	32	√		null
seminare	admission_prelim	tinyint unsigned	3			0
seminare	admission_prelim_txt	text	65535	√		null
seminare	admission_selection_take_place	tinyint	3	√		0
seminare	admission_starttime	int	10			-1
seminare	admission_turnout	int	10	√		null
seminare	admission_type	int	10			0
seminare	art	varchar	255	√		null
seminare	aux_lock_rule	varchar	32	√		null
seminare	Beschreibung	text	65535
seminare	chdate	int	10			0
seminare	duration_time	int	10	√		null
seminare	ects	varchar	32	√		null
seminare	Institut_id	varchar	32			0
seminare	leistungsnachweis	text	65535	√		null
seminare	lernorga	text	65535	√		null
seminare	Lesezugriff	tinyint	3			0
seminare	lock_rule	varchar	32	√		null
seminare	mkdate	int	10			0
seminare	modules	int unsigned	10	√		null
seminare	Name	varchar	255
seminare	Ort	varchar	255	√		null
seminare	Passwort	varchar	32	√		null
seminare	Schreibzugriff	tinyint	3			0
seminare	Seminar_id	varchar	32			0
seminare	showscore	tinyint	3	√		0
seminare	Sonstiges	text	65535	√		null
seminare	start_time	int	10	√		0
seminare	status	tinyint unsigned	3			1
seminare	teilnehmer	text	65535	√		null
seminare	Untertitel	varchar	255	√		null
seminare	VeranstaltungsNummer	varchar	100	√		null
seminare	visible	tinyint unsigned	3			1
seminare	vorrausetzungen	text	65535	√		null
session_data	changed	timestamp	19			CURRENT_TIMESTAMP
session_data	sid	varchar	32
session_data	val	mediumtext	16777215
siteinfo_details	content	text	65535
siteinfo_details	detail_id	smallint unsigned	5		√
siteinfo_details	name	varchar	255
siteinfo_details	position	tinyint unsigned	3	√		null
siteinfo_details	rubric_id	smallint unsigned	5
siteinfo_rubrics	name	varchar	255
siteinfo_rubrics	position	tinyint unsigned	3	√		null
siteinfo_rubrics	rubric_id	smallint unsigned	5		√
smiley	chdate	int unsigned	10	√		null
smiley	fav_counter	int unsigned	10			0
smiley	mkdate	int unsigned	10	√		null
smiley	short_counter	int unsigned	10			0
smiley	short_name	varchar	50
smiley	smiley_counter	int unsigned	10			0
smiley	smiley_height	int	10			0
smiley	smiley_id	int unsigned	10		√
smiley	smiley_name	varchar	50
smiley	smiley_width	int	10			0
statusgruppe_user	inherit	tinyint	3			1
statusgruppe_user	position	int	10			0
statusgruppe_user	statusgruppe_id	varchar	32
statusgruppe_user	user_id	varchar	32
statusgruppe_user	visible	tinyint	3			1
statusgruppen	calendar_group	tinyint unsigned	3			0
statusgruppen	chdate	int	10			0
statusgruppen	mkdate	int	10			0
statusgruppen	name	varchar	255
statusgruppen	position	int	10			0
statusgruppen	range_id	varchar	32
statusgruppen	selfassign	tinyint	3			0
statusgruppen	size	int	10			0
statusgruppen	statusgruppe_id	varchar	32
stm_abstract	chdate	int	10	√		null	Datum der letzten Aenderung
stm_abstract	credits	tinyint unsigned	3	√		null	Anzahl der Leistungspunkte/Kreditpunkte
stm_abstract	duration	varchar	155	√		null
stm_abstract	homeinst	varchar	32	√		null
stm_abstract	id_number	varchar	10	√		null	alphanummerische Identifikationsnummer f
stm_abstract	mkdate	int	10	√		null	Erstellungdatum
stm_abstract	stm_abstr_id	varchar	32
stm_abstract	turnus	bit	0	√		null	(optional) Angebotsturnus - Modulbeginn
stm_abstract	workload	smallint unsigned	5	√		null	Studentischer Arbeitsaufwand in Stunden
stm_abstract_assign	abschl	char	3				ID eines Studienabschlusses
stm_abstract_assign	earliest	tinyint	3	√		null	fr
stm_abstract_assign	latest	tinyint	3	√		null	sp
stm_abstract_assign	pversion	varchar	8				Version der Pr
stm_abstract_assign	recommed	tinyint	3	√		null	empfohlener Zpkt.
stm_abstract_assign	stg	char	3				ID eines Studienprogramms/-fachs
stm_abstract_assign	stm_abstr_id	varchar	32
stm_abstract_assign	stm_type_id	varchar	32				ID eines Modultyps
stm_abstract_elements	custom_name	varchar	50	√		null	selbstgew
stm_abstract_elements	element_id	varchar	32				ID eines abstrakten Modulbestandzeiles
stm_abstract_elements	element_type_id	varchar	32				um welche Art von Element handelt es sich
stm_abstract_elements	elementgroup	tinyint	3			0	Kombinationsvariante
stm_abstract_elements	position	tinyint	3			0	Reihenfolge
stm_abstract_elements	semester	bit	0	√		null	Sommer od. Winter (Sommer = 1; Winter = 2)
stm_abstract_elements	stm_abstr_id	varchar	32				ID eines abstrakten Studienmodules
stm_abstract_elements	sws	tinyint	3			0	Semesterwochenstunden f
stm_abstract_elements	workload	int	10			0
stm_abstract_text	aims	text	65535				Lernziele
stm_abstract_text	hints	text	65535	√		null
stm_abstract_text	lang_id	varchar	32				ID der verwendeten Sprache
stm_abstract_text	stm_abstr_id	varchar	32				ID des abstrakten Studienmodules
stm_abstract_text	subtitle	varchar	155	√		null	optionaler Untertitel
stm_abstract_text	title	varchar	155				Allgemeiner Modultitel (Name des Moduls)
stm_abstract_text	topics	text	65535				Inhalte (behandelte Themen etc.)
stm_abstract_types	abbrev	varchar	5				Abkuerzung
stm_abstract_types	lang_id	varchar	32				ID der verwendeten Sprache
stm_abstract_types	name	varchar	25				vollstaendige Bezeichnung
stm_abstract_types	stm_type_id	varchar	32				ID eines Modultyps
stm_element_types	abbrev	varchar	5	√		null	Kurzname
stm_element_types	element_type_id	varchar	32				ID des Modulbestandteils
stm_element_types	lang_id	varchar	32				ID der verwendeten Sprache
stm_element_types	name	varchar	50				Name
stm_instances	complete	bit	0			0	Erfassung komplett (0=FALSE)
stm_instances	creator	varchar	32
stm_instances	homeinst	varchar	32	√		null	ID des anbietenden Institutes
stm_instances	lang_id	varchar	32				ID der Sprache in der das Modul angeboten wird
stm_instances	responsible	varchar	32	√		null	ID des Modulverantwortlichen Dozenten
stm_instances	semester_id	varchar	32				ID des ersten Semesters in dem die Instanz stattfindet
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	element_id	varchar	32				ID des abstrakten Modulbestandteils
stm_instances_elements	sem_id	varchar	32				ID der konkreten Veranstaltung
stm_instances_elements	stm_instance_id	varchar	32				ID eines konkreten Studienmodules
stm_instances_text	hints	text	65535	√		null
stm_instances_text	lang_id	varchar	32				ID der verwendeten Sprache
stm_instances_text	stm_instance_id	varchar	32				ID eines konkreten Studienmodules
stm_instances_text	subtitle	varchar	155	√		null	optionaler Untertitel
stm_instances_text	title	varchar	155				Allgemeiner Modultitel
stm_instances_text	topics	text	65535				Inhalte
studiengaenge	beschreibung	text	65535	√		null
studiengaenge	chdate	int	10			0
studiengaenge	mkdate	int	10			0
studiengaenge	name	varchar	255	√		null
studiengaenge	studiengang_id	varchar	32
teilnehmer_view	active	tinyint	3	√		null
teilnehmer_view	datafield_id	varchar	40
teilnehmer_view	seminar_id	varchar	40
termin_related_persons	range_id	varchar	32
termin_related_persons	user_id	varchar	32
termine	autor_id	varchar	32
termine	chdate	int	10			0
termine	content	varchar	255
termine	date	int	10			0
termine	date_typ	tinyint	3			0
termine	description	text	65535	√		null
termine	end_time	int	10			0
termine	metadate_id	varchar	32	√		null
termine	mkdate	int	10			0
termine	range_id	varchar	32
termine	raum	varchar	255	√		null
termine	termin_id	varchar	32
termine	topic_id	varchar	32	√		null
themen	author_id	varchar	32
themen	chdate	int unsigned	10			0
themen	description	text	65535
themen	issue_id	varchar	32
themen	mkdate	int unsigned	10			0
themen	priority	smallint unsigned	5			0
themen	seminar_id	varchar	32
themen	title	varchar	255
themen_termine	issue_id	varchar	32
themen_termine	termin_id	varchar	32
user_config	chdate	int	10			0
user_config	comment	text	65535
user_config	field	varchar	255
user_config	mkdate	int	10			0
user_config	parent_id	varchar	32	√		null
user_config	user_id	varchar	32
user_config	userconfig_id	varchar	32
user_config	value	text	65535
user_data	changed	timestamp	19			CURRENT_TIMESTAMP
user_data	sid	varchar	32
user_data	val	mediumtext	16777215
user_info	chdate	int	10			0
user_info	email_forward	tinyint	3			0
user_info	geschlecht	tinyint	3			0
user_info	guestbook	tinyint	3			0
user_info	hobby	varchar	255
user_info	Home	varchar	200
user_info	lebenslauf	text	65535	√		null
user_info	lock_rule	varchar	32
user_info	mkdate	int	10			0
user_info	motto	varchar	255
user_info	preferred_language	varchar	20	√		null
user_info	privadr	varchar	64
user_info	privatcell	varchar	32
user_info	privatnr	varchar	32
user_info	publi	text	65535
user_info	schwerp	text	65535
user_info	score	int unsigned	10			0
user_info	smiley_favorite	varchar	255
user_info	smsforward_copy	bit	0			1
user_info	smsforward_rec	varchar	32
user_info	title_front	varchar	64
user_info	title_rear	varchar	64
user_info	user_id	varchar	32
user_inst	externdefault	tinyint unsigned	3			0
user_inst	Fax	varchar	32
user_inst	inst_perms	enum	6			user
user_inst	Institut_id	varchar	32			0
user_inst	priority	tinyint unsigned	3			0
user_inst	raum	varchar	200
user_inst	sprechzeiten	varchar	200
user_inst	Telefon	varchar	32
user_inst	user_id	varchar	32			0
user_inst	visible	tinyint unsigned	3			1
user_studiengang	abschluss_id	char	32	√		0
user_studiengang	semester	tinyint	3	√		0
user_studiengang	studiengang_id	varchar	32
user_studiengang	user_id	varchar	32
user_token	expiration	int	10
user_token	token	varchar	32
user_token	user_id	varchar	32
user_userdomains	user_id	varchar	32
user_userdomains	userdomain_id	varchar	32
user_visibility	chat	bit	0			1
user_visibility	default_homepage_visibility	int	10			0
user_visibility	email	bit	0			1
user_visibility	homepage	text	65535
user_visibility	mkdate	int	10			0
user_visibility	online	bit	0			1
user_visibility	search	bit	0			1
user_visibility	user_id	varchar	32
userdomains	name	varchar	255
userdomains	userdomain_id	varchar	32
vote	anonymous	bit	0			1
vote	author_id	varchar	32
vote	changeable	bit	0			0
vote	chdate	int	10			0
vote	co_visibility	bit	0	√		null
vote	mkdate	int	10			0
vote	multiplechoice	bit	0			0
vote	namesvisibility	bit	0			0
vote	question	text	65535
vote	range_id	varchar	32
vote	resultvisibility	enum	8			ever
vote	startdate	int	10	√		null
vote	state	enum	9			new
vote	stopdate	int	10	√		null
vote	timespan	int	10	√		null
vote	title	varchar	100
vote	type	enum	5			vote
vote	vote_id	varchar	32
vote_user	user_id	varchar	32
vote_user	vote_id	varchar	32
vote_user	votedate	int	10	√		null
voteanswers	answer	varchar	255
voteanswers	answer_id	varchar	32
voteanswers	correct	bit	0	√		null
voteanswers	counter	int	10			0
voteanswers	position	int	10			0
voteanswers	vote_id	varchar	32
voteanswers_user	answer_id	varchar	32
voteanswers_user	user_id	varchar	32
voteanswers_user	votedate	int	10	√		null
webservice_access_rules	api_key	varchar	100
webservice_access_rules	id	int	10		√
webservice_access_rules	ip_range	varchar	200
webservice_access_rules	method	varchar	100
webservice_access_rules	type	enum	6			allow
wiki	body	text	65535	√		null
wiki	chdate	int	10	√		null
wiki	keyword	varchar	128
wiki	range_id	varchar	32
wiki	user_id	varchar	32	√		null
wiki	version	int	10			0
wiki_links	from_keyword	char	128
wiki_links	range_id	char	32
wiki_links	to_keyword	char	128
wiki_locks	chdate	int	10			0
wiki_locks	keyword	varchar	128
wiki_locks	range_id	varchar	32
wiki_locks	user_id	varchar	32