iliasRelease_3_8_x_branch contains 2026 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
crs_settings	abo	tinyint	3	√		1
ut_access	acc_obj_id	int	10			0
ut_access	acc_obj_type	char	10
ut_access	acc_sub_id	int	10			0
ut_access	acc_sub_type	char	10
ut_access	acc_time	datetime	19	√		null
crs_timings_usr_accept	accept	bit	0			0
member_agreement	acceptance_time	int	10			0
member_agreement	accepted	bit	0			0
payment_statistic	access	int	10			0
frm_thread_access	access_last	int	10			0
frm_thread_access	access_old	int	10			0
ut_learning_progress	access_time	int	10			0
ut_online	access_time	int	10			0
cmi_node	accesscount	int	10	√		null
cmi_node	accessduration	varchar	20	√		null
cmi_node	accessed	varchar	20	√		null
payment_bill_vendor	account_number	char	32	√		null
cp_rule	action	varchar	50	√		null
history	action	varchar	20
ut_access	action_type	char	10	√		null
crs_settings	activation_end	int	10	√		null
ilinc_data	activation_end	int	10	√		null
ilinc_data	activation_offline	enum	2	√		null
crs_settings	activation_start	int	10	√		null
ilinc_data	activation_start	int	10	√		null
crs_settings	activation_type	bit	0			0
ilinc_data	activation_unlimited	tinyint	3	√		null
ldap_server_settings	active	int	10			0
lm_data	active	enum	2	√		y
lm_menu	active	enum	2			n
style_data	active	tinyint	3	√		1
usr_data	active	int unsigned	10			0
webr_items	active	bit	0	√		null
survey_answer	active_fi	int	10			0
tst_active_qst_sol_settings	active_fi	int	10			0
tst_manual_feedback	active_fi	int	10			0
tst_solutions	active_fi	int	10			0
tst_test_random_question	active_fi	int	10			0
tst_test_result	active_fi	int	10			0
tst_times	active_fi	int	10			0
tst_active	active_id	int unsigned	10		√
cmi_node	activityAbsoluteDuration	varchar	20	√		null
cp_sequencing	activityAbsoluteDurationLimit	varchar	20	√		null
cmi_node	activityAttemptCount	int	10	√		null
cmi_node	activityExperiencedDuration	varchar	20	√		null
cp_sequencing	activityExperiencedDurationLimit	varchar	20	√		null
cmi_node	activityProgressStatus	tinyint	3	√		null
payment_settings	add_info	text	65535
addressbook	addr_id	int	10		√
payment_settings	address	text	65535
usr_data	agree_date	datetime	19			0000-00-00 00:00:00
ilinc_data	akclassvalue1	varchar	40	√		null
ilinc_data	akclassvalue2	varchar	40	√		null
role_data	allow_register	bit	0			0
tst_tests	allowedUsers	int	10	√		null
tst_tests	allowedUsersTimeGap	int	10	√		null
tst_tests	anonymity	enum	2			0
survey_survey	anonymize	enum	2			0
frm_settings	anonymized	bit	0			0
feedback_items	anonymous	bit	0			1
survey_anonymous	anonymous_id	int	10		√
survey_answer	anonymous_id	varchar	32
survey_finished	anonymous_id	varchar	32	√		null
tst_active	anonymous_id	varchar	5	√		null
qpl_feedback_imagemap	answer	int	10			0
qpl_feedback_multiplechoice	answer	int	10			0
qpl_feedback_singlechoice	answer	int	10			0
tst_tests	answer_feedback	enum	2			0
tst_tests	answer_feedback_points	enum	2			0
qpl_answer_cloze	answer_id	int unsigned	10		√
qpl_answer_imagemap	answer_id	int unsigned	10		√
qpl_answer_matching	answer_id	int unsigned	10		√
qpl_answer_multiplechoice	answer_id	int unsigned	10		√
qpl_answer_ordering	answer_id	int unsigned	10		√
qpl_answer_singlechoice	answer_id	int unsigned	10		√
qpl_answer_textsubset	answer_id	int unsigned	10		√
survey_answer	answer_id	int	10		√
qpl_answer_cloze	answertext	text	65535
qpl_answer_imagemap	answertext	text	65535
qpl_answer_matching	answertext	text	65535
qpl_answer_multiplechoice	answertext	text	65535
qpl_answer_ordering	answertext	text	65535
qpl_answer_singlechoice	answertext	text	65535
qpl_answer_textsubset	answertext	text	65535
qpl_answer_cloze	aorder	int unsigned	10			0
qpl_answer_imagemap	aorder	int unsigned	10			0
qpl_answer_matching	aorder	int unsigned	10			0
qpl_answer_multiplechoice	aorder	int unsigned	10			0
qpl_answer_ordering	aorder	int unsigned	10			0
qpl_answer_singlechoice	aorder	int unsigned	10			0
qpl_answer_textsubset	aorder	int unsigned	10			0
qpl_numeric_range	aorder	int	10			0
sahs_lm	api_adapter	varchar	80	√		API
sahs_lm	api_func_prefix	varchar	20	√		LMS
grp_registration	application_date	datetime	19			0000-00-00 00:00:00
ilinc_registration	application_date	datetime	19	√		null
event_appointment	appointment_id	int	10		√
usr_data	approve_date	datetime	19			0000-00-00 00:00:00
crs_archives	archive_date	int	10	√		null
crs_settings	archive_end	int	10	√		null
crs_archives	archive_id	int	10		√
crs_archives	archive_lang	varchar	16	√		null
crs_archives	archive_name	varchar	255
crs_archives	archive_size	int	10	√		null
crs_settings	archive_start	int	10	√		null
crs_archives	archive_type	tinyint	3			0
crs_settings	archive_type	int	10	√		null
qpl_answer_imagemap	area	varchar	20	√		null
ass_log	ass_log_id	int	10		√
rbac_fa	assign	enum	2	√		null
role_data	assign_users	char	2	√		0
reg_email_role_assignments	assignment_id	int	10		√
tst_eval_settings	atimeofwork	enum	2			1
mail	attachments	varchar	255	√		null
mail_saved	attachments	varchar	255	√		null
cmi_node	attemptAbsoluteDuration	varchar	20	√		null
cp_sequencing	attemptAbsoluteDurationLimit	varchar	20	√		null
cmi_node	attemptCompletionAmount	double	22	√		null
cmi_node	attemptCompletionStatus	tinyint	3	√		null
cmi_node	attemptExperiencedDuration	varchar	20	√		null
cp_sequencing	attemptExperiencedDurationLimit	varchar	20	√		null
cp_sequencing	attemptLimit	int	10	√		null
cmi_node	attemptProgressStatus	tinyint	3	√		null
xml_attribute_name	attribute	char	32
xml_attribute_idx	attribute_id	smallint unsigned	5			0
xml_attribute_name	attribute_id	smallint unsigned	5		√
xml_attribute_namespace	attribute_id	smallint unsigned	5		√
aicc_units	au_password	varchar	50	√		null
cmi_node	audio_captioning	int	10	√		null
cmi_node	audio_level	double	22	√		null
role_data	auth_mode	enum	10			default
usr_data	auth_mode	enum	10			default
note	author	int	10			0
qpl_questions	author	varchar	50
survey_question	author	varchar	100
survey_survey	author	varchar	50
tst_tests	author	varchar	50
sahs_lm	auto_review	enum	2			n
cp_auxilaryResource	auxiliaryResourceID	varchar	255	√		null
cmi_node	availableChildren	varchar	255	√		null
payment_statistic	b_pay_method	int	10	√		null
payment_statistic	b_vendor_id	int	10	√		null
note_data	bad	enum	2			n
payment_settings	bank_data	text	65535
payment_bill_vendor	bankcode	char	32	√		null
payment_bill_vendor	bankname	char	64	√		null
cp_manifest	base	varchar	200	√		null
cp_resource	base	varchar	200	√		null
ldap_server_settings	base_dn	varchar	255
dp_dates	begin	int	10			0
cp_sequencing	beginTimeLimit	varchar	20	√		null
benchmark	benchmark	varchar	150	√		null
payment_bill_vendor	bic	char	64	√		null
ldap_server_settings	bind_pass	varchar	32
ldap_server_settings	bind_type	int	10			0
ldap_server_settings	bind_user	varchar	255
survey_question_matrix	bipolar_adjective1	varchar	255	√		null
survey_question_matrix	bipolar_adjective2	varchar	255	√		null
il_block_setting	block_id	int	10			0
crs_members	blocked	tinyint	3			0
usr_new_account_mail	body	mediumtext	16777215	√		null
payment_statistic	booking_id	int	10		√
ut_access	browser	char	60
il_meta_requirement	browser_maximum_version	text	65535	√		null
il_meta_requirement	browser_minimum_version	text	65535	√		null
il_meta_requirement	browser_name	varchar	32	√		null
ctrl_structure	call_node	mediumtext	16777215	√		null
media_item	caption	text	65535	√		null
il_meta_identifier	catalog	text	65535	√		null
il_meta_identifier_	catalog	text	65535	√		null
style_data	category	int	10	√		null
survey_phrase_category	category_fi	int	10			0
survey_variable	category_fi	int	10			0
survey_category	category_id	int	10		√
xml_cdata	cdata	text	65535
benchmark	cdate	datetime	19	√		null
tst_tests	certificate_visibility	enum	2			0
crs_items	changeable	bit	0			0
user_defined_field_definition	changeable	bit	0			0
dp_dates	changed	int	10			0
xml_object	charset	varchar	40	√		null
chat_blocked	chat_id	int	10			0
chat_records	chat_id	int	10			0
chat_room_messages	chat_id	int	10			0
chat_rooms	chat_id	int	10			0
chat_user	chat_id	int	10			0
usr_search	checked	text	65535
bookmark_tree	child	int unsigned	10			0
cp_tree	child	int	10	√		null
ctrl_calls	child	varchar	100	√		null
lm_tree	child	int unsigned	10			0
mail_tree	child	int unsigned	10			0
mep_tree	child	int	10			0
scorm_tree	child	int unsigned	10			0
search_tree	child	int unsigned	10			0
tree	child	int unsigned	10			0
cp_rule	childActivitySet	varchar	50	√		null
cp_sequencing	choice	tinyint	3	√		null
cp_sequencing	choiceExit	tinyint	3	√		null
payment_bill_vendor	city	char	64	√		null
usr_data	city	varchar	40	√		null
ctrl_classfile	class	varchar	100
module_class	class	varchar	100
rbac_operations	class	enum	7			notused
service_class	class	varchar	100
style_parameter	class	varchar	100	√		null
content_object	clean_frames	enum	2			n
usr_data	client_ip	varchar	15	√		null
ut_access	client_ip	char	15	√		null
tst_invited_user	clientip	varchar	15	√		null
qpl_answer_cloze	cloze_type	enum	2	√		null
cmi_comment	cmi_comment_id	int	10		√
cmi_correct_response	cmi_correct_response_id	int	10		√
cmi_correct_response	cmi_interaction_id	int	10	√		null
cmi_interaction	cmi_interaction_id	int	10		√
cmi_objective	cmi_interaction_id	int	10	√		null
cmi_comment	cmi_node_id	int	10	√		null
cmi_interaction	cmi_node_id	int	10	√		null
cmi_node	cmi_node_id	int	10		√
cmi_objective	cmi_node_id	int	10	√		null
cmi_objective	cmi_objective_id	int	10		√
survey_question_matrix	column_header_position	enum	2			0
survey_question_matrix	column_images	enum	2			0
survey_question_matrix	column_order	enum	2			0
survey_question_matrix	column_placeholders	int	10			0
survey_question_matrix	column_separators	enum	2			0
aicc_units	command_line	varchar	255	√		null
cmi_comment	comment	text	65535	√		null
event_participants	comment	text	65535
qpl_questions	comment	text	65535	√		null
ut_lp_marks	comment	text	65535
xml_comment	comment	text	65535
chat_room_messages	commit_timestamp	timestamp	19			CURRENT_TIMESTAMP
qpl_questions	complete	enum	2			1
survey_question	complete	enum	2			0
survey_survey	complete	enum	2			0
tst_tests	complete	enum	2			1
ut_lp_marks	completed	int	10			0
cmi_node	completion	double	22	√		null
cmi_node	completion_status	varchar	32	√		null
cmi_objective	completion_status	double	22	√		null
cmi_node	completion_threshold	varchar	32	√		null
cp_sequencing	completionSetByContent	tinyint	3	√		null
cp_item	completionThreshold	varchar	50	√		null
cp_condition	condition	varchar	50	√		null
cp_rule	conditionCombination	varchar	50	√		null
cp_sequencing	constrainChoice	tinyint	3	√		null
survey_question_constraint	constraint_fi	int	10			0
survey_constraint	constraint_id	int	10		√
crs_settings	contact_consultation	text	65535	√		null
crs_settings	contact_email	varchar	255	√		null
ilinc_data	contact_email	varchar	255	√		null
crs_settings	contact_name	varchar	255	√		null
ilinc_data	contact_name	varchar	255	√		null
crs_settings	contact_phone	varchar	255	√		null
ilinc_data	contact_phone	varchar	255	√		null
crs_settings	contact_responsibility	varchar	255	√		null
ilinc_data	contact_responsibility	varchar	255	√		null
il_html_block	content	text	65535	√		null
il_news_item	content	text	65535	√		null
page_object	content	mediumtext	16777215	√		null
xhtml_page	content	mediumtext	16777215	√		null
il_news_item	content_is_lang_var	tinyint	3	√		0
il_news_item	content_long	text	65535	√		null
il_news_item	content_type	enum	5	√		text
il_meta_educational	context	varchar	16	√		null
il_custom_block	context_obj_id	int	10	√		null
il_news_item	context_obj_id	int	10	√		null
il_custom_block	context_obj_type	varchar	10	√		null
il_news_item	context_obj_type	varchar	10	√		null
il_custom_block	context_sub_obj_id	int	10	√		null
il_news_item	context_sub_obj_id	int	10	√		null
il_custom_block	context_sub_obj_type	varchar	10	√		null
il_news_item	context_sub_obj_type	varchar	10	√		null
map_area	coords	varchar	200	√		null
qpl_answer_imagemap	coords	text	65535	√		null
copy_wizard_options	copy_id	int	10			0
il_meta_rights	copyright_and_other_restrictions	char	3	√		null
aicc_units	core_vendor	text	65535	√		null
qpl_question_textsubset	correctanswers	int	10	√		0
qpl_answer_cloze	correctness	enum	2			0
qpl_answer_imagemap	correctness	enum	2			0
qpl_feedback_generic	correctness	enum	2			0
payment_vendors	cost_center	varchar	16
il_meta_rights	costs	char	3	√		null
tst_tests	count_system	enum	2			0
payment_bill_vendor	country	char	64	√		null
usr_data	country	varchar	40	√		null
aicc_course	course_creator	varchar	255	√		null
user_defined_field_definition	course_export	bit	0			0
aicc_course	course_id	varchar	50	√		null
crs_archives	course_id	int	10			0
crs_file	course_id	int	10			0
ilinc_data	course_id	int unsigned	10			0
aicc_course	course_system	varchar	50	√		null
aicc_course	course_title	varchar	255	√		null
il_meta_general	coverage	text	65535	√		null
il_meta_general	coverage_language	char	2	√		null
cmi_node	cp_node_id	int	10	√		null
cp_auxilaryResource	cp_node_id	int	10			0
cp_condition	cp_node_id	int	10			0
cp_dependency	cp_node_id	int	10			0
cp_file	cp_node_id	int	10			0
cp_hideLMSUI	cp_node_id	int	10			0
cp_item	cp_node_id	int	10			0
cp_manifest	cp_node_id	int	10			0
cp_mapinfo	cp_node_id	int	10			0
cp_node	cp_node_id	int	10		√
cp_objective	cp_node_id	int	10			0
cp_organization	cp_node_id	int	10			0
cp_resource	cp_node_id	int	10			0
cp_rule	cp_node_id	int	10			0
cp_sequencing	cp_node_id	int	10			0
glossary_term	create_date	datetime	19			0000-00-00 00:00:00
lm_data	create_date	datetime	19			0000-00-00 00:00:00
note_data	create_date	datetime	19			0000-00-00 00:00:00
object_data	create_date	datetime	19			0000-00-00 00:00:00
usr_data	create_date	datetime	19			0000-00-00 00:00:00
webr_items	create_date	int	10			0
cmi_node	created	varchar	20	√		null
cp_package	created	varchar	20	√		null
crs_objectives	created	int	10			0
dp_dates	created	int	10			0
qpl_questions	created	varchar	14
survey_question	created	varchar	14
survey_survey	created	varchar	14
tst_tests	created	varchar	14	√		null
il_news_item	creation_date	datetime	19	√		null
note	creation_date	datetime	19	√		null
cmi_node	credit	varchar	32	√		null
sahs_lm	credit	enum	9			credit
crs_groupings	crs_grp_id	int	10			0
crs_groupings	crs_id	int	10			0
crs_objectives	crs_id	int	10			0
crs_start	crs_id	int	10			0
crs_timings_usr_accept	crs_id	int	10			0
crs_groupings	crs_ref_id	int	10			0
crs_lm_history	crs_ref_id	int	10			0
crs_start	crs_start_id	int	10		√
usr_pwassist	ctime	int	10			0
usr_session	ctime	int	10			0
payment_prices	currency	int	10			0
payment_currencies	currency_id	int	10			0
payment_settings	currency_subunit	varchar	255
payment_settings	currency_unit	varchar	255
payment_shopping_cart	customer_id	int	10			0
payment_statistic	customer_id	int	10			0
usr_session	data	text	65535
cp_item	dataFromLMS	varchar	255	√		null
sc_item	datafromlms	text	65535	√		null
frm_posts_tree	date	datetime	19			0000-00-00 00:00:00
il_meta_annotation	date	text	65535	√		null
il_meta_contribute	date	text	65535	√		null
dp_changed_dates	date_ID	int	10			0
dp_keywords	date_ID	int	10			0
dp_neg_dates	date_ID	int	10			0
content_object	default_layout	varchar	100			toc2win
sahs_lm	default_lesson_mode	enum	7			normal
sc_organizations	default_organization	varchar	200	√		null
frm_settings	default_view	int	10			0
cp_manifest	defaultOrganization	varchar	50	√		null
tst_test_defaults	defaults	text	65535
survey_category	defaultvalue	enum	2			0
survey_phrase	defaultvalue	enum	2			0
object_reference	deleted	datetime	19			0000-00-00 00:00:00
usr_data	delicious	varchar	40	√		null
cmi_node	delivery_speed	double	22	√		null
payment_bill_vendor	department	char	64	√		null
usr_data	department	varchar	80
bookmark_tree	depth	smallint unsigned	5			0
cp_tree	depth	int	10	√		null
frm_posts_tree	depth	int	10			0
lm_tree	depth	smallint unsigned	5			0
mail_tree	depth	smallint unsigned	5			0
mep_tree	depth	smallint	5			0
scorm_tree	depth	smallint unsigned	5			0
search_tree	depth	smallint unsigned	5			0
tree	depth	smallint unsigned	5			0
xml_tree	depth	smallint unsigned	5			0
adv_md_field_definition	description	text	65535
adv_md_record	description	text	65535
aicc_course	description	text	65535	√		null
aicc_object	description	text	65535	√		null
bookmark_data	description	varchar	255
chat_records	description	text	65535
cmi_interaction	description	text	65535	√		null
cmi_objective	description	text	65535	√		null
crs_objectives	description	varchar	128
event	description	text	65535
feedback_items	description	text	65535	√		null
il_meta_annotation	description	text	65535	√		null
il_meta_classification	description	text	65535	√		null
il_meta_description	description	text	65535	√		null
il_meta_rights	description	text	65535	√		null
meta_data	description	blob	65535
object_data	description	char	128	√		null
object_description	description	text	65535
object_translation	description	text	65535	√		null
rbac_operations	description	char	255	√		null
survey_question	description	varchar	200
webr_items	description	text	65535
xml_node_type	description	varchar	50	√		null
il_meta_annotation	description_language	char	2	√		null
il_meta_classification	description_language	char	2	√		null
il_meta_description	description_language	char	2	√		null
il_meta_rights	description_language	char	2	√		null
event	details	text	65535
aicc_object	developer_id	varchar	50	√		null
il_meta_educational	difficulty	varchar	16	√		null
module	dir	varchar	200
module_class	dir	varchar	200
service	dir	varchar	200
service_class	dir	varchar	200
webr_items	disable_check	bit	0	√		null
tst_eval_settings	distancemedian	enum	2			1
ldap_role_group_mapping	dn	varchar	255
reg_email_role_assignments	domain	varchar	128
exc_usr_tutor	download_time	timestamp	19			CURRENT_TIMESTAMP
content_object	downloads_active	enum	2	√		n
glossary	downloads_active	enum	2	√		n
content_object	downloads_public_active	enum	2			y
benchmark	duration	double	14,5	√		null
il_meta_technical	duration	text	65535	√		null
meta_technical	duration	varchar	50
payment_prices	duration	int	10			0
payment_statistic	duration	char	16	√		null
dp_properties	dv_endtime	time	8			00:00:00
dp_properties	dv_starttime	time	8			00:00:00
crs_items	earliest_start	int	10			0
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	float	12	√		null
tst_tests	ects_output	enum	2			0
xml_element_name	element	char	32
xml_element_idx	element_id	smallint unsigned	5			0
xml_element_name	element_id	smallint unsigned	5		√
xml_element_namespace	element_id	smallint unsigned	5		√
xml_entity_reference	element_id	smallint unsigned	5		√
addressbook	email	varchar	40	√		null
payment_bill_vendor	email	char	64	√		null
usr_data	email	varchar	80
crs_settings	enable_course_map	tinyint	3			0
grp_data	enable_group_map	tinyint	3			0
tst_tests	enable_processing_time	enum	2			0
xml_object	encoding	varchar	40	√		null
dp_dates	end	int	10			0
dp_dates	end_rotation	int	10			0
chat_records	end_time	int	10			0
survey_survey	enddate	date	10	√		null
event_appointment	ending_time	int	10			0
tst_tests	ending_time	varchar	14	√		null
feedback_items	endtime	int	10	√		0
cp_sequencing	endTimeLimit	varchar	20	√		null
il_meta_annotation	entity	text	65535	√		null
il_meta_entity	entity	text	65535	√		null
xml_entity_reference	entity_reference	char	128
il_meta_identifier	entry	text	65535	√		null
il_meta_identifier_	entry	text	65535	√		null
chat_room_messages	entry_id	int	10		√
tst_eval_settings	eval_settings_id	int	10		√
survey_survey	evaluation_access	enum	2			0
event	event_id	int	10		√
event_appointment	event_id	int	10			0
event_file	event_id	int	10			0
event_items	event_id	int	10			0
event_participants	event_id	int	10			0
cmi_node	exit	varchar	255	√		null
grp_data	expiration	datetime	19	√		0000-00-00 00:00:00
usr_pwassist	expires	int	10			0
usr_session	expires	int	10			0
user_defined_field_definition	export	bit	0			0
usr_data	ext_account	varchar	50	√		null
usr_search	failed	text	65535
payment_bill_vendor	fax	char	32	√		null
usr_data	fax	varchar	40
feedback_items	fb_id	int	10		√
feedback_results	fb_id	int	10			0
usr_data	feed_hash	varchar	32	√		null
il_external_feed_block	feed_url	varchar	250	√		null
exc_members	feedback	bit	0			0
qpl_feedback_generic	feedback	text	65535
qpl_feedback_imagemap	feedback	text	65535
qpl_feedback_multiplechoice	feedback	text	65535
qpl_feedback_singlechoice	feedback	text	65535
tst_manual_feedback	feedback	text	65535	√		null
qpl_feedback_generic	feedback_id	int	10		√
qpl_feedback_imagemap	feedback_id	int	10		√
qpl_feedback_multiplechoice	feedback_id	int	10		√
qpl_feedback_singlechoice	feedback_id	int	10		√
exc_members	feedback_time	timestamp	19			0000-00-00 00:00:00
adv_md_field_definition	field_id	int	10		√
crs_defined_field_definitions	field_id	int	10		√
crs_user_data	field_id	int	10			0
user_defined_field_definition	field_id	int	10		√
crs_defined_field_definitions	field_name	varchar	255
user_defined_field_definition	field_name	tinytext	255
crs_defined_field_definitions	field_required	bit	0			0
adv_md_field_definition	field_type	bit	0			0
crs_defined_field_definitions	field_type	bit	0			0
user_defined_field_definition	field_type	bit	0			0
adv_md_field_definition	field_values	text	65535
crs_defined_field_definitions	field_values	text	65535
user_defined_field_definition	field_values	text	65535
ctrl_classfile	file	varchar	250	√		null
crs_file	file_id	int	10		√
event_file	file_id	int	10		√
file_data	file_id	int	10			0
aicc_units	file_name	varchar	255	√		null
crs_file	file_name	char	64
event_file	file_name	char	64
file_data	file_name	char	128
crs_file	file_size	int	10			0
event_file	file_size	int	10			0
file_data	file_size	int	10			0
crs_file	file_type	char	64
event_file	file_type	char	64
file_data	file_type	char	64
exc_returned	filename	mediumtext	16777215
exc_returned	filetitle	mediumtext	16777215
ldap_server_settings	filter	varchar	255
ut_lp_filter	filter_type	varchar	4
tst_times	finished	datetime	19			0000-00-00 00:00:00
survey_finished	finished_id	int	10		√
xml_tree	first_child_node_id	int unsigned	10			0
feedback_items	first_vote_best	bit	0	√		0
addressbook	firstname	varchar	40	√		null
payment_bill_vendor	firstname	char	64	√		null
usr_data	firstname	varchar	32
tst_eval_settings	firstvisit	enum	2			1
tst_tests	fixed_participants	enum	2			0
qpl_question_cloze	fixed_textlen	int	10	√		null
qpl_question_flashapp	flash_file	varchar	100	√		null
cp_sequencing	flow	tinyint	3	√		null
mail	folder_id	int	10			0
style_folder_styles	folder_id	int	10			0
content_object	footer_page	int	10			0
il_meta_format	format	text	65535	√		null
media_item	format	varchar	200	√		null
meta_techn_format	format	varchar	150	√		null
ctrl_structure	forward	mediumtext	16777215	√		null
cp_sequencing	forwardOnly	tinyint	3	√		null
frm_posts_tree	fpt_pk	bigint	19		√
frm_notification	frm_id	int	10			0
event_appointment	fulltime	bit	0			0
qpl_answer_cloze	gap_id	int unsigned	10			0
payment_bill_vendor	gender	tinyint	3	√		null
usr_data	gender	enum	2			m
il_meta_general	general_structure	varchar	16	√		null
glossary_term	glo_id	int	10			0
glossary	glo_menu_active	enum	2	√		y
note_data	good	enum	2			n
ldap_server_settings	group_attribute	varchar	64
ldap_server_settings	group_dn	varchar	255
survey_invited_group	group_fi	int	10			0
ldap_server_settings	group_filter	varchar	255
dp_dates	group_ID	int	10			0
ldap_server_settings	group_member	varchar	255
ldap_server_settings	group_memberisdn	bit	0			0
ldap_server_settings	group_name	varchar	255
ldap_server_settings	group_optional	bit	0			0
ldap_server_settings	group_scope	bit	0			0
ldap_server_settings	group_user_filter	varchar	255
grp_data	grp_id	int	10			0
grp_registration	grp_id	int	10			0
chat_invitations	guest_id	int	10			0
chat_invitations	guest_informed	bit	0			0
media_item	halign	enum	10	√		null
history	hdate	datetime	19	√		null
content_object	header_page	int	10			0
survey_survey_question	heading	text	65535	√		null
media_item	height	varchar	10	√		null
survey_question_text	height	int	10			5
ut_lp_filter	hidden	text	65535
content_object	hist_user_comments	enum	2	√		n
usr_data	hobby	text	65535
cp_file	href	varchar	50	√		null
cp_resource	href	varchar	250	√		null
map_area	href	varchar	200	√		null
sc_resource	href	varchar	250	√		null
sc_resource_file	href	text	65535	√		null
link_check	http_status_code	int	10			0
usr_data	i2passwd	varchar	32
payment_bill_vendor	iban	char	64	√		null
cmi_interaction	id	varchar	255	√		null
cmi_objective	id	varchar	255	√		null
conditions	id	int	10		√
container_settings	id	int	10			0
content_object	id	int	10			0
cp_item	id	varchar	200	√		null
cp_manifest	id	varchar	200	√		null
cp_organization	id	varchar	200	√		null
cp_resource	id	varchar	200	√		null
cp_sequencing	id	varchar	200	√		null
dbk_translations	id	int	10			0
dp_changed_dates	ID	int	10		√
dp_dates	ID	int	10		√
dp_keyword	ID	int	10		√
dp_keywords	ID	int	10		√
dp_neg_dates	ID	int	10		√
dp_properties	ID	int	10		√
file_based_lm	id	int	10			0
file_usage	id	int	10			0
glossary	id	int	10			0
glossary_definition	id	int	10		√
glossary_term	id	int	10		√
history	id	int	10		√
il_custom_block	id	int	10		√
il_external_feed_block	id	int	10		√
il_html_block	id	int	10			0
il_media_cast_data	id	int	10		√
il_news_item	id	int	10		√
lm_menu	id	int	10		√
media_item	id	int	10		√
mob_usage	id	int	10			0
note	id	int	10		√
sahs_lm	id	int	10			0
sc_resource_dependency	id	int	10		√
sc_resource_file	id	int	10		√
style_data	id	int	10			0
style_parameter	id	int	10		√
ut_access	id	int	10		√
xhtml_page	id	int	10		√
xml_object	ID	int	10		√
qpl_questionpool	id_questionpool	int	10		√
survey_questionpool	id_questionpool	int	10		√
survey_question_matrix_rows	id_survey_question_matrix_rows	int	10		√
qpl_question_cloze	identical_scoring	enum	2			1
cp_package	identifier	varchar	255	√		null
lng_data	identifier	varchar	50
sc_item	identifierref	varchar	200	√		null
sc_resource_dependency	identifierref	varchar	200	√		null
usr_data	ilinc_id	int unsigned	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_msn	varchar	40	√		null
usr_data	im_skype	varchar	40	√		null
usr_data	im_yahoo	varchar	40	√		null
qpl_question_imagemap	image_file	varchar	100	√		null
qpl_question_javaapplet	image_file	varchar	100	√		null
qpl_answer_multiplechoice	imagefile	text	65535	√		null
qpl_answer_singlechoice	imagefile	text	65535	√		null
adv_md_field_definition	import_id	varchar	32
adv_md_record	import_id	varchar	64
glossary_term	import_id	varchar	50
lm_data	import_id	varchar	50
object_data	import_id	char	50
qpl_suggested_solutions	import_id	varchar	50	√
sc_item	import_id	varchar	200	√		null
sc_manifest	import_id	varchar	200	√		null
sc_organization	import_id	varchar	200	√		null
sc_resource	import_id	varchar	200	√		null
survey_material	import_id	varchar	50	√		null
frm_posts	import_name	text	65535	√		null
frm_threads	import_name	text	65535	√		null
mail	import_name	text	65535	√		null
crs_settings	important	text	65535
note_data	important	enum	2			n
mail_options	incoming_type	tinyint	3	√		null
history	info_params	text	65535
meta_technical	install_remarks	text	65535
meta_technical	install_remarks_lang	char	2
il_meta_technical	installation_remarks	text	65535	√		null
il_meta_technical	installation_remarks_language	char	2	√		null
tst_tests	instant_verification	enum	2			0
payment_bill_vendor	institution	char	64	√		null
usr_data	institution	varchar	80	√		null
exc_data	instruction	text	65535	√		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
qpl_suggested_solutions	internal_link	varchar	50	√
survey_material	internal_link	varchar	50	√		null
feedback_items	interval_unit	tinyint	3	√		null
survey_survey	introduction	text	65535	√		null
tst_tests	introduction	text	65535	√		null
survey_survey	invitation	enum	2			0
survey_survey	invitation_mode	enum	2			1
chat_invitations	invitation_time	int	10			0
survey_invited_group	invited_group_id	int	10		√
survey_invited_user	invited_user_id	int	10		√
cp_item	isvisible	varchar	32	√		null
sc_item	isvisible	enum	5	√
crs_timings_planed	item_id	int	10			0
desktop_item	item_id	int	10			0
event_items	item_id	int	10			0
map_area	item_id	int	10			0
personal_clipboard	item_id	int	10			0
role_desktop_items	item_id	int	10			0
ut_lp_collections	item_id	int	10			0
ut_lp_event_collections	item_id	int	10			0
crs_start	item_ref_id	int	10			0
role_desktop_items	item_type	char	16
cp_package	jsdata	text	65535	√		null
tst_tests	keep_questions	tinyint	3			0
container_settings	keyword	char	40
dp_keyword	keyword	varchar	20
il_meta_keyword	keyword	text	65535	√		null
ldap_attribute_mapping	keyword	varchar	32
meta_keyword	keyword	varchar	200
settings	keyword	varchar	50
usr_pref	keyword	char	40
dp_keywords	keyword_ID	int	10			0
il_meta_keyword	keyword_language	char	2	√		null
qpl_question_essay	keywords	text	65535	√		null
chat_user	kicked	tinyint	3	√		0
il_meta_relation	kind	char	16	√		null
note	label	int	10			0
usr_new_account_mail	lang	varchar	5
lng_modules	lang_array	mediumtext	16777215	√		null
object_translation	lang_code	char	2
object_translation	lang_default	bit	0			0
lng_data	lang_key	char	2
lng_modules	lang_key	char	2
cmi_node	language	varchar	5	√		null
glossary_term	language	char	2	√		null
il_meta_language	language	char	2	√		null
il_meta_meta_data	language	char	2	√		null
meta_data	language	varchar	200
meta_keyword	language	char	2
ut_access	language	char	15	√		null
crs_lm_history	last_access	int	10			0
link_check	last_check	int	10			0
webr_items	last_check	int	10	√		null
chat_user	last_conn_timestamp	int	10	√		null
usr_data	last_login	datetime	19			0000-00-00 00:00:00
glossary_term	last_update	datetime	19			0000-00-00 00:00:00
lm_data	last_update	datetime	19			0000-00-00 00:00:00
object_data	last_update	datetime	19			0000-00-00 00:00:00
usr_data	last_update	datetime	19			0000-00-00 00:00:00
webr_items	last_update	int	10			0
qpl_answer_cloze	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_answer_imagemap	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_answer_matching	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_answer_multiplechoice	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_answer_ordering	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_answer_singlechoice	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_answer_textsubset	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_feedback_generic	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_feedback_imagemap	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_feedback_multiplechoice	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_feedback_singlechoice	lastchange	timestamp	19			CURRENT_TIMESTAMP
qpl_numeric_range	lastchange	timestamp	19			CURRENT_TIMESTAMP
survey_question_matrix	lastchange	timestamp	19			CURRENT_TIMESTAMP
tst_manual_feedback	lastchange	timestamp	19			CURRENT_TIMESTAMP
tst_test_defaults	lastchange	timestamp	19			CURRENT_TIMESTAMP
tst_active	lastindex	tinyint	3			1
addressbook	lastname	varchar	40	√		null
payment_bill_vendor	lastname	char	64	√		null
usr_data	lastname	varchar	32
tst_eval_settings	lastvisit	enum	2			1
cmi_interaction	latency	varchar	20	√		null
crs_items	latest_end	int	10			0
crs_settings	latitude	varchar	30
grp_data	latitude	varchar	30
usr_data	latitude	varchar	30
cmi_node	launch_data	text	65535	√		null
survey_question_matrix	layout	text	65535	√		null
xml_pi_data	leaf_id	int unsigned	10		√
xml_pi_target	leaf_id	int unsigned	10		√
xml_pi_data	leaf_text	text	65535
xml_pi_target	leaf_text	text	65535
cmi_node	learner_name	varchar	255	√		null
cmi_interaction	learner_response	text	65535	√		null
il_meta_educational	learning_resource_type	varchar	32	√		null
survey_question_matrix	legend	enum	2			0
aicc_course	level	varchar	5	√		null
bookmark_tree	lft	int unsigned	10			0
cp_tree	lft	int	10	√		null
frm_posts_tree	lft	int	10			0
lm_tree	lft	int unsigned	10			0
mail_tree	lft	int unsigned	10			0
mep_tree	lft	int	10			0
scorm_tree	lft	int unsigned	10			0
search_tree	lft	int unsigned	10			0
tree	lft	int unsigned	10			0
xml_tree	lft	smallint unsigned	5			0
xml_node_type	lft_delimiter	varchar	10	√		null
il_meta_lifecycle	lifecycle_status	varchar	16	√		null
reg_access_limitation	limit_absolute	int unsigned	10	√		null
reg_access_limitation	limit_mode	enum	9			absolute
reg_access_limitation	limit_relative_d	int unsigned	10	√		null
reg_access_limitation	limit_relative_m	int unsigned	10	√		null
reg_access_limitation	limit_relative_y	int unsigned	10	√		null
mail_options	linebreak	tinyint	3			0
webr_items	link_id	int	10		√
webr_params	link_id	int	10			0
lm_menu	link_ref_id	int	10	√		null
lm_menu	link_type	enum	7	√		null
map_area	link_type	char	3	√		null
crs_objective_lm	lm_ass_id	int	10		√
lm_data	lm_id	int	10			0
lm_menu	lm_id	int	10			0
lm_tree	lm_id	int	10			0
lo_access	lm_id	int	10			0
content_object	lm_menu_active	enum	2	√		y
crs_lm_history	lm_page_id	int	10			0
crs_lm_history	lm_ref_id	int	10			0
lo_access	lm_title	varchar	200
note_data	lo_id	int	10			0
usr_data	loc_zoom	int	10			0
cmi_comment	location	varchar	255	√		null
cmi_node	location	varchar	255	√		null
event	location	text	65535
il_meta_location	location	text	65535	√		null
media_item	location	varchar	200	√		null
meta_techn_loc	location	varchar	150	√		null
il_meta_location	location_type	varchar	16	√		null
media_item	location_type	enum	10			LocalFile
crs_settings	location_zoom	int	10			0
grp_data	location_zoom	int	10			0
addressbook	login	varchar	40	√		null
usr_data	login	varchar	80
ass_log	logtext	text	65535
crs_settings	longitude	varchar	30
grp_data	longitude	varchar	30
usr_data	longitude	varchar	30
survey_relation	longname	varchar	20
qpl_answer_cloze	lowerlimit	varchar	20			0
qpl_numeric_range	lowerlimit	varchar	20			0
ut_learning_progress	lp_id	int	10		√
scorm_tracking	lvalue	varchar	64
mail	m_email	bit	0	√		null
mail_saved	m_email	bit	0	√		null
mail	m_message	text	65535	√		null
mail_saved	m_message	text	65535	√		null
mail	m_status	varchar	16	√		null
mail	m_subject	varchar	255	√		null
mail_saved	m_subject	varchar	255	√		null
mail	m_type	varchar	255	√		null
mail_saved	m_type	varchar	16	√		null
mail	mail_id	int	10		√
mail_attachment	mail_id	int	10			0
tst_manual_feedback	manual_feedback_id	int	10		√
ldap_role_group_mapping	mapping_id	int	10		√
ldap_role_group_mapping	mapping_info	text	65535	√		null
ldap_role_group_mapping	mapping_info_type	bit	0			1
event_participants	mark	text	65535
ut_lp_marks	mark	varchar	32
tst_mark	mark_id	int unsigned	10		√
tst_test_defaults	marks	text	65535
aicc_units	mastery_score	smallint	5	√		null
sc_item	masteryscore	varchar	200	√		null
qpl_answer_matching	matching_order	int unsigned	10	√		null
qpl_question_matching	matching_type	enum	2	√		null
qpl_answer_matching	matchingtext	text	65535	√		null
survey_material	material_id	int	10		√
survey_question_material	material_id	int	10		√
survey_material	material_title	varchar	255	√		null
survey_question_material	materials	text	65535	√		null
survey_question_material	materials_file	varchar	200
usr_data	matriculation	varchar	40	√		null
cmi_node	max	double	22	√		null
cmi_objective	max	double	22	√		null
aicc_course	max_fields_cst	smallint	5	√		null
aicc_course	max_fields_ort	smallint	5	√		null
aicc_course	max_normal	tinyint	3	√		null
aicc_units	max_score	decimal	10	√		null
aicc_units	max_time_allowed	time	8	√		null
survey_question_text	maxchars	int	10	√		null
qpl_question_essay	maxNumOfChars	int	10			0
qpl_question_numeric	maxNumOfChars	int	10			0
sc_item	maxtimeallowed	varchar	30	√		null
tst_tests	mc_scoring	enum	2			0
cp_sequencing	measureSatisfactionIfActive	tinyint	3	√		null
cp_condition	measureThreshold	varchar	50	√		null
mob_parameter	med_item_id	int	10			0
ldap_role_group_mapping	member_attribute	varchar	64
ldap_role_group_mapping	member_isdn	bit	0			0
mep_tree	mep_id	int	10			0
chat_record_data	message	mediumtext	16777215
chat_room_messages	message	text	65535	√		null
il_meta_annotation	meta_annotation_id	int	10		√
il_meta_classification	meta_classification_id	int	10		√
il_meta_contribute	meta_contribute_id	int	10		√
il_meta_meta_data	meta_data_scheme	char	16	√		null
il_meta_description	meta_description_id	int	10		√
il_meta_educational	meta_educational_id	int	10		√
il_meta_entity	meta_entity_id	int	10		√
il_meta_format	meta_format_id	int	10		√
il_meta_general	meta_general_id	int	10		√
il_meta_identifier_	meta_identifier__id	int	10		√
il_meta_identifier	meta_identifier_id	int	10		√
il_meta_keyword	meta_keyword_id	int	10		√
il_meta_language	meta_language_id	int	10		√
il_meta_lifecycle	meta_lifecycle_id	int	10		√
il_meta_location	meta_location_id	int	10		√
il_meta_meta_data	meta_meta_data_id	int	10		√
il_meta_relation	meta_relation_id	int	10		√
il_meta_requirement	meta_requirement_id	int	10		√
il_meta_rights	meta_rights_id	int	10		√
il_meta_taxon	meta_taxon_id	int	10		√
il_meta_taxon_path	meta_taxon_path_id	int	10		√
il_meta_technical	meta_technical_id	int	10		√
il_meta_typical_age_range	meta_typical_age_range_id	int	10		√
il_meta_lifecycle	meta_version	text	65535	√		null
exc_returned	mimetype	varchar	40
cmi_node	min	double	22	√		null
cmi_objective	min	double	22	√		null
tst_mark	minimum_level	double	22			0
cp_rule	minimumCount	int	10	√		null
cp_rule	minimumPercent	varchar	50	√		null
cp_objective	minNormalizedMeasure	varchar	50	√		null
il_news_item	mob_id	int	10	√		null
media_item	mob_id	int	10			0
cmi_node	mode	varchar	20	√		null
file_data	mode	char	8	√		object
ut_lp_settings	mode	bit	0			0
chat_records	moderator_id	int	10			0
cmi_node	modified	varchar	20	√		null
cp_package	modified	varchar	20	√		null
benchmark	module	varchar	150	√		null
lng_data	module	varchar	30
lng_modules	module	varchar	30
module_class	module	varchar	100
settings	module	varchar	50			common
chat_record_data	msg_time	int	10			0
ldap_server_settings	name	varchar	32
mob_parameter	name	varchar	50	√		null
module	name	varchar	100
qpl_answer_cloze	name	varchar	50
service	name	varchar	100
tst_test_defaults	name	varchar	255
webr_params	name	char	128
xml_attribute_namespace	namespace	char	64
xml_element_namespace	namespace	char	64
survey_category	neutral	enum	2			0
survey_question_matrix	neutral_column_separator	enum	2			1
il_news_read	news_id	int	10			0
xml_tree	next_sibling_node_id	int unsigned	10			0
xml_attribute_idx	node_id	int unsigned	10			0
xml_attribute_namespace	node_id	int unsigned	10			0
xml_cdata	node_id	int unsigned	10		√
xml_comment	node_id	int unsigned	10		√
xml_element_idx	node_id	int unsigned	10			0
xml_element_namespace	node_id	int unsigned	10			0
xml_entity_reference	node_id	int unsigned	10			0
xml_pi_data	node_id	int unsigned	10			0
xml_pi_target	node_id	int unsigned	10			0
xml_text	node_id	int unsigned	10			0
xml_tree	node_id	int unsigned	10		√
xml_node_type	node_type_id	int	10		√
xml_tree	node_type_id	tinyint unsigned	3			0
cp_node	nodeName	varchar	50	√		null
feedback_results	note	text	65535
note_data	note_id	int	10			0
exc_members	notice	text	65535	√		null
crs_members	notification	tinyint	3			0
frm_notification	notification_id	int	10		√
frm_posts	notify	bit	0			0
glossary_definition	nr	int	10			0
map_area	nr	int	10			0
media_item	nr	int	10			0
meta_techn_format	nr	int	10	√		null
meta_techn_loc	nr	int	10	√		null
sc_resource_dependency	nr	int	10	√		null
sc_resource_file	nr	int	10	√		null
tst_tests	nr_of_tries	tinyint unsigned	3			0
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
tst_test_random	num_of_q	int unsigned	10			0
content_object	numbering	enum	2	√		n
ass_log	obj_fi	int	10			0
qpl_questionpool	obj_fi	int	10			0
qpl_questions	obj_fi	int unsigned	10			0
survey_question	obj_fi	int unsigned	10			0
survey_questionpool	obj_fi	int	10			0
survey_survey	obj_fi	int	10			0
tst_tests	obj_fi	int	10			0
aicc_course	obj_id	int	10			0
aicc_object	obj_id	int	10		√
aicc_units	obj_id	int	10		√
bookmark_data	obj_id	int	10		√
cp_package	obj_id	int	10			0
cp_tree	obj_id	int	10	√		null
crs_defined_field_definitions	obj_id	int	10			0
crs_items	obj_id	int	10			0
crs_members	obj_id	int	10			0
crs_objective_lm	obj_id	int	10			0
crs_objective_qst	obj_id	int	10			0
crs_objective_tst	obj_id	int	10			0
crs_settings	obj_id	int	10			0
crs_subscribers	obj_id	int	10			0
crs_waiting_list	obj_id	int	10			0
event	obj_id	int	10			0
exc_data	obj_id	int	10			0
exc_members	obj_id	int	10			0
exc_returned	obj_id	int	10			0
exc_usr_tutor	obj_id	int	10			0
feedback_items	obj_id	int	10	√		0
frm_settings	obj_id	int	10			0
frm_thread_access	obj_id	int	10			0
frm_user_read	obj_id	int	10			0
history	obj_id	int	10			0
il_meta_annotation	obj_id	int	10	√		null
il_meta_classification	obj_id	int	10	√		null
il_meta_contribute	obj_id	int	10	√		null
il_meta_description	obj_id	int	10	√		null
il_meta_educational	obj_id	int	10	√		null
il_meta_entity	obj_id	int	10	√		null
il_meta_format	obj_id	int	10	√		null
il_meta_general	obj_id	int	10	√		null
il_meta_identifier	obj_id	int	10	√		null
il_meta_identifier_	obj_id	int	10	√		null
il_meta_keyword	obj_id	int	10	√		null
il_meta_language	obj_id	int	10	√		null
il_meta_lifecycle	obj_id	int	10	√		null
il_meta_location	obj_id	int	10	√		null
il_meta_meta_data	obj_id	int	10	√		null
il_meta_relation	obj_id	int	10	√		null
il_meta_requirement	obj_id	int	10	√		null
il_meta_rights	obj_id	int	10	√		null
il_meta_taxon	obj_id	int	10	√		null
il_meta_taxon_path	obj_id	int	10	√		null
il_meta_technical	obj_id	int	10	√		null
il_meta_typical_age_range	obj_id	int	10	√		null
ilinc_data	obj_id	int unsigned	10			0
ilinc_registration	obj_id	int unsigned	10			0
link_check	obj_id	int	10			0
link_check_report	obj_id	int	10			0
lm_data	obj_id	int	10		√
lo_access	obj_id	int	10			0
mail_obj_data	obj_id	int	10		√
member_agreement	obj_id	int	10			0
meta_data	obj_id	int	10			0
meta_keyword	obj_id	int	10			0
meta_technical	obj_id	int	10			0
note	obj_id	int	10			0
object_data	obj_id	int	10		√
object_description	obj_id	int	10			0
object_reference	obj_id	int	10			0
object_translation	obj_id	int	10			0
sc_item	obj_id	int	10			0
sc_manifest	obj_id	int	10			0
sc_organization	obj_id	int	10			0
sc_organizations	obj_id	int	10			0
sc_resource	obj_id	int	10			0
sc_resources	obj_id	int	10			0
scorm_object	obj_id	int	10		√
scorm_tracking	obj_id	int	10			0
search_data	obj_id	int	10		√
ut_learning_progress	obj_id	int	10			0
ut_lp_collections	obj_id	int	10			0
ut_lp_event_collections	obj_id	int	10			0
ut_lp_marks	obj_id	int	10			0
ut_lp_settings	obj_id	int	10			0
adv_md_record_objs	obj_type	char	6
adv_md_substitutions	obj_type	varchar	4
history	obj_type	varchar	8
il_meta_annotation	obj_type	varchar	6	√		null
il_meta_classification	obj_type	varchar	6	√		null
il_meta_contribute	obj_type	varchar	6	√		null
il_meta_description	obj_type	varchar	6	√		null
il_meta_educational	obj_type	varchar	6	√		null
il_meta_entity	obj_type	varchar	6	√		null
il_meta_format	obj_type	varchar	6	√		null
il_meta_general	obj_type	varchar	6	√		null
il_meta_identifier	obj_type	varchar	6	√		null
il_meta_identifier_	obj_type	varchar	6	√		null
il_meta_keyword	obj_type	varchar	6	√		null
il_meta_language	obj_type	char	6	√		null
il_meta_lifecycle	obj_type	varchar	6	√		null
il_meta_location	obj_type	varchar	6	√		null
il_meta_meta_data	obj_type	char	6	√		null
il_meta_relation	obj_type	char	6	√		null
il_meta_requirement	obj_type	varchar	6	√		null
il_meta_rights	obj_type	varchar	6	√		null
il_meta_taxon	obj_type	varchar	6	√		null
il_meta_taxon_path	obj_type	varchar	6	√		null
il_meta_technical	obj_type	varchar	6	√		null
il_meta_typical_age_range	obj_type	varchar	6	√		null
meta_data	obj_type	char	3
meta_keyword	obj_type	char	3
meta_technical	obj_type	char	3
note	obj_type	varchar	10	√		null
ut_learning_progress	obj_type	char	4
ut_lp_settings	obj_type	char	4
crs_objective_lm	objective_id	int	10			0
crs_objective_qst	objective_id	int	10			0
crs_objective_status	objective_id	int	10			0
crs_objective_status_pretest	objective_id	int	10			0
crs_objective_tst	objective_id	int	10			0
crs_objectives	objective_id	int	10		√
cp_objective	objectiveID	varchar	200	√		null
cp_sequencing	objectiveMeasureWeight	double	22	√		null
cp_sequencing	objectiveSetByContent	tinyint	3	√		null
cp_organization	objectivesGlobalToSystem	tinyint	3	√		null
survey_question	obligatory	enum	2			1
survey_question_obligatory	obligatory	enum	2			1
tst_mark	official_name	varchar	50
content_object	online	enum	2	√		n
file_based_lm	online	enum	2	√		n
glossary	online	enum	2	√		n
il_media_cast_data	online	tinyint	3	√		0
qpl_questionpool	online	enum	2			0
sahs_lm	online	enum	2	√		n
survey_questionpool	online	enum	2			0
ut_online	online_time	int	10			0
rbac_operations	op_order	smallint unsigned	5	√		null
il_meta_requirement	operating_system_maximum_version	text	65535	√		null
il_meta_requirement	operating_system_minimum_version	text	65535	√		null
il_meta_requirement	operating_system_name	varchar	16	√		null
rbac_operations	operation	char	32
conditions	operator	varchar	64	√		null
cp_condition	operator	varchar	50	√		null
rbac_operations	ops_id	int	10		√
rbac_pa	ops_id	text	65535
rbac_ta	ops_id	smallint	5			0
rbac_templates	ops_id	int	10			0
copy_wizard_options	options	text	65535
il_meta_requirement	or_composite_id	int	10			0
payment_statistic	order_date	int	10	√		null
qpl_question_ordering	ordering_type	enum	2	√		null
survey_question_nominal	orientation	enum	2			0
survey_question_ordinal	orientation	enum	2			0
ass_log	original_fi	int	10	√		null
qpl_questions	original_id	int	10	√		null
survey_question	original_id	int	10	√		null
il_meta_technical	other_platform_requirements	text	65535	√		null
il_meta_technical	other_platform_requirements_language	char	2	√		null
meta_technical	other_requirements	text	65535
meta_technical	other_requirements_lang	char	2
survey_survey	outro	text	65535	√		null
chat_rooms	owner	int	10			0
object_data	owner	int	10			0
qpl_questions	owner	int	10			0
survey_category	owner_fi	int	10			0
survey_phrase	owner_fi	int	10			0
survey_question	owner_fi	int	10			0
survey_questionblock	owner_fi	int	10			0
usr_search	page	tinyint	3			0
content_object	page_header	enum	9	√		st_title
link_check	page_id	int	10			0
page_object	page_id	int	10			0
media_item	param	text	65535	√		null
webr_params	param_id	int	10		√
xmlparam	param_name	char	50
xmlparam	param_value	char	255
style_parameter	parameter	varchar	100	√		null
cp_item	parameters	varchar	255	√		null
desktop_item	parameters	varchar	200	√		null
sc_item	parameters	text	65535	√		null
qpl_question_flashapp	params	text	65535	√		null
qpl_question_javaapplet	params	text	65535	√		null
bookmark_tree	parent	int unsigned	10	√		null
cp_tree	parent	int	10	√		null
ctrl_calls	parent	varchar	100
ctrl_structure	parent	mediumtext	16777215	√		null
lm_tree	parent	int unsigned	10	√		null
mail_tree	parent	int unsigned	10	√		null
mep_tree	parent	int	10			0
rbac_fa	parent	int	10			0
rbac_templates	parent	int	10			0
scorm_tree	parent	int unsigned	10	√		null
search_tree	parent	int unsigned	10	√		null
tree	parent	int unsigned	10	√		null
crs_items	parent_id	int	10			0
il_meta_contribute	parent_id	int	10	√		null
il_meta_description	parent_id	int	10	√		null
il_meta_entity	parent_id	int	10	√		null
il_meta_identifier	parent_id	int	10	√		null
il_meta_identifier_	parent_id	int	10	√		null
il_meta_keyword	parent_id	int	10	√		null
il_meta_language	parent_id	int	10	√		null
il_meta_location	parent_id	int	10	√		null
il_meta_requirement	parent_id	int	10	√		null
il_meta_taxon	parent_id	int	10	√		null
il_meta_taxon_path	parent_id	int	10	√		null
il_meta_typical_age_range	parent_id	int	10	√		null
page_object	parent_id	int	10	√		null
xml_tree	parent_node_id	int unsigned	10			0
frm_posts_tree	parent_pos	bigint	19			0
il_meta_contribute	parent_type	varchar	32	√		null
il_meta_description	parent_type	varchar	16	√		null
il_meta_entity	parent_type	varchar	16	√		null
il_meta_identifier	parent_type	varchar	16	√		null
il_meta_identifier_	parent_type	varchar	16	√		null
il_meta_keyword	parent_type	varchar	32	√		null
il_meta_language	parent_type	char	16	√		null
il_meta_location	parent_type	varchar	16	√		null
il_meta_requirement	parent_type	varchar	16	√		null
il_meta_taxon	parent_type	varchar	32	√		null
il_meta_taxon_path	parent_type	varchar	32	√		null
il_meta_typical_age_range	parent_type	varchar	16	√		null
link_check	parent_type	varchar	8
page_object	parent_type	varchar	4			lm
event_participants	participated	bit	0			0
event	participation	bit	0			0
tst_manual_feedback	pass	int	10			0
tst_solutions	pass	int	10			0
tst_test_random_question	pass	int	10			0
tst_test_result	pass	int	10			0
tst_tests	pass_scoring	enum	2			0
crs_members	passed	bit	0	√		null
tst_mark	passed	enum	2			0
usr_data	passwd	varchar	32
grp_data	password	varchar	255	√		null
tst_tests	password	varchar	20	√		null
mail_attachment	path	text	65535
cmi_correct_response	pattern	varchar	255	√		null
payment_objects	pay_method	int	10			0
payment_statistic	payed	int	10			0
payment_settings	paypal	text	65535
payment_settings	pdf_path	varchar	255
ldap_attribute_mapping	perform_update	bit	0			0
payment_trustees	perm_obj	int	10			0
payment_trustees	perm_stat	int	10	√		null
cp_package	persistPreviousAttempts	int	10	√		null
payment_bill_vendor	phone	char	32	√		null
usr_data	phone_home	varchar	40
usr_data	phone_mobile	varchar	40
usr_data	phone_office	varchar	40
ut_access	php_script	char	100
survey_phrase_category	phrase_category_id	int	10		√
survey_phrase_category	phrase_fi	int	10			0
survey_phrase	phrase_id	int	10		√
crs_timings_planed	planed_end	int	10			0
crs_timings_planed	planed_start	int	10			0
il_news_item	playtime	varchar	8	√		null
payment_bill_vendor	pobject_id	int	10			0
payment_objects	pobject_id	int	10		√
payment_prices	pobject_id	int	10			0
payment_shopping_cart	pobject_id	int	10			0
payment_statistic	pobject_id	int	10			0
crs_objective_results	points	int	10			0
qpl_answer_cloze	points	double	22			0
qpl_answer_imagemap	points	double	22			0
qpl_answer_matching	points	double	22			0
qpl_answer_multiplechoice	points	double	22			0
qpl_answer_ordering	points	double	22			0
qpl_answer_singlechoice	points	double	22			0
qpl_answer_textsubset	points	double	22			0
qpl_numeric_range	points	double	22			0
qpl_questions	points	double	22	√		null
tst_solutions	points	double	22	√		null
tst_test_result	points	double	22			0
qpl_answer_multiplechoice	points_unchecked	double	22			0
frm_posts	pos_cens	tinyint	3			0
frm_posts	pos_cens_com	text	65535
frm_posts	pos_date	datetime	19			0000-00-00 00:00:00
frm_posts_tree	pos_fk	bigint	19			0
frm_posts	pos_message	text	65535
frm_posts	pos_pk	bigint	19		√
frm_posts	pos_subject	text	65535
frm_posts	pos_thr_fk	bigint	19			0
frm_posts	pos_top_fk	bigint	19			0
frm_posts	pos_update	datetime	19			0000-00-00 00:00:00
frm_posts	pos_usr_alias	varchar	255
frm_posts	pos_usr_id	bigint	19			0
adv_md_field_definition	position	int	10			0
crs_items	position	int	10	√		null
crs_objectives	position	int	10			0
frm_user_read	post_id	int	10			0
tst_active	postponed	text	65535	√		null
sc_item	prereq_type	varchar	200	√		null
sc_item	prerequisites	text	65535	√		null
xml_tree	prev_sibling_node_id	int unsigned	10			0
cp_sequencing	preventActivation	tinyint	3	√		null
payment_statistic	price	char	16
payment_prices	price_id	int	10		√
payment_shopping_cart	price_id	int	10			0
cp_objective	primary	tinyint	3	√		null
content_object	print_view_active	enum	2	√		y
il_news_item	priority	int	10	√		1
tst_tests	processing_time	time	8	√		null
usr_data	profile_incomplete	int	10	√		0
cmi_node	progress_measure	double	22	√		null
cmi_objective	progress_measure	double	22	√		null
rbac_fa	protected	enum	2	√		n
payment_shopping_cart	psc_id	int	10		√
content_object	pub_notes	enum	2			n
lm_data	public_access	enum	2			n
content_object	public_access_mode	enum	9			complete
il_media_cast_data	public_files	tinyint	3	√		0
content_object	public_html_file	varchar	50
glossary	public_html_file	varchar	50
content_object	public_xml_file	varchar	50
glossary	public_xml_file	varchar	50
cp_auxilaryResource	purpose	varchar	255	√		null
il_meta_classification	purpose	varchar	32	√		null
media_item	purpose	enum	10	√		null
usr_pwassist	pwassist_id	varchar	32
tst_eval_settings	pworkedthrough	enum	2			1
crs_objective_qst	qst_ass_id	int	10		√
ut_lp_filter	query_string	varchar	128
note_data	question	enum	2			n
survey_question_constraint	question_constraint_id	int	10		√
ass_log	question_fi	int	10	√		null
qpl_answer_cloze	question_fi	int unsigned	10			0
qpl_answer_imagemap	question_fi	int unsigned	10			0
qpl_answer_matching	question_fi	int unsigned	10			0
qpl_answer_multiplechoice	question_fi	int unsigned	10			0
qpl_answer_ordering	question_fi	int unsigned	10			0
qpl_answer_singlechoice	question_fi	int unsigned	10			0
qpl_answer_textsubset	question_fi	int unsigned	10			0
qpl_feedback_generic	question_fi	int	10			0
qpl_feedback_imagemap	question_fi	int	10			0
qpl_feedback_multiplechoice	question_fi	int	10			0
qpl_feedback_singlechoice	question_fi	int	10			0
qpl_numeric_range	question_fi	int	10			0
qpl_question_cloze	question_fi	int	10			0
qpl_question_essay	question_fi	int	10			0
qpl_question_flashapp	question_fi	int	10			0
qpl_question_imagemap	question_fi	int	10			0
qpl_question_javaapplet	question_fi	int	10			0
qpl_question_matching	question_fi	int	10			0
qpl_question_multiplechoice	question_fi	int	10			0
qpl_question_numeric	question_fi	int	10			0
qpl_question_ordering	question_fi	int	10			0
qpl_question_singlechoice	question_fi	int	10			0
qpl_question_textsubset	question_fi	int	10			0
qpl_suggested_solutions	question_fi	int	10			0
survey_answer	question_fi	int	10			0
survey_constraint	question_fi	int	10			0
survey_material	question_fi	int	10			0
survey_question_constraint	question_fi	int	10			0
survey_question_material	question_fi	int	10			0
survey_question_matrix	question_fi	int	10			0
survey_question_matrix_rows	question_fi	int	10			0
survey_question_metric	question_fi	int	10			0
survey_question_nominal	question_fi	int	10			0
survey_question_obligatory	question_fi	int	10			0
survey_question_ordinal	question_fi	int	10			0
survey_question_text	question_fi	int	10			0
survey_questionblock_question	question_fi	int	10			0
survey_survey_question	question_fi	int	10			0
survey_variable	question_fi	int	10			0
tst_active_qst_sol_settings	question_fi	int unsigned	10			0
tst_manual_feedback	question_fi	int	10			0
tst_solutions	question_fi	int unsigned	10			0
tst_test_question	question_fi	int	10			0
tst_test_random_question	question_fi	int	10			0
tst_test_result	question_fi	int unsigned	10			0
crs_objective_qst	question_id	int	10			0
crs_objective_results	question_id	int	10			0
qpl_questions	question_id	int	10		√
survey_question	question_id	int	10		√
survey_question_obligatory	question_obligatory_id	int	10		√
qpl_questions	question_text	text	65535
qpl_questions	question_type_fi	int unsigned	10			0
qpl_question_type	question_type_id	int unsigned	10		√
survey_questionblock_question	questionblock_fi	int	10			0
survey_questionblock	questionblock_id	int	10		√
survey_questionblock_question	questionblock_question_id	int	10		√
qpl_questionpool	questioncount	int	10			0
tst_test_random	questionpool_fi	int	10			0
survey_question	questiontext	text	65535
survey_question	questiontype_fi	int	10			0
survey_questiontype	questiontype_id	int	10		√
tst_eval_settings	qworkedthrough	enum	2			1
tst_tests	random_question_count	int	10	√		null
survey_question_matrix	random_rows	enum	2			0
tst_tests	random_test	enum	2			0
cp_sequencing	randomizationTiming	varchar	50	√		null
qpl_numeric_range	range_id	int	10		√
cmi_node	raw	double	22	√		null
cmi_objective	raw	double	22	√		null
il_meta_annotation	rbac_id	int	10	√		null
il_meta_classification	rbac_id	int	10	√		null
il_meta_contribute	rbac_id	int	10	√		null
il_meta_description	rbac_id	int	10	√		null
il_meta_educational	rbac_id	int	10	√		null
il_meta_entity	rbac_id	int	10	√		null
il_meta_format	rbac_id	int	10	√		null
il_meta_general	rbac_id	int	10	√		null
il_meta_identifier	rbac_id	int	10	√		null
il_meta_identifier_	rbac_id	int	10	√		null
il_meta_keyword	rbac_id	int	10	√		null
il_meta_language	rbac_id	int	10	√		null
il_meta_lifecycle	rbac_id	int	10	√		null
il_meta_location	rbac_id	int	10	√		null
il_meta_meta_data	rbac_id	int	10	√		null
il_meta_relation	rbac_id	int	10	√		null
il_meta_requirement	rbac_id	int	10	√		null
il_meta_rights	rbac_id	int	10	√		null
il_meta_taxon	rbac_id	int	10	√		null
il_meta_taxon_path	rbac_id	int	10	√		null
il_meta_technical	rbac_id	int	10	√		null
il_meta_typical_age_range	rbac_id	int	10	√		null
mail	rcp_bcc	text	65535	√		null
mail_saved	rcp_bcc	varchar	255	√		null
mail	rcp_cc	text	65535	√		null
mail_saved	rcp_cc	varchar	255	√		null
mail	rcp_to	text	65535	√		null
mail_saved	rcp_to	varchar	255	√		null
cp_mapinfo	readNormalizedMeasure	tinyint	3	√		null
cp_mapinfo	readSatisfiedStatus	tinyint	3	√		null
chat_record_data	record_data_id	int	10		√
adv_md_field_definition	record_id	int	10			0
adv_md_record	record_id	tinyint	3		√
adv_md_record_objs	record_id	tinyint	3			0
chat_record_data	record_id	int	10			0
chat_records	record_id	int	10		√
ass_log	ref_id	int	10	√		null
crs_objective_lm	ref_id	int	10			0
crs_objective_qst	ref_id	int	10			0
crs_objective_tst	ref_id	int	10			0
feedback_items	ref_id	int	10	√		0
il_news_subscription	ref_id	int	10			0
object_reference	ref_id	int	10		√
payment_objects	ref_id	int	10			0
rbac_pa	ref_id	int	10			0
cp_condition	referencedObjective	varchar	50	√		null
usr_data	referral_comment	varchar	250	√
ldap_server_settings	referrals	int	10			0
grp_data	register	int	10	√		1
event_participants	registered	bit	0			0
event	registration	bit	0			0
survey_constraint	relation_fi	int	10			0
survey_relation	relation_id	int	10		√
crs_timings_usr_accept	remark	text	65535
cp_sequencing	reorderChildren	tinyint	3	√		null
note	rep_obj_id	int	10			0
survey_question_matrix	repeat_column_header	enum	2			0
feedback_items	repeat_interval	int	10	√		null
tst_tests	reporting_date	varchar	14	√		null
adv_md_field_definition	required	bit	0			0
feedback_items	required	bit	0	√		0
user_defined_field_definition	required	bit	0			0
cp_sequencing	requiredForCompleted	varchar	50	√		null
cp_sequencing	requiredForIncomplete	varchar	50	√		null
cp_sequencing	requiredForNotSatisfied	varchar	50	√		null
cp_sequencing	requiredForSatisfied	varchar	50	√		null
crs_objective_results	res_id	int	10		√
sc_resource_dependency	res_id	int	10	√		null
sc_resource_file	res_id	int	10	√		null
cp_dependency	resourceId	varchar	50	√		null
cp_item	resourceId	varchar	200	√		null
sc_resource	resourcetype	varchar	30	√		null
acc_cache	result	mediumtext	16777215	√		null
cmi_interaction	result	text	65535	√		null
tst_tests	results_presentation	int	10			3
tst_eval_settings	resultsmarks	enum	2			1
tst_eval_settings	resultspoints	enum	2			1
exc_members	returned	bit	0			0
exc_returned	returned_id	int	10		√
bookmark_tree	rgt	int unsigned	10			0
cp_tree	rgt	int	10	√		null
frm_posts_tree	rgt	int	10			0
lm_tree	rgt	int unsigned	10			0
mail_tree	rgt	int unsigned	10			0
mep_tree	rgt	int	10			0
scorm_tree	rgt	int unsigned	10			0
search_tree	rgt	int unsigned	10			0
tree	rgt	int unsigned	10			0
xml_tree	rgt	smallint unsigned	5			0
xml_node_type	rgt_delimiter	varchar	10	√		null
rbac_fa	rol_id	int	10			0
rbac_pa	rol_id	int	10			0
rbac_templates	rol_id	int	10			0
rbac_ua	rol_id	int	10			0
il_meta_contribute	role	varchar	32	√		null
ldap_role_group_mapping	role	int	10			0
reg_email_role_assignments	role	int	10			0
ldap_server_settings	role_bind_dn	varchar	255
ldap_server_settings	role_bind_pass	varchar	32
reg_access_limitation	role_id	int unsigned	10			0
role_data	role_id	int	10			0
role_desktop_items	role_id	int	10			0
role_desktop_items	role_item_id	int	10		√
ldap_server_settings	role_sync_active	bit	0			0
cp_sequencing	rollupObjectiveSatisfied	tinyint	3	√		null
cp_sequencing	rollupProgressCompletion	tinyint	3	√		null
chat_invitations	room_id	int	10			0
chat_records	room_id	int	10			0
chat_room_messages	room_id	int	10			0
chat_rooms	room_id	int	10		√
chat_user	room_id	int	10			0
ctrl_structure	root_class	varchar	40
ut_lp_filter	root_node	int	10			0
dp_dates	rotation	int	10			0
survey_answer	row	int	10			0
survey_question_matrix	row_images	enum	2			0
survey_question_matrix	row_separators	enum	2			0
scorm_tracking	rvalue	text	65535	√		null
usr_new_account_mail	sal_f	varchar	200
usr_new_account_mail	sal_g	varchar	200
usr_new_account_mail	sal_m	varchar	200
cp_objective	satisfiedByMeasure	tinyint	3	√		null
xhtml_page	save_content	mediumtext	16777215	√		null
cmi_node	scaled	double	22	√		null
cmi_objective	scaled	double	22	√		null
cmi_node	scaled_passing_score	double	22	√		null
scorm_tracking	sco_id	int	10			0
cmi_objective	scope	varchar	16	√		null
tst_tests	score_cutting	enum	2			0
tst_tests	score_reporting	tinyint unsigned	3			0
cp_resource	scormType	varchar	32	√		null
sc_resource	scormtype	enum	5	√		null
ldap_server_settings	search_base	varchar	255
usr_search	search_result	text	65535	√		null
usr_search	search_type	tinyint	3			0
adv_md_field_definition	searchable	bit	0			0
user_defined_field_definition	searchable	bit	0			0
cp_sequencing	selectCount	int	10	√		null
cp_sequencing	selectionTiming	varchar	50	√		null
il_meta_educational	semantic_density	varchar	16	√		null
mail	send_time	datetime	19			0000-00-00 00:00:00
mail	sender_id	int	10	√		null
exc_members	sent	bit	0	√		null
exc_members	sent_time	timestamp	19			0000-00-00 00:00:00
survey_phrase_category	sequence	int	10			0
survey_question_matrix_rows	sequence	int	10			0
survey_survey_question	sequence	int	10			0
survey_variable	sequence	int	10			0
tst_active	sequence	text	65535
tst_test_question	sequence	int unsigned	10			0
tst_test_random_question	sequence	int unsigned	10			0
tst_tests	sequence_settings	tinyint unsigned	3			0
cp_item	sequencingId	varchar	50	√		null
cp_organization	sequencingId	varchar	50	√		null
cp_sequencing	sequencingId	varchar	50	√		null
ldap_attribute_mapping	server_id	int	10			0
ldap_role_group_mapping	server_id	int	10			0
ldap_server_settings	server_id	int	10		√
service_class	service	varchar	100
usr_session	session_id	varchar	32
ut_access	session_id	char	40	√		null
cmi_node	session_time	varchar	20	√		null
il_block_setting	setting	varchar	40
cp_package	settings	varchar	255	√		null
member_export_user_settings	settings	text	65535
payment_settings	settings_id	bigint	19		√
map_area	shape	varchar	20	√		null
tst_mark	short_name	varchar	15
glossary_definition	short_text	varchar	200
survey_relation	shortname	char	2
dp_dates	shorttext	varchar	50
tst_tests	show_cancel	enum	2			1
tst_tests	show_marker	tinyint	3			0
crs_settings	show_members	tinyint	3			1
feedback_items	show_on	varchar	6	√		null
survey_survey	show_question_titles	enum	2			1
tst_tests	show_question_titles	enum	2			1
survey_questionblock	show_questiontext	enum	2	√		1
tst_tests	show_summary	int	10			0
qpl_answer_cloze	shuffle	enum	2			1
qpl_question_matching	shuffle	enum	2			1
qpl_question_multiplechoice	shuffle	enum	2			1
qpl_question_singlechoice	shuffle	enum	2			1
tst_tests	shuffle_questions	enum	2			0
mail_options	signature	text	65535
survey_question_matrix	singleline_row_caption	enum	2			0
il_meta_technical	size	text	65535	√		null
meta_technical	size	varchar	50
settings_deactivated_styles	skin	varchar	100
aicc_object	slm_id	int	10			0
cp_node	slm_id	int	10	√		null
scorm_object	slm_id	int	10			0
scorm_tree	slm_id	int	10			0
tst_solutions	solution_id	int unsigned	10		√
qpl_answer_ordering	solution_order	int unsigned	10			0
exc_members	solved	bit	0	√		null
tst_active_qst_sol_settings	solved	tinyint unsigned	3			0
crs_settings	sortorder	int	10	√		null
il_meta_taxon_path	source	text	65535	√		null
copy_wizard_options	source_id	int	10			0
int_link	source_id	int	10			0
il_meta_taxon_path	source_language	char	2	√		null
int_link	source_type	varchar	10
cmi_comment	sourceIsLMS	tinyint	3	√		null
ut_learning_progress	spent_time	int	10			0
style_data	standard	tinyint	3	√		0
chat_records	start_time	int	10			0
survey_survey	startdate	date	10	√		null
tst_times	started	datetime	19			0000-00-00 00:00:00
file_based_lm	startfile	varchar	200	√		null
event_appointment	starting_time	int	10			0
tst_tests	starting_time	varchar	14	√		null
feedback_items	starttime	int	10	√		0
survey_finished	state	enum	2			0
frm_settings	statistics_enabled	bit	0			0
crs_objective_status	status	bit	0			0
dp_changed_dates	status	int	10			0
exc_members	status	enum	10			notgraded
payment_objects	status	int	10			0
survey_survey	status	enum	2			1
exc_members	status_time	timestamp	19			CURRENT_TIMESTAMP
payment_bill_vendor	street	char	64	√		null
usr_data	street	varchar	40	√		null
xml_tree	struct	tinyint unsigned	3			0
cp_organization	structure	varchar	200	√		null
sc_organization	structure	varchar	200	√		null
settings_deactivated_styles	style	varchar	100
style_folder_styles	style_id	int	10			0
style_parameter	style_id	int	10			0
content_object	stylesheet	int	10			0
crs_subscribers	sub_time	int	10			0
crs_waiting_list	sub_time	int	10			0
payment_prices	sub_unit_value	char	3	√		00
grp_registration	subject	varchar	255
note	subject	varchar	200
usr_new_account_mail	subject	varchar	200	√
tst_active	submitted	tinyint unsigned	3	√		0
tst_active	submittimestamp	datetime	19	√		null
qpl_suggested_solutions	subquestion_index	int	10			0
crs_settings	subscription_end	int	10	√		null
ilinc_data	subscription_end	int	10	√		null
crs_settings	subscription_limitation_type	bit	0			0
crs_settings	subscription_max_members	int	10	√		null
crs_settings	subscription_notify	int	10	√		null
crs_settings	subscription_password	varchar	32	√		null
ilinc_data	subscription_password	varchar	32	√		null
crs_settings	subscription_start	int	10	√		null
ilinc_data	subscription_start	int	10	√		null
crs_settings	subscription_type	int	10	√		null
ilinc_data	subscription_type	tinyint	3	√		null
ilinc_data	subscription_unlimited	tinyint	3	√		null
adv_md_substitutions	substitution	text	65535
survey_question_matrix	subtype	int	10			0
survey_question_metric	subtype	enum	2			3
survey_question_nominal	subtype	enum	2			1
payment_currencies	subunit	char	32
cmi_node	success_status	varchar	255	√		null
cmi_objective	success_status	varchar	32	√		null
qpl_suggested_solutions	suggested_solution_id	int	10		√
crs_items	suggestion_end	int	10			0
crs_items	suggestion_start	int	10			0
survey_anonymous	survey_fi	int	10			0
survey_answer	survey_fi	int	10			0
survey_finished	survey_fi	int	10			0
survey_invited_group	survey_fi	int	10			0
survey_invited_user	survey_fi	int	10			0
survey_question_constraint	survey_fi	int	10			0
survey_question_obligatory	survey_fi	int	10			0
survey_questionblock_question	survey_fi	int	10			0
survey_survey_question	survey_fi	int	10			0
survey_survey	survey_id	int	10		√
survey_anonymous	survey_key	varchar	32
survey_survey_question	survey_question_id	int	10		√
cmi_node	suspend_data	text	65535	√		null
crs_settings	syllabus	text	65535	√		null
ldap_server_settings	sync_on_login	bit	0			0
ldap_server_settings	sync_per_cron	bit	0			0
aicc_object	system_id	varchar	50
aicc_units	system_vendor	text	65535	√		null
style_parameter	tag	varchar	100	√		null
xmltags	tag_depth	int	10			0
xmlparam	tag_fk	int	10			0
xmlvalue	tag_fk	int	10			0
xmltags	tag_name	char	50
xmltags	tag_pk	int	10		√
xmlvalue	tag_value	text	65535
xmlvalue	tag_value_pk	int	10		√
bookmark_data	target	varchar	200
lm_menu	target	varchar	200	√		null
map_area	target	varchar	50	√		null
search_data	target	text	65535
webr_items	target	text	65535	√		null
map_area	target_frame	varchar	50	√		null
int_link	target_id	int	10			0
int_link	target_inst	int	10			0
conditions	target_obj_id	int	10			0
conditions	target_ref_id	int	10			0
conditions	target_type	varchar	8
int_link	target_type	varchar	4
cp_mapinfo	targetObjectiveID	varchar	50	√		null
il_meta_taxon	taxon	text	65535	√		null
il_meta_taxon	taxon_id	text	65535	√		null
il_meta_taxon	taxon_language	char	2	√		null
meta_techn_format	tech_id	int	10			0
meta_techn_loc	tech_id	int	10			0
meta_technical	tech_id	int	10		√
glossary_term	term	varchar	200	√		null
glossary_definition	term_id	int	10			0
tst_test_defaults	test_defaults_id	int	10		√
tst_active	test_fi	int unsigned	10			0
tst_invited_user	test_fi	int	10			0
tst_mark	test_fi	int unsigned	10			0
tst_test_question	test_fi	int	10			0
tst_test_random	test_fi	int	10			0
tst_tests	test_id	int unsigned	10		√
crs_objective_tst	test_objective_id	int	10		√
ass_log	test_only	enum	2			0
tst_test_question	test_question_id	int	10		√
tst_test_random	test_random_id	int	10		√
tst_test_random_question	test_random_question_id	int	10		√
tst_test_result	test_result_id	int unsigned	10		√
dp_dates	text	text	65535	√		null
note	text	mediumtext	16777215	√		null
note_data	text	text	65535	√		null
feedback_items	text_answer	bit	0	√		0
survey_answer	textanswer	text	65535	√		null
qpl_question_cloze	textgap_rating	enum	3	√		null
qpl_question_essay	textgap_rating	enum	3	√		null
qpl_question_textsubset	textgap_rating	enum	3	√		null
xml_text	textnode	text	65535
frm_threads	thr_date	datetime	19			0000-00-00 00:00:00
frm_posts_tree	thr_fk	bigint	19			0
frm_threads	thr_last_post	varchar	50
frm_threads	thr_num_posts	int	10			0
frm_threads	thr_pk	bigint	19		√
frm_threads	thr_subject	varchar	255
frm_threads	thr_top_fk	bigint	19			0
frm_threads	thr_update	datetime	19			0000-00-00 00:00:00
frm_threads	thr_usr_alias	varchar	255
frm_threads	thr_usr_id	bigint	19			0
frm_notification	thread_id	int	10			0
frm_thread_access	thread_id	int	10			0
frm_user_read	thread_id	int	10			0
acc_cache	time	int	10			0
aicc_units	time_limit_action	varchar	50	√		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
exc_data	time_stamp	int	10	√		null
cp_item	timeLimitAction	varchar	30	√		null
sc_item	timelimitaction	varchar	30	√		null
tst_eval_settings	timeofwork	enum	2			1
tst_times	times_id	int	10		√
ass_log	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
cmi_comment	timestamp	varchar	20	√		null
cmi_interaction	timestamp	varchar	20	√		null
dp_changed_dates	timestamp	int	10			0
dp_neg_dates	timestamp	int	10	√		null
exc_returned	timestamp	timestamp	19			CURRENT_TIMESTAMP
lo_access	timestamp	datetime	19			0000-00-00 00:00:00
qpl_questionpool	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
qpl_questions	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
qpl_suggested_solutions	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_anonymous	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_answer	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_category	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_finished	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_invited_group	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_invited_user	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_material	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_phrase	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_question	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_question_obligatory	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_questionblock	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_questionpool	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_questiontype	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_relation	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_survey	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_survey_question	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
survey_variable	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_active	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_eval_settings	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_invited_user	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_mark	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_solutions	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_test_question	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_test_random	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_test_random_question	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_test_result	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_tests	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
tst_times	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
xml_object	TIMESTAMP	timestamp	19			CURRENT_TIMESTAMP
crs_items	timing_end	int	10	√		null
crs_items	timing_start	int	10	√		null
crs_items	timing_type	tinyint	3	√		null
adv_md_field_definition	title	text	65535
adv_md_record	title	varchar	128
aicc_object	title	text	65535
bookmark_data	title	varchar	200
chat_records	title	varchar	255
chat_rooms	title	varchar	64	√		null
cp_item	title	varchar	255	√		null
cp_manifest	title	varchar	255	√		null
cp_organization	title	varchar	255	√		null
crs_objectives	title	varchar	70
event	title	varchar	70
feedback_items	title	varchar	255	√		null
il_custom_block	title	varchar	200	√		null
il_meta_general	title	text	65535	√		null
il_news_item	title	varchar	200	√		null
lm_data	title	varchar	200
lm_menu	title	varchar	200	√		null
mail_obj_data	title	char	70
map_area	title	varchar	200	√		null
meta_data	title	varchar	200
object_data	title	char	128
object_translation	title	varchar	70
payment_bill_vendor	title	char	64	√		null
personal_clipboard	title	char	70
qpl_questions	title	varchar	100
scorm_object	title	varchar	200	√		null
search_data	title	varchar	200
survey_category	title	varchar	100
survey_phrase	title	varchar	100
survey_question	title	varchar	100
survey_question_matrix_rows	title	varchar	255
survey_questionblock	title	text	65535	√		null
usr_data	title	varchar	32
webr_items	title	varchar	127	√		null
il_meta_general	title_language	char	2	√		null
tst_tests	title_output	enum	2			0
ldap_server_settings	tls	int	10			0
content_object	toc_active	enum	2	√		y
content_object	toc_mode	enum	9	√		chapters
frm_data	top_date	datetime	19			0000-00-00 00:00:00
frm_data	top_description	varchar	255
frm_data	top_frm_fk	bigint	19			0
frm_data	top_last_post	varchar	50
frm_data	top_mods	int	10			0
frm_data	top_name	varchar	255
frm_data	top_num_posts	int	10			0
frm_data	top_num_threads	int	10			0
frm_data	top_pk	bigint	19		√
frm_data	top_update	datetime	19			0000-00-00 00:00:00
frm_data	top_usr_id	bigint	19			0
aicc_course	total_aus	smallint	5	√		null
aicc_course	total_blocks	smallint	5	√		null
aicc_course	total_complex_obj	smallint	5	√		null
aicc_course	total_objectives	smallint	5	√		null
cmi_node	total_time	varchar	20	√		null
dbk_translations	tr_id	int	10			0
cp_sequencing	tracked	tinyint	3	√		null
payment_statistic	transaction	char	64	√		null
payment_statistic	transaction_extern	char	64	√		null
bookmark_tree	tree	int	10			0
mail_tree	tree	int	10			0
search_tree	tree	int	10			0
tree	tree	int	10			0
media_item	tried_thumb	enum	2	√		n
tst_active	tries	int	10			0
conditions	trigger_obj_id	int	10			0
conditions	trigger_ref_id	int	10			0
conditions	trigger_type	varchar	8
payment_trustees	trustee_id	int	10			0
crs_objective_tst	tst_limit	tinyint	3	√		null
crs_objective_tst	tst_status	tinyint	3	√		null
event	tutor_email	varchar	127
exc_usr_tutor	tutor_id	int	10			0
event	tutor_name	text	65535
event	tutor_phone	varchar	127
rbac_ta	typ_id	int	10			0
aicc_object	type	char	3
aicc_units	type	varchar	50	√		null
bookmark_data	type	varchar	4
cmi_interaction	type	varchar	32	√		null
cp_resource	type	varchar	30	√		null
cp_rule	type	varchar	50	√		null
crs_objective_lm	type	char	6
desktop_item	type	varchar	4
il_block_setting	type	varchar	20
il_custom_block	type	varchar	20	√		null
ilinc_data	type	varchar	5
lm_data	type	char	2
mail_obj_data	type	char	16
map_area	type	varchar	20	√		null
meta_techn_loc	type	enum	10			LocalFile
note	type	int	10			0
object_data	type	char	4			none
personal_clipboard	type	char	4
rbac_templates	type	char	5
sahs_lm	type	enum	9	√		null
scorm_object	type	char	3	√		null
search_data	type	varchar	4
qpl_question_type	type_tag	char	35
survey_questiontype	type_tag	varchar	30
il_meta_typical_age_range	typical_age_range	text	65535	√		null
il_meta_typical_age_range	typical_age_range_language	char	2	√		null
il_meta_typical_age_range	typical_age_range_max	tinyint	3			-1
il_meta_typical_age_range	typical_age_range_min	tinyint	3			-1
il_meta_educational	typical_learning_time	text	65535	√		null
crs_groupings	unique_field	char	32
payment_currencies	unit	char	32
payment_prices	unit_value	char	6	√		0
il_news_item	update_date	datetime	19	√		null
note	update_date	datetime	19			0000-00-00 00:00:00
frm_data	update_user	int	10			0
frm_posts	update_user	int	10			0
qpl_answer_cloze	upperlimit	varchar	20			0
qpl_numeric_range	upperlimit	varchar	20			0
style_data	uptodate	tinyint	3	√		0
cp_manifest	uri	varchar	255	√		null
ldap_role_group_mapping	url	varchar	255
ldap_server_settings	url	varchar	255
link_check	url	varchar	255
file_usage	usage_id	int	10			0
mob_usage	usage_id	int	10			0
file_usage	usage_type	varchar	10
mob_usage	usage_type	varchar	10
tst_tests	use_previous_answers	enum	2			1
cp_sequencing	useCurrentAttemptObjectiveInfo	tinyint	3	√		null
cp_sequencing	useCurrentAttemptProgressInfo	tinyint	3	√		null
il_block_setting	user	int	10			0
ldap_server_settings	user_attribute	varchar	255
history	user_comment	text	65535
ass_log	user_fi	int	10			0
survey_answer	user_fi	int	10			0
survey_finished	user_fi	int	10			0
survey_invited_user	user_fi	int	10			0
tst_active	user_fi	int unsigned	10			0
tst_eval_settings	user_fi	int	10			0
tst_invited_user	user_fi	int	10			0
tst_test_defaults	user_fi	int	10			0
acc_cache	user_id	int	10			0
addressbook	user_id	int	10			0
bookmark_data	user_id	int	10			0
cmi_node	user_id	int	10	√		null
crs_objective_status	user_id	int	10			0
crs_objective_status_pretest	user_id	int	10			0
desktop_item	user_id	int	10			0
dp_changed_dates	user_ID	int	10			0
dp_dates	user_ID	int	10			0
dp_keyword	user_ID	int	10			0
dp_neg_dates	user_ID	int	10			0
dp_properties	user_ID	int	10			0
exc_returned	user_id	int	10			0
feedback_results	user_id	int	10	√		null
frm_notification	user_id	int	10			0
grp_registration	user_id	int	10			0
il_news_item	user_id	int	10	√		null
il_news_read	user_id	int	10			0
il_news_subscription	user_id	int	10			0
mail	user_id	int	10			0
mail_obj_data	user_id	int	10			0
mail_options	user_id	int	10			0
mail_saved	user_id	int	10			0
member_export_user_settings	user_id	int	10			0
personal_clipboard	user_id	int	10			0
scorm_tracking	user_id	int	10			0
search_data	user_id	int	10			0
usr_pwassist	user_id	int unsigned	10			0
usr_session	user_id	int unsigned	10			0
ut_access	user_id	int unsigned	10			0
ut_learning_progress	user_id	int	10			0
survey_anonymous	user_key	varchar	40	√		null
ldap_server_settings	user_scope	bit	0			0
chat_blocked	usr_id	int	10			0
chat_user	usr_id	int	10			0
crs_lm_history	usr_id	int	10			0
crs_members	usr_id	int	10			0
crs_objective_results	usr_id	int	10			0
crs_subscribers	usr_id	int	10			0
crs_timings_planed	usr_id	int	10			0
crs_timings_usr_accept	usr_id	int	10			0
crs_user_data	usr_id	int	10			0
crs_waiting_list	usr_id	int	10			0
event_participants	usr_id	int	10			0
exc_members	usr_id	int	10			0
exc_usr_tutor	usr_id	int	10			0
frm_thread_access	usr_id	int	10			0
frm_user_read	usr_id	int	10			0
history	usr_id	int	10			0
ilinc_registration	usr_id	int unsigned	10			0
link_check_report	usr_id	int	10			0
lo_access	usr_id	int	10			0
member_agreement	usr_id	int	10			0
rbac_ua	usr_id	int	10			0
usr_data	usr_id	int unsigned	10			0
usr_defined_data	usr_id	int	10			0
usr_pref	usr_id	int unsigned	10			0
usr_search	usr_id	int	10			0
ut_lp_filter	usr_id	int	10			0
ut_lp_marks	usr_id	int	10			0
ut_online	usr_id	int	10			0
ilinc_registration	usr_text	varchar	255	√		null
webr_items	valid	bit	0			0
conditions	value	varchar	64	√		null
container_settings	value	char	50	√		null
cp_hideLMSUI	value	varchar	50	√		null
crs_user_data	value	text	65535
il_block_setting	value	varchar	200
ldap_attribute_mapping	value	varchar	255
lng_data	value	blob	65535
mob_parameter	value	text	65535	√		null
settings	value	text	65535
style_parameter	value	varchar	100	√		null
survey_answer	value	double	22	√		null
survey_constraint	value	double	22			0
usr_pref	value	char	40	√		null
webr_params	value	tinyint	3			0
xml_attribute_value	value	char	32			0
survey_variable	value1	double	22	√		null
tst_solutions	value1	text	65535	√		null
survey_variable	value2	double	22	√		null
tst_solutions	value2	text	65535	√		null
xml_attribute_idx	value_id	smallint unsigned	5			0
xml_attribute_value	value_id	smallint unsigned	5		√
survey_variable	variable_id	int	10		√
payment_settings	vat_rate	varchar	255
payment_objects	vendor_id	int	10			0
payment_trustees	vendor_id	int	10			0
payment_vendors	vendor_id	int	10			0
aicc_course	version	varchar	10	√		null
cp_manifest	version	varchar	200	√		null
file_data	version	int	10	√		null
ldap_server_settings	version	int	10			0
sc_manifest	version	varchar	200	√		null
xml_object	version	varchar	5
il_meta_lifecycle	version_language	char	2	√		null
crs_settings	view_mode	bit	0			0
glossary	virtual	enum	7			none
il_news_item	visibility	enum	6	√		users
crs_items	visible	bit	0			0
crs_timings_usr_accept	visible	bit	0			0
user_defined_field_definition	visible	bit	0			0
frm_data	visits	int	10			0
frm_threads	visits	int	10			0
ut_learning_progress	visits	int	10			0
ut_lp_settings	visits	int	10	√		0
feedback_results	vote	int	10			0
feedback_items	votes	text	65535	√		null
feedback_results	votetime	int	10			0
payment_statistic	voucher	char	64	√		null
crs_settings	waiting_list	bit	0			1
aicc_units	web_launch	varchar	255	√		null
webr_items	webr_id	int	10			0
webr_params	webr_id	int	10			0
cmi_interaction	weighting	double	22	√		null
media_item	width	varchar	10	√		null
survey_question_text	width	int	10			50
qpl_questions	working_time	time	8			00:00:00
cp_mapinfo	writeNormalizedMeasure	tinyint	3	√		null
cp_mapinfo	writeSatisfiedStatus	tinyint	3	√		null
sc_manifest	xml_base	varchar	200	√		null
sc_resource	xml_base	varchar	200	√		null
sc_resources	xml_base	varchar	200	√		null
xml_tree	xml_id	mediumint unsigned	8			0
cp_package	xmldata	text	65535	√		null
payment_bill_vendor	zipcode	char	16	√		null
usr_data	zipcode	varchar	10	√		null