studiptrunk Database

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Default
user_studiengang	Table	abschluss_id	CHAR	32		0
abschluss	Table	abschluss_id	CHAR	32
mvv_studiengang	Table	abschluss_id	VARCHAR	32	√	null
mvv_abschl_zuord	Table	abschluss_id	VARCHAR	32		null
mvv_stgteilabschnitt_modul	Table	abschnitt_id	VARCHAR	32		null
mvv_modulteil_stgteilabschnitt	Table	abschnitt_id	VARCHAR	32		null
mvv_stgteilabschnitt	Table	abschnitt_id	VARCHAR	32		null
mvv_stgteilabschnitt_modul	Table	abschnitt_modul_id	VARCHAR	32		null
help_tour_settings	Table	access	enum('standard', 'link', 'autostart', 'autostart_once')	14	√	null
file_urls	Table	access_type	enum('proxy', 'redirect')	8		proxy
lit_catalog	Table	accession_number	VARCHAR	100	√	null
log_events	Table	action_id	VARCHAR	32
log_actions	Table	action_id	VARCHAR	32
help_tour_steps	Table	action_next	VARCHAR	255		null
help_tour_steps	Table	action_prev	VARCHAR	255		null
log_actions	Table	active	BIT	1		1
help_tour_settings	Table	active	TINYINT	3		null
cronjobs_tasks	Table	active	BIT	1		0
api_consumers	Table	active	BIT	1		0
etask_assignments	Table	active	BIT	1		null
admissionrules	Table	active	BIT	1		0
cronjobs_schedules	Table	active	BIT	1		0
activities	Table	actor_id	VARCHAR	255		null
activities	Table	actor_type	VARCHAR	255		null
banner_ads	Table	ad_id	VARCHAR	32
sem_classes	Table	admin	VARCHAR	64	√	null
seminare	Table	admission_binding	TINYINT	3	√	null
seminare	Table	admission_disable_waitlist	TINYINT UNSIGNED	3		0
seminare	Table	admission_disable_waitlist_move	TINYINT UNSIGNED	3		0
seminare	Table	admission_prelim	TINYINT UNSIGNED	3		0
sem_classes	Table	admission_prelim_default	TINYINT	3		0
seminare	Table	admission_prelim_txt	TEXT	65535	√	null
seminare	Table	admission_turnout	INT	10	√	null
sem_classes	Table	admission_type_default	TINYINT	3		0
seminare	Table	admission_waitlist_max	INT UNSIGNED	10		0
log_events	Table	affected_range_id	VARCHAR	32	√	null
coursesets	Table	algorithm	VARCHAR	255		null
coursesets	Table	algorithm_run	BIT	1		0
news	Table	allow_comments	BIT	1		0
lti_tool	Table	allow_custom_url	BIT	1		0
mvv_lvgruppe	Table	alttext	TINYTEXT	255	√	null
banner_ads	Table	alttext	VARCHAR	255	√	null
questionnaires	Table	anonymous	BIT	1		0
forum_entries	Table	anonymous	TINYINT	3		0
eval	Table	anonymous	BIT	1		1
questionnaire_anonymous_answers	Table	anonymous_answer_id	VARCHAR	32		null
questionnaire_answers	Table	answer_id	VARCHAR	32		null
questionnaire_answers	Table	answerdata	TEXT	65535		null
message_user	Table	answered	BIT	1		0
mvv_modulteil	Table	anteil_note	INT	10	√	null

Showing 1 to 50 of 1,813 entries