iliaseassessment contains 2966 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
abstraction_progress	step	int	10
abstraction_progress	table_name	varchar	100
acc_access_key	access_key	char	1	√		null
acc_access_key	function_id	int	10
acc_access_key	lang_key	char	2
acc_cache	result	longtext	2147483647	√		null
acc_cache	time	int	10			0
acc_cache	user_id	int	10			0
acc_user_access_key	access_key	char	1	√		null
acc_user_access_key	function_id	smallint	5
acc_user_access_key	user_id	int	10
addressbook	addr_id	int	10			0
addressbook	email	varchar	80	√		null
addressbook	firstname	varchar	40	√		null
addressbook	lastname	varchar	40	√		null
addressbook	login	varchar	80	√		null
addressbook	user_id	int	10			0
addressbook_mlist	changedate	datetime	19	√		null
addressbook_mlist	createdate	datetime	19	√		null
addressbook_mlist	description	varchar	4000	√		null
addressbook_mlist	ml_id	bigint	19			0
addressbook_mlist	title	varchar	255	√		null
addressbook_mlist	user_id	bigint	19			0
addressbook_mlist_ass	a_id	bigint	19			0
addressbook_mlist_ass	addr_id	bigint	19			0
addressbook_mlist_ass	ml_id	bigint	19			0
addressbook_mlist_ass_seq	sequence	int	10		√
addressbook_mlist_seq	sequence	int	10		√
addressbook_seq	sequence	int	10		√
adv_md_record	active	tinyint	3			0
adv_md_record	description	varchar	4000	√		null
adv_md_record	import_id	varchar	64	√		null
adv_md_record	record_id	tinyint	3			0
adv_md_record	title	varchar	128	√		null
adv_md_record_objs	obj_type	char	6
adv_md_record_objs	record_id	tinyint	3			0
adv_md_record_seq	sequence	int	10		√
adv_md_substitutions	hide_description	tinyint	3			0
adv_md_substitutions	hide_field_names	tinyint	3			0
adv_md_substitutions	obj_type	varchar	4
adv_md_substitutions	substitution	longtext	2147483647	√		null
adv_md_values	disabled	tinyint	3			0
adv_md_values	field_id	int	10			0
adv_md_values	obj_id	int	10			0
adv_md_values	value	varchar	4000	√		null
adv_mdf_definition	description	varchar	2000	√		null
adv_mdf_definition	field_id	int	10			0
adv_mdf_definition	field_type	tinyint	3			0
adv_mdf_definition	field_values	varchar	4000	√		null
adv_mdf_definition	import_id	varchar	32	√		null
adv_mdf_definition	position	int	10			0
adv_mdf_definition	record_id	int	10			0
adv_mdf_definition	required	tinyint	3			0
adv_mdf_definition	searchable	tinyint	3			0
adv_mdf_definition	title	varchar	255	√		null
adv_mdf_definition_seq	sequence	int	10		√
aicc_course	c_level	varchar	5	√		null
aicc_course	course_creator	varchar	255	√		null
aicc_course	course_id	varchar	50	√		null
aicc_course	course_system	varchar	50	√		null
aicc_course	course_title	varchar	255	√		null
aicc_course	description	longtext	2147483647	√		null
aicc_course	max_fields_cst	int	10	√		0
aicc_course	max_fields_ort	int	10	√		0
aicc_course	max_normal	tinyint	3	√		null
aicc_course	obj_id	int	10			0
aicc_course	total_aus	int	10			0
aicc_course	total_blocks	int	10			0
aicc_course	total_complex_obj	int	10	√		0
aicc_course	total_objectives	int	10	√		0
aicc_course	version	varchar	10	√		null
aicc_object	c_type	varchar	50	√		null
aicc_object	description	longtext	2147483647	√		null
aicc_object	developer_id	varchar	50	√		null
aicc_object	obj_id	int	10			0
aicc_object	slm_id	int	10			0
aicc_object	system_id	varchar	50	√		null
aicc_object	title	varchar	4000	√		null
aicc_object_seq	sequence	int	10		√
aicc_units	au_password	varchar	50	√		null
aicc_units	c_type	varchar	50	√		null
aicc_units	command_line	varchar	255	√		null
aicc_units	core_vendor	varchar	4000	√		null
aicc_units	file_name	varchar	255	√		null
aicc_units	mastery_score	int	10			0
aicc_units	max_score	double	22	√		null
aicc_units	max_time_allowed	time	8	√		null
aicc_units	obj_id	int	10			0
aicc_units	system_vendor	varchar	4000	√		null
aicc_units	time_limit_action	varchar	50	√		null
aicc_units	web_launch	varchar	255	√		null
aicc_units_seq	sequence	int	10		√
ass_log	ass_log_id	int	10			0
ass_log	logtext	varchar	4000	√		null
ass_log	obj_fi	int	10			0
ass_log	original_fi	int	10	√		null
ass_log	question_fi	int	10	√		null
ass_log	ref_id	int	10	√		null
ass_log	test_only	varchar	1	√		0
ass_log	tstamp	int	10			0
ass_log	user_fi	int	10			0
ass_log_seq	sequence	int	10		√
benchmark	benchmark	varchar	150	√		null
benchmark	cdate	datetime	19	√		null
benchmark	duration	double	22	√		null
benchmark	module	varchar	150	√		null
benchmark	sql_stmt	longtext	2147483647	√		null
booking_entry	booking_id	int	10
booking_entry	deadline	int	10
booking_entry	num_bookings	int	10
booking_entry	obj_id	int	10
booking_entry	target_obj_id	int	10	√		null
booking_entry_seq	sequence	int	10		√
booking_object	booking_object_id	int	10
booking_object	schedule_id	int	10	√		null
booking_object	title	varchar	255
booking_object	type_id	int	10
booking_object_seq	sequence	int	10		√
booking_reservation	booking_reservation_id	int	10
booking_reservation	date_from	int	10
booking_reservation	date_to	int	10
booking_reservation	object_id	int	10
booking_reservation	status	smallint	5	√		null
booking_reservation	user_id	int	10
booking_reservation_seq	sequence	int	10		√
booking_schedule	auto_break	int	10	√		null
booking_schedule	booking_schedule_id	int	10
booking_schedule	deadline	int	10	√		null
booking_schedule	pool_id	int	10
booking_schedule	raster	int	10	√		null
booking_schedule	rent_max	int	10	√		null
booking_schedule	rent_min	int	10	√		null
booking_schedule	title	varchar	255
booking_schedule_seq	sequence	int	10		√
booking_schedule_slot	booking_schedule_id	int	10
booking_schedule_slot	day_id	varchar	2
booking_schedule_slot	slot_id	tinyint	3
booking_schedule_slot	times	varchar	50
booking_settings	booking_pool_id	int	10
booking_settings	pool_offline	tinyint	3	√		null
booking_settings	public_log	tinyint	3	√		null
booking_settings	slots_no	smallint	5	√		0
booking_type	booking_type_id	int	10
booking_type	pool_id	int	10
booking_type	schedule_id	int	10	√		null
booking_type	title	varchar	255
booking_type_seq	sequence	int	10		√
booking_user	entry_id	int	10
booking_user	tstamp	int	10
booking_user	user_id	int	10
bookmark_data	description	varchar	255	√		null
bookmark_data	obj_id	int	10			0
bookmark_data	target	varchar	200	√		null
bookmark_data	title	varchar	200	√		null
bookmark_data	type	varchar	4	√		null
bookmark_data	user_id	int	10			0
bookmark_data_seq	sequence	int	10		√
bookmark_social_bm	sbm_active	tinyint	3	√		null
bookmark_social_bm	sbm_icon	varchar	200	√		null
bookmark_social_bm	sbm_id	int	10			0
bookmark_social_bm	sbm_link	varchar	200	√		null
bookmark_social_bm	sbm_title	varchar	50	√		null
bookmark_social_bm_seq	sequence	int	10		√
bookmark_tree	child	int	10			0
bookmark_tree	depth	smallint	5			0
bookmark_tree	lft	int	10			0
bookmark_tree	parent	int	10	√		null
bookmark_tree	rgt	int	10			0
bookmark_tree	tree	int	10			0
cache_clob	component	varchar	50
cache_clob	entry_id	varchar	50
cache_clob	expire_time	int	10
cache_clob	ilias_version	varchar	10	√		null
cache_clob	int_key_1	int	10	√		null
cache_clob	int_key_2	int	10	√		null
cache_clob	name	varchar	50
cache_clob	text_key_1	varchar	20	√		null
cache_clob	text_key_2	varchar	20	√		null
cache_clob	value	longtext	2147483647	√		null
cache_text	component	varchar	50
cache_text	entry_id	varchar	50
cache_text	expire_time	int	10
cache_text	ilias_version	varchar	10	√		null
cache_text	int_key_1	int	10	√		null
cache_text	int_key_2	int	10	√		null
cache_text	name	varchar	50
cache_text	text_key_1	varchar	20	√		null
cache_text	text_key_2	varchar	20	√		null
cache_text	value	varchar	4000	√		null
cal_auth_token	c_time	int	10			0
cal_auth_token	calendar	int	10
cal_auth_token	hash	varchar	32
cal_auth_token	ical	longtext	2147483647	√		null
cal_auth_token	selection	int	10
cal_auth_token	user_id	int	10
cal_cat_assignments	cal_id	int	10			0
cal_cat_assignments	cat_id	int	10			0
cal_categories	cat_id	int	10			0
cal_categories	color	char	8	√		null
cal_categories	obj_id	int	10			0
cal_categories	title	char	128	√		null
cal_categories	type	tinyint	3			0
cal_categories_hidden	cat_id	int	10			0
cal_categories_hidden	user_id	int	10			0
cal_categories_seq	sequence	int	10		√
cal_ch_settings	admin_id	int	10
cal_ch_settings	user_id	int	10
cal_entries	auto_generated	tinyint	3			0
cal_entries	cal_id	int	10			0
cal_entries	completion	int	10			0
cal_entries	context_id	int	10			0
cal_entries	description	varchar	4000	√		null
cal_entries	enda	datetime	19	√		null
cal_entries	fullday	tinyint	3			0
cal_entries	informations	varchar	4000	√		null
cal_entries	is_milestone	tinyint	3			0
cal_entries	last_update	datetime	19	√		null
cal_entries	location	varchar	4000	√		null
cal_entries	notification	tinyint	3			0
cal_entries	starta	datetime	19	√		null
cal_entries	subtitle	char	64	√		null
cal_entries	title	char	128	√		null
cal_entries	translation_type	tinyint	3			0
cal_entries_seq	sequence	int	10		√
cal_entry_responsible	cal_id	int	10			0
cal_entry_responsible	user_id	int	10			0
cal_rec_exclusion	cal_id	int	10
cal_rec_exclusion	excl_date	date	10	√		null
cal_rec_exclusion	excl_id	int	10
cal_rec_exclusion_seq	sequence	int	10		√
cal_recurrence_rules	byday	char	64	√		null
cal_recurrence_rules	bymonth	char	64	√		null
cal_recurrence_rules	bymonthday	char	64	√		null
cal_recurrence_rules	bysetpos	char	64	√		0
cal_recurrence_rules	byweekno	char	64	√		0
cal_recurrence_rules	byyearday	char	64	√		null
cal_recurrence_rules	cal_id	int	10			0
cal_recurrence_rules	cal_recurrence	int	10			0
cal_recurrence_rules	freq_type	char	20	√		null
cal_recurrence_rules	freq_until_count	int	10			0
cal_recurrence_rules	freq_until_date	datetime	19	√		null
cal_recurrence_rules	intervall	int	10			0
cal_recurrence_rules	rule_id	int	10			0
cal_recurrence_rules	weekstart	char	2	√		null
cal_recurrence_rules_seq	sequence	int	10		√
cal_registrations	cal_id	int	10
cal_registrations	dend	int	10			0
cal_registrations	dstart	int	10			0
cal_registrations	usr_id	int	10
cal_shared	cal_id	int	10			0
cal_shared	create_date	datetime	19	√		null
cal_shared	obj_id	int	10			0
cal_shared	obj_type	int	10			0
cal_shared_status	cal_id	int	10			0
cal_shared_status	status	int	10			0
cal_shared_status	usr_id	int	10			0
catch_write_events	obj_id	int	10			0
catch_write_events	ts	datetime	19	√		null
catch_write_events	usr_id	int	10			0
chat_blocked	chat_id	int	10			0
chat_blocked	usr_id	int	10			0
chat_invitations	chat_id	int	10			0
chat_invitations	guest_id	int	10			0
chat_invitations	guest_informed	tinyint	3			0
chat_invitations	invitation_time	int	10			0
chat_invitations	room_id	int	10			0
chat_record_data	message	varchar	4000	√		null
chat_record_data	msg_time	int	10			0
chat_record_data	record_data_id	int	10			0
chat_record_data	record_id	int	10			0
chat_record_data_seq	sequence	int	10		√
chat_records	chat_id	int	10			0
chat_records	description	varchar	4000	√		null
chat_records	end_time	int	10			0
chat_records	moderator_id	int	10			0
chat_records	record_id	int	10			0
chat_records	room_id	int	10			0
chat_records	start_time	int	10			0
chat_records	title	varchar	255	√		null
chat_records_seq	sequence	int	10		√
chat_room_messages	chat_id	int	10			0
chat_room_messages	commit_timestamp	int	10			0
chat_room_messages	entry_id	int	10			0
chat_room_messages	message	varchar	4000	√		null
chat_room_messages	room_id	int	10			0
chat_room_messages_seq	sequence	int	10		√
chat_rooms	chat_id	int	10			0
chat_rooms	owner	int	10			0
chat_rooms	room_id	int	10			0
chat_rooms	title	varchar	64	√		null
chat_rooms_seq	sequence	int	10		√
chat_smilies	smiley_id	int	10			0
chat_smilies	smiley_keywords	varchar	100	√		null
chat_smilies	smiley_path	varchar	200	√		null
chat_smilies_seq	sequence	int	10		√
chat_user	chat_id	int	10			0
chat_user	kicked	tinyint	3	√		0
chat_user	last_conn_timestamp	int	10	√		null
chat_user	room_id	int	10			0
chat_user	usr_id	int	10			0
cmi_comment	c_comment	longtext	2147483647	√		null
cmi_comment	c_timestamp	datetime	19	√		null
cmi_comment	cmi_comment_id	int	10			0
cmi_comment	cmi_node_id	int	10	√		null
cmi_comment	location	varchar	255	√		null
cmi_comment	sourceislms	tinyint	3	√		null
cmi_comment_seq	sequence	int	10		√
cmi_correct_response	cmi_correct_resp_id	int	10			0
cmi_correct_response	cmi_interaction_id	int	10	√		null
cmi_correct_response	pattern	varchar	255	√		null
cmi_correct_response_seq	sequence	int	10		√
cmi_custom	c_timestamp	datetime	19	√		null
cmi_custom	lvalue	varchar	64
cmi_custom	obj_id	int	10			0
cmi_custom	rvalue	varchar	255	√		null
cmi_custom	sco_id	int	10			0
cmi_custom	user_id	int	10			0
cmi_gobjective	measure	varchar	50	√		null
cmi_gobjective	objective_id	varchar	255	√		null
cmi_gobjective	satisfied	varchar	50	√		null
cmi_gobjective	scope_id	int	10	√		null
cmi_gobjective	status	varchar	50	√		null
cmi_gobjective	user_id	int	10	√		null
cmi_interaction	c_timestamp	varchar	20	√		null
cmi_interaction	c_type	varchar	32	√		null
cmi_interaction	cmi_interaction_id	int	10			0
cmi_interaction	cmi_node_id	int	10	√		null
cmi_interaction	description	longtext	2147483647	√		null
cmi_interaction	id	varchar	255	√		null
cmi_interaction	latency	varchar	20	√		null
cmi_interaction	learner_response	longtext	2147483647	√		null
cmi_interaction	result	varchar	4000	√		null
cmi_interaction	weighting	double	22	√		null
cmi_interaction_seq	sequence	int	10		√
cmi_node	accesscount	int	10	√		null
cmi_node	accessduration	varchar	20	√		null
cmi_node	accessed	varchar	20	√		null
cmi_node	activityabsduration	varchar	20	√		null
cmi_node	activityattemptcount	int	10	√		null
cmi_node	activityexpduration	varchar	20	√		null
cmi_node	activityprogstatus	tinyint	3	√		null
cmi_node	attemptabsduration	varchar	20	√		null
cmi_node	attemptcomplamount	double	22	√		null
cmi_node	attemptcomplstatus	tinyint	3	√		null
cmi_node	attemptexpduration	varchar	20	√		null
cmi_node	attemptprogstatus	tinyint	3	√		null
cmi_node	audio_captioning	int	10	√		null
cmi_node	audio_level	double	22	√		null
cmi_node	availablechildren	varchar	255	√		null
cmi_node	c_entry	varchar	255	√		null
cmi_node	c_exit	varchar	255	√		null
cmi_node	c_language	varchar	5	√		null
cmi_node	c_max	double	22	√		null
cmi_node	c_min	double	22	√		null
cmi_node	c_mode	varchar	20	√		null
cmi_node	c_raw	double	22	√		null
cmi_node	c_timestamp	datetime	19	√		null
cmi_node	cmi_node_id	int	10			0
cmi_node	completion	double	22	√		null
cmi_node	completion_status	varchar	32	√		null
cmi_node	completion_threshold	varchar	32	√		null
cmi_node	cp_node_id	int	10	√		null
cmi_node	created	varchar	20	√		null
cmi_node	credit	varchar	32	√		null
cmi_node	delivery_speed	double	22	√		null
cmi_node	launch_data	longtext	2147483647	√		null
cmi_node	learner_name	varchar	255	√		null
cmi_node	location	varchar	255	√		null
cmi_node	modified	varchar	20	√		null
cmi_node	progress_measure	double	22	√		null
cmi_node	scaled	double	22	√		null
cmi_node	scaled_passing_score	double	22	√		null
cmi_node	session_time	varchar	20	√		null
cmi_node	success_status	varchar	255	√		null
cmi_node	suspend_data	longtext	2147483647	√		null
cmi_node	total_time	varchar	20	√		null
cmi_node	user_id	int	10	√		null
cmi_node_seq	sequence	int	10		√
cmi_objective	c_max	double	22	√		null
cmi_objective	c_min	double	22	√		null
cmi_objective	c_raw	double	22	√		null
cmi_objective	cmi_interaction_id	int	10	√		null
cmi_objective	cmi_node_id	int	10	√		null
cmi_objective	cmi_objective_id	int	10			0
cmi_objective	completion_status	double	22	√		null
cmi_objective	description	longtext	2147483647	√		null
cmi_objective	id	varchar	255	√		null
cmi_objective	progress_measure	double	22	√		null
cmi_objective	scaled	double	22	√		null
cmi_objective	scope	varchar	16	√		null
cmi_objective	success_status	varchar	32	√		null
cmi_objective_seq	sequence	int	10		√
conditions	condition_id	int	10			0
conditions	operator	varchar	64	√		null
conditions	ref_handling	tinyint	3			1
conditions	target_obj_id	int	10			0
conditions	target_ref_id	int	10			0
conditions	target_type	varchar	8	√		null
conditions	trigger_obj_id	int	10			0
conditions	trigger_ref_id	int	10			0
conditions	trigger_type	varchar	8	√		null
conditions	value	varchar	64	√		null
conditions_seq	sequence	int	10		√
container_reference	obj_id	int	10			0
container_reference	target_obj_id	int	10			0
container_settings	id	int	10			0
container_settings	keyword	char	40
container_settings	value	char	50	√		null
container_sorting	child_id	int	10			0
container_sorting	obj_id	int	10			0
container_sorting	parent_id	int	10			0
container_sorting	parent_type	varchar	5	√		null
container_sorting	position	int	10			0
container_sorting_set	obj_id	int	10			0
container_sorting_set	sort_mode	tinyint	3			0
content_object	clean_frames	char	1	√		n
content_object	default_layout	varchar	100	√		toc2win
content_object	downloads_active	char	1	√		n
content_object	downloads_public_active	char	1	√		y
content_object	footer_page	int	10			0
content_object	header_page	int	10			0
content_object	hist_user_comments	char	1	√		n
content_object	id	int	10			0
content_object	is_online	char	1	√		n
content_object	layout_per_page	tinyint	3	√		null
content_object	lm_menu_active	char	1	√		y
content_object	no_glo_appendix	char	1	√		n
content_object	numbering	char	1	√		n
content_object	page_header	char	8	√		st_title
content_object	print_view_active	char	1	√		y
content_object	pub_notes	char	1	√		y
content_object	public_access_mode	char	8	√		complete
content_object	public_html_file	varchar	50	√		null
content_object	public_scorm_file	varchar	50	√		null
content_object	public_xml_file	varchar	50	√		null
content_object	stylesheet	int	10			0
content_object	toc_active	char	1	√		y
content_object	toc_mode	char	8	√		chapters
copy_wizard_options	copy_id	int	10			0
copy_wizard_options	options	longtext	2147483647	√		null
copy_wizard_options	source_id	int	10			0
cp_auxilaryresource	auxiliaryresourceid	varchar	255	√		null
cp_auxilaryresource	cp_node_id	int	10			0
cp_auxilaryresource	purpose	varchar	255	√		null
cp_condition	c_condition	varchar	50	√		null
cp_condition	c_operator	varchar	50	√		null
cp_condition	cp_node_id	int	10			0
cp_condition	measurethreshold	varchar	50	√		null
cp_condition	referencedobjective	varchar	50	√		null
cp_dependency	cp_node_id	int	10			0
cp_dependency	resourceid	varchar	50	√		null
cp_file	cp_node_id	int	10			0
cp_file	href	varchar	4000	√		null
cp_hidelmsui	cp_node_id	int	10			0
cp_hidelmsui	value	varchar	50	√		null
cp_item	completionthreshold	varchar	50	√		null
cp_item	cp_node_id	int	10			0
cp_item	datafromlms	varchar	4000	√		null
cp_item	id	varchar	200	√		null
cp_item	isvisible	varchar	32	√		null
cp_item	parameters	varchar	255	√		null
cp_item	resourceid	varchar	200	√		null
cp_item	sequencingid	varchar	50	√		null
cp_item	timelimitaction	varchar	30	√		null
cp_item	title	varchar	255	√		null
cp_manifest	base	varchar	200	√		null
cp_manifest	cp_node_id	int	10			0
cp_manifest	defaultorganization	varchar	50	√		null
cp_manifest	id	varchar	200	√		null
cp_manifest	title	varchar	255	√		null
cp_manifest	uri	varchar	255	√		null
cp_manifest	version	varchar	200	√		null
cp_mapinfo	cp_node_id	int	10			0
cp_mapinfo	readnormalmeasure	tinyint	3	√		null
cp_mapinfo	readsatisfiedstatus	tinyint	3	√		null
cp_mapinfo	targetobjectiveid	varchar	255	√		null
cp_mapinfo	writenormalmeasure	tinyint	3	√		null
cp_mapinfo	writesatisfiedstatus	tinyint	3	√		null
cp_node	cp_node_id	int	10			0
cp_node	nodename	varchar	50	√		null
cp_node	slm_id	int	10	√		null
cp_node_seq	sequence	int	10		√
cp_objective	c_primary	tinyint	3	√		null
cp_objective	cp_node_id	int	10			0
cp_objective	minnormalmeasure	varchar	50	√		null
cp_objective	objectiveid	varchar	200	√		null
cp_objective	satisfiedbymeasure	tinyint	3	√		null
cp_organization	cp_node_id	int	10			0
cp_organization	id	varchar	200	√		null
cp_organization	objectivesglobtosys	tinyint	3	√		null
cp_organization	sequencingid	varchar	50	√		null
cp_organization	structure	varchar	200	√		null
cp_organization	title	varchar	255	√		null
cp_package	activitytree	longtext	2147483647	√		null
cp_package	c_identifier	varchar	255	√		null
cp_package	c_settings	varchar	255	√		null
cp_package	created	varchar	20	√		null
cp_package	global_to_system	tinyint	3			1
cp_package	jsdata	longtext	2147483647	√		null
cp_package	modified	varchar	20	√		null
cp_package	obj_id	int	10			0
cp_package	persistprevattempts	int	10	√		null
cp_package	xmldata	longtext	2147483647	√		null
cp_resource	base	varchar	4000	√		null
cp_resource	c_type	varchar	30	√		null
cp_resource	cp_node_id	int	10			0
cp_resource	href	varchar	4000	√		null
cp_resource	id	varchar	200	√		null
cp_resource	scormtype	varchar	32	√		null
cp_rule	action	varchar	50	√		null
cp_rule	c_type	varchar	50	√		null
cp_rule	childactivityset	varchar	50	√		null
cp_rule	conditioncombination	varchar	50	√		null
cp_rule	cp_node_id	int	10			0
cp_rule	minimumcount	int	10	√		null
cp_rule	minimumpercent	varchar	50	√		null
cp_sequencing	activityabsdurlimit	varchar	20	√		null
cp_sequencing	activityexpdurlimit	varchar	20	√		null
cp_sequencing	attemptabsdurlimit	varchar	20	√		null
cp_sequencing	attemptexpdurlimit	varchar	20	√		null
cp_sequencing	attemptlimit	int	10	√		null
cp_sequencing	begintimelimit	varchar	20	√		null
cp_sequencing	choice	tinyint	3	√		null
cp_sequencing	choiceexit	tinyint	3	√		null
cp_sequencing	completionbycontent	tinyint	3	√		null
cp_sequencing	constrainchoice	tinyint	3	√		null
cp_sequencing	cp_node_id	int	10			0
cp_sequencing	endtimelimit	varchar	20	√		null
cp_sequencing	flow	tinyint	3	√		null
cp_sequencing	forwardonly	tinyint	3	√		null
cp_sequencing	id	varchar	200	√		null
cp_sequencing	measuresatisfactive	tinyint	3	√		null
cp_sequencing	objectivebycontent	tinyint	3	√		null
cp_sequencing	objectivemeasweight	double	22	√		null
cp_sequencing	preventactivation	tinyint	3	√		null
cp_sequencing	randomizationtiming	varchar	50	√		null
cp_sequencing	reorderchildren	tinyint	3	√		null
cp_sequencing	requiredcompleted	varchar	50	√		null
cp_sequencing	requiredforsatisfied	varchar	50	√		null
cp_sequencing	requiredincomplete	varchar	50	√		null
cp_sequencing	requirednotsatisfied	varchar	50	√		null
cp_sequencing	rollupobjectivesatis	tinyint	3	√		null
cp_sequencing	rollupprogcompletion	tinyint	3	√		null
cp_sequencing	selectcount	int	10	√		null
cp_sequencing	selectiontiming	varchar	50	√		null
cp_sequencing	sequencingid	varchar	50	√		null
cp_sequencing	tracked	tinyint	3	√		null
cp_sequencing	usecurattemptobjinfo	tinyint	3	√		null
cp_sequencing	usecurattemptproginfo	tinyint	3	√		null
cp_suspend	data	longtext	2147483647	√		null
cp_suspend	obj_id	int	10	√		null
cp_suspend	user_id	int	10	√		null
cp_tree	child	int	10	√		null
cp_tree	depth	int	10	√		null
cp_tree	lft	int	10	√		null
cp_tree	obj_id	int	10	√		null
cp_tree	parent	int	10	√		null
cp_tree	rgt	int	10	√		null
crs_archives	archive_date	int	10	√		null
crs_archives	archive_id	int	10			0
crs_archives	archive_lang	varchar	16	√		null
crs_archives	archive_name	varchar	255	√		null
crs_archives	archive_size	int	10	√		null
crs_archives	archive_type	tinyint	3			0
crs_archives	course_id	int	10			0
crs_archives_seq	sequence	int	10		√
crs_f_definitions	field_id	int	10			0
crs_f_definitions	field_name	varchar	255	√		null
crs_f_definitions	field_required	tinyint	3			0
crs_f_definitions	field_type	tinyint	3			0
crs_f_definitions	field_values	longtext	2147483647	√		null
crs_f_definitions	obj_id	int	10			0
crs_f_definitions_seq	sequence	int	10		√
crs_file	course_id	int	10			0
crs_file	file_id	int	10			0
crs_file	file_name	char	64	√		null
crs_file	file_size	int	10			0
crs_file	file_type	char	64	√		null
crs_file_seq	sequence	int	10		√
crs_groupings	crs_grp_id	int	10			0
crs_groupings	crs_id	int	10			0
crs_groupings	crs_ref_id	int	10			0
crs_groupings	unique_field	char	32	√		null
crs_items	changeable	tinyint	3			0
crs_items	earliest_start	int	10			0
crs_items	latest_end	int	10			0
crs_items	obj_id	int	10			0
crs_items	parent_id	int	10			0
crs_items	position	int	10	√		null
crs_items	suggestion_end	int	10			0
crs_items	suggestion_start	int	10			0
crs_items	timing_end	int	10			0
crs_items	timing_start	int	10			0
crs_items	timing_type	tinyint	3	√		null
crs_items	visible	tinyint	3			0
crs_lm_history	crs_ref_id	int	10			0
crs_lm_history	last_access	int	10			0
crs_lm_history	lm_page_id	int	10			0
crs_lm_history	lm_ref_id	int	10			0
crs_lm_history	usr_id	int	10			0
crs_members	blocked	tinyint	3			0
crs_members	notification	tinyint	3			0
crs_members	obj_id	int	10			0
crs_members	passed	tinyint	3	√		null
crs_members	usr_id	int	10			0
crs_objective_lm	lm_ass_id	int	10			0
crs_objective_lm	obj_id	int	10			0
crs_objective_lm	objective_id	int	10			0
crs_objective_lm	ref_id	int	10			0
crs_objective_lm	type	char	6	√		null
crs_objective_lm_seq	sequence	int	10		√
crs_objective_qst	obj_id	int	10			0
crs_objective_qst	objective_id	int	10			0
crs_objective_qst	qst_ass_id	int	10			0
crs_objective_qst	question_id	int	10			0
crs_objective_qst	ref_id	int	10			0
crs_objective_qst_seq	sequence	int	10		√
crs_objective_status	objective_id	int	10			0
crs_objective_status	status	tinyint	3			0
crs_objective_status	user_id	int	10			0
crs_objective_status_p	objective_id	int	10			0
crs_objective_status_p	user_id	int	10			0
crs_objective_tst	obj_id	int	10			0
crs_objective_tst	objective_id	int	10			0
crs_objective_tst	ref_id	int	10			0
crs_objective_tst	test_objective_id	int	10			0
crs_objective_tst	tst_limit	tinyint	3	√		null
crs_objective_tst	tst_status	tinyint	3	√		null
crs_objective_tst_seq	sequence	int	10		√
crs_objectives	created	int	10			0
crs_objectives	crs_id	int	10			0
crs_objectives	description	varchar	128	√		null
crs_objectives	objective_id	int	10			0
crs_objectives	position	int	10			0
crs_objectives	title	varchar	70	√		null
crs_objectives_seq	sequence	int	10		√
crs_settings	abo	tinyint	3	√		1
crs_settings	activation_end	int	10	√		null
crs_settings	activation_start	int	10	√		null
crs_settings	activation_type	tinyint	3			0
crs_settings	archive_end	int	10	√		null
crs_settings	archive_start	int	10	√		null
crs_settings	archive_type	int	10	√		null
crs_settings	contact_consultation	varchar	4000	√		null
crs_settings	contact_email	varchar	255	√		null
crs_settings	contact_name	varchar	255	√		null
crs_settings	contact_phone	varchar	255	√		null
crs_settings	contact_responsibility	varchar	255	√		null
crs_settings	enable_course_map	tinyint	3			0
crs_settings	important	varchar	4000	√		null
crs_settings	latitude	varchar	30	√		null
crs_settings	location_zoom	int	10			0
crs_settings	longitude	varchar	30	√		null
crs_settings	obj_id	int	10			0
crs_settings	reg_ac	varchar	32	√		null
crs_settings	reg_ac_enabled	tinyint	3
crs_settings	session_limit	tinyint	3			0
crs_settings	session_next	bigint	19			-1
crs_settings	session_prev	bigint	19			-1
crs_settings	show_members	tinyint	3			1
crs_settings	sortorder	int	10	√		null
crs_settings	sub_end	int	10	√		null
crs_settings	sub_limitation_type	tinyint	3			0
crs_settings	sub_max_members	int	10	√		null
crs_settings	sub_mem_limit	tinyint	3			0
crs_settings	sub_notify	int	10	√		null
crs_settings	sub_password	varchar	32	√		null
crs_settings	sub_start	int	10	√		null
crs_settings	sub_type	int	10	√		null
crs_settings	syllabus	varchar	4000	√		null
crs_settings	view_mode	tinyint	3			0
crs_settings	waiting_list	tinyint	3			1
crs_start	crs_id	int	10			0
crs_start	crs_start_id	int	10			0
crs_start	item_ref_id	int	10			0
crs_start_seq	sequence	int	10		√
crs_timings_planed	item_id	int	10			0
crs_timings_planed	planed_end	int	10			0
crs_timings_planed	planed_start	int	10			0
crs_timings_planed	usr_id	int	10			0
crs_timings_usr_accept	accept	tinyint	3			0
crs_timings_usr_accept	crs_id	int	10			0
crs_timings_usr_accept	remark	varchar	4000	√		null
crs_timings_usr_accept	usr_id	int	10			0
crs_timings_usr_accept	visible	tinyint	3			0
crs_user_data	field_id	int	10			0
crs_user_data	usr_id	int	10			0
crs_user_data	value	varchar	4000	√		null
crs_waiting_list	obj_id	int	10			0
crs_waiting_list	sub_time	int	10			0
crs_waiting_list	usr_id	int	10			0
ctrl_calls	child	varchar	100	√		null
ctrl_calls	comp_prefix	varchar	50	√		null
ctrl_calls	parent	varchar	100	√		null
ctrl_classfile	cid	varchar	4	√		null
ctrl_classfile	class	varchar	100
ctrl_classfile	comp_prefix	varchar	50	√		null
ctrl_classfile	filename	varchar	250	√		null
ctrl_classfile	plugin_path	varchar	250	√		null
ctrl_structure	call_node	longtext	2147483647	√		null
ctrl_structure	forward	longtext	2147483647	√		null
ctrl_structure	parent	longtext	2147483647	√		null
ctrl_structure	root_class	varchar	40
data_cache	keyword	varchar	50
data_cache	module	varchar	50			common
data_cache	value	longtext	2147483647	√		null
dav_lock	dav_owner	varchar	200	√		null
dav_lock	depth	int	10			0
dav_lock	expires	int	10			0
dav_lock	ilias_owner	int	10			0
dav_lock	node_id	int	10			0
dav_lock	obj_id	int	10			0
dav_lock	scope	char	1	√		s
dav_lock	token	varchar	255
dav_lock	type	char	1	√		w
dav_property	name	varchar	120
dav_property	node_id	int	10			0
dav_property	ns	varchar	120			DAV:
dav_property	obj_id	int	10			0
dav_property	value	varchar	4000	√		null
dbk_translations	id	int	10			0
dbk_translations	tr_id	int	10			0
desktop_item	item_id	int	10			0
desktop_item	parameters	varchar	200	√		null
desktop_item	type	varchar	4	√		null
desktop_item	user_id	int	10			0
ecs_container_mapping	container_id	int	10			0
ecs_container_mapping	date_range_end	int	10			0
ecs_container_mapping	date_range_start	int	10			0
ecs_container_mapping	field_name	varchar	255	√		null
ecs_container_mapping	mapping_id	int	10			0
ecs_container_mapping	mapping_type	tinyint	3			0
ecs_container_mapping	mapping_value	varchar	255	√		null
ecs_events	event_id	int	10			0
ecs_events	id	int	10			0
ecs_events	op	char	32	√		null
ecs_events	type	char	32	√		null
ecs_events_seq	sequence	int	10		√
ecs_export	econtent_id	int	10			0
ecs_export	obj_id	int	10			0
ecs_import	econtent_id	int	10			0
ecs_import	mid	int	10			0
ecs_import	obj_id	int	10			0
event	description	varchar	4000	√		null
event	details	varchar	4000	√		null
event	event_id	int	10			0
event	location	varchar	4000	√		null
event	obj_id	int	10			0
event	participation	tinyint	3			0
event	registration	tinyint	3			0
event	title	varchar	70	√		null
event	tutor_email	varchar	127	√		null
event	tutor_name	varchar	4000	√		null
event	tutor_phone	varchar	127	√		null
event_appointment	appointment_id	int	10			0
event_appointment	e_end	datetime	19	√		null
event_appointment	e_start	datetime	19	√		null
event_appointment	ending_time	int	10			0
event_appointment	event_id	int	10			0
event_appointment	fulltime	tinyint	3			0
event_appointment	starting_time	int	10			0
event_appointment_seq	sequence	int	10		√
event_file	event_id	int	10			0
event_file	file_id	int	10			0
event_file	file_name	char	64	√		null
event_file	file_size	int	10			0
event_file	file_type	char	64	√		null
event_file_seq	sequence	int	10		√
event_items	event_id	int	10			0
event_items	item_id	int	10			0
event_participants	e_comment	longtext	2147483647	√		null
event_participants	event_id	int	10			0
event_participants	mark	longtext	2147483647	√		null
event_participants	participated	tinyint	3			0
event_participants	registered	tinyint	3			0
event_participants	usr_id	int	10			0
event_seq	sequence	int	10		√
exc_assignment	exc_id	int	10
exc_assignment	id	int	10
exc_assignment	instruction	longtext	2147483647	√		null
exc_assignment	mandatory	tinyint	3	√		1
exc_assignment	order_nr	int	10			0
exc_assignment	start_time	int	10	√		null
exc_assignment	time_stamp	int	10	√		null
exc_assignment	title	varchar	200	√		null
exc_assignment_seq	sequence	int	10		√
exc_data	instruction	longtext	2147483647	√		null
exc_data	obj_id	int	10			0
exc_data	pass_mode	varchar	8			all
exc_data	pass_nr	int	10	√		null
exc_data	show_submissions	tinyint	3			0
exc_data	time_stamp	int	10	√		null
exc_mem_ass_status	ass_id	int	10
exc_mem_ass_status	feedback	tinyint	3			0
exc_mem_ass_status	feedback_time	datetime	19	√		null
exc_mem_ass_status	mark	varchar	32	√		null
exc_mem_ass_status	notice	varchar	4000	√		null
exc_mem_ass_status	returned	tinyint	3			0
exc_mem_ass_status	sent	tinyint	3	√		null
exc_mem_ass_status	sent_time	datetime	19	√		null
exc_mem_ass_status	solved	tinyint	3	√		null
exc_mem_ass_status	status	char	9	√		notgraded
exc_mem_ass_status	status_time	datetime	19	√		null
exc_mem_ass_status	u_comment	varchar	4000	√		null
exc_mem_ass_status	usr_id	int	10
exc_members	feedback	tinyint	3			0
exc_members	feedback_time	datetime	19	√		null
exc_members	notice	varchar	4000	√		null
exc_members	obj_id	int	10			0
exc_members	returned	tinyint	3			0
exc_members	sent	tinyint	3	√		null
exc_members	sent_time	datetime	19	√		null
exc_members	solved	tinyint	3	√		null
exc_members	status	char	9	√		notgraded
exc_members	status_time	datetime	19	√		null
exc_members	usr_id	int	10			0
exc_returned	ass_id	int	10	√		null
exc_returned	filename	varchar	1000	√		null
exc_returned	filetitle	varchar	1000	√		null
exc_returned	mimetype	varchar	40	√		null
exc_returned	obj_id	int	10			0
exc_returned	returned_id	int	10			0
exc_returned	ts	datetime	19	√		null
exc_returned	user_id	int	10			0
exc_returned_seq	sequence	int	10		√
exc_usr_tutor	ass_id	int	10			0
exc_usr_tutor	download_time	datetime	19	√		null
exc_usr_tutor	obj_id	int	10			0
exc_usr_tutor	tutor_id	int	10			0
exc_usr_tutor	usr_id	int	10			0
export_file_info	create_date	datetime	19
export_file_info	export_type	varchar	32
export_file_info	file_name	varchar	64
export_file_info	filename	varchar	64
export_file_info	obj_id	int	10
export_file_info	version	varchar	16	√		null
export_options	export_id	smallint	5
export_options	keyword	smallint	5
export_options	obj_id	int	10
export_options	pos	int	10			0
export_options	ref_id	int	10
export_options	value	varchar	32	√		null
feedback_items	anonymous	tinyint	3			1
feedback_items	description	longtext	2147483647	√		null
feedback_items	endtime	int	10	√		0
feedback_items	fb_id	int	10			0
feedback_items	first_vote_best	tinyint	3	√		0
feedback_items	interval_unit	tinyint	3	√		null
feedback_items	obj_id	int	10	√		0
feedback_items	ref_id	int	10	√		0
feedback_items	repeat_interval	int	10	√		null
feedback_items	required	tinyint	3	√		0
feedback_items	show_on	varchar	6	√		null
feedback_items	starttime	int	10	√		0
feedback_items	text_answer	tinyint	3	√		0
feedback_items	title	varchar	255	√		null
feedback_items	votes	longtext	2147483647	√		null
feedback_items_seq	sequence	int	10		√
feedback_results	fb_id	int	10			0
feedback_results	note	longtext	2147483647	√		null
feedback_results	user_id	int	10	√		null
feedback_results	vote	int	10			0
feedback_results	votetime	int	10			0
file_based_lm	id	int	10			0
file_based_lm	is_online	char	1	√		n
file_based_lm	startfile	varchar	200	√		null
file_data	f_mode	char	8	√		object
file_data	file_id	int	10			0
file_data	file_name	char	250	√		null
file_data	file_size	int	10			0
file_data	file_type	char	250	√		null
file_data	version	int	10	√		null
file_usage	id	int	10			0
file_usage	usage_hist_nr	int	10			0
file_usage	usage_id	int	10			0
file_usage	usage_type	varchar	10
frm_data	top_date	datetime	19	√		null
frm_data	top_description	varchar	255	√		null
frm_data	top_frm_fk	bigint	19			0
frm_data	top_last_post	varchar	50	√		null
frm_data	top_mods	int	10			0
frm_data	top_name	varchar	255	√		null
frm_data	top_num_posts	int	10			0
frm_data	top_num_threads	int	10			0
frm_data	top_pk	bigint	19			0
frm_data	top_update	datetime	19	√		null
frm_data	top_usr_id	bigint	19			0
frm_data	update_user	int	10			0
frm_data	visits	int	10			0
frm_data_seq	sequence	int	10		√
frm_notification	admin_force_noti	tinyint	3			0
frm_notification	frm_id	int	10			0
frm_notification	notification_id	int	10			0
frm_notification	thread_id	int	10			0
frm_notification	user_id	int	10			0
frm_notification	user_id_noti	int	10	√		null
frm_notification	user_toggle_noti	tinyint	3			0
frm_notification_seq	sequence	int	10		√
frm_posts	import_name	varchar	4000	√		null
frm_posts	notify	tinyint	3			0
frm_posts	pos_cens	tinyint	3			0
frm_posts	pos_cens_com	varchar	4000	√		null
frm_posts	pos_date	datetime	19	√		null
frm_posts	pos_message	longtext	2147483647	√		null
frm_posts	pos_pk	bigint	19			0
frm_posts	pos_status	tinyint	3			1
frm_posts	pos_subject	varchar	4000	√		null
frm_posts	pos_thr_fk	bigint	19			0
frm_posts	pos_top_fk	bigint	19			0
frm_posts	pos_update	datetime	19	√		null
frm_posts	pos_usr_alias	varchar	255	√		null
frm_posts	pos_usr_id	bigint	19			0
frm_posts	update_user	int	10			0
frm_posts_seq	sequence	int	10		√
frm_posts_tree	depth	int	10			0
frm_posts_tree	fpt_date	datetime	19	√		null
frm_posts_tree	fpt_pk	bigint	19			0
frm_posts_tree	lft	int	10			0
frm_posts_tree	parent_pos	bigint	19			0
frm_posts_tree	pos_fk	bigint	19			0
frm_posts_tree	rgt	int	10			0
frm_posts_tree	thr_fk	bigint	19			0
frm_posts_tree_seq	sequence	int	10		√
frm_settings	add_re_subject	tinyint	3			0
frm_settings	admin_force_noti	tinyint	3			0
frm_settings	anonymized	tinyint	3			0
frm_settings	default_view	int	10			0
frm_settings	notification_type	varchar	10	√		null
frm_settings	obj_id	int	10			0
frm_settings	post_activation	tinyint	3			0
frm_settings	preset_subject	tinyint	3			0
frm_settings	statistics_enabled	tinyint	3			0
frm_settings	user_toggle_noti	tinyint	3			0
frm_thread_access	access_last	int	10			0
frm_thread_access	access_old	int	10			0
frm_thread_access	access_old_ts	datetime	19	√		null
frm_thread_access	obj_id	int	10			0
frm_thread_access	thread_id	int	10			0
frm_thread_access	usr_id	int	10			0
frm_threads	import_name	varchar	4000	√		null
frm_threads	is_closed	tinyint	3			0
frm_threads	is_sticky	tinyint	3			0
frm_threads	thr_date	datetime	19	√		null
frm_threads	thr_last_post	varchar	50	√		null
frm_threads	thr_num_posts	int	10			0
frm_threads	thr_pk	bigint	19			0
frm_threads	thr_subject	varchar	255	√		null
frm_threads	thr_top_fk	bigint	19			0
frm_threads	thr_update	datetime	19	√		null
frm_threads	thr_usr_alias	varchar	255	√		null
frm_threads	thr_usr_id	bigint	19			0
frm_threads	visits	int	10			0
frm_threads_seq	sequence	int	10		√
frm_user_read	obj_id	int	10			0
frm_user_read	post_id	int	10			0
frm_user_read	thread_id	int	10			0
frm_user_read	usr_id	int	10			0
glossary	downloads_active	char	1	√		n
glossary	glo_menu_active	char	1	√		y
glossary	id	int	10			0
glossary	is_online	char	1	√		n
glossary	pres_mode	varchar	10			table
glossary	public_html_file	varchar	50	√		null
glossary	public_xml_file	varchar	50	√		null
glossary	snippet_length	int	10			200
glossary	virtual	char	7	√		none
glossary_definition	id	int	10			0
glossary_definition	nr	int	10			0
glossary_definition	short_text	varchar	4000	√		null
glossary_definition	short_text_dirty	int	10			0
glossary_definition	term_id	int	10			0
glossary_definition_seq	sequence	int	10		√
glossary_term	create_date	datetime	19	√		null
glossary_term	glo_id	int	10			0
glossary_term	id	int	10			0
glossary_term	import_id	varchar	50	√		null
glossary_term	language	char	2	√		null
glossary_term	last_update	datetime	19	√		null
glossary_term	term	varchar	200	√		null
glossary_term_seq	sequence	int	10		√
grp_settings	enablemap	tinyint	3			0
grp_settings	grp_type	tinyint	3			0
grp_settings	information	varchar	4000	√		null
grp_settings	latitude	varchar	30	√		null
grp_settings	location_zoom	int	10			0
grp_settings	longitude	varchar	30	√		null
grp_settings	obj_id	int	10			0
grp_settings	reg_ac	varchar	32	√		null
grp_settings	reg_ac_enabled	tinyint	3
grp_settings	registration_enabled	tinyint	3			0
grp_settings	registration_end	datetime	19	√		null
grp_settings	registration_max_members	int	10			0
grp_settings	registration_mem_limit	tinyint	3			0
grp_settings	registration_password	char	32	√		null
grp_settings	registration_start	datetime	19	√		null
grp_settings	registration_type	tinyint	3			0
grp_settings	registration_unlimited	tinyint	3			0
grp_settings	waiting_list	tinyint	3			0
history	action	varchar	20	√		null
history	hdate	datetime	19	√		null
history	id	int	10			0
history	info_params	varchar	4000	√		null
history	obj_id	int	10			0
history	obj_type	varchar	8	√		null
history	user_comment	longtext	2147483647	√		null
history	usr_id	int	10			0
history_seq	sequence	int	10		√
il_block_setting	block_id	int	10			0
il_block_setting	setting	varchar	40
il_block_setting	type	varchar	20
il_block_setting	user_id	int	10			0
il_block_setting	value	varchar	200	√		null
il_component	id	char	10
il_component	name	varchar	200	√		null
il_component	type	char	10
il_custom_block	context_obj_id	int	10	√		null
il_custom_block	context_obj_type	varchar	10	√		null
il_custom_block	context_sub_obj_id	int	10	√		null
il_custom_block	context_sub_obj_type	varchar	10	√		null
il_custom_block	id	int	10			0
il_custom_block	title	varchar	200	√		null
il_custom_block	type	varchar	20	√		null
il_custom_block_seq	sequence	int	10		√
il_external_feed_block	feed_url	varchar	250	√		null
il_external_feed_block	id	int	10			0
il_external_feed_block_seq	sequence	int	10		√
il_html_block	content	varchar	4000	√		null
il_html_block	id	int	10			0
il_log	created	datetime	19	√		null
il_log	log_level	int	10			0
il_log	message	varchar	250	√		null
il_log	module	varchar	50	√		null
il_md_cpr_selections	copyright	longtext	2147483647	√		null
il_md_cpr_selections	costs	tinyint	3			0
il_md_cpr_selections	cpr_restrictions	tinyint	3			1
il_md_cpr_selections	description	longtext	2147483647	√		null
il_md_cpr_selections	entry_id	int	10			0
il_md_cpr_selections	language	char	2	√		null
il_md_cpr_selections	title	varchar	128	√		null
il_md_cpr_selections_seq	sequence	int	10		√
il_media_cast_data	def_access	tinyint	3	√		0
il_media_cast_data	downloadable	tinyint	3	√		0
il_media_cast_data	id	int	10			0
il_media_cast_data	is_online	tinyint	3	√		0
il_media_cast_data	public_files	tinyint	3	√		0
il_meta_annotation	a_date	longtext	2147483647	√		null
il_meta_annotation	description	longtext	2147483647	√		null
il_meta_annotation	description_language	char	2	√		null
il_meta_annotation	entity	longtext	2147483647	√		null
il_meta_annotation	meta_annotation_id	int	10			0
il_meta_annotation	obj_id	int	10	√		null
il_meta_annotation	obj_type	varchar	6	√		null
il_meta_annotation	rbac_id	int	10	√		null
il_meta_annotation_seq	sequence	int	10		√
il_meta_classification	description	varchar	4000	√		null
il_meta_classification	description_language	char	2	√		null
il_meta_classification	meta_classification_id	int	10			0
il_meta_classification	obj_id	int	10	√		null
il_meta_classification	obj_type	varchar	6	√		null
il_meta_classification	purpose	varchar	32	√		null
il_meta_classification	rbac_id	int	10	√		null
il_meta_classification_seq	sequence	int	10		√
il_meta_contribute	c_date	varchar	4000	√		null
il_meta_contribute	meta_contribute_id	int	10			0
il_meta_contribute	obj_id	int	10	√		null
il_meta_contribute	obj_type	varchar	6	√		null
il_meta_contribute	parent_id	int	10	√		null
il_meta_contribute	parent_type	varchar	32	√		null
il_meta_contribute	rbac_id	int	10	√		null
il_meta_contribute	role	varchar	32	√		null
il_meta_contribute_seq	sequence	int	10		√
il_meta_description	description	longtext	2147483647	√		null
il_meta_description	description_language	char	2	√		null
il_meta_description	meta_description_id	int	10			0
il_meta_description	obj_id	int	10	√		null
il_meta_description	obj_type	varchar	6	√		null
il_meta_description	parent_id	int	10	√		null
il_meta_description	parent_type	varchar	16	√		null
il_meta_description	rbac_id	int	10	√		null
il_meta_description_seq	sequence	int	10		√
il_meta_educational	context	varchar	16	√		null
il_meta_educational	difficulty	varchar	16	√		null
il_meta_educational	intended_end_user_role	varchar	16	√		null
il_meta_educational	interactivity_level	varchar	16	√		null
il_meta_educational	interactivity_type	varchar	16	√		null
il_meta_educational	learning_resource_type	varchar	32	√		null
il_meta_educational	meta_educational_id	int	10			0
il_meta_educational	obj_id	int	10	√		null
il_meta_educational	obj_type	varchar	6	√		null
il_meta_educational	rbac_id	int	10	√		null
il_meta_educational	semantic_density	varchar	16	√		null
il_meta_educational	typical_learning_time	varchar	4000	√		null
il_meta_educational_seq	sequence	int	10		√
il_meta_entity	entity	varchar	4000	√		null
il_meta_entity	meta_entity_id	int	10			0
il_meta_entity	obj_id	int	10	√		null
il_meta_entity	obj_type	varchar	6	√		null
il_meta_entity	parent_id	int	10	√		null
il_meta_entity	parent_type	varchar	16	√		null
il_meta_entity	rbac_id	int	10	√		null
il_meta_entity_seq	sequence	int	10		√
il_meta_format	format	varchar	255	√		null
il_meta_format	meta_format_id	int	10			0
il_meta_format	obj_id	int	10	√		null
il_meta_format	obj_type	varchar	6	√		null
il_meta_format	rbac_id	int	10	√		null
il_meta_format_seq	sequence	int	10		√
il_meta_general	coverage	varchar	4000	√		null
il_meta_general	coverage_language	char	2	√		null
il_meta_general	general_structure	varchar	16	√		null
il_meta_general	meta_general_id	int	10			0
il_meta_general	obj_id	int	10	√		null
il_meta_general	obj_type	varchar	6	√		null
il_meta_general	rbac_id	int	10	√		null
il_meta_general	title	varchar	4000	√		null
il_meta_general	title_language	char	2	√		null
il_meta_general_seq	sequence	int	10		√
il_meta_identifier	catalog	varchar	4000	√		null
il_meta_identifier	entry	varchar	4000	√		null
il_meta_identifier	meta_identifier_id	int	10			0
il_meta_identifier	obj_id	int	10	√		null
il_meta_identifier	obj_type	varchar	6	√		null
il_meta_identifier	parent_id	int	10	√		null
il_meta_identifier	parent_type	varchar	16	√		null
il_meta_identifier	rbac_id	int	10	√		null
il_meta_identifier_	catalog	varchar	4000	√		null
il_meta_identifier_	entry	varchar	4000	√		null
il_meta_identifier_	meta_identifier__id	int	10			0
il_meta_identifier_	obj_id	int	10	√		null
il_meta_identifier_	obj_type	varchar	6	√		null
il_meta_identifier_	parent_id	int	10	√		null
il_meta_identifier_	parent_type	varchar	16	√		null
il_meta_identifier_	rbac_id	int	10	√		null
il_meta_identifier__seq	sequence	int	10		√
il_meta_identifier_seq	sequence	int	10		√
il_meta_keyword	keyword	varchar	4000	√		null
il_meta_keyword	keyword_language	char	2	√		null
il_meta_keyword	meta_keyword_id	int	10			0
il_meta_keyword	obj_id	int	10	√		null
il_meta_keyword	obj_type	varchar	6	√		null
il_meta_keyword	parent_id	int	10	√		null
il_meta_keyword	parent_type	varchar	32	√		null
il_meta_keyword	rbac_id	int	10	√		null
il_meta_keyword_seq	sequence	int	10		√
il_meta_language	language	char	2	√		null
il_meta_language	meta_language_id	int	10			0
il_meta_language	obj_id	int	10	√		null
il_meta_language	obj_type	char	6	√		null
il_meta_language	parent_id	int	10	√		null
il_meta_language	parent_type	char	16	√		null
il_meta_language	rbac_id	int	10	√		null
il_meta_language_seq	sequence	int	10		√
il_meta_lifecycle	lifecycle_status	varchar	16	√		null
il_meta_lifecycle	meta_lifecycle_id	int	10			0
il_meta_lifecycle	meta_version	varchar	4000	√		null
il_meta_lifecycle	obj_id	int	10	√		null
il_meta_lifecycle	obj_type	varchar	6	√		null
il_meta_lifecycle	rbac_id	int	10	√		null
il_meta_lifecycle	version_language	char	2	√		null
il_meta_lifecycle_seq	sequence	int	10		√
il_meta_location	location	varchar	4000	√		null
il_meta_location	location_type	varchar	16	√		null
il_meta_location	meta_location_id	int	10			0
il_meta_location	obj_id	int	10	√		null
il_meta_location	obj_type	varchar	6	√		null
il_meta_location	parent_id	int	10	√		null
il_meta_location	parent_type	varchar	16	√		null
il_meta_location	rbac_id	int	10	√		null
il_meta_location_seq	sequence	int	10		√
il_meta_meta_data	language	char	2	√		null
il_meta_meta_data	meta_data_scheme	char	16	√		null
il_meta_meta_data	meta_meta_data_id	int	10			0
il_meta_meta_data	obj_id	int	10	√		null
il_meta_meta_data	obj_type	char	6	√		null
il_meta_meta_data	rbac_id	int	10	√		null
il_meta_meta_data_seq	sequence	int	10		√
il_meta_relation	kind	char	16	√		null
il_meta_relation	meta_relation_id	int	10			0
il_meta_relation	obj_id	int	10	√		null
il_meta_relation	obj_type	char	6	√		null
il_meta_relation	rbac_id	int	10	√		null
il_meta_relation_seq	sequence	int	10		√
il_meta_requirement	browser_maximum_version	char	255	√		null
il_meta_requirement	browser_minimum_version	char	255	√		null
il_meta_requirement	browser_name	varchar	32	√		null
il_meta_requirement	meta_requirement_id	int	10			0
il_meta_requirement	obj_id	int	10	√		null
il_meta_requirement	obj_type	varchar	6	√		null
il_meta_requirement	operating_system_name	varchar	16	√		null
il_meta_requirement	or_composite_id	int	10			0
il_meta_requirement	os_max_version	char	255	√		null
il_meta_requirement	os_min_version	char	255	√		null
il_meta_requirement	parent_id	int	10	√		null
il_meta_requirement	parent_type	varchar	16	√		null
il_meta_requirement	rbac_id	int	10	√		null
il_meta_requirement_seq	sequence	int	10		√
il_meta_rights	costs	char	3	√		null
il_meta_rights	cpr_and_or	char	3	√		null
il_meta_rights	description	varchar	4000	√		null
il_meta_rights	description_language	char	2	√		null
il_meta_rights	meta_rights_id	int	10			0
il_meta_rights	obj_id	int	10	√		null
il_meta_rights	obj_type	varchar	6	√		null
il_meta_rights	rbac_id	int	10	√		null
il_meta_rights_seq	sequence	int	10		√
il_meta_tar	meta_tar_id	int	10			0
il_meta_tar	obj_id	int	10	√		null
il_meta_tar	obj_type	varchar	6	√		null
il_meta_tar	parent_id	int	10	√		null
il_meta_tar	parent_type	varchar	16	√		null
il_meta_tar	rbac_id	int	10	√		null
il_meta_tar	tar_language	char	2	√		null
il_meta_tar	tar_max	char	2	√		null
il_meta_tar	tar_min	char	2	√		null
il_meta_tar	typical_age_range	varchar	4000	√		null
il_meta_tar_seq	sequence	int	10		√
il_meta_taxon	meta_taxon_id	int	10			0
il_meta_taxon	obj_id	int	10	√		null
il_meta_taxon	obj_type	varchar	6	√		null
il_meta_taxon	parent_id	int	10	√		null
il_meta_taxon	parent_type	varchar	32	√		null
il_meta_taxon	rbac_id	int	10	√		null
il_meta_taxon	taxon	varchar	4000	√		null
il_meta_taxon	taxon_id	varchar	4000	√		null
il_meta_taxon	taxon_language	char	2	√		null
il_meta_taxon_path	meta_taxon_path_id	int	10			0
il_meta_taxon_path	obj_id	int	10	√		null
il_meta_taxon_path	obj_type	varchar	6	√		null
il_meta_taxon_path	parent_id	int	10	√		null
il_meta_taxon_path	parent_type	varchar	32	√		null
il_meta_taxon_path	rbac_id	int	10	√		null
il_meta_taxon_path	source	varchar	4000	√		null
il_meta_taxon_path	source_language	char	2	√		null
il_meta_taxon_path_seq	sequence	int	10		√
il_meta_taxon_seq	sequence	int	10		√
il_meta_technical	duration	varchar	4000	√		null
il_meta_technical	ir	varchar	4000	√		null
il_meta_technical	ir_language	char	2	√		null
il_meta_technical	meta_technical_id	int	10			0
il_meta_technical	obj_id	int	10	√		null
il_meta_technical	obj_type	varchar	6	√		null
il_meta_technical	opr	varchar	4000	√		null
il_meta_technical	opr_language	char	2	√		null
il_meta_technical	rbac_id	int	10	√		null
il_meta_technical	t_size	varchar	4000	√		null
il_meta_technical_seq	sequence	int	10		√
il_news_item	content	longtext	2147483647	√		null
il_news_item	content_is_lang_var	tinyint	3	√		0
il_news_item	content_long	longtext	2147483647	√		null
il_news_item	content_type	char	5	√		text
il_news_item	context_obj_id	int	10	√		null
il_news_item	context_obj_type	varchar	10	√		null
il_news_item	context_sub_obj_id	int	10	√		null
il_news_item	context_sub_obj_type	varchar	10	√		null
il_news_item	creation_date	datetime	19	√		null
il_news_item	end_date	datetime	19	√		null
il_news_item	id	int	10			0
il_news_item	mob_id	int	10	√		null
il_news_item	playtime	varchar	8	√		null
il_news_item	priority	int	10	√		1
il_news_item	start_date	datetime	19	√		null
il_news_item	title	varchar	200	√		null
il_news_item	update_date	datetime	19	√		null
il_news_item	user_id	int	10	√		null
il_news_item	visibility	char	6	√		users
il_news_item_seq	sequence	int	10		√
il_news_read	news_id	int	10			0
il_news_read	user_id	int	10			0
il_news_subscription	ref_id	int	10			0
il_news_subscription	user_id	int	10			0
il_object_def	allow_copy	tinyint	3			0
il_object_def	allow_link	tinyint	3			0
il_object_def	checkbox	tinyint	3			0
il_object_def	class_name	varchar	200	√		null
il_object_def	component	varchar	200	√		null
il_object_def	default_pos	int	10			0
il_object_def	default_pres_pos	int	10			0
il_object_def	devmode	tinyint	3			0
il_object_def	export	tinyint	3			0
il_object_def	grp	char	10	√		null
il_object_def	id	char	10
il_object_def	inherit	tinyint	3			0
il_object_def	location	varchar	250	√		null
il_object_def	rbac	tinyint	3			0
il_object_def	sideblock	tinyint	3			0
il_object_def	system	tinyint	3			0
il_object_def	translate	char	5	√		null
il_object_group	default_pres_pos	int	10			0
il_object_group	id	char	10
il_object_group	name	varchar	200	√		null
il_object_subobj	mmax	tinyint	3			0
il_object_subobj	parent	char	10
il_object_subobj	subobj	char	10
il_plugin	active	tinyint	3	√		null
il_plugin	component_name	varchar	90
il_plugin	component_type	char	10
il_plugin	db_version	int	10			0
il_plugin	last_update_version	char	10	√		null
il_plugin	name	varchar	40
il_plugin	plugin_id	varchar	20	√		null
il_plugin	slot_id	char	10
il_pluginslot	component	varchar	200
il_pluginslot	id	char	10
il_pluginslot	name	varchar	200	√		null
il_rating	obj_id	int	10			0
il_rating	obj_type	char	10
il_rating	rating	int	10			0
il_rating	sub_obj_id	int	10			0
il_rating	sub_obj_type	char	10
il_rating	user_id	int	10			0
il_request_token	session_id	varchar	100	√		null
il_request_token	stamp	datetime	19	√		null
il_request_token	token	char	64	√		null
il_request_token	user_id	int	10			0
il_subscribers	obj_id	int	10			0
il_subscribers	sub_time	int	10			0
il_subscribers	subject	varchar	255	√		null
il_subscribers	usr_id	int	10			0
il_tag	is_offline	tinyint	3			0
il_tag	obj_id	int	10			0
il_tag	obj_type	char	10
il_tag	sub_obj_id	int	10			0
il_tag	sub_obj_type	char	10
il_tag	tag	varchar	100
il_tag	user_id	int	10			0
il_wiki_contributor	status	int	10	√		null
il_wiki_contributor	status_time	datetime	19	√		null
il_wiki_contributor	user_id	int	10			0
il_wiki_contributor	wiki_id	int	10			0
il_wiki_data	id	int	10			0
il_wiki_data	introduction	longtext	2147483647	√		null
il_wiki_data	is_online	tinyint	3	√		0
il_wiki_data	rating	tinyint	3	√		0
il_wiki_data	short	varchar	20	√		null
il_wiki_data	startpage	varchar	200	√		null
il_wiki_missing_page	source_id	int	10			0
il_wiki_missing_page	target_name	varchar	200	√		null
il_wiki_missing_page	wiki_id	int	10			0
il_wiki_page	id	int	10			0
il_wiki_page	title	varchar	200	√		null
il_wiki_page	wiki_id	int	10			0
il_wiki_page_seq	sequence	int	10		√
ilinc_data	activation_end	int	10	√		null
ilinc_data	activation_offline	varchar	3	√		null
ilinc_data	activation_start	int	10	√		null
ilinc_data	activation_unlimited	tinyint	3	√		null
ilinc_data	akclassvalue1	varchar	40	√		null
ilinc_data	akclassvalue2	varchar	40	√		null
ilinc_data	contact_email	varchar	255	√		null
ilinc_data	contact_name	varchar	255	√		null
ilinc_data	contact_phone	varchar	255	√		null
ilinc_data	contact_responsibili	varchar	255	√		null
ilinc_data	course_id	int	10			0
ilinc_data	i_type	varchar	5	√		null
ilinc_data	obj_id	int	10			0
ilinc_data	subscription_end	int	10	√		null
ilinc_data	subscription_passwd	varchar	32	√		null
ilinc_data	subscription_start	int	10	√		null
ilinc_data	subscription_type	tinyint	3	√		null
ilinc_data	subscription_unlimit	tinyint	3	√		null
ilinc_registration	application_date	datetime	19	√		null
ilinc_registration	obj_id	int	10			0
ilinc_registration	usr_id	int	10			0
ilinc_registration	usr_text	varchar	255	√		null
int_link	source_id	int	10			0
int_link	source_type	varchar	10
int_link	target_id	int	10			0
int_link	target_inst	int	10			0
int_link	target_type	varchar	4
ldap_attribute_mapping	keyword	varchar	32
ldap_attribute_mapping	perform_update	tinyint	3			0
ldap_attribute_mapping	server_id	int	10			0
ldap_attribute_mapping	value	varchar	255	√		null
ldap_rg_mapping	dn	varchar	255	√		null
ldap_rg_mapping	mapping_id	int	10			0
ldap_rg_mapping	mapping_info	varchar	4000	√		null
ldap_rg_mapping	mapping_info_type	tinyint	3			1
ldap_rg_mapping	member_attribute	varchar	64	√		null
ldap_rg_mapping	member_isdn	tinyint	3			0
ldap_rg_mapping	role	int	10			0
ldap_rg_mapping	server_id	int	10			0
ldap_rg_mapping	url	varchar	255	√		null
ldap_rg_mapping_seq	sequence	int	10		√
ldap_role_assignments	add_on_update	tinyint	3	√		null
ldap_role_assignments	att_name	varchar	255	√		null
ldap_role_assignments	att_value	varchar	255	√		null
ldap_role_assignments	attribute	varchar	32	√		null
ldap_role_assignments	dn	varchar	1000	√		null
ldap_role_assignments	isdn	tinyint	3			0
ldap_role_assignments	plugin_id	int	10	√		null
ldap_role_assignments	remove_on_update	tinyint	3	√		null
ldap_role_assignments	role_id	int	10			0
ldap_role_assignments	rule_id	tinyint	3			0
ldap_role_assignments	server_id	int	10			0
ldap_role_assignments	type	tinyint	3			0
ldap_role_assignments_seq	sequence	int	10		√
ldap_server_settings	active	int	10			0
ldap_server_settings	base_dn	varchar	255	√		null
ldap_server_settings	bind_pass	varchar	32	√		null
ldap_server_settings	bind_type	int	10			0
ldap_server_settings	bind_user	varchar	255	√		null
ldap_server_settings	filter	varchar	255	√		null
ldap_server_settings	group_attribute	varchar	64	√		null
ldap_server_settings	group_dn	varchar	255	√		null
ldap_server_settings	group_filter	varchar	255	√		null
ldap_server_settings	group_member	varchar	255	√		null
ldap_server_settings	group_memberisdn	tinyint	3			0
ldap_server_settings	group_name	varchar	255	√		null
ldap_server_settings	group_optional	tinyint	3			0
ldap_server_settings	group_scope	tinyint	3			0
ldap_server_settings	group_user_filter	varchar	255	√		null
ldap_server_settings	migration	tinyint	3			0
ldap_server_settings	name	varchar	32	√		null
ldap_server_settings	referrals	int	10			0
ldap_server_settings	role_bind_dn	varchar	255	√		null
ldap_server_settings	role_bind_pass	varchar	32	√		null
ldap_server_settings	role_sync_active	tinyint	3			0
ldap_server_settings	search_base	varchar	255	√		null
ldap_server_settings	server_id	int	10			0
ldap_server_settings	sync_on_login	tinyint	3			0
ldap_server_settings	sync_per_cron	tinyint	3			0
ldap_server_settings	tls	int	10			0
ldap_server_settings	url	varchar	255	√		null
ldap_server_settings	user_attribute	varchar	255	√		null
ldap_server_settings	user_scope	tinyint	3			0
ldap_server_settings	version	int	10			0
ldap_server_settings_seq	sequence	int	10		√
license_data	licenses	int	10			0
license_data	obj_id	int	10			0
license_data	remarks	longtext	2147483647	√		null
license_data	used	int	10			0
link_check	http_status_code	int	10			0
link_check	last_check	int	10			0
link_check	obj_id	int	10			0
link_check	page_id	int	10			0
link_check	parent_type	varchar	8	√		null
link_check	url	varchar	255	√		null
link_check_report	obj_id	int	10			0
link_check_report	usr_id	int	10			0
lm_data	active	char	1	√		y
lm_data	create_date	datetime	19	√		null
lm_data	import_id	varchar	50	√		null
lm_data	last_update	datetime	19	√		null
lm_data	layout	varchar	100	√		null
lm_data	lm_id	int	10			0
lm_data	obj_id	int	10			0
lm_data	public_access	char	1	√		n
lm_data	title	varchar	200	√		null
lm_data	type	char	2	√		null
lm_data_seq	sequence	int	10		√
lm_menu	active	char	1	√		n
lm_menu	id	int	10			0
lm_menu	link_ref_id	int	10	√		null
lm_menu	link_type	char	6	√		extern
lm_menu	lm_id	int	10			0
lm_menu	target	varchar	200	√		null
lm_menu	title	varchar	200	√		null
lm_menu_seq	sequence	int	10		√
lm_tree	child	int	10			0
lm_tree	depth	smallint	5			0
lm_tree	lft	int	10			0
lm_tree	lm_id	int	10			0
lm_tree	parent	int	10	√		null
lm_tree	rgt	int	10			0
lng_data	identifier	varchar	60
lng_data	lang_key	char	2
lng_data	local_change	datetime	19	√		null
lng_data	module	varchar	30
lng_data	remarks	varchar	250	√		null
lng_data	value	varchar	4000	√		null
lng_modules	lang_array	longtext	2147483647	√		null
lng_modules	lang_key	char	2
lng_modules	module	varchar	30
lo_access	lm_id	int	10			0
lo_access	lm_title	varchar	200	√		null
lo_access	obj_id	int	10			0
lo_access	timestamp	datetime	19	√		null
lo_access	usr_id	int	10			0
loginname_history	history_date	int	10
loginname_history	login	varchar	80
loginname_history	usr_id	int	10
mail	attachments	longtext	2147483647	√		null
mail	folder_id	int	10			0
mail	import_name	varchar	4000	√		null
mail	m_email	tinyint	3	√		null
mail	m_message	longtext	2147483647	√		null
mail	m_status	varchar	16	√		null
mail	m_subject	varchar	255	√		null
mail	m_type	varchar	255	√		null
mail	mail_id	int	10			0
mail	rcp_bcc	longtext	2147483647	√		null
mail	rcp_cc	longtext	2147483647	√		null
mail	rcp_to	longtext	2147483647	√		null
mail	send_time	datetime	19	√		null
mail	sender_id	int	10	√		null
mail	use_placeholders	tinyint	3			0
mail	user_id	int	10			0
mail_attachment	mail_id	int	10			0
mail_attachment	path	varchar	4000	√		null
mail_obj_data	m_type	char	16	√		null
mail_obj_data	obj_id	int	10			0
mail_obj_data	title	char	70	√		null
mail_obj_data	user_id	int	10			0
mail_obj_data_seq	sequence	int	10		√
mail_options	cronjob_notification	tinyint	3			0
mail_options	incoming_type	tinyint	3	√		null
mail_options	linebreak	tinyint	3			0
mail_options	signature	varchar	4000	√		null
mail_options	user_id	int	10			0
mail_saved	attachments	longtext	2147483647	√		null
mail_saved	m_email	tinyint	3	√		null
mail_saved	m_message	longtext	2147483647	√		null
mail_saved	m_subject	varchar	255	√		null
mail_saved	m_type	varchar	255	√		null
mail_saved	rcp_bcc	longtext	2147483647	√		null
mail_saved	rcp_cc	longtext	2147483647	√		null
mail_saved	rcp_to	longtext	2147483647	√		null
mail_saved	use_placeholders	tinyint	3			0
mail_saved	user_id	int	10			0
mail_seq	sequence	int	10		√
mail_template	body	longtext	2147483647	√		null
mail_template	lang	varchar	5
mail_template	sal_f	varchar	200	√		null
mail_template	sal_g	varchar	200	√		null
mail_template	sal_m	varchar	200	√		null
mail_template	subject	varchar	200	√		null
mail_template	type	varchar	4
mail_tree	child	int	10			0
mail_tree	depth	smallint	5			0
mail_tree	lft	int	10			0
mail_tree	parent	int	10	√		null
mail_tree	rgt	int	10			0
mail_tree	tree	int	10			0
map_area	coords	varchar	200	√		null
map_area	href	varchar	200	√		null
map_area	item_id	int	10			0
map_area	link_type	char	3	√		null
map_area	nr	int	10			0
map_area	shape	varchar	20	√		null
map_area	target	varchar	50	√		null
map_area	target_frame	varchar	50	√		null
map_area	title	varchar	200	√		null
map_area	type	varchar	20	√		null
media_item	caption	varchar	3000	√		null
media_item	format	varchar	200	√		null
media_item	halign	char	10	√		Left
media_item	height	varchar	10	√		null
media_item	id	int	10			0
media_item	location	varchar	200	√		null
media_item	location_type	char	10	√		LocalFile
media_item	mob_id	int	10			0
media_item	nr	int	10			0
media_item	param	varchar	2000	√		null
media_item	purpose	char	20	√		Standard
media_item	text_representation	varchar	4000	√		null
media_item	tried_thumb	char	1	√		n
media_item	width	varchar	10	√		null
media_item_seq	sequence	int	10		√
member_agreement	acceptance_time	int	10			0
member_agreement	accepted	tinyint	3			0
member_agreement	obj_id	int	10			0
member_agreement	usr_id	int	10			0
member_usr_settings	settings	varchar	4000	√		null
member_usr_settings	user_id	int	10			0
mep_data	default_height	int	10	√		null
mep_data	default_width	int	10	√		null
mep_data	id	int	10
mep_item	foreign_id	int	10	√		null
mep_item	obj_id	int	10			0
mep_item	title	varchar	128	√		null
mep_item	type	varchar	10	√		null
mep_item_seq	sequence	int	10		√
mep_tree	child	int	10			0
mep_tree	depth	smallint	5			0
mep_tree	lft	int	10			0
mep_tree	mep_id	int	10			0
mep_tree	parent	int	10			0
mep_tree	rgt	int	10			0
mob_parameter	med_item_id	int	10			0
mob_parameter	name	varchar	50	√		null
mob_parameter	value	varchar	2000	√		null
mob_usage	id	int	10			0
mob_usage	usage_hist_nr	int	10			0
mob_usage	usage_id	int	10			0
mob_usage	usage_type	varchar	10
module_class	class	varchar	100
module_class	dir	varchar	200	√		null
module_class	module	varchar	100	√		null
note	author	int	10			0
note	creation_date	datetime	19	√		null
note	id	int	10			0
note	label	int	10			0
note	note_text	longtext	2147483647	√		null
note	obj_id	int	10			0
note	obj_type	varchar	10	√		null
note	rep_obj_id	int	10			0
note	subject	varchar	200	√		null
note	type	int	10			0
note	update_date	datetime	19	√		null
note_seq	sequence	int	10		√
notification	id	int	10
notification	last_mail	datetime	19	√		null
notification	page_id	int	10	√		0
notification	type	tinyint	3
notification	user_id	int	10
object_data	create_date	datetime	19	√		null
object_data	description	char	128	√		null
object_data	import_id	char	50	√		null
object_data	last_update	datetime	19	√		null
object_data	obj_id	int	10			0
object_data	owner	int	10			0
object_data	title	char	128	√		null
object_data	type	char	4	√		none
object_data_seq	sequence	int	10		√
object_description	description	longtext	2147483647	√		null
object_description	obj_id	int	10			0
object_reference	deleted	datetime	19	√		null
object_reference	obj_id	int	10			0
object_reference	ref_id	int	10			0
object_reference_seq	sequence	int	10		√
object_translation	description	varchar	4000	√		null
object_translation	lang_code	char	2
object_translation	lang_default	tinyint	3			0
object_translation	obj_id	int	10			0
object_translation	title	varchar	128	√		null
openid_provider	enabled	tinyint	3	√		null
openid_provider	image	smallint	5	√		null
openid_provider	name	varchar	128	√		null
openid_provider	provider_id	int	10			0
openid_provider	url	varchar	512	√		null
openid_provider_seq	sequence	int	10		√
org_unit_assignments	oa_cc_compl_invit	int	10			0
org_unit_assignments	oa_cc_compl_not1	int	10			0
org_unit_assignments	oa_cc_compl_not2	int	10			0
org_unit_assignments	oa_ou_id	int	10			0
org_unit_assignments	oa_reporting_access	int	10			0
org_unit_assignments	oa_usr_id	int	10			0
org_unit_data	ou_id	int	10			0
org_unit_data	ou_import_id	varchar	64	√		null
org_unit_data	ou_subtitle	varchar	128	√		null
org_unit_data	ou_title	varchar	128	√		null
org_unit_data_seq	sequence	int	10		√
org_unit_tree	child	int	10			0
org_unit_tree	depth	int	10			0
org_unit_tree	lft	int	10			0
org_unit_tree	parent	int	10			0
org_unit_tree	rgt	int	10			0
org_unit_tree	tree	int	10			0
page_anchor	anchor_name	varchar	120
page_anchor	page_id	int	10			0
page_anchor	page_parent_type	varchar	10
page_editor_settings	name	varchar	30
page_editor_settings	settings_grp	varchar	10
page_editor_settings	value	varchar	30	√		null
page_history	content	longtext	2147483647	√		null
page_history	hdate	datetime	19
page_history	ilias_version	varchar	20	√		null
page_history	nr	int	10	√		null
page_history	page_id	int	10			0
page_history	parent_id	int	10	√		null
page_history	parent_type	varchar	4
page_history	user_id	int	10	√		null
page_layout	active	tinyint	3	√		0
page_layout	content	longtext	2147483647	√		null
page_layout	description	varchar	255	√		null
page_layout	layout_id	int	10			0
page_layout	title	varchar	128	√		null
page_layout_seq	sequence	int	10		√
page_object	activation_end	datetime	19	√		null
page_object	activation_start	datetime	19	√		null
page_object	active	tinyint	3			1
page_object	content	longtext	2147483647	√		null
page_object	create_user	int	10	√		null
page_object	created	datetime	19	√		null
page_object	inactive_elements	tinyint	3	√		0
page_object	int_links	tinyint	3	√		0
page_object	is_empty	tinyint	3			0
page_object	last_change	datetime	19	√		null
page_object	last_change_user	int	10	√		null
page_object	page_id	int	10			0
page_object	parent_id	int	10	√		null
page_object	parent_type	varchar	4			lm
page_object	render_md5	varchar	32	√		null
page_object	rendered_content	longtext	2147483647	√		null
page_object	rendered_time	datetime	19	√		null
page_object	view_cnt	int	10	√		0
page_pc_usage	pc_id	int	10
page_pc_usage	pc_type	varchar	30
page_pc_usage	usage_hist_nr	int	10
page_pc_usage	usage_id	int	10
page_pc_usage	usage_type	varchar	30
page_qst_answer	passed	tinyint	3
page_qst_answer	points	double	22
page_qst_answer	qst_id	int	10
page_qst_answer	try	tinyint	3
page_qst_answer	user_id	int	10
page_question	page_id	int	10			0
page_question	page_parent_type	varchar	4	√		null
page_question	question_id	int	10			0
page_style_usage	page_id	int	10
page_style_usage	page_nr	int	10
page_style_usage	page_type	char	10
page_style_usage	sname	char	30	√		null
page_style_usage	stype	varchar	30	√		null
page_style_usage	template	tinyint	3			0
payment_coupons	pc_description	varchar	4000	√		null
payment_coupons	pc_from	date	10	√		null
payment_coupons	pc_from_enabled	tinyint	3			0
payment_coupons	pc_last_change_usr_id	int	10			0
payment_coupons	pc_last_changed	datetime	19	√		null
payment_coupons	pc_pk	bigint	19			0
payment_coupons	pc_till	date	10	√		null
payment_coupons	pc_till_enabled	tinyint	3			0
payment_coupons	pc_title	varchar	255	√		null
payment_coupons	pc_type	char	8	√		fix
payment_coupons	pc_uses	int	10			0
payment_coupons	pc_value	double	22			0
payment_coupons	usr_id	int	10			0
payment_coupons_codes	pcc_code	varchar	255	√		null
payment_coupons_codes	pcc_pc_fk	bigint	19			0
payment_coupons_codes	pcc_pk	bigint	19			0
payment_coupons_codes_seq	sequence	int	10		√
payment_coupons_obj	pco_pc_fk	bigint	19			0
payment_coupons_obj	ref_id	bigint	19			0
payment_coupons_seq	sequence	int	10		√
payment_coupons_track	pct_date	datetime	19	√		null
payment_coupons_track	pct_pcc_fk	bigint	19			0
payment_coupons_track	pct_pk	bigint	19			0
payment_coupons_track	usr_id	int	10			0
payment_coupons_track_seq	sequence	int	10		√
payment_currencies	conversion_rate	double	22			0
payment_currencies	currency_id	int	10			0
payment_currencies	iso_code	varchar	4	√		null
payment_currencies	symbol	varchar	4	√		null
payment_currencies	unit	varchar	16
payment_currencies_seq	sequence	int	10		√
payment_erp	description	varchar	2000	√		null
payment_erp	erp_id	int	10
payment_erp	erp_short	varchar	12
payment_erp	name	varchar	32
payment_erp	save_copy	int	10	√		0
payment_erp	url	varchar	255	√		null
payment_erp	use_ean	int	10	√		0
payment_erps	active	int	10	√		null
payment_erps	erp_id	int	10			0
payment_erps	erps_id	int	10			0
payment_erps	settings	varchar	4000	√		null
payment_news	creation_date	datetime	19	√		null
payment_news	news_content	longtext	2147483647	√		null
payment_news	news_id	int	10			0
payment_news	news_title	varchar	200	√		null
payment_news	update_date	datetime	19	√		null
payment_news	user_id	int	10			0
payment_news	visibility	varchar	8	√		users
payment_news_seq	sequence	int	10		√
payment_objects	image	varchar	255	√		null
payment_objects	pay_method	int	10			0
payment_objects	pobject_id	int	10			0
payment_objects	pt_topic_fk	int	10			0
payment_objects	ref_id	int	10			0
payment_objects	status	int	10			0
payment_objects	vat_id	int	10			0
payment_objects	vendor_id	int	10			0
payment_objects_seq	sequence	int	10		√
payment_paymethods	pm_enabled	tinyint	3			0
payment_paymethods	pm_id	int	10			0
payment_paymethods	pm_title	varchar	60
payment_paymethods	save_usr_adr	tinyint	3			0
payment_paymethods_seq	sequence	int	10		√
payment_prices	currency	int	10			0
payment_prices	duration	int	10			0
payment_prices	pobject_id	int	10			0
payment_prices	price	double	22			0
payment_prices	price_id	int	10			0
payment_prices	unlimited_duration	tinyint	3			0
payment_prices_seq	sequence	int	10		√
payment_settings	add_info	varchar	4000	√		null
payment_settings	address	varchar	1600	√		null
payment_settings	bank_data	varchar	1600	√		null
payment_settings	bmf	varchar	4000	√		null
payment_settings	currency_subunit	varchar	255	√		null
payment_settings	currency_unit	varchar	255	√		null
payment_settings	epay	varchar	1600	√		null
payment_settings	hide_advanced_search	int	10	√		null
payment_settings	hide_coupons	int	10	√		null
payment_settings	hide_news	int	10	√		null
payment_settings	max_hits	int	10			0
payment_settings	objects_allow_custom_sorting	int	10			0
payment_settings	paypal	varchar	1600	√		null
payment_settings	pdf_path	varchar	255	√		null
payment_settings	settings_id	bigint	19			0
payment_settings	shop_enabled	tinyint	3			0
payment_settings	topics_allow_custom_sorting	tinyint	3			0
payment_settings	topics_sorting_direction	varchar	4	√		null
payment_settings	topics_sorting_type	tinyint	3			0
payment_settings_seq	sequence	int	10		√
payment_shopping_cart	customer_id	int	10			0
payment_shopping_cart	pobject_id	int	10			0
payment_shopping_cart	price_id	int	10			0
payment_shopping_cart	psc_id	int	10			0
payment_shopping_cart	session_id	varchar	80
payment_shopping_cart_seq	sequence	int	10		√
payment_statistic	access_granted	int	10			0
payment_statistic	b_pay_method	int	10	√		null
payment_statistic	b_vendor_id	int	10	√		null
payment_statistic	booking_id	int	10			0
payment_statistic	city	varchar	40	√		null
payment_statistic	country	varchar	40	√		null
payment_statistic	currency_unit	varchar	16	√		null
payment_statistic	customer_id	int	10			0
payment_statistic	discount	double	22			0
payment_statistic	duration	char	16	√		null
payment_statistic	email_extern	varchar	80	√		null
payment_statistic	name_extern	varchar	80	√		null
payment_statistic	object_title	varchar	128	√		null
payment_statistic	order_date	int	10	√		null
payment_statistic	payed	int	10			0
payment_statistic	po_box	varchar	40	√		null
payment_statistic	pobject_id	int	10			0
payment_statistic	price	double	22			0
payment_statistic	street	varchar	40	√		null
payment_statistic	transaction	char	64	√		null
payment_statistic	transaction_extern	char	64	√		null
payment_statistic	vat_rate	double	22			0
payment_statistic	vat_unit	double	22			0
payment_statistic	voucher	char	64	√		null
payment_statistic	zipcode	varchar	40	√		null
payment_statistic_coup	psc_pc_fk	bigint	19			0
payment_statistic_coup	psc_pcc_fk	bigint	19			0
payment_statistic_coup	psc_ps_fk	bigint	19			0
payment_statistic_seq	sequence	int	10		√
payment_topic_usr_sort	ptus_pt_topic_fk	int	10			0
payment_topic_usr_sort	ptus_sorting	int	10			0
payment_topic_usr_sort	ptus_usr_id	int	10			0
payment_topics	pt_topic_changed	int	10			0
payment_topics	pt_topic_created	int	10			0
payment_topics	pt_topic_pk	bigint	19			0
payment_topics	pt_topic_sort	int	10			0
payment_topics	pt_topic_title	varchar	255	√		null
payment_topics_seq	sequence	int	10		√
payment_trustees	perm_coupons	tinyint	3			0
payment_trustees	perm_obj	int	10			0
payment_trustees	perm_stat	int	10	√		null
payment_trustees	trustee_id	int	10			0
payment_trustees	vendor_id	int	10			0
payment_vats	vat_id	int	10
payment_vats	vat_rate	double	22			0
payment_vats	vat_title	varchar	255
payment_vats_seq	sequence	int	10		√
payment_vendors	cost_center	varchar	16	√		null
payment_vendors	vendor_id	int	10			0
personal_clipboard	insert_time	datetime	19	√		null
personal_clipboard	item_id	int	10			0
personal_clipboard	order_nr	int	10			0
personal_clipboard	parent	int	10			0
personal_clipboard	title	char	70	√		null
personal_clipboard	type	char	4
personal_clipboard	user_id	int	10			0
personal_pc_clipboard	content	longtext	2147483647	√		null
personal_pc_clipboard	insert_time	datetime	19	√		null
personal_pc_clipboard	order_nr	int	10	√		null
personal_pc_clipboard	user_id	int	10			0
qpl_a_cloze	answer_id	int	10			0
qpl_a_cloze	answertext	varchar	1000	√		null
qpl_a_cloze	aorder	smallint	5			0
qpl_a_cloze	cloze_type	varchar	1	√		0
qpl_a_cloze	gap_id	smallint	5			0
qpl_a_cloze	lowerlimit	varchar	20	√		0
qpl_a_cloze	points	double	22			0
qpl_a_cloze	question_fi	int	10			0
qpl_a_cloze	shuffle	varchar	1	√		1
qpl_a_cloze	tstamp	int	10			0
qpl_a_cloze	upperlimit	varchar	20	√		0
qpl_a_cloze_seq	sequence	int	10		√
qpl_a_errortext	answer_id	int	10
qpl_a_errortext	points	double	22			0
qpl_a_errortext	question_fi	int	10
qpl_a_errortext	sequence	smallint	5			0
qpl_a_errortext	text_correct	varchar	150	√		null
qpl_a_errortext	text_wrong	varchar	150
qpl_a_errortext_seq	sequence	int	10		√
qpl_a_imagemap	answer_id	int	10			0
qpl_a_imagemap	answertext	varchar	4000	√		null
qpl_a_imagemap	aorder	smallint	5			0
qpl_a_imagemap	area	varchar	20	√		null
qpl_a_imagemap	coords	varchar	4000	√		null
qpl_a_imagemap	points	double	22			0
qpl_a_imagemap	question_fi	int	10			0
qpl_a_imagemap	tstamp	int	10			0
qpl_a_imagemap_seq	sequence	int	10		√
qpl_a_matching	answer_id	int	10			0
qpl_a_matching	definition_fi	int	10			0
qpl_a_matching	points	double	22			0
qpl_a_matching	question_fi	int	10			0
qpl_a_matching	term_fi	int	10			0
qpl_a_matching_seq	sequence	int	10		√
qpl_a_mc	answer_id	int	10			0
qpl_a_mc	answertext	varchar	1000	√		null
qpl_a_mc	aorder	smallint	5			0
qpl_a_mc	imagefile	varchar	1000	√		null
qpl_a_mc	points	double	22			0
qpl_a_mc	points_unchecked	double	22			0
qpl_a_mc	question_fi	int	10			0
qpl_a_mc	tstamp	int	10			0
qpl_a_mc_seq	sequence	int	10		√
qpl_a_mdef	def_id	int	10
qpl_a_mdef	definition	varchar	1000	√		null
qpl_a_mdef	morder	int	10
qpl_a_mdef	picture	varchar	1000	√		null
qpl_a_mdef	question_fi	int	10
qpl_a_mdef_seq	sequence	int	10		√
qpl_a_mterm	picture	varchar	1000	√		null
qpl_a_mterm	question_fi	int	10			0
qpl_a_mterm	term	varchar	1000	√		null
qpl_a_mterm	term_id	int	10			0
qpl_a_mterm_seq	sequence	int	10		√
qpl_a_ordering	answer_id	int	10			0
qpl_a_ordering	answertext	varchar	1000	√		null
qpl_a_ordering	question_fi	int	10			0
qpl_a_ordering	random_id	int	10			0
qpl_a_ordering	solution_order	smallint	5			0
qpl_a_ordering	tstamp	int	10			0
qpl_a_ordering_seq	sequence	int	10		√
qpl_a_sc	answer_id	int	10			0
qpl_a_sc	answertext	varchar	1000	√		null
qpl_a_sc	aorder	smallint	5			0
qpl_a_sc	imagefile	varchar	1000	√		null
qpl_a_sc	points	double	22			0
qpl_a_sc	question_fi	int	10			0
qpl_a_sc	tstamp	int	10			0
qpl_a_sc_seq	sequence	int	10		√
qpl_a_textsubset	answer_id	int	10			0
qpl_a_textsubset	answertext	varchar	1000	√		null
qpl_a_textsubset	aorder	smallint	5			0
qpl_a_textsubset	points	double	22			0
qpl_a_textsubset	question_fi	int	10			0
qpl_a_textsubset	tstamp	int	10			0
qpl_a_textsubset_seq	sequence	int	10		√
qpl_fb_generic	correctness	varchar	1	√		0
qpl_fb_generic	feedback	varchar	4000	√		null
qpl_fb_generic	feedback_id	int	10			0
qpl_fb_generic	question_fi	int	10			0
qpl_fb_generic	tstamp	int	10			0
qpl_fb_generic_seq	sequence	int	10		√
qpl_fb_imap	answer	int	10			0
qpl_fb_imap	feedback	varchar	4000	√		null
qpl_fb_imap	feedback_id	int	10			0
qpl_fb_imap	question_fi	int	10			0
qpl_fb_imap	tstamp	int	10			0
qpl_fb_imap_seq	sequence	int	10		√
qpl_fb_mc	answer	int	10			0
qpl_fb_mc	feedback	varchar	4000	√		null
qpl_fb_mc	feedback_id	int	10			0
qpl_fb_mc	question_fi	int	10			0
qpl_fb_mc	tstamp	int	10			0
qpl_fb_mc_seq	sequence	int	10		√
qpl_fb_sc	answer	int	10			0
qpl_fb_sc	feedback	varchar	4000	√		null
qpl_fb_sc	feedback_id	int	10			0
qpl_fb_sc	question_fi	int	10			0
qpl_fb_sc	tstamp	int	10			0
qpl_fb_sc_seq	sequence	int	10		√
qpl_num_range	aorder	int	10			0
qpl_num_range	lowerlimit	varchar	20	√		0
qpl_num_range	points	double	22			0
qpl_num_range	question_fi	int	10			0
qpl_num_range	range_id	int	10			0
qpl_num_range	tstamp	int	10			0
qpl_num_range	upperlimit	varchar	20	√		0
qpl_num_range_seq	sequence	int	10		√
qpl_qst_cloze	fixed_textlen	int	10	√		null
qpl_qst_cloze	identical_scoring	varchar	1	√		1
qpl_qst_cloze	question_fi	int	10			0
qpl_qst_cloze	textgap_rating	varchar	2	√		null
qpl_qst_errortext	errortext	varchar	4000
qpl_qst_errortext	points_wrong	double	22			-1
qpl_qst_errortext	question_fi	int	10
qpl_qst_errortext	textsize	double	22			100
qpl_qst_essay	keywords	varchar	4000	√		null
qpl_qst_essay	matchcondition	smallint	5			0
qpl_qst_essay	maxnumofchars	int	10			0
qpl_qst_essay	question_fi	int	10			0
qpl_qst_essay	textgap_rating	varchar	2	√		null
qpl_qst_fileupload	allowedextensions	varchar	255	√		null
qpl_qst_fileupload	maxsize	double	22	√		null
qpl_qst_fileupload	question_fi	int	10			0
qpl_qst_flash	applet	varchar	150	√		null
qpl_qst_flash	height	int	10			400
qpl_qst_flash	params	varchar	4000	√		null
qpl_qst_flash	question_fi	int	10			0
qpl_qst_flash	width	int	10			550
qpl_qst_horder	ordertext	varchar	2000	√		null
qpl_qst_horder	question_fi	int	10			0
qpl_qst_horder	textsize	double	22	√		null
qpl_qst_imagemap	image_file	varchar	100	√		null
qpl_qst_imagemap	question_fi	int	10			0
qpl_qst_javaapplet	image_file	varchar	100	√		null
qpl_qst_javaapplet	params	varchar	4000	√		null
qpl_qst_javaapplet	question_fi	int	10			0
qpl_qst_matching	element_height	int	10	√		null
qpl_qst_matching	matching_type	varchar	1	√		1
qpl_qst_matching	question_fi	int	10			0
qpl_qst_matching	shuffle	varchar	1	√		1
qpl_qst_matching	thumb_geometry	int	10			100
qpl_qst_mc	allow_images	varchar	1	√		0
qpl_qst_mc	question_fi	int	10			0
qpl_qst_mc	resize_images	varchar	1	√		0
qpl_qst_mc	shuffle	varchar	1	√		1
qpl_qst_mc	thumb_size	smallint	5	√		null
qpl_qst_numeric	maxnumofchars	int	10			0
qpl_qst_numeric	question_fi	int	10			0
qpl_qst_ordering	element_height	int	10	√		null
qpl_qst_ordering	ordering_type	varchar	1	√		1
qpl_qst_ordering	question_fi	int	10			0
qpl_qst_ordering	reduced_points	double	22			0
qpl_qst_ordering	scoring_type	mediumint	7			0
qpl_qst_ordering	thumb_geometry	int	10			100
qpl_qst_sc	allow_images	varchar	1	√		0
qpl_qst_sc	question_fi	int	10			0
qpl_qst_sc	resize_images	varchar	1	√		0
qpl_qst_sc	shuffle	varchar	1	√		1
qpl_qst_sc	thumb_size	smallint	5	√		null
qpl_qst_textsubset	correctanswers	int	10	√		0
qpl_qst_textsubset	question_fi	int	10			0
qpl_qst_textsubset	textgap_rating	varchar	2	√		null
qpl_qst_type	plugin	tinyint	3			0
qpl_qst_type	question_type_id	int	10			0
qpl_qst_type	type_tag	varchar	35	√		null
qpl_questionpool	id_questionpool	int	10			0
qpl_questionpool	isonline	varchar	1	√		0
qpl_questionpool	obj_fi	int	10			0
qpl_questionpool	questioncount	int	10			0
qpl_questionpool	tstamp	int	10			0
qpl_questionpool_seq	sequence	int	10		√
qpl_questions	author	varchar	50	√		null
qpl_questions	complete	varchar	1	√		1
qpl_questions	created	int	10			0
qpl_questions	description	varchar	1000	√		null
qpl_questions	nr_of_tries	int	10			0
qpl_questions	obj_fi	int	10			0
qpl_questions	original_id	int	10	√		null
qpl_questions	owner	int	10			0
qpl_questions	points	double	22	√		null
qpl_questions	question_id	int	10			0
qpl_questions	question_text	longtext	2147483647	√		null
qpl_questions	question_type_fi	int	10			0
qpl_questions	title	varchar	100	√		null
qpl_questions	tstamp	int	10			0
qpl_questions	working_time	varchar	8	√		00:00:00
qpl_questions_seq	sequence	int	10		√
qpl_sol_sug	import_id	varchar	50	√		null
qpl_sol_sug	internal_link	varchar	50	√		null
qpl_sol_sug	question_fi	int	10			0
qpl_sol_sug	subquestion_index	int	10			0
qpl_sol_sug	suggested_solution_id	int	10			0
qpl_sol_sug	tstamp	int	10			0
qpl_sol_sug	type	varchar	32	√		null
qpl_sol_sug	value	varchar	4000	√		null
qpl_sol_sug_seq	sequence	int	10		√
rbac_fa	assign	char	1	√		null
rbac_fa	parent	int	10			0
rbac_fa	protected	char	1	√		n
rbac_fa	rol_id	int	10			0
rbac_log	action	tinyint	3
rbac_log	created	int	10
rbac_log	data	varchar	4000	√		null
rbac_log	ref_id	int	10
rbac_log	user_id	int	10
rbac_operations	class	char	16	√		null
rbac_operations	description	char	255	√		null
rbac_operations	op_order	smallint	5	√		null
rbac_operations	operation	char	32	√		null
rbac_operations	ops_id	int	10			0
rbac_operations_seq	sequence	int	10		√
rbac_pa	ops_id	varchar	4000	√		null
rbac_pa	ref_id	int	10			0
rbac_pa	rol_id	int	10			0
rbac_ta	ops_id	smallint	5			0
rbac_ta	typ_id	int	10			0
rbac_templates	ops_id	int	10			0
rbac_templates	parent	int	10			0
rbac_templates	rol_id	int	10			0
rbac_templates	type	char	5	√		null
rbac_ua	rol_id	int	10			0
rbac_ua	usr_id	int	10			0
read_event	childs_read_count	int	10			0
read_event	childs_spent_seconds	int	10			0
read_event	first_access	datetime	19	√		null
read_event	last_access	int	10	√		null
read_event	obj_id	int	10			0
read_event	read_count	int	10			0
read_event	spent_seconds	int	10			0
read_event	usr_id	int	10			0
reg_access_limit	limit_absolute	int	10	√		null
reg_access_limit	limit_mode	char	16	√		absolute
reg_access_limit	limit_relative_d	int	10	√		null
reg_access_limit	limit_relative_m	int	10	√		null
reg_access_limit	limit_relative_y	int	10	√		null
reg_access_limit	role_id	int	10			0
reg_er_assignments	assignment_id	int	10			0
reg_er_assignments	domain	varchar	128	√		null
reg_er_assignments	role	int	10			0
reg_er_assignments_seq	sequence	int	10		√
reg_registration_codes	code	varchar	50	√		null
reg_registration_codes	code_id	int	10			0
reg_registration_codes	generated	int	10	√		0
reg_registration_codes	role	int	10	√		0
reg_registration_codes	used	int	10			0
reg_registration_codes_seq	sequence	int	10		√
remote_course_settings	availability_type	tinyint	3			0
remote_course_settings	local_information	varchar	4000	√		null
remote_course_settings	mid	int	10			0
remote_course_settings	obj_id	int	10			0
remote_course_settings	organization	varchar	4000	√		null
remote_course_settings	r_end	int	10			0
remote_course_settings	r_start	int	10			0
remote_course_settings	remote_link	varchar	4000	√		null
role_data	allow_register	tinyint	3			0
role_data	assign_users	tinyint	3	√		0
role_data	auth_mode	char	16	√		default
role_data	disk_quota	bigint	19			0
role_data	role_id	int	10			0
role_desktop_items	item_id	int	10			0
role_desktop_items	item_type	char	16	√		null
role_desktop_items	role_id	int	10			0
role_desktop_items	role_item_id	int	10			0
role_desktop_items_seq	sequence	int	10		√
sahs_lm	api_adapter	varchar	80	√		API
sahs_lm	api_func_prefix	varchar	20	√		LMS
sahs_lm	auto_continue	varchar	1			n
sahs_lm	auto_review	varchar	3	√		n
sahs_lm	c_online	varchar	3	√		n
sahs_lm	c_type	varchar	10	√		null
sahs_lm	credit	varchar	10	√		credit
sahs_lm	debug	varchar	1			n
sahs_lm	debugpw	varchar	50	√		n
sahs_lm	default_lesson_mode	varchar	8	√		normal
sahs_lm	editable	int	10			0
sahs_lm	glossary	int	10			0
sahs_lm	hide_navig	varchar	1			n
sahs_lm	id	int	10			0
sahs_lm	max_attempt	int	10	√		0
sahs_lm	module_version	int	10	√		1
sahs_lm	no_menu	varchar	1			n
sahs_lm	question_tries	int	10	√		3
sahs_lm	stylesheet	int	10			0
sahs_lm	unlimited_session	varchar	1			n
sahs_sc13_seq_assign	identifier	varchar	50	√		null
sahs_sc13_seq_assign	sahs_sc13_tree_node_id	int	10			0
sahs_sc13_seq_cond	cond	varchar	50	√		null
sahs_sc13_seq_cond	measurethreshold	varchar	50	√		null
sahs_sc13_seq_cond	operator	varchar	50	√		null
sahs_sc13_seq_cond	referencedobjective	varchar	50	√		null
sahs_sc13_seq_cond	seqnodeid	int	10			0
sahs_sc13_seq_course	choice	tinyint	3	√		1
sahs_sc13_seq_course	flow	tinyint	3	√		0
sahs_sc13_seq_course	forwardonly	tinyint	3	√		0
sahs_sc13_seq_course	obj_id	int	10			0
sahs_sc13_seq_item	importid	varchar	32	√		null
sahs_sc13_seq_item	nocopy	tinyint	3	√		null
sahs_sc13_seq_item	nodelete	tinyint	3	√		null
sahs_sc13_seq_item	nomove	tinyint	3	√		null
sahs_sc13_seq_item	rootlevel	tinyint	3			0
sahs_sc13_seq_item	sahs_sc13_tree_node_id	int	10			0
sahs_sc13_seq_item	seqnodeid	int	10			0
sahs_sc13_seq_item	sequencingid	varchar	50	√		null
sahs_sc13_seq_item	seqxml	longtext	2147483647	√		null
sahs_sc13_seq_mapinfo	readnormalizedmeasure	tinyint	3	√		null
sahs_sc13_seq_mapinfo	readsatisfiedstatus	tinyint	3	√		null
sahs_sc13_seq_mapinfo	seqnodeid	int	10			0
sahs_sc13_seq_mapinfo	targetobjectiveid	varchar	50	√		null
sahs_sc13_seq_mapinfo	writenormalizedmeasure	tinyint	3	√		null
sahs_sc13_seq_mapinfo	writesatisfiedstatus	tinyint	3	√		null
sahs_sc13_seq_node	nodename	varchar	50	√		null
sahs_sc13_seq_node	seqnodeid	int	10			0
sahs_sc13_seq_node	tree_node_id	int	10	√		null
sahs_sc13_seq_node_seq	sequence	int	10		√
sahs_sc13_seq_obj	import_objective_id	varchar	200	√		null
sahs_sc13_seq_obj	minnormalizedmeasure	varchar	50	√		null
sahs_sc13_seq_obj	objectiveid	varchar	200	√		null
sahs_sc13_seq_obj	primary_obj	tinyint	3	√		null
sahs_sc13_seq_obj	satisfiedbymeasure	tinyint	3	√		null
sahs_sc13_seq_obj	seqnodeid	int	10			0
sahs_sc13_seq_rule	action	varchar	50	√		null
sahs_sc13_seq_rule	childactivityset	varchar	50	√		null
sahs_sc13_seq_rule	conditioncombination	varchar	50	√		null
sahs_sc13_seq_rule	minimumcount	int	10	√		null
sahs_sc13_seq_rule	minimumpercent	varchar	50	√		null
sahs_sc13_seq_rule	seqnodeid	int	10			0
sahs_sc13_seq_rule	type	varchar	50	√		null
sahs_sc13_seq_seq	activityabsolutedurationlimit	varchar	20	√		null
sahs_sc13_seq_seq	activityexperienceddurlimit	varchar	20	√		null
sahs_sc13_seq_seq	attemptabsolutedurationlimit	varchar	20	√		null
sahs_sc13_seq_seq	attemptexperienceddurlimit	varchar	20	√		null
sahs_sc13_seq_seq	attemptlimit	int	10	√		null
sahs_sc13_seq_seq	begintimelimit	varchar	20	√		null
sahs_sc13_seq_seq	choice	tinyint	3	√		null
sahs_sc13_seq_seq	choiceexit	tinyint	3	√		null
sahs_sc13_seq_seq	completionsetbycontent	tinyint	3	√		null
sahs_sc13_seq_seq	constrainchoice	tinyint	3	√		null
sahs_sc13_seq_seq	endtimelimit	varchar	20	√		null
sahs_sc13_seq_seq	flow	tinyint	3	√		null
sahs_sc13_seq_seq	forwardonly	tinyint	3	√		null
sahs_sc13_seq_seq	id	varchar	200	√		null
sahs_sc13_seq_seq	importid	varchar	32	√		null
sahs_sc13_seq_seq	measuresatisfactionifactive	tinyint	3	√		null
sahs_sc13_seq_seq	objectivemeasureweight	double	22	√		null
sahs_sc13_seq_seq	objectivesetbycontent	tinyint	3	√		null
sahs_sc13_seq_seq	preventactivation	tinyint	3	√		null
sahs_sc13_seq_seq	randomizationtiming	varchar	50	√		null
sahs_sc13_seq_seq	reorderchildren	tinyint	3	√		null
sahs_sc13_seq_seq	requiredforcompleted	varchar	50	√		null
sahs_sc13_seq_seq	requiredforincomplete	varchar	50	√		null
sahs_sc13_seq_seq	requiredfornotsatisfied	varchar	50	√		null
sahs_sc13_seq_seq	requiredforsatisfied	varchar	50	√		null
sahs_sc13_seq_seq	rollupobjectivesatisfied	tinyint	3	√		null
sahs_sc13_seq_seq	rollupprogresscompletion	tinyint	3	√		null
sahs_sc13_seq_seq	selectcount	int	10	√		null
sahs_sc13_seq_seq	selectiontiming	varchar	50	√		null
sahs_sc13_seq_seq	seqnodeid	int	10			0
sahs_sc13_seq_seq	sequencingid	varchar	50	√		null
sahs_sc13_seq_seq	tracked	tinyint	3	√		null
sahs_sc13_seq_seq	usecurrentattemptobjectiveinfo	tinyint	3	√		null
sahs_sc13_seq_seq	usecurrentattemptprogressinfo	tinyint	3	√		null
sahs_sc13_seq_templ	id	varchar	50	√		null
sahs_sc13_seq_templ	seqnodeid	int	10	√		null
sahs_sc13_seq_templts	filename	varchar	50	√		null
sahs_sc13_seq_templts	id	int	10			0
sahs_sc13_seq_templts	identifier	varchar	50	√		null
sahs_sc13_seq_templts_seq	sequence	int	10		√
sahs_sc13_seq_tree	child	int	10	√		null
sahs_sc13_seq_tree	depth	smallint	5	√		null
sahs_sc13_seq_tree	importid	varchar	32	√		null
sahs_sc13_seq_tree	lft	int	10	√		null
sahs_sc13_seq_tree	parent	int	10	√		null
sahs_sc13_seq_tree	rgt	int	10	√		null
sahs_sc13_tree	child	int	10			0
sahs_sc13_tree	depth	smallint	5			0
sahs_sc13_tree	lft	int	10			0
sahs_sc13_tree	parent	int	10	√		null
sahs_sc13_tree	rgt	int	10			0
sahs_sc13_tree	slm_id	int	10			0
sahs_sc13_tree_node	create_date	datetime	19	√		null
sahs_sc13_tree_node	import_id	varchar	50	√		null
sahs_sc13_tree_node	last_update	datetime	19	√		null
sahs_sc13_tree_node	obj_id	int	10			0
sahs_sc13_tree_node	slm_id	int	10			0
sahs_sc13_tree_node	title	varchar	200	√		null
sahs_sc13_tree_node	type	char	4	√		null
sahs_sc13_tree_node_seq	sequence	int	10		√
sc_item	datafromlms	longtext	2147483647	√		null
sc_item	identifierref	varchar	200	√		null
sc_item	import_id	varchar	200	√		null
sc_item	isvisible	varchar	6	√		null
sc_item	masteryscore	varchar	200	√		null
sc_item	maxtimeallowed	varchar	30	√		null
sc_item	obj_id	int	10			0
sc_item	parameters	varchar	4000	√		null
sc_item	prereq_type	varchar	200	√		null
sc_item	prerequisites	varchar	4000	√		null
sc_item	timelimitaction	varchar	30	√		null
sc_manifest	import_id	varchar	200	√		null
sc_manifest	obj_id	int	10			0
sc_manifest	version	varchar	200	√		null
sc_manifest	xml_base	varchar	200	√		null
sc_organization	import_id	varchar	200	√		null
sc_organization	obj_id	int	10			0
sc_organization	structure	varchar	200	√		null
sc_organizations	default_organization	varchar	200	√		null
sc_organizations	obj_id	int	10			0
sc_resource	href	varchar	250	√		null
sc_resource	import_id	varchar	200	√		null
sc_resource	obj_id	int	10			0
sc_resource	resourcetype	varchar	30	√		null
sc_resource	scormtype	varchar	6	√		null
sc_resource	xml_base	varchar	200	√		null
sc_resource_dependen	id	int	10			0
sc_resource_dependen	identifierref	varchar	200	√		null
sc_resource_dependen	nr	int	10	√		null
sc_resource_dependen	res_id	int	10	√		null
sc_resource_dependen_seq	sequence	int	10		√
sc_resource_file	href	varchar	4000	√		null
sc_resource_file	id	int	10			0
sc_resource_file	nr	int	10	√		null
sc_resource_file	res_id	int	10	√		null
sc_resource_file_seq	sequence	int	10		√
sc_resources	obj_id	int	10			0
sc_resources	xml_base	varchar	200	√		null
scorm_object	c_type	char	3	√		null
scorm_object	obj_id	int	10			0
scorm_object	slm_id	int	10			0
scorm_object	title	varchar	200	√		null
scorm_object_seq	sequence	int	10		√
scorm_tracking	c_timestamp	datetime	19	√		null
scorm_tracking	lvalue	varchar	64
scorm_tracking	obj_id	int	10			0
scorm_tracking	rvalue	longtext	2147483647	√		null
scorm_tracking	sco_id	int	10			0
scorm_tracking	user_id	int	10			0
scorm_tree	child	int	10			0
scorm_tree	depth	smallint	5			0
scorm_tree	lft	int	10			0
scorm_tree	parent	int	10	√		null
scorm_tree	rgt	int	10			0
scorm_tree	slm_id	int	10			0
search_command_queue	command	char	16	√		null
search_command_queue	finished	tinyint	3			0
search_command_queue	last_update	datetime	19	√		null
search_command_queue	obj_id	int	10			0
search_command_queue	obj_type	char	4
search_command_queue	sub_id	int	10			0
search_command_queue	sub_type	char	4	√		null
search_data	obj_id	int	10			0
search_data	target	varchar	4000	√		null
search_data	title	varchar	200	√		null
search_data	type	varchar	4	√		null
search_data	user_id	int	10			0
search_data_seq	sequence	int	10		√
search_tree	child	int	10			0
search_tree	depth	smallint	5			0
search_tree	lft	int	10			0
search_tree	parent	int	10	√		null
search_tree	rgt	int	10			0
search_tree	tree	int	10			0
service_class	class	varchar	100
service_class	dir	varchar	200	√		null
service_class	service	varchar	100	√		null
settings	keyword	varchar	50
settings	module	varchar	50			common
settings	value	longtext	2147483647	√		null
settings_deactivated_s	skin	varchar	100
settings_deactivated_s	style	varchar	100
shib_role_assignment	add_on_update	tinyint	3			0
shib_role_assignment	name	char	255	√		null
shib_role_assignment	plugin	tinyint	3			0
shib_role_assignment	plugin_id	int	10			0
shib_role_assignment	remove_on_update	tinyint	3			0
shib_role_assignment	role_id	int	10			0
shib_role_assignment	rule_id	int	10			0
shib_role_assignment	value	char	255	√		null
shib_role_assignment_seq	sequence	int	10		√
style_char	characteristic	varchar	30
style_char	hide	tinyint	3			0
style_char	style_id	int	10			0
style_char	type	varchar	30
style_color	color_code	char	10	√		null
style_color	color_name	varchar	30			.
style_color	style_id	int	10
style_data	active	tinyint	3	√		1
style_data	category	int	10	√		null
style_data	id	int	10			0
style_data	standard	tinyint	3	√		0
style_data	uptodate	tinyint	3	√		0
style_folder_styles	folder_id	int	10			0
style_folder_styles	style_id	int	10			0
style_parameter	class	varchar	100	√		null
style_parameter	id	int	10			0
style_parameter	parameter	varchar	100	√		null
style_parameter	style_id	int	10			0
style_parameter	tag	varchar	100	√		null
style_parameter	type	varchar	30	√		null
style_parameter	value	varchar	200	√		null
style_parameter_seq	sequence	int	10		√
style_setting	name	varchar	30
style_setting	style_id	int	10
style_setting	value	varchar	30	√		null
style_template	id	int	10
style_template	name	varchar	30
style_template	preview	varchar	4000	√		null
style_template	style_id	int	10
style_template	temp_type	varchar	30	√		null
style_template_class	class	char	30	√		null
style_template_class	class_type	char	30	√		null
style_template_class	template_id	int	10
style_template_seq	sequence	int	10		√
style_usage	obj_id	int	10
style_usage	style_id	int	10
svy_anonymous	anonymous_id	int	10			0
svy_anonymous	externaldata	varchar	4000	√		null
svy_anonymous	sent	smallint	5			0
svy_anonymous	survey_fi	int	10			0
svy_anonymous	survey_key	varchar	32	√		null
svy_anonymous	tstamp	int	10			0
svy_anonymous	user_key	varchar	40	√		null
svy_anonymous_seq	sequence	int	10		√
svy_answer	active_fi	int	10			0
svy_answer	answer_id	int	10			0
svy_answer	question_fi	int	10			0
svy_answer	rowvalue	int	10			0
svy_answer	textanswer	varchar	4000	√		null
svy_answer	tstamp	int	10			0
svy_answer	value	double	22	√		null
svy_answer_seq	sequence	int	10		√
svy_category	category_id	int	10			0
svy_category	defaultvalue	varchar	1	√		0
svy_category	neutral	varchar	1	√		0
svy_category	owner_fi	int	10			0
svy_category	title	varchar	1000	√		null
svy_category	tstamp	int	10			0
svy_category_seq	sequence	int	10		√
svy_constraint	conjunction	smallint	5			0
svy_constraint	constraint_id	int	10			0
svy_constraint	question_fi	int	10			0
svy_constraint	relation_fi	int	10			0
svy_constraint	value	double	22			0
svy_constraint_seq	sequence	int	10		√
svy_finished	anonymous_id	varchar	32	√		null
svy_finished	finished_id	int	10			0
svy_finished	lastpage	int	10			0
svy_finished	state	varchar	1	√		0
svy_finished	survey_fi	int	10			0
svy_finished	tstamp	int	10			0
svy_finished	user_fi	int	10			0
svy_finished_seq	sequence	int	10		√
svy_inv_grp_seq	sequence	int	10		√
svy_inv_usr	invited_user_id	int	10			0
svy_inv_usr	survey_fi	int	10			0
svy_inv_usr	tstamp	int	10			0
svy_inv_usr	user_fi	int	10			0
svy_inv_usr_seq	sequence	int	10		√
svy_material	external_link	varchar	500	√		null
svy_material	file_material	varchar	200	√		null
svy_material	import_id	varchar	50	√		null
svy_material	internal_link	varchar	50	√		null
svy_material	material_id	int	10			0
svy_material	material_title	varchar	255	√		null
svy_material	material_type	int	10	√		0
svy_material	question_fi	int	10			0
svy_material	text_material	varchar	4000	√		null
svy_material	tstamp	int	10			0
svy_material_seq	sequence	int	10		√
svy_phrase	defaultvalue	varchar	1	√		0
svy_phrase	owner_fi	int	10			0
svy_phrase	phrase_id	int	10			0
svy_phrase	title	varchar	100	√		null
svy_phrase	tstamp	int	10			0
svy_phrase_cat	category_fi	int	10			0
svy_phrase_cat	other	smallint	5			0
svy_phrase_cat	phrase_category_id	int	10			0
svy_phrase_cat	phrase_fi	int	10			0
svy_phrase_cat	scale	int	10	√		null
svy_phrase_cat	sequence	int	10			0
svy_phrase_cat_seq	sequence	int	10		√
svy_phrase_seq	sequence	int	10		√
svy_qblk	owner_fi	int	10			0
svy_qblk	questionblock_id	int	10			0
svy_qblk	show_questiontext	varchar	1	√		1
svy_qblk	title	varchar	4000	√		null
svy_qblk	tstamp	int	10			0
svy_qblk_qst	qblk_qst_id	int	10			0
svy_qblk_qst	question_fi	int	10			0
svy_qblk_qst	questionblock_fi	int	10			0
svy_qblk_qst	survey_fi	int	10			0
svy_qblk_qst_seq	sequence	int	10		√
svy_qblk_seq	sequence	int	10		√
svy_qpl	id_questionpool	int	10			0
svy_qpl	isonline	varchar	1	√		0
svy_qpl	obj_fi	int	10			0
svy_qpl	tstamp	int	10			0
svy_qpl_seq	sequence	int	10		√
svy_qst_constraint	constraint_fi	int	10			0
svy_qst_constraint	question_constraint_id	int	10			0
svy_qst_constraint	question_fi	int	10			0
svy_qst_constraint	survey_fi	int	10			0
svy_qst_constraint_seq	sequence	int	10		√
svy_qst_mat_seq	sequence	int	10		√
svy_qst_matrix	bipolar_adjective1	varchar	255	√		null
svy_qst_matrix	bipolar_adjective2	varchar	255	√		null
svy_qst_matrix	column_header_position	varchar	1	√		0
svy_qst_matrix	column_images	varchar	1	√		0
svy_qst_matrix	column_order	varchar	1	√		0
svy_qst_matrix	column_placeholders	int	10			0
svy_qst_matrix	column_separators	varchar	1	√		0
svy_qst_matrix	layout	varchar	4000	√		null
svy_qst_matrix	legend	varchar	1	√		0
svy_qst_matrix	neutral_column_separator	varchar	1	√		1
svy_qst_matrix	question_fi	int	10			0
svy_qst_matrix	random_rows	varchar	1	√		0
svy_qst_matrix	repeat_column_header	varchar	1	√		0
svy_qst_matrix	row_images	varchar	1	√		0
svy_qst_matrix	row_separators	varchar	1	√		0
svy_qst_matrix	singleline_row_caption	varchar	1	√		0
svy_qst_matrix	subtype	int	10			0
svy_qst_matrix	tstamp	int	10			0
svy_qst_matrixrows	id_svy_qst_matrixrows	int	10			0
svy_qst_matrixrows	label	varchar	255	√		null
svy_qst_matrixrows	other	tinyint	3			0
svy_qst_matrixrows	question_fi	int	10			0
svy_qst_matrixrows	sequence	int	10			0
svy_qst_matrixrows	title	varchar	255	√		null
svy_qst_matrixrows_seq	sequence	int	10		√
svy_qst_mc	nr_max_answers	smallint	5	√		null
svy_qst_mc	nr_min_answers	smallint	5	√		null
svy_qst_mc	orientation	varchar	1	√		0
svy_qst_mc	question_fi	int	10			0
svy_qst_mc	use_min_answers	tinyint	3			0
svy_qst_metric	question_fi	int	10			0
svy_qst_metric	subtype	varchar	1	√		3
svy_qst_oblig	obligatory	varchar	1	√		1
svy_qst_oblig	question_fi	int	10			0
svy_qst_oblig	question_obligatory_id	int	10			0
svy_qst_oblig	survey_fi	int	10			0
svy_qst_oblig	tstamp	int	10			0
svy_qst_oblig_seq	sequence	int	10		√
svy_qst_sc	orientation	varchar	1	√		0
svy_qst_sc	question_fi	int	10			0
svy_qst_text	height	int	10			5
svy_qst_text	maxchars	int	10	√		null
svy_qst_text	question_fi	int	10			0
svy_qst_text	width	int	10			50
svy_qtype	plugin	tinyint	3			0
svy_qtype	questiontype_id	int	10			0
svy_qtype	type_tag	varchar	30	√		null
svy_qtype_seq	sequence	int	10		√
svy_question	author	varchar	100	√		null
svy_question	complete	varchar	1	√		0
svy_question	created	varchar	14	√		null
svy_question	description	varchar	200	√		null
svy_question	label	varchar	255	√		null
svy_question	obj_fi	int	10			0
svy_question	obligatory	varchar	1	√		1
svy_question	original_id	int	10	√		null
svy_question	owner_fi	int	10			0
svy_question	question_id	int	10			0
svy_question	questiontext	longtext	2147483647	√		null
svy_question	questiontype_fi	int	10			0
svy_question	title	varchar	100	√		null
svy_question	tstamp	int	10			0
svy_question_seq	sequence	int	10		√
svy_relation	longname	varchar	20	√		null
svy_relation	relation_id	int	10			0
svy_relation	shortname	varchar	2	√		null
svy_relation	tstamp	int	10			0
svy_relation_seq	sequence	int	10		√
svy_settings	keyword	varchar	40
svy_settings	settings_id	int	10
svy_settings	title	varchar	400	√		null
svy_settings	usr_id	int	10
svy_settings	value	longtext	2147483647	√		null
svy_settings_seq	sequence	int	10		√
svy_svy	anonymize	varchar	1	√		0
svy_svy	author	varchar	50	√		null
svy_svy	complete	varchar	1	√		0
svy_svy	created	int	10			0
svy_svy	enddate	varchar	14	√		null
svy_svy	evaluation_access	varchar	1	√		0
svy_svy	introduction	longtext	2147483647	√		null
svy_svy	invitation	varchar	1	√		0
svy_svy	invitation_mode	varchar	1	√		1
svy_svy	mailaddresses	varchar	2000	√		null
svy_svy	mailnotification	tinyint	3	√		null
svy_svy	mailparticipantdata	varchar	4000	√		null
svy_svy	obj_fi	int	10			0
svy_svy	outro	longtext	2147483647	√		null
svy_svy	show_question_titles	varchar	1	√		1
svy_svy	startdate	varchar	14	√		null
svy_svy	status	varchar	1	√		1
svy_svy	survey_id	int	10			0
svy_svy	tstamp	int	10			0
svy_svy_qst	heading	varchar	4000	√		null
svy_svy_qst	question_fi	int	10			0
svy_svy_qst	sequence	int	10			0
svy_svy_qst	survey_fi	int	10			0
svy_svy_qst	survey_question_id	int	10			0
svy_svy_qst	tstamp	int	10			0
svy_svy_qst_seq	sequence	int	10		√
svy_svy_seq	sequence	int	10		√
svy_times	entered_page	int	10	√		null
svy_times	finished_fi	int	10
svy_times	first_question	int	10	√		null
svy_times	left_page	int	10	√		null
svy_variable	category_fi	int	10			0
svy_variable	other	smallint	5			0
svy_variable	question_fi	int	10			0
svy_variable	scale	mediumint	7	√		null
svy_variable	sequence	int	10			0
svy_variable	tstamp	int	10			0
svy_variable	value1	double	22	√		null
svy_variable	value2	double	22	√		null
svy_variable	variable_id	int	10			0
svy_variable_seq	sequence	int	10		√
table_properties	property	varchar	20
table_properties	table_id	varchar	30
table_properties	user_id	int	10
table_properties	value	varchar	4000
table_templates	context	varchar	128
table_templates	name	varchar	64
table_templates	user_id	int	10
table_templates	value	longtext	2147483647	√		null
tree	child	int	10			0
tree	depth	smallint	5			0
tree	lft	int	10			0
tree	parent	int	10	√		null
tree	rgt	int	10			0
tree	tree	int	10			0
tst_active	active_id	int	10			0
tst_active	anonymous_id	varchar	5	√		null
tst_active	importname	varchar	400	√		null
tst_active	lastindex	tinyint	3			1
tst_active	submitted	tinyint	3			0
tst_active	submittimestamp	datetime	19	√		null
tst_active	test_fi	int	10			0
tst_active	tries	int	10			0
tst_active	tstamp	int	10			0
tst_active	user_fi	int	10			0
tst_active_seq	sequence	int	10		√
tst_invited_user	clientip	varchar	255	√		null
tst_invited_user	test_fi	int	10			0
tst_invited_user	tstamp	int	10			0
tst_invited_user	user_fi	int	10			0
tst_manual_fb	active_fi	int	10			0
tst_manual_fb	feedback	varchar	4000	√		null
tst_manual_fb	manual_feedback_id	int	10			0
tst_manual_fb	pass	int	10			0
tst_manual_fb	question_fi	int	10			0
tst_manual_fb	tstamp	int	10			0
tst_manual_fb_seq	sequence	int	10		√
tst_mark	mark_id	int	10			0
tst_mark	minimum_level	double	22			0
tst_mark	official_name	varchar	50	√		null
tst_mark	passed	varchar	1	√		0
tst_mark	short_name	varchar	15	√		null
tst_mark	test_fi	int	10			0
tst_mark	tstamp	int	10			0
tst_mark_seq	sequence	int	10		√
tst_pass_result	active_fi	int	10			0
tst_pass_result	answeredquestions	int	10			0
tst_pass_result	maxpoints	double	22			0
tst_pass_result	pass	int	10			0
tst_pass_result	points	double	22			0
tst_pass_result	questioncount	int	10			0
tst_pass_result	tstamp	int	10			0
tst_pass_result	workingtime	int	10			0
tst_qst_solved	active_fi	int	10			0
tst_qst_solved	question_fi	int	10			0
tst_qst_solved	solved	tinyint	3			0
tst_result_cache	active_fi	int	10
tst_result_cache	failed	int	10
tst_result_cache	mark_official	varchar	256
tst_result_cache	mark_short	varchar	256
tst_result_cache	max_points	double	22			0
tst_result_cache	pass	int	10
tst_result_cache	passed	int	10
tst_result_cache	reached_points	double	22			0
tst_result_cache	tstamp	int	10			0
tst_rnd_cpy	copy_id	int	10
tst_rnd_cpy	qpl_fi	int	10
tst_rnd_cpy	qst_fi	int	10
tst_rnd_cpy	tst_fi	int	10
tst_rnd_cpy_seq	sequence	int	10		√
tst_rnd_qpl_title	qpl_fi	int	10
tst_rnd_qpl_title	qpl_title	varchar	1000
tst_rnd_qpl_title	title_id	int	10
tst_rnd_qpl_title	tst_fi	int	10
tst_rnd_qpl_title_seq	sequence	int	10		√
tst_sequence	active_fi	int	10			0
tst_sequence	hidden	varchar	4000	√		null
tst_sequence	pass	int	10			0
tst_sequence	postponed	varchar	4000	√		null
tst_sequence	sequence	longtext	2147483647	√		null
tst_sequence	tstamp	int	10			0
tst_solutions	active_fi	int	10			0
tst_solutions	pass	int	10			0
tst_solutions	points	double	22	√		null
tst_solutions	question_fi	int	10			0
tst_solutions	solution_id	int	10			0
tst_solutions	tstamp	int	10			0
tst_solutions	value1	longtext	2147483647	√		null
tst_solutions	value2	longtext	2147483647	√		null
tst_solutions_seq	sequence	int	10		√
tst_test_defaults	defaults	varchar	4000	√		null
tst_test_defaults	marks	varchar	4000	√		null
tst_test_defaults	name	varchar	255	√		null
tst_test_defaults	test_defaults_id	int	10			0
tst_test_defaults	tstamp	int	10			0
tst_test_defaults	user_fi	int	10			0
tst_test_defaults_seq	sequence	int	10		√
tst_test_question	question_fi	int	10			0
tst_test_question	sequence	smallint	5			0
tst_test_question	test_fi	int	10			0
tst_test_question	test_question_id	int	10			0
tst_test_question	tstamp	int	10			0
tst_test_question_seq	sequence	int	10		√
tst_test_random	num_of_q	int	10			0
tst_test_random	questionpool_fi	int	10			0
tst_test_random	sequence	int	10			0
tst_test_random	test_fi	int	10			0
tst_test_random	test_random_id	int	10			0
tst_test_random	tstamp	int	10			0
tst_test_random_seq	sequence	int	10		√
tst_test_result	active_fi	int	10			0
tst_test_result	manual	tinyint	3			0
tst_test_result	pass	int	10			0
tst_test_result	points	double	22			0
tst_test_result	question_fi	int	10			0
tst_test_result	test_result_id	int	10			0
tst_test_result	tstamp	int	10			0
tst_test_result_seq	sequence	int	10		√
tst_test_rnd_qst	active_fi	int	10			0
tst_test_rnd_qst	pass	int	10			0
tst_test_rnd_qst	question_fi	int	10			0
tst_test_rnd_qst	sequence	smallint	5			0
tst_test_rnd_qst	test_random_question_id	int	10			0
tst_test_rnd_qst	tstamp	int	10			0
tst_test_rnd_qst_seq	sequence	int	10		√
tst_tests	allowedusers	int	10	√		null
tst_tests	alloweduserstimegap	int	10	√		null
tst_tests	anonymity	varchar	1	√		0
tst_tests	answer_feedback	varchar	1	√		0
tst_tests	answer_feedback_points	varchar	1	√		0
tst_tests	author	varchar	50	√		null
tst_tests	certificate_visibility	varchar	1	√		0
tst_tests	complete	varchar	1	√		1
tst_tests	count_system	varchar	1	√		0
tst_tests	created	int	10			0
tst_tests	customstyle	varchar	128	√		null
tst_tests	ects_a	double	22			90
tst_tests	ects_b	double	22			65
tst_tests	ects_c	double	22			35
tst_tests	ects_d	double	22			10
tst_tests	ects_e	double	22			0
tst_tests	ects_fx	double	22	√		null
tst_tests	ects_output	varchar	1	√		0
tst_tests	enable_processing_time	varchar	1	√		0
tst_tests	ending_time	varchar	14	√		null
tst_tests	exportsettings	int	10			0
tst_tests	finalstatement	varchar	4000	√		null
tst_tests	fixed_participants	varchar	1	√		0
tst_tests	forcejs	int	10			0
tst_tests	instant_verification	varchar	1	√		0
tst_tests	introduction	varchar	4000	√		null
tst_tests	keep_questions	tinyint	3			0
tst_tests	kiosk	int	10			0
tst_tests	mailnotification	tinyint	3	√		0
tst_tests	mailnottype	smallint	5			0
tst_tests	mc_scoring	varchar	1	√		0
tst_tests	nr_of_tries	smallint	5			0
tst_tests	obj_fi	int	10			0
tst_tests	pass_scoring	varchar	1	√		0
tst_tests	password	varchar	20	√		null
tst_tests	processing_time	varchar	8	√		null
tst_tests	random_question_count	int	10	√		null
tst_tests	random_test	varchar	1	√		0
tst_tests	reporting_date	varchar	14	√		null
tst_tests	reset_processing_time	tinyint	3			0
tst_tests	resultoutput	int	10			0
tst_tests	results_presentation	int	10			3
tst_tests	score_cutting	varchar	1	√		0
tst_tests	score_reporting	tinyint	3			0
tst_tests	sequence_settings	tinyint	3			0
tst_tests	show_cancel	varchar	1	√		1
tst_tests	show_marker	tinyint	3			0
tst_tests	show_question_titles	varchar	1	√		1
tst_tests	show_summary	int	10			0
tst_tests	showfinalstatement	int	10			0
tst_tests	showinfo	int	10			1
tst_tests	shuffle_questions	varchar	1	√		0
tst_tests	starting_time	varchar	14	√		null
tst_tests	test_id	int	10			0
tst_tests	title_output	varchar	1	√		0
tst_tests	tstamp	int	10			0
tst_tests	use_previous_answers	varchar	1	√		1
tst_tests_seq	sequence	int	10		√
tst_times	active_fi	int	10			0
tst_times	finished	datetime	19	√		null
tst_times	pass	smallint	5			0
tst_times	started	datetime	19	√		null
tst_times	times_id	int	10			0
tst_times	tstamp	int	10			0
tst_times_seq	sequence	int	10		√
udf_clob	field_id	int	10
udf_clob	usr_id	int	10
udf_clob	value	longtext	2147483647	√		null
udf_data	usr_id	int	10			0
udf_definition	changeable	tinyint	3			0
udf_definition	changeable_lua	tinyint	3			0
udf_definition	course_export	tinyint	3			0
udf_definition	export	tinyint	3			0
udf_definition	field_id	int	10			0
udf_definition	field_name	char	255	√		null
udf_definition	field_type	tinyint	3			0
udf_definition	field_values	longtext	2147483647	√		null
udf_definition	group_export	tinyint	3	√		0
udf_definition	registration_visible	tinyint	3	√		0
udf_definition	required	tinyint	3			0
udf_definition	searchable	tinyint	3			0
udf_definition	visible	tinyint	3			0
udf_definition	visible_lua	tinyint	3			0
udf_definition_seq	sequence	int	10		√
udf_text	field_id	int	10
udf_text	usr_id	int	10
udf_text	value	varchar	4000	√		null
usr_data	active	int	10			0
usr_data	agree_date	datetime	19	√		null
usr_data	approve_date	datetime	19	√		null
usr_data	auth_mode	char	10	√		default
usr_data	birthday	date	10	√		null
usr_data	city	varchar	40	√		null
usr_data	client_ip	varchar	255	√		null
usr_data	country	varchar	40	√		null
usr_data	create_date	datetime	19	√		null
usr_data	delicious	varchar	40	√		null
usr_data	department	varchar	80	√		null
usr_data	email	varchar	80	√		null
usr_data	ext_account	varchar	50	√		null
usr_data	fax	varchar	40	√		null
usr_data	feed_hash	varchar	32	√		null
usr_data	firstname	varchar	32	√		null
usr_data	gender	char	1	√		m
usr_data	hobby	varchar	4000	√		null
usr_data	i2passwd	varchar	32	√		null
usr_data	ilinc_id	int	10	√		null
usr_data	ilinc_login	varchar	40	√		null
usr_data	ilinc_passwd	varchar	40	√		null
usr_data	im_aim	varchar	40	√		null
usr_data	im_icq	varchar	40	√		null
usr_data	im_jabber	varchar	40	√		null
usr_data	im_msn	varchar	40	√		null
usr_data	im_skype	varchar	40	√		null
usr_data	im_voip	varchar	40	√		null
usr_data	im_yahoo	varchar	40	√		null
usr_data	institution	varchar	80	√		null
usr_data	last_login	datetime	19	√		null
usr_data	last_password_change	int	10			0
usr_data	last_update	datetime	19	√		null
usr_data	lastname	varchar	32	√		null
usr_data	latitude	varchar	30	√		null
usr_data	loc_zoom	int	10			0
usr_data	login	varchar	80	√		null
usr_data	login_attempts	tinyint	3			0
usr_data	longitude	varchar	30	√		null
usr_data	matriculation	varchar	40	√		null
usr_data	passwd	varchar	32	√		null
usr_data	phone_home	varchar	40	√		null
usr_data	phone_mobile	varchar	40	√		null
usr_data	phone_office	varchar	40	√		null
usr_data	profile_incomplete	int	10	√		0
usr_data	referral_comment	varchar	250	√		null
usr_data	reg_hash	char	32	√		null
usr_data	sel_country	varchar	2	√		null
usr_data	street	varchar	40	√		null
usr_data	time_limit_from	int	10	√		0
usr_data	time_limit_message	int	10	√		0
usr_data	time_limit_owner	int	10	√		0
usr_data	time_limit_unlimited	int	10	√		0
usr_data	time_limit_until	int	10	√		0
usr_data	title	varchar	32	√		null
usr_data	usr_id	int	10			0
usr_data	zipcode	varchar	10	√		null
usr_ext_profile_page	id	int	10			0
usr_ext_profile_page	order_nr	int	10			0
usr_ext_profile_page	title	varchar	200	√		null
usr_ext_profile_page	user_id	int	10			0
usr_ext_profile_page_seq	sequence	int	10		√
usr_pref	keyword	char	40
usr_pref	usr_id	int	10			0
usr_pref	value	char	40	√		null
usr_pwassist	ctime	int	10			0
usr_pwassist	expires	int	10			0
usr_pwassist	pwassist_id	varchar	32
usr_pwassist	user_id	int	10			0
usr_search	checked	longtext	2147483647	√		null
usr_search	failed	longtext	2147483647	√		null
usr_search	item_filter	varchar	1000	√		null
usr_search	page	tinyint	3			0
usr_search	query	longtext	2147483647	√		null
usr_search	root	int	10	√		1
usr_search	search_result	longtext	2147483647	√		null
usr_search	search_type	tinyint	3			0
usr_search	usr_id	int	10			0
usr_session	createtime	int	10	√		null
usr_session	ctime	int	10			0
usr_session	data	longtext	2147483647	√		null
usr_session	expires	int	10			0
usr_session	last_remind_ts	int	10			0
usr_session	session_id	varchar	80
usr_session	type	int	10	√		null
usr_session	user_id	int	10			0
ut_access	acc_obj_id	int	10			0
ut_access	acc_obj_type	char	10	√		null
ut_access	acc_sub_id	int	10			0
ut_access	acc_sub_type	char	10	√		null
ut_access	acc_time	datetime	19	√		null
ut_access	action_type	char	10	√		null
ut_access	browser	char	255	√		null
ut_access	client_ip	char	15	√		null
ut_access	id	int	10			0
ut_access	language	char	15	√		null
ut_access	php_script	char	100	√		null
ut_access	session_id	char	40	√		null
ut_access	user_id	int	10			0
ut_access	ut_month	varchar	10	√		null
ut_access_seq	sequence	int	10		√
ut_lp_collections	item_id	int	10			0
ut_lp_collections	obj_id	int	10			0
ut_lp_marks	completed	int	10			0
ut_lp_marks	mark	varchar	32	√		null
ut_lp_marks	obj_id	int	10			0
ut_lp_marks	percentage	tinyint	3			0
ut_lp_marks	status	tinyint	3			0
ut_lp_marks	status_changed	datetime	19	√		null
ut_lp_marks	status_dirty	tinyint	3			0
ut_lp_marks	u_comment	varchar	4000	√		null
ut_lp_marks	usr_id	int	10			0
ut_lp_settings	obj_id	int	10			0
ut_lp_settings	obj_type	char	4	√		null
ut_lp_settings	u_mode	tinyint	3			0
ut_lp_settings	visits	int	10	√		0
ut_lp_user_status	additional_info	varchar	4000	√		null
ut_lp_user_status	obj_id	int	10			0
ut_lp_user_status	status	tinyint	3			0
ut_lp_user_status	usr_id	int	10			0
ut_online	access_time	int	10			0
ut_online	online_time	int	10			0
ut_online	usr_id	int	10			0
webr_items	active	tinyint	3	√		null
webr_items	create_date	int	10			0
webr_items	description	varchar	4000	√		null
webr_items	disable_check	tinyint	3	√		null
webr_items	last_check	int	10	√		null
webr_items	last_update	int	10			0
webr_items	link_id	int	10			0
webr_items	target	varchar	4000	√		null
webr_items	title	varchar	127	√		null
webr_items	valid	tinyint	3			0
webr_items	webr_id	int	10			0
webr_items_seq	sequence	int	10		√
webr_params	link_id	int	10			0
webr_params	name	char	128	√		null
webr_params	param_id	int	10			0
webr_params	value	tinyint	3			0
webr_params	webr_id	int	10			0
webr_params_seq	sequence	int	10		√
write_event	action	varchar	8
write_event	obj_id	int	10			0
write_event	parent_obj_id	int	10			0
write_event	ts	datetime	19			1970-01-01 00:00:00
write_event	usr_id	int	10			0
write_event	write_id	int	10			0
write_event_seq	sequence	int	10		√
xhtml_page	content	longtext	2147483647	√		null
xhtml_page	id	int	10			0
xhtml_page	save_content	longtext	2147483647	√		null
xhtml_page_seq	sequence	int	10		√
xmlnestedset	ns_book_fk	int	10			0
xmlnestedset	ns_l	int	10	√		null
xmlnestedset	ns_r	int	10	√		null
xmlnestedset	ns_tag_fk	int	10	√		null
xmlnestedset	ns_type	char	50	√		null
xmlnestedsettmp	ns_book_fk	int	10
xmlnestedsettmp	ns_l	int	10
xmlnestedsettmp	ns_r	int	10
xmlnestedsettmp	ns_tag_fk	int	10
xmlnestedsettmp	ns_type	varchar	50
xmlnestedsettmp	ns_unique_id	varchar	32
xmlparam	param_name	char	50	√		null
xmlparam	param_value	char	255	√		null
xmlparam	tag_fk	int	10			0
xmltags	tag_depth	int	10			0
xmltags	tag_name	char	50	√		null
xmltags	tag_pk	int	10			0
xmltags_seq	sequence	int	10		√
xmlvalue	tag_fk	int	10			0
xmlvalue	tag_value	longtext	2147483647	√		null
xmlvalue	tag_value_pk	int	10			0
xmlvalue_seq	sequence	int	10		√