iliasRelease_5_0_x_branch contains 4341 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
addressbook_mlist_ass_seq	sequence	int	10		√
addressbook_mlist_seq	sequence	int	10		√
addressbook_seq	sequence	int	10		√
adm_settings_template_seq	sequence	int	10		√
adv_md_record_seq	sequence	int	10		√
adv_mdf_definition_seq	sequence	int	10		√
aicc_object_seq	sequence	int	10		√
aicc_units_seq	sequence	int	10		√
ass_log_seq	sequence	int	10		√
booking_entry_seq	sequence	int	10		√
booking_object_seq	sequence	int	10		√
booking_reservation_group_seq	sequence	int	10		√
booking_reservation_seq	sequence	int	10		√
booking_schedule_seq	sequence	int	10		√
bookmark_data_seq	sequence	int	10		√
bookmark_social_bm_seq	sequence	int	10		√
cal_categories_seq	sequence	int	10		√
cal_ch_group_seq	sequence	int	10		√
cal_entries_seq	sequence	int	10		√
cal_notification_seq	sequence	int	10		√
cal_rec_exclusion_seq	sequence	int	10		√
cal_recurrence_rules_seq	sequence	int	10		√
chat_record_data_seq	sequence	int	10		√
chat_records_seq	sequence	int	10		√
chat_room_messages_seq	sequence	int	10		√
chat_rooms_seq	sequence	int	10		√
chat_smilies_seq	sequence	int	10		√
chatroom_admconfig_seq	sequence	int	10		√
chatroom_prooms_seq	sequence	int	10		√
chatroom_settings_seq	sequence	int	10		√
chatroom_smilies_seq	sequence	int	10		√
chatroom_uploads_seq	sequence	int	10		√
cmi_comment_seq	sequence	int	10		√
cmi_correct_response_seq	sequence	int	10		√
cmi_interaction_seq	sequence	int	10		√
cmi_node_seq	sequence	int	10		√
cmi_objective_seq	sequence	int	10		√
conditions_seq	sequence	int	10		√
cp_node_seq	sequence	int	10		√
crs_archives_seq	sequence	int	10		√
crs_f_definitions_seq	sequence	int	10		√
crs_file_seq	sequence	int	10		√
crs_objective_lm_seq	sequence	int	10		√
crs_objective_qst_seq	sequence	int	10		√
crs_objective_tst_seq	sequence	int	10		√
crs_objectives_seq	sequence	int	10		√
crs_start_seq	sequence	int	10		√
didactic_tpl_a_seq	sequence	int	10		√
didactic_tpl_fp_seq	sequence	int	10		√
didactic_tpl_settings_seq	sequence	int	10		√
ecs_cmap_rule_seq	sequence	int	10		√
ecs_cms_data_seq	sequence	int	10		√
ecs_container_mapping_seq	sequence	int	10		√
ecs_course_assignments_seq	sequence	int	10		√
ecs_crs_mapping_atts_seq	sequence	int	10		√
ecs_events_seq	sequence	int	10		√
ecs_remote_user_seq	sequence	int	10		√
ecs_server_seq	sequence	int	10		√
event_appointment_seq	sequence	int	10		√
event_file_seq	sequence	int	10		√
event_seq	sequence	int	10		√
exc_assignment_seq	sequence	int	10		√
exc_returned_seq	sequence	int	10		√
feedback_items_seq	sequence	int	10		√
frm_data_seq	sequence	int	10		√
frm_notification_seq	sequence	int	10		√
frm_posts_seq	sequence	int	10		√
frm_posts_tree_seq	sequence	int	10		√
frm_threads_seq	sequence	int	10		√
glossary_definition_seq	sequence	int	10		√
glossary_term_seq	sequence	int	10		√
help_module_seq	sequence	int	10		√
help_tooltip_seq	sequence	int	10		√
history_seq	sequence	int	10		√
il_bibl_attribute_seq	sequence	int	10		√
il_bibl_entry_seq	sequence	int	10		√
il_bibl_settings_seq	sequence	int	10		√
il_blog_posting_seq	sequence	int	10		√
il_custom_block_seq	sequence	int	10		√
il_dcl_data_seq	sequence	int	10		√
il_dcl_field_prop_seq	sequence	int	10		√
il_dcl_field_seq	sequence	int	10		√
il_dcl_record_field_seq	sequence	int	10		√
il_dcl_record_seq	sequence	int	10		√
il_dcl_stloc1_value_seq	sequence	int	10		√
il_dcl_stloc2_value_seq	sequence	int	10		√
il_dcl_stloc3_value_seq	sequence	int	10		√
il_dcl_table_seq	sequence	int	10		√
il_dcl_view_seq	sequence	int	10		√
il_exc_team_seq	sequence	int	10		√
il_external_feed_block_seq	sequence	int	10		√
il_md_cpr_selections_seq	sequence	int	10		√
il_meta_annotation_seq	sequence	int	10		√
il_meta_classification_seq	sequence	int	10		√
il_meta_contribute_seq	sequence	int	10		√
il_meta_description_seq	sequence	int	10		√
il_meta_educational_seq	sequence	int	10		√
il_meta_entity_seq	sequence	int	10		√
il_meta_format_seq	sequence	int	10		√
il_meta_general_seq	sequence	int	10		√
il_meta_identifier__seq	sequence	int	10		√
il_meta_identifier_seq	sequence	int	10		√
il_meta_keyword_seq	sequence	int	10		√
il_meta_language_seq	sequence	int	10		√
il_meta_lifecycle_seq	sequence	int	10		√
il_meta_location_seq	sequence	int	10		√
il_meta_meta_data_seq	sequence	int	10		√
il_meta_relation_seq	sequence	int	10		√
il_meta_requirement_seq	sequence	int	10		√
il_meta_rights_seq	sequence	int	10		√
il_meta_tar_seq	sequence	int	10		√
il_meta_taxon_path_seq	sequence	int	10		√
il_meta_taxon_seq	sequence	int	10		√
il_meta_technical_seq	sequence	int	10		√
il_new_item_grp_seq	sequence	int	10		√
il_news_item_seq	sequence	int	10		√
il_poll_answer_seq	sequence	int	10		√
il_qpl_qst_fq_res_seq	sequence	int	10		√
il_qpl_qst_fq_res_unit_seq	sequence	int	10		√
il_qpl_qst_fq_ucat_seq	sequence	int	10		√
il_qpl_qst_fq_unit_seq	sequence	int	10		√
il_qpl_qst_fq_var_seq	sequence	int	10		√
il_rating_cat_seq	sequence	int	10		√
il_wiki_page_seq	sequence	int	10		√
ldap_rg_mapping_seq	sequence	int	10		√
ldap_role_assignments_seq	sequence	int	10		√
ldap_server_settings_seq	sequence	int	10		√
lm_data_seq	sequence	int	10		√
lm_menu_seq	sequence	int	10		√
mail_obj_data_seq	sequence	int	10		√
mail_seq	sequence	int	10		√
media_item_seq	sequence	int	10		√
mep_item_seq	sequence	int	10		√
note_seq	sequence	int	10		√
notification_data_seq	sequence	int	10		√
notification_osd_seq	sequence	int	10		√
object_data_seq	sequence	int	10		√
object_reference_seq	sequence	int	10		√
object_reference_ws_seq	sequence	int	10		√
openid_provider_seq	sequence	int	10		√
orgu_types_seq	sequence	int	10		√
page_layout_seq	sequence	int	10		√
payment_coupons_codes_seq	sequence	int	10		√
payment_coupons_seq	sequence	int	10		√
payment_coupons_track_seq	sequence	int	10		√
payment_currencies_seq	sequence	int	10		√
payment_news_seq	sequence	int	10		√
payment_objects_seq	sequence	int	10		√
payment_paymethods_seq	sequence	int	10		√
payment_prices_seq	sequence	int	10		√
payment_shopping_cart_seq	sequence	int	10		√
payment_statistic_seq	sequence	int	10		√
payment_topics_seq	sequence	int	10		√
payment_vats_seq	sequence	int	10		√
pg_amd_page_list_seq	sequence	int	10		√
qpl_a_cloze_seq	sequence	int	10		√
qpl_a_errortext_seq	sequence	int	10		√
qpl_a_essay_seq	sequence	int	10		√
qpl_a_imagemap_seq	sequence	int	10		√
qpl_a_matching_seq	sequence	int	10		√
qpl_a_mc_seq	sequence	int	10		√
qpl_a_mdef_seq	sequence	int	10		√
qpl_a_mterm_seq	sequence	int	10		√
qpl_a_ordering_seq	sequence	int	10		√
qpl_a_sc_seq	sequence	int	10		√
qpl_a_textsubset_seq	sequence	int	10		√
qpl_fb_generic_seq	sequence	int	10		√
qpl_fb_specific_seq	sequence	int	10		√
qpl_hint_tracking_seq	sequence	int	10		√
qpl_hints_seq	sequence	int	10		√
qpl_num_range_seq	sequence	int	10		√
qpl_questionpool_seq	sequence	int	10		√
qpl_questions_seq	sequence	int	10		√
qpl_sol_sug_seq	sequence	int	10		√
rbac_operations_seq	sequence	int	10		√
reg_er_assignments_seq	sequence	int	10		√
reg_registration_codes_seq	sequence	int	10		√
role_desktop_items_seq	sequence	int	10		√
sahs_sc13_seq_node_seq	sequence	int	10		√
sahs_sc13_seq_templts_seq	sequence	int	10		√
sahs_sc13_tree_node_seq	sequence	int	10		√
sc_resource_dependen_seq	sequence	int	10		√
sc_resource_file_seq	sequence	int	10		√
scorm_object_seq	sequence	int	10		√
search_data_seq	sequence	int	10		√
shib_role_assignment_seq	sequence	int	10		√
skl_level_seq	sequence	int	10		√
skl_profile_seq	sequence	int	10		√
skl_self_eval_seq	sequence	int	10		√
skl_tree_node_seq	sequence	int	10		√
sty_media_query_seq	sequence	int	10		√
style_parameter_seq	sequence	int	10		√
style_template_seq	sequence	int	10		√
svy_anonymous_seq	sequence	int	10		√
svy_answer_seq	sequence	int	10		√
svy_category_seq	sequence	int	10		√
svy_constraint_seq	sequence	int	10		√
svy_finished_seq	sequence	int	10		√
svy_inv_usr_seq	sequence	int	10		√
svy_material_seq	sequence	int	10		√
svy_phrase_cat_seq	sequence	int	10		√
svy_phrase_seq	sequence	int	10		√
svy_qblk_qst_seq	sequence	int	10		√
svy_qblk_seq	sequence	int	10		√
svy_qpl_seq	sequence	int	10		√
svy_qst_constraint_seq	sequence	int	10		√
svy_qst_matrixrows_seq	sequence	int	10		√
svy_qst_oblig_seq	sequence	int	10		√
svy_qtype_seq	sequence	int	10		√
svy_question_seq	sequence	int	10		√
svy_relation_seq	sequence	int	10		√
svy_settings_seq	sequence	int	10		√
svy_svy_qst_seq	sequence	int	10		√
svy_svy_seq	sequence	int	10		√
svy_variable_seq	sequence	int	10		√
sysc_groups_seq	sequence	int	10		√
sysc_tasks_seq	sequence	int	10		√
tax_node_seq	sequence	int	10		√
tos_acceptance_track_seq	sequence	int	10		√
tos_versions_seq	sequence	int	10		√
tst_active_seq	sequence	int	10		√
tst_manual_fb_seq	sequence	int	10		√
tst_mark_seq	sequence	int	10		√
tst_rnd_cpy_seq	sequence	int	10		√
tst_rnd_qpl_title_seq	sequence	int	10		√
tst_rnd_quest_set_qpls_seq	sequence	int	10		√
tst_solutions_seq	sequence	int	10		√
tst_test_defaults_seq	sequence	int	10		√
tst_test_question_seq	sequence	int	10		√
tst_test_result_seq	sequence	int	10		√
tst_test_rnd_qst_seq	sequence	int	10		√
tst_tests_seq	sequence	int	10		√
tst_times_seq	sequence	int	10		√
udf_definition_seq	sequence	int	10		√
usr_account_codes_seq	sequence	int	10		√
usr_ext_profile_page_seq	sequence	int	10		√
usr_portfolio_page_seq	sequence	int	10		√
webr_items_seq	sequence	int	10		√
webr_params_seq	sequence	int	10		√
write_event_seq	sequence	int	10		√
xhtml_page_seq	sequence	int	10		√
xmltags_seq	sequence	int	10		√
xmlvalue_seq	sequence	int	10		√
il_meta_annotation	a_date	longtext	2147483647	√		null
addressbook_mlist_ass	a_id	bigint	19			0
crs_settings	abo	tinyint	3	√		1
il_blog	abs_image	tinyint	3	√		0
il_blog	abs_img_height	smallint	5	√		0
il_blog	abs_img_width	smallint	5	√		0
il_blog	abs_shorten	tinyint	3	√		0
il_blog	abs_shorten_len	smallint	5	√		0
crs_timings_usr_accept	accept	tinyint	3			0
member_agreement	acceptance_time	int	10			0
member_agreement	accepted	tinyint	3			0
payment_statistic	access_enddate	datetime	19	√		null
payment_statistic	access_granted	int	10			0
acc_access_key	access_key	char	1	√		null
acc_user_access_key	access_key	char	1	√		null
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
payment_statistic	access_startdate	datetime	19	√		null
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
cp_rule	action	varchar	50	√		null
history	action	varchar	20	√		null
il_exc_team_log	action	tinyint	3
rbac_log	action	tinyint	3
sahs_sc13_seq_rule	action	varchar	50	√		null
write_event	action	varchar	8
didactic_tpl_abr	action_id	int	10
didactic_tpl_alp	action_id	int	10
didactic_tpl_alr	action_id	int	10
note_settings	activated	tinyint	3			0
crs_settings	activation_end	int	10	√		null
ilinc_data	activation_end	int	10	√		null
page_object	activation_end	datetime	19	√		null
ilinc_data	activation_offline	varchar	3	√		null
crs_settings	activation_start	int	10	√		null
ilinc_data	activation_start	int	10	√		null
page_object	activation_start	datetime	19	√		null
crs_settings	activation_type	tinyint	3			0
ilinc_data	activation_unlimited	tinyint	3	√		null
adv_md_record	active	tinyint	3			0
crs_objectives	active	tinyint	3	√		1
ecs_server	active	tinyint	3	√		0
il_plugin	active	tinyint	3	√		null
ldap_server_settings	active	int	10			0
lm_data	active	char	1	√		y
lm_menu	active	char	1	√		n
page_layout	active	tinyint	3	√		0
page_object	active	tinyint	3			1
payment_erps	active	int	10	√		null
style_data	active	tinyint	3	√		1
usr_data	active	int	10			0
ut_lp_collections	active	tinyint	3			1
webr_items	active	tinyint	3	√		null
usr_session_stats	active_avg	int	10	√		null
usr_session_stats	active_end	int	10	√		null
svy_answer	active_fi	int	10			0
tst_addtime	active_fi	bigint	19			0
tst_manual_fb	active_fi	int	10			0
tst_pass_result	active_fi	int	10			0
tst_qst_solved	active_fi	int	10			0
tst_result_cache	active_fi	int	10
tst_seq_qst_answstatus	active_fi	int	10			0
tst_seq_qst_checked	active_fi	int	10			0
tst_seq_qst_postponed	active_fi	int	10			0
tst_seq_qst_tracking	active_fi	int	10			0
tst_sequence	active_fi	int	10			0
tst_solutions	active_fi	int	10			0
tst_test_result	active_fi	int	10			0
tst_test_rnd_qst	active_fi	int	10			0
tst_times	active_fi	int	10			0
tst_active	active_id	int	10			0
usr_session_stats	active_max	int	10	√		null
usr_session_stats	active_min	int	10	√		null
cmi_node	activityabsduration	varchar	20	√		null
cp_sequencing	activityabsdurlimit	varchar	20	√		null
sahs_sc13_seq_seq	activityabsolutedurationlimit	varchar	20	√		null
cmi_node	activityattemptcount	int	10	√		null
cmi_node	activityexpduration	varchar	20	√		null
cp_sequencing	activityexpdurlimit	varchar	20	√		null
sahs_sc13_seq_seq	activityexperienceddurlimit	varchar	20	√		null
cmi_node	activityprogstatus	tinyint	3	√		null
cp_package	activitytree	longtext	2147483647	√		null
qpl_questions	add_cont_edit_mode	varchar	16	√		null
ldap_role_assignments	add_on_update	tinyint	3	√		null
shib_role_assignment	add_on_update	tinyint	3			0
il_dcl_table	add_perm	tinyint	3			1
frm_settings	add_re_subject	tinyint	3			0
wiki_page_template	add_to_page	tinyint	3			0
ut_lp_user_status	additional_info	varchar	4000	√		null
cmi_node	additional_tables	tinyint	3			0
tst_addtime	additionaltime	bigint	19			0
addressbook	addr_id	int	10			0
addressbook_mlist_ass	addr_id	bigint	19			0
frm_notification	admin_force_noti	tinyint	3			0
frm_settings	admin_force_noti	tinyint	3			0
cal_ch_settings	admin_id	int	10
il_object_def	administration	tinyint	3			0
ecs_data_mapping	advmd_id	int	10
usr_data	agree_date	datetime	19	√		null
ilinc_data	akclassvalue1	varchar	40	√		null
ilinc_data	akclassvalue2	varchar	40	√		null
reg_registration_codes	alimit	varchar	50	√		null
reg_registration_codes	alimitdt	varchar	255	√		null
cron_job	alive_ts	int	10	√		null
chatroom_settings	allow_anonymous	tinyint	3	√		0
il_object_def	allow_copy	tinyint	3			0
chatroom_settings	allow_custom_usernames	tinyint	3	√		0
qpl_qst_mc	allow_images	varchar	1	√		0
qpl_qst_sc	allow_images	varchar	1	√		0
il_object_def	allow_link	tinyint	3			0
chatroom_settings	allow_private_rooms	tinyint	3	√		0
role_data	allow_register	tinyint	3			0
qpl_qst_fileupload	allowedextensions	varchar	255	√		null
tst_tests	allowedusers	int	10	√		null
tst_tests	alloweduserstimegap	int	10	√		null
il_object_def	amet	tinyint	3			0
il_object_sub_type	amet	tinyint	3			0
page_anchor	anchor_name	varchar	120
tst_tests	anonymity	varchar	1	√		0
svy_svy	anonymize	varchar	1	√		0
frm_settings	anonymized	tinyint	3			0
feedback_items	anonymous	tinyint	3			1
svy_360_rater	anonymous_id	int	10			0
svy_anonymous	anonymous_id	int	10			0
svy_finished	anonymous_id	varchar	32	√		null
tst_active	anonymous_id	varchar	5	√		null
il_poll_answer	answer	varchar	1000	√		null
qpl_a_cloze_combi_res	answer	varchar	1000	√		null
qpl_fb_specific	answer	int	10
tst_tests	answer_feedback	varchar	1	√		0
tst_tests	answer_feedback_points	varchar	1	√		0
tst_dyn_quest_set_cfg	answer_filter_enabled	tinyint	3	√		null
il_poll_vote	answer_id	int	10
qpl_a_cloze	answer_id	int	10			0
qpl_a_errortext	answer_id	int	10
qpl_a_essay	answer_id	int	10			0
qpl_a_imagemap	answer_id	int	10			0
qpl_a_matching	answer_id	int	10			0
qpl_a_mc	answer_id	int	10			0
qpl_a_ordering	answer_id	int	10			0
qpl_a_sc	answer_id	int	10			0
qpl_a_textsubset	answer_id	int	10			0
svy_answer	answer_id	int	10			0
qpl_qst_kprim	answer_type	varchar	16			singleLine
tst_test_result	answered	tinyint	3			1
tst_pass_result	answeredquestions	int	10			0
tst_active	answerstatusfilter	varchar	16	√		null
qpl_a_cloze	answertext	varchar	1000	√		null
qpl_a_essay	answertext	varchar	1000	√		null
qpl_a_imagemap	answertext	varchar	4000	√		null
qpl_a_kprim	answertext	varchar	1000	√		null
qpl_a_mc	answertext	varchar	1000	√		null
qpl_a_ordering	answertext	varchar	1000	√		null
qpl_a_sc	answertext	varchar	1000	√		null
qpl_a_textsubset	answertext	varchar	1000	√		null
qpl_a_cloze	aorder	smallint	5			0
qpl_a_imagemap	aorder	smallint	5			0
qpl_a_mc	aorder	smallint	5			0
qpl_a_sc	aorder	smallint	5			0
qpl_a_textsubset	aorder	smallint	5			0
qpl_num_range	aorder	int	10			0
sahs_lm	api_adapter	varchar	80	√		API
sahs_lm	api_func_prefix	varchar	20	√		LMS
qpl_qst_flash	applet	varchar	150	√		null
ilinc_registration	application_date	datetime	19	√		null
event_appointment	appointment_id	int	10			0
svy_360_rater	appr_id	int	10			0
svy_finished	appr_id	int	10	√		0
il_blog	approval	tinyint	3	√		0
il_dcl_data	approval	tinyint	3	√		null
ecs_server	approval_rcp	varchar	512	√		null
usr_data	approve_date	datetime	19	√		null
il_blog_posting	approved	tinyint	3	√		0
crs_archives	archive_date	int	10	√		null
crs_settings	archive_end	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_settings	archive_start	int	10	√		null
crs_archives	archive_type	tinyint	3			0
crs_settings	archive_type	int	10	√		null
qpl_a_imagemap	area	varchar	20	√		null
exc_assignment_peer	ass_id	int	10
exc_mem_ass_status	ass_id	int	10
exc_returned	ass_id	int	10	√		null
exc_usr_tutor	ass_id	int	10			0
il_exc_team	ass_id	int	10
ass_log	ass_log_id	int	10			0
rbac_fa	assign	char	1	√		null
role_data	assign_users	tinyint	3	√		0
reg_er_assignments	assignment_id	int	10			0
exc_returned	atext	longtext	2147483647	√		null
mail_template	att_file	varchar	400	√		null
ldap_role_assignments	att_name	varchar	255	√		null
ldap_role_assignments	att_value	varchar	255	√		null
mail	attachments	longtext	2147483647	√		null
mail_saved	attachments	longtext	2147483647	√		null
cmi_node	attemptabsduration	varchar	20	√		null
cp_sequencing	attemptabsdurlimit	varchar	20	√		null
sahs_sc13_seq_seq	attemptabsolutedurationlimit	varchar	20	√		null
cmi_node	attemptcomplamount	double	22	√		null
cmi_node	attemptcomplstatus	tinyint	3	√		null
cmi_node	attemptexpduration	varchar	20	√		null
cp_sequencing	attemptexpdurlimit	varchar	20	√		null
sahs_sc13_seq_seq	attemptexperienceddurlimit	varchar	20	√		null
cp_sequencing	attemptlimit	int	10	√		null
sahs_sc13_seq_seq	attemptlimit	int	10	√		null
cmi_node	attemptprogstatus	tinyint	3	√		null
ecs_cmap_rule	attribute	varchar	64	√		null
ldap_role_assignments	attribute	varchar	32	√		null
aicc_units	au_password	varchar	50	√		null
cmi_node	audio_captioning	int	10	√		null
cmi_node	audio_level	double	22	√		null
il_cld_data	auth_complete	tinyint	3	√		null
role_data	auth_mode	char	16	√		default
usr_data	auth_mode	char	10	√		default
ecs_server	auth_pass	varchar	128	√		null
ecs_server	auth_type	tinyint	3	√		1
ecs_server	auth_user	varchar	32	√		null
ldap_server_settings	authentication	tinyint	3			1
ldap_server_settings	authentication_type	tinyint	3			0
il_blog_posting	author	int	10			0
note	author	int	10			0
qpl_questions	author	varchar	50	√		null
svy_question	author	varchar	100	√		null
svy_svy	author	varchar	50	√		null
tst_tests	author	varchar	50	√		null
il_blog	authors	tinyint	3			1
booking_schedule	auto_break	int	10	√		null
sahs_lm	auto_continue	varchar	1			n
adm_settings_template	auto_generated	tinyint	3	√		0
cal_entries	auto_generated	tinyint	3			0
sahs_lm	auto_last_visited	varchar	1			y
crs_settings	auto_notification	tinyint	3			1
sahs_lm	auto_review	varchar	3	√		n
sahs_lm	auto_suspend	varchar	1			n
addressbook	auto_update	int	10			1
chatroom_settings	autogen_usernames	varchar	50	√		Anonymous #
tst_tests	autosave	tinyint	3			0
tst_tests	autosave_ival	int	10			0
cp_auxilaryresource	auxiliaryresourceid	varchar	255	√		null
rgrp_settings	availability_end	int	10	√		null
rtst_settings	availability_end	int	10	√		null
rgrp_settings	availability_start	int	10	√		null
rtst_settings	availability_start	int	10	√		null
remote_course_settings	availability_type	tinyint	3			0
rglo_settings	availability_type	tinyint	3			0
rgrp_settings	availability_type	tinyint	3			0
rlm_settings	availability_type	tinyint	3			0
rtst_settings	availability_type	tinyint	3			0
rwik_settings	availability_type	tinyint	3			0
cmi_node	availablechildren	varchar	255	√		null
frm_threads	avg_rating	double	22			0
wiki_stat	avg_rating	int	10
wiki_stat_page	avg_rating	int	10
payment_statistic	b_pay_method	int	10	√		null
payment_statistic	b_vendor_id	int	10	√		null
cp_manifest	base	varchar	200	√		null
cp_resource	base	varchar	4000	√		null
ldap_server_settings	base_dn	varchar	255	√		null
skl_profile_level	base_skill_id	int	10
skl_skill_resource	base_skill_id	int	10
svy_quest_skill	base_skill_id	int	10
svy_skill_threshold	base_skill_id	int	10
il_qpl_qst_fq_unit	baseunit_fi	int	10			0
cp_sequencing	begintimelimit	varchar	20	√		null
sahs_sc13_seq_seq	begintimelimit	varchar	20	√		null
benchmark	benchmark	varchar	150	√		null
qpl_a_cloze_combi_res	best_solution	tinyint	3	√		null
il_blog	bg_color	char	6	√		null
usr_portfolio	bg_color	char	6	√		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
svy_qst_matrix	bipolar_adjective1	varchar	255	√		null
svy_qst_matrix	bipolar_adjective2	varchar	255	√		null
usr_data	birthday	date	10	√		null
il_block_setting	block_id	int	10			0
container_sorting_bl	block_ids	varchar	4000	√		null
il_wiki_page	blocked	tinyint	3	√		null
obj_members	blocked	tinyint	3			0
il_blog_posting	blog_id	int	10			0
mail_template	body	longtext	2147483647	√		null
booking_entry	booking_group	int	10			0
booking_entry	booking_id	int	10
booking_obj_assignment	booking_id	int	10
payment_statistic	booking_id	int	10			0
booking_user	booking_message	varchar	1024	√		null
booking_object	booking_object_id	int	10
booking_settings	booking_pool_id	int	10
booking_reservation	booking_reservation_id	int	10
booking_schedule	booking_schedule_id	int	10
booking_schedule_slot	booking_schedule_id	int	10
tst_tests	broken	tinyint	3	√		null
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
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
cmi_comment	c_comment	longtext	2147483647	√		null
cp_condition	c_condition	varchar	50	√		null
il_meta_contribute	c_date	varchar	4000	√		null
cmi_node	c_entry	varchar	255	√		null
cmi_node	c_exit	varchar	255	√		null
cp_package	c_identifier	varchar	255	√		null
cmi_node	c_language	varchar	5	√		null
aicc_course	c_level	varchar	5	√		null
cmi_node	c_max	double	22	√		null
cmi_objective	c_max	double	22	√		null
cmi_node	c_min	double	22	√		null
cmi_objective	c_min	double	22	√		null
cmi_node	c_mode	varchar	20	√		null
sahs_lm	c_online	varchar	3	√		n
cp_condition	c_operator	varchar	50	√		null
cp_objective	c_primary	tinyint	3	√		null
cmi_node	c_raw	double	22	√		null
cmi_objective	c_raw	double	22	√		null
cp_package	c_settings	varchar	255	√		null
cal_auth_token	c_time	int	10			0
cmi_comment	c_timestamp	datetime	19	√		null
cmi_custom	c_timestamp	datetime	19	√		null
cmi_interaction	c_timestamp	varchar	20	√		null
cmi_node	c_timestamp	datetime	19	√		null
scorm_tracking	c_timestamp	datetime	19	√		null
aicc_object	c_type	varchar	50	√		null
aicc_units	c_type	varchar	50	√		null
cmi_interaction	c_type	varchar	32	√		null
cp_resource	c_type	varchar	30	√		null
cp_rule	c_type	varchar	50	√		null
sahs_lm	c_type	varchar	10	√		null
scorm_object	c_type	char	3	√		null
ecs_server	ca_cert_path	varchar	512	√		null
cal_cat_assignments	cal_id	int	10			0
cal_entries	cal_id	int	10			0
cal_entry_responsible	cal_id	int	10			0
cal_notification	cal_id	int	10			0
cal_rec_exclusion	cal_id	int	10
cal_recurrence_rules	cal_id	int	10			0
cal_registrations	cal_id	int	10
cal_shared	cal_id	int	10			0
cal_shared_status	cal_id	int	10			0
cal_recurrence_rules	cal_recurrence	int	10			0
cal_auth_token	calendar	int	10
ctrl_structure	call_node	longtext	2147483647	√		null
media_item	caption	varchar	3000	√		null
cal_cat_assignments	cat_id	int	10			0
cal_categories	cat_id	int	10			0
cal_categories_hidden	cat_id	int	10			0
il_meta_identifier	catalog	varchar	4000	√		null
il_meta_identifier_	catalog	varchar	4000	√		null
il_qpl_qst_fq_ucat	category	varchar	255	√		null
style_data	category	int	10	√		null
il_qpl_qst_fq_unit	category_fi	int	10			0
svy_phrase_cat	category_fi	int	10			0
svy_variable	category_fi	int	10			0
il_qpl_qst_fq_ucat	category_id	int	10			0
il_rating	category_id	int	10			0
svy_category	category_id	int	10			0
syst_style_cat	category_ref_id	int	10			0
benchmark	cdate	datetime	19	√		null
ecs_server	cert_serial	varchar	32	√		null
udf_definition	certificate	tinyint	3			0
exc_data	certificate_visibility	tinyint	3			0
tst_tests	certificate_visibility	varchar	1	√		0
crs_items	changeable	tinyint	3			0
udf_definition	changeable	tinyint	3			0
udf_definition	changeable_lua	tinyint	3			0
addressbook_mlist	changedate	datetime	19	√		null
wiki_stat_page_user	changes	int	10			0
notification_usercfg	channel	varchar	100
notification_channels	channel_name	varchar	100
help_map	chap	int	10
tst_tests	char_selector_availability	int	10			0
tst_tests	char_selector_definition	varchar	4000	√		null
style_char	characteristic	varchar	30
chat_blocked	chat_id	int	10			0
chat_invitations	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
sahs_lm	check_values	varchar	1			y
il_object_def	checkbox	tinyint	3			0
usr_search	checked	longtext	2147483647	√		null
bookmark_tree	child	int	10			0
cp_tree	child	int	10	√		null
ctrl_calls	child	varchar	100	√		null
ecs_cms_tree	child	int	10			0
lm_tree	child	int	10			0
mail_tree	child	int	10			0
mep_tree	child	int	10			0
sahs_sc13_seq_tree	child	int	10	√		null
sahs_sc13_tree	child	int	10			0
scorm_tree	child	int	10			0
search_tree	child	int	10			0
skl_tree	child	int	10			0
tax_tree	child	int	10			0
tree	child	int	10			0
tree_workspace	child	int	10			0
container_sorting	child_id	int	10			0
cp_rule	childactivityset	varchar	50	√		null
sahs_sc13_seq_rule	childactivityset	varchar	50	√		null
obj_stat	childs_read_count	int	10	√		null
obj_stat_log	childs_read_count	int	10	√		null
obj_stat_tmp	childs_read_count	int	10	√		null
read_event	childs_read_count	int	10			0
obj_stat	childs_spent_seconds	int	10	√		null
obj_stat_log	childs_spent_seconds	int	10	√		null
obj_stat_tmp	childs_spent_seconds	int	10	√		null
read_event	childs_spent_seconds	int	10			0
cp_sequencing	choice	tinyint	3	√		null
sahs_sc13_seq_course	choice	tinyint	3	√		1
sahs_sc13_seq_seq	choice	tinyint	3	√		null
cp_sequencing	choiceexit	tinyint	3	√		null
sahs_sc13_seq_seq	choiceexit	tinyint	3	√		null
ctrl_classfile	cid	varchar	4	√		null
ecs_community	cid	int	10
payment_statistic	city	varchar	40	√		null
usr_data	city	varchar	40	√		null
cron_job	class	varchar	255	√		null
ctrl_classfile	class	varchar	100
module_class	class	varchar	100
notification_channels	class	varchar	100
rbac_operations	class	char	16	√		null
service_class	class	varchar	100
style_parameter	class	varchar	100	√		null
style_template_class	class	char	30	√		null
copg_pobj_def	class_name	varchar	80
il_object_def	class_name	varchar	200	√		null
style_template_class	class_type	char	30	√		null
content_object	clean_frames	char	1	√		n
ecs_server	client_cert_path	varchar	512	√		null
usr_data	client_ip	varchar	255	√		null
chatroom_admconfig	client_settings	varchar	1000
tst_invited_user	clientip	varchar	255	√		null
chatroom_prooms	closed	int	10	√		0
usr_session_stats	closed_expire	int	10	√		null
usr_session_stats	closed_idle	int	10	√		null
usr_session_stats	closed_idle_first	int	10	√		null
usr_session_stats	closed_limit	int	10	√		null
usr_session_stats	closed_login	int	10	√		null
usr_session_stats	closed_manual	int	10	√		null
usr_session_stats	closed_misc	int	10	√		0
qpl_qst_cloze	cloze_text	longtext	2147483647	√		null
qpl_a_cloze	cloze_type	varchar	1	√		0
cmi_comment	cmi_comment_id	int	10			0
cmi_correct_response	cmi_correct_resp_id	int	10			0
cmi_correct_response	cmi_interaction_id	int	10	√		null
cmi_interaction	cmi_interaction_id	int	10			0
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			0
cmi_objective	cmi_node_id	int	10	√		null
cmi_objective	cmi_objective_id	int	10			0
ecs_cms_data	cms_id	varchar	512	√		null
ecs_course_assignments	cms_id	int	10
ecs_course_assignments	cms_sub_id	int	10	√		0
ecs_community	cname	varchar	255	√		null
ecs_part_settings	cname	varchar	255	√		null
tst_seq_qst_postponed	cnt	int	10			0
obj_type_stat	cnt_deleted	int	10	√		null
obj_type_stat	cnt_objects	int	10	√		null
obj_type_stat	cnt_references	int	10	√		null
reg_registration_codes	code	varchar	50	√		null
usr_account_codes	code	varchar	50	√		null
reg_registration_codes	code_id	int	10			0
usr_account_codes	code_id	int	10			0
cal_categories	color	char	8	√		null
style_color	color_code	char	10	√		null
style_color	color_name	varchar	30			.
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
qpl_a_cloze_combi_res	combination_id	int	10
search_command_queue	command	char	16	√		null
aicc_units	command_line	varchar	255	√		null
sahs_lm	comments	varchar	1			y
chat_room_messages	commit_timestamp	int	10			0
help_tooltip	comp	varchar	10
ctrl_calls	comp_prefix	varchar	50	√		null
ctrl_classfile	comp_prefix	varchar	50	√		null
exc_data	compl_by_submission	tinyint	3			0
qpl_qst_fileupload	compl_by_submission	tinyint	3			0
qpl_questions	complete	varchar	1	√		1
svy_question	complete	varchar	1	√		0
svy_svy	complete	varchar	1	√		0
tst_tests	complete	varchar	1	√		1
obj_lp_stat	completed	int	10	√		null
ut_lp_coll_manual	completed	tinyint	3			0
ut_lp_marks	completed	int	10			0
cp_item	completedbymeasure	tinyint	3	√		0
cal_entries	completion	int	10			0
cmi_node	completion	double	22	√		null
cmi_gobjective	completion_status	varchar	50	√		null
cmi_node	completion_status	varchar	32	√		null
cmi_objective	completion_status	varchar	32	√		null
cmi_node	completion_threshold	varchar	32	√		null
cp_sequencing	completionbycontent	tinyint	3	√		null
sahs_sc13_seq_seq	completionsetbycontent	tinyint	3	√		null
cp_item	completionthreshold	varchar	50	√		1.0
cache_clob	component	varchar	50
cache_text	component	varchar	50
copg_pc_def	component	varchar	40	√		null
copg_pobj_def	component	varchar	40	√		null
cron_job	component	varchar	200	√		null
help_map	component	varchar	10
il_event_handling	component	varchar	50
il_object_def	component	varchar	200	√		null
il_pluginslot	component	varchar	200
sysc_groups	component	char	16	√		null
tax_node_assignment	component	varchar	10
usr_sess_istorage	component_id	varchar	30
il_plugin	component_name	varchar	90
il_plugin	component_type	char	10
sahs_sc13_seq_cond	cond	varchar	50	√		null
conditions	condition_id	int	10			0
cp_rule	conditioncombination	varchar	50	√		null
sahs_sc13_seq_rule	conditioncombination	varchar	50	√		null
notification_channels	config_type	varchar	30
notification_types	config_type	varchar	30
svy_constraint	conjunction	smallint	5			0
chatroom_psessions	connected	int	10
chatroom_sessions	connected	int	10
chatroom_users	connected	int	10
cp_sequencing	constrainchoice	tinyint	3	√		null
sahs_sc13_seq_seq	constrainchoice	tinyint	3	√		null
svy_qst_constraint	constraint_fi	int	10			0
svy_constraint	constraint_id	int	10			0
crs_settings	contact_consultation	varchar	4000	√		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
ilinc_data	contact_responsibili	varchar	255	√		null
crs_settings	contact_responsibility	varchar	255	√		null
ecs_container_mapping	container_id	int	10			0
loc_rnd_qpl	container_id	int	10			0
loc_tst_run	container_id	int	10			0
il_html_block	content	varchar	4000	√		null
il_news_item	content	longtext	2147483647	√		null
page_history	content	longtext	2147483647	√		null
page_layout	content	longtext	2147483647	√		null
page_object	content	longtext	2147483647	√		null
personal_pc_clipboard	content	longtext	2147483647	√		null
xhtml_page	content	longtext	2147483647	√		null
ecs_import	content_id	varchar	255	√		null
il_news_item	content_is_lang_var	tinyint	3	√		0
il_news_item	content_long	longtext	2147483647	√		null
il_news_item	content_text_is_lang_var	tinyint	3			0
il_news_item	content_type	char	5	√		text
il_meta_educational	context	varchar	16	√		null
table_templates	context	varchar	128
cal_entries	context_id	int	10			0
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
payment_currencies	conversion_rate	double	22			0
map_area	coords	varchar	200	√		null
qpl_a_imagemap	coords	varchar	4000	√		null
copy_wizard_options	copy_id	int	10			0
tst_rnd_cpy	copy_id	int	10
il_md_cpr_selections	copyright	longtext	2147483647	√		null
aicc_units	core_vendor	varchar	4000	√		null
qpl_qst_textsubset	correctanswers	int	10	√		0
qpl_a_kprim	correctness	tinyint	3			0
qpl_fb_generic	correctness	varchar	1	√		0
tst_seq_qst_answstatus	correctness	tinyint	3			0
payment_vendors	cost_center	varchar	16	√		null
il_md_cpr_selections	costs	tinyint	3			0
il_meta_rights	costs	char	3	√		null
tst_tests	count_system	varchar	1	√		0
obj_user_stat	counter	int	10	√		null
payment_statistic	country	varchar	40	√		null
usr_data	country	varchar	40	√		null
aicc_course	course_creator	varchar	255	√		null
udf_definition	course_export	tinyint	3			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	10			0
loc_user_results	course_id	int	10			0
aicc_course	course_system	varchar	50	√		null
aicc_course	course_title	varchar	255	√		null
il_meta_general	coverage	varchar	4000	√		null
il_meta_general	coverage_language	char	2	√		null
cmi_node	cp_node_id	int	10			0
cp_auxilaryresource	cp_node_id	int	10			0
cp_condition	cp_node_id	int	10			0
cp_datamap	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			0
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
il_meta_rights	cpr_and_or	char	3	√		null
il_md_cpr_selections	cpr_restrictions	tinyint	3			1
cal_shared	create_date	datetime	19	√		null
export_file_info	create_date	datetime	19
glossary_term	create_date	datetime	19	√		null
il_dcl_record	create_date	datetime	19	√		null
lm_data	create_date	datetime	19	√		null
lm_data_transl	create_date	datetime	19	√		null
object_data	create_date	datetime	19	√		null
orgu_types	create_date	datetime	19	√		null
sahs_sc13_tree_node	create_date	datetime	19	√		null
skl_tree_node	create_date	datetime	19	√		null
tax_node	create_date	datetime	19	√		null
usr_data	create_date	datetime	19	√		null
webr_items	create_date	int	10			0
ecs_cmap_rule	create_subdir	tinyint	3
page_object	create_user	int	10	√		null
chatroom_prooms	created	int	10			0
cmi_node	created	varchar	20	√		null
cp_package	created	varchar	20	√		null
crs_objectives	created	int	10			0
il_blog_posting	created	datetime	19
il_log	created	datetime	19	√		null
page_object	created	datetime	19	√		null
qpl_questions	created	int	10			0
rbac_log	created	int	10
skl_self_eval	created	datetime	19
svy_question	created	varchar	14	√		null
svy_svy	created	int	10			0
tst_tests	created	int	10			0
addressbook_mlist	createdate	datetime	19	√		null
usr_session	createtime	int	10	√		null
il_news_item	creation_date	datetime	19	√		null
note	creation_date	datetime	19	√		null
payment_news	creation_date	datetime	19	√		null
cmi_node	credit	varchar	32	√		null
sahs_lm	credit	varchar	10	√		credit
mail_options	cronjob_notification	tinyint	3			0
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			0
ecs_node_mapping_a	cs_id	int	10			0
ecs_node_mapping_a	cs_root	int	10			0
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_statistic	currency_unit	varchar	16	√		null
style_parameter	custom	tinyint	3			0
qpl_qst_kprim	custom_false	varchar	255	√		null
qpl_qst_kprim	custom_true	varchar	255	√		null
payment_shopping_cart	customer_id	int	10			0
payment_statistic	customer_id	int	10			0
tst_tests	customstyle	varchar	128	√		null
cp_suspend	data	longtext	2147483647	√		null
pg_amd_page_list	data	varchar	4000	√		null
rbac_log	data	longtext	2147483647	√		null
usr_session	data	longtext	2147483647	√		null
il_bibl_entry	data_id	int	10	√		null
cp_item	datafromlms	varchar	4000	√		null
sc_item	datafromlms	longtext	2147483647	√		null
il_dcl_datatype_prop	datatype_id	int	10	√		null
il_dcl_field	datatype_id	int	10
il_dcl_field_prop	datatype_prop_id	int	10
booking_reservation	date_from	int	10
ecs_container_mapping	date_range_end	int	10			0
ecs_container_mapping	date_range_start	int	10			0
booking_reservation	date_to	int	10
dav_lock	dav_owner	varchar	200	√		null
booking_schedule_slot	day_id	varchar	2
il_plugin	db_version	int	10			0
obj_lp_stat	dd	tinyint	3
obj_stat	dd	tinyint	3	√		null
obj_stat_log	dd	tinyint	3	√		null
obj_stat_tmp	dd	tinyint	3	√		null
obj_type_stat	dd	tinyint	3
obj_user_stat	dd	tinyint	3
booking_entry	deadline	int	10
booking_schedule	deadline	int	10	√		null
sahs_lm	debug	varchar	1			n
sahs_lm	debugpw	varchar	50	√		n
il_media_cast_data	def_access	tinyint	3	√		0
copg_pc_def	def_enabled	tinyint	3	√		0
qpl_a_mdef	def_id	int	10
tst_rnd_quest_set_qpls	def_id	int	10			0
chatroom_admconfig	default_config	tinyint	3			0
mep_data	default_height	int	10	√		null
orgu_types	default_lang	varchar	4
content_object	default_layout	varchar	100	√		toc2win
sahs_lm	default_lesson_mode	varchar	8	√		normal
sc_organizations	default_organization	varchar	200	√		null
il_object_def	default_pos	int	10			0
il_object_def	default_pres_pos	int	10			0
il_object_group	default_pres_pos	int	10			0
il_dcl_table	default_sort_field_id	varchar	16			0
il_dcl_table	default_sort_field_order	varchar	4			asc
frm_settings	default_view	int	10			0
mep_data	default_width	int	10	√		null
cp_manifest	defaultorganization	varchar	50	√		null
tst_test_defaults	defaults	longtext	2147483647	√		null
svy_category	defaultvalue	varchar	1	√		0
svy_phrase	defaultvalue	varchar	1	√		0
qpl_a_mdef	definition	varchar	1000	√		null
qpl_a_matching	definition_fi	int	10			0
wiki_stat	del_pages	int	10
il_dcl_table	delete_perm	tinyint	3			1
ecs_cms_data	deleted	tinyint	3			0
object_reference	deleted	datetime	19	√		null
object_reference_ws	deleted	datetime	19	√		null
wiki_stat_page	deleted	tinyint	3			0
usr_data	delicious	varchar	40	√		null
cmi_node	delivery_speed	double	22	√		null
cal_registrations	dend	int	10			0
usr_data	department	varchar	80	√		null
bookmark_tree	depth	smallint	5			0
cp_tree	depth	int	10	√		null
dav_lock	depth	int	10			0
ecs_cms_tree	depth	int	10	√		null
frm_posts_tree	depth	int	10			0
lm_tree	depth	smallint	5			0
mail_tree	depth	smallint	5			0
mep_tree	depth	smallint	5			0
qpl_a_ordering	depth	int	10			0
sahs_sc13_seq_tree	depth	smallint	5	√		null
sahs_sc13_tree	depth	smallint	5			0
scorm_tree	depth	smallint	5			0
search_tree	depth	smallint	5			0
skl_tree	depth	smallint	5			0
tax_tree	depth	smallint	5			0
tree	depth	smallint	5			0
tree_workspace	depth	smallint	5			0
addressbook_mlist	description	varchar	4000	√		null
adm_settings_template	description	longtext	2147483647	√		null
adv_md_record	description	varchar	4000	√		null
adv_mdf_definition	description	varchar	2000	√		null
aicc_course	description	longtext	2147483647	√		null
aicc_object	description	longtext	2147483647	√		null
booking_object	description	varchar	1000	√		null
bookmark_data	description	varchar	255	√		null
cal_entries	description	varchar	4000	√		null
chat_records	description	varchar	4000	√		null
cmi_interaction	description	longtext	2147483647	√		null
cmi_objective	description	longtext	2147483647	√		null
crs_objectives	description	varchar	500	√		null
didactic_tpl_settings	description	varchar	512	√		null
event	description	varchar	4000	√		null
feedback_items	description	longtext	2147483647	√		null
il_dcl_field	description	longtext	2147483647	√		null
il_dcl_table	description	varchar	4000	√		null
il_md_cpr_selections	description	longtext	2147483647	√		null
il_meta_annotation	description	longtext	2147483647	√		null
il_meta_classification	description	varchar	4000	√		null
il_meta_description	description	longtext	2147483647	√		null
il_meta_rights	description	varchar	4000	√		null
il_rating_cat	description	varchar	1000	√		null
notification_channels	description	varchar	4000
notification_types	description	varchar	100
object_data	description	char	128	√		null
object_description	description	longtext	2147483647	√		null
object_translation	description	varchar	4000	√		null
page_layout	description	varchar	255	√		null
payment_erp	description	varchar	2000	√		null
payment_prices	description	varchar	255	√		null
qpl_questions	description	varchar	1000	√		null
rbac_operations	description	char	255	√		null
skl_level	description	longtext	2147483647	√		null
skl_profile	description	varchar	4000	√		null
svy_question	description	varchar	200	√		null
webr_items	description	varchar	4000	√		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	varchar	4000	√		null
il_exc_team_log	details	varchar	500	√		null
aicc_object	developer_id	varchar	50	√		null
il_object_def	devmode	tinyint	3			0
il_meta_educational	difficulty	varchar	16	√		null
module_class	dir	varchar	200	√		null
service_class	dir	varchar	200	√		null
copg_pc_def	directory	varchar	40	√		null
copg_pobj_def	directory	varchar	40	√		null
ecs_cmap_rule	directory	varchar	64	√		null
webr_items	disable_check	tinyint	3	√		null
content_object	disable_def_feedback	int	10			0
adv_md_values_date	disabled	tinyint	3			0
adv_md_values_datetime	disabled	tinyint	3			0
adv_md_values_float	disabled	tinyint	3			0
adv_md_values_int	disabled	tinyint	3			0
adv_md_values_location	disabled	tinyint	3			0
adv_md_values_text	disabled	tinyint	3			0
notification_listener	disabled	tinyint	3
chatroom_psessions	disconnected	int	10
chatroom_sessions	disconnected	int	10
payment_statistic	discount	double	22			0
role_data	disk_quota	bigint	19			0
chatroom_settings	display_past_msgs	int	10			0
ldap_rg_mapping	dn	varchar	255	√		null
ldap_role_assignments	dn	varchar	1000	√		null
reg_er_assignments	domain	varchar	128	√		null
exc_usr_tutor	download_time	datetime	19	√		null
il_media_cast_data	downloadable	tinyint	3	√		0
content_object	downloads_active	char	1	√		n
glossary	downloads_active	char	1	√		n
content_object	downloads_public_active	char	1	√		y
cal_registrations	dstart	int	10			0
ecs_part_settings	dtoken	tinyint	3			1
benchmark	duration	double	22	√		null
ecs_server	duration	int	10	√		0
il_meta_technical	duration	varchar	4000	√		null
payment_prices	duration	int	10			0
payment_statistic	duration	char	16	√		null
payment_prices	duration_from	date	10	√		null
payment_prices	duration_until	date	10	√		null
event_participants	e_comment	longtext	2147483647	√		null
event_appointment	e_end	datetime	19	√		null
event_appointment	e_start	datetime	19	√		null
crs_items	earliest_start	int	10			0
ecs_export	econtent_id	int	10			0
ecs_import	econtent_id	varchar	512	√		null
ecs_server	econtent_rcp	varchar	512	√		null
ecs_data_mapping	ecs_field	varchar	32
ecs_import	ecs_id	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	double	22	√		null
tst_tests	ects_output	varchar	1	√		0
il_dcl_table	edit_by_owner	tinyint	3			1
page_object	edit_lock_ts	int	10			0
page_object	edit_lock_user	int	10	√		null
il_dcl_table	edit_perm	tinyint	3			1
sahs_lm	editable	int	10			0
obj_user_data_hist	editing_time	datetime	19	√		null
qpl_qst_ordering	element_height	int	10	√		null
addressbook	email	varchar	80	√		null
cal_notification	email	varchar	64	√		null
usr_data	email	varchar	80	√		null
payment_statistic	email_extern	varchar	80	√		null
il_wiki_data	empty_page_templ	tinyint	3			1
tst_tests	enable_archiving	tinyint	3	√		null
crs_settings	enable_course_map	tinyint	3			0
tst_tests	enable_examview	tinyint	3	√		null
chatroom_settings	enable_history	tinyint	3	√		0
tst_tests	enable_processing_time	varchar	1	√		0
didactic_tpl_settings	enabled	tinyint	3
openid_provider	enabled	tinyint	3	√		null
tst_tests	enabled_view_mode	varchar	20	√		0
grp_settings	enablemap	tinyint	3			0
usr_session_stats_raw	end_context	smallint	5	√		null
il_news_item	end_date	datetime	19	√		null
chat_records	end_time	int	10			0
usr_session_stats_raw	end_time	int	10	√		null
cal_entries	enda	datetime	19	√		null
svy_svy	enddate	varchar	14	√		null
event_appointment	ending_time	int	10			0
tst_tests	ending_time	varchar	14	√		null
tst_tests	ending_time_enabled	tinyint	3	√		null
feedback_items	endtime	int	10	√		0
cp_sequencing	endtimelimit	varchar	20	√		null
sahs_sc13_seq_seq	endtimelimit	varchar	20	√		null
svy_times	entered_page	int	10	√		null
il_meta_annotation	entity	longtext	2147483647	√		null
il_meta_entity	entity	varchar	4000	√		null
il_meta_identifier	entry	varchar	4000	√		null
il_meta_identifier_	entry	varchar	4000	√		null
booking_user	entry_id	int	10
cache_clob	entry_id	varchar	50
cache_text	entry_id	varchar	50
chat_room_messages	entry_id	int	10			0
il_bibl_attribute	entry_id	int	10	√		null
il_md_cpr_selections	entry_id	int	10			0
sahs_lm	entry_page	int	10			0
payment_erp	erp_id	int	10
payment_erps	erp_id	int	10			0
payment_erp	erp_short	varchar	12
payment_erps	erps_id	int	10			0
qpl_qst_errortext	errortext	varchar	4000
ecs_remote_user	eru_id	int	10			0
svy_svy	evaluation_access	varchar	1	√		0
ecs_events	event_id	int	10			0
event	event_id	int	10			0
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
tst_pass_result	exam_id	varchar	128	√		null
tst_tests	examid_in_test_pass	int	10			0
tst_tests	examid_in_test_res	int	10			0
exc_assignment	exc_id	int	10
cal_rec_exclusion	excl_date	date	10	√		null
cal_rec_exclusion	excl_id	int	10
cache_clob	expire_time	int	10
cache_text	expire_time	int	10
dav_lock	expires	int	10			0
usr_pwassist	expires	int	10			0
usr_session	expires	int	10			0
ecs_part_settings	export	tinyint	3
il_object_def	export	tinyint	3			0
udf_definition	export	tinyint	3			0
il_dcl_table	export_enabled	tinyint	3	√		null
export_options	export_id	smallint	5
export_file_info	export_type	varchar	32
ecs_part_settings	export_types	varchar	4000	√		null
tst_tests	exportsettings	int	10			0
usr_data	ext_account	varchar	250	√		null
reg_registration_codes	ext_enabled	tinyint	3			0
wiki_stat_page	ext_links	int	10
acl_ws	extended_data	varchar	200	√		null
usr_portf_acl	extended_data	varchar	200	√		null
payment_prices	extension	tinyint	3			0
qpl_questions	external_id	varchar	255	√		null
svy_material	external_link	varchar	500	√		null
svy_anonymous	externaldata	varchar	4000	√		null
file_data	f_mode	char	8	√		object
il_qpl_qst_fq_unit	factor	double	22			0
obj_lp_stat	failed	int	10	√		null
tst_result_cache	failed	int	10
usr_search	failed	longtext	2147483647	√		null
usr_data	fax	varchar	40	√		null
exc_assignment	fb_cron	tinyint	3			0
exc_assignment	fb_cron_done	tinyint	3			0
exc_assignment	fb_date	tinyint	3			1
exc_assignment	fb_file	varchar	1000	√		null
feedback_items	fb_id	int	10			0
feedback_results	fb_id	int	10			0
usr_data	feed_hash	varchar	32	√		null
il_external_feed_block	feed_url	varchar	250	√		null
exc_mem_ass_status	feedback	tinyint	3			0
exc_members	feedback	tinyint	3			0
qpl_fb_generic	feedback	longtext	2147483647	√		null
qpl_fb_specific	feedback	longtext	2147483647	√		null
tst_manual_fb	feedback	longtext	2147483647	√		null
qpl_fb_generic	feedback_id	int	10			0
qpl_fb_specific	feedback_id	int	10
qpl_qst_kprim	feedback_setting	int	10			1
qpl_qst_mc	feedback_setting	tinyint	3			1
qpl_qst_sc	feedback_setting	tinyint	3	√		2
exc_mem_ass_status	feedback_time	datetime	19	√		null
exc_members	feedback_time	datetime	19	√		null
il_dcl_viewdefinition	field	varchar	255
adv_md_values_date	field_id	int	10			0
adv_md_values_datetime	field_id	int	10			0
adv_md_values_float	field_id	int	10			0
adv_md_values_int	field_id	int	10			0
adv_md_values_location	field_id	int	10			0
adv_md_values_text	field_id	int	10			0
adv_mdf_definition	field_id	int	10			0
crs_f_definitions	field_id	int	10			0
crs_user_data	field_id	int	10			0
glo_advmd_col_order	field_id	int	10
il_dcl_field_prop	field_id	int	10
il_dcl_record_field	field_id	int	10
pg_amd_page_list	field_id	int	10			0
udf_clob	field_id	int	10
udf_definition	field_id	int	10			0
udf_text	field_id	int	10
usr_data_multi	field_id	varchar	255
crs_f_definitions	field_name	varchar	255	√		null
ecs_container_mapping	field_name	varchar	255	√		null
udf_definition	field_name	char	255	√		null
il_dcl_viewdefinition	field_order	int	10
crs_f_definitions	field_required	tinyint	3			0
adv_mdf_definition	field_type	tinyint	3			0
crs_f_definitions	field_type	tinyint	3			0
udf_definition	field_type	tinyint	3			0
adv_mdf_definition	field_values	varchar	4000	√		null
crs_f_definitions	field_values	longtext	2147483647	√		null
udf_definition	field_values	longtext	2147483647	√		null
crs_f_definitions	field_values_opt	varchar	1000	√		null
crs_file	file_id	int	10			0
event_file	file_id	int	10			0
file_data	file_id	int	10			0
svy_material	file_material	varchar	200	√		null
aicc_units	file_name	varchar	255	√		null
crs_file	file_name	char	64	√		null
event_file	file_name	char	64	√		null
export_file_info	file_name	varchar	64
file_data	file_name	char	250	√		null
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	√		null
event_file	file_type	char	64	√		null
file_data	file_type	char	250	√		null
chatroom_uploads	filename	varchar	200
ctrl_classfile	filename	varchar	250	√		null
exc_returned	filename	varchar	1000	√		null
export_file_info	filename	varchar	64
il_bibl_data	filename	varchar	256	√		null
sahs_sc13_seq_templts	filename	varchar	50	√		null
exc_returned	filetitle	varchar	1000	√		null
chatroom_uploads	filetype	varchar	200
il_bibl_overview_model	filetype	varchar	8	√		null
ecs_cmap_rule	filter	varchar	512	√		null
ldap_server_settings	filter	varchar	512	√		null
didactic_tpl_abr	filter_type	tinyint	3
didactic_tpl_alp	filter_type	tinyint	3
tst_tests	finalstatement	varchar	4000	√		null
search_command_queue	finished	tinyint	3			0
tst_times	finished	datetime	19	√		null
svy_times	finished_fi	int	10
svy_finished	finished_id	int	10			0
read_event	first_access	datetime	19	√		null
sahs_user	first_access	datetime	19	√		null
svy_times	first_question	int	10	√		null
feedback_items	first_vote_best	tinyint	3	√		0
addressbook	firstname	varchar	40	√		null
usr_data	firstname	varchar	32	√		null
tst_tests	fixed_participants	varchar	1	√		0
qpl_qst_cloze	fixed_textlen	int	10	√		null
cp_sequencing	flow	tinyint	3	√		null
sahs_sc13_seq_course	flow	tinyint	3	√		0
sahs_sc13_seq_seq	flow	tinyint	3	√		null
mail	folder_id	int	10			0
style_folder_styles	folder_id	int	10			0
il_blog	font_color	char	6	√		null
usr_portfolio	font_color	char	6	√		null
content_object	footer_page	int	10			0
wiki_stat_page	footnotes	int	10
tst_tests	forcejs	int	10			0
mep_item	foreign_id	int	10	√		null
il_meta_format	format	varchar	255	√		null
media_item	format	varchar	200	√		null
il_dcl_view	formtype	tinyint	3	√		null
il_qpl_qst_fq_res	formula	longtext	2147483647	√		null
ctrl_structure	forward	longtext	2147483647	√		null
cp_sequencing	forwardonly	tinyint	3	√		null
sahs_sc13_seq_course	forwardonly	tinyint	3	√		0
sahs_sc13_seq_seq	forwardonly	tinyint	3	√		null
sahs_lm	fourth_edition	varchar	1			n
frm_posts_tree	fpt_date	datetime	19	√		null
frm_posts_tree	fpt_pk	bigint	19			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
frm_notification	frm_id	int	10			0
obj_lp_stat	fulldate	int	10
obj_type_stat	fulldate	int	10
obj_user_stat	fulldate	int	10
cal_entries	fullday	tinyint	3			0
event_appointment	fulltime	tinyint	3			0
acc_access_key	function_id	int	10
acc_user_access_key	function_id	smallint	5
qpl_a_cloze_combi_res	gap_fi	int	10
qpl_a_cloze	gap_id	smallint	5			0
qpl_a_cloze	gap_size	int	10			0
usr_data	gender	char	1	√		m
il_meta_general	general_structure	varchar	16	√		null
reg_registration_codes	generated	int	10	√		0
usr_account_codes	generated	int	10	√		0
exc_assignment_peer	giver_id	int	10
glo_advmd_col_order	glo_id	int	10
glossary_term	glo_id	int	10			0
lm_glossaries	glo_id	int	10			0
glossary	glo_menu_active	char	1	√		y
ecs_server	global_role	int	10	√		0
cp_package	global_to_system	tinyint	3			1
sahs_lm	glossary	int	10			0
last_visited	goto_link	varchar	1000	√		null
ldap_server_settings	group_attribute	varchar	64	√		null
ldap_server_settings	group_dn	varchar	255	√		null
udf_definition	group_export	tinyint	3	√		0
ldap_server_settings	group_filter	varchar	255	√		null
booking_reservation	group_id	int	10	√		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
ut_lp_collections	grouping_id	int	10			0
il_object_def	grp	char	10	√		null
cal_ch_group	grp_id	int	10
sysc_tasks	grp_id	int	10
grp_settings	grp_type	tinyint	3			0
chat_invitations	guest_id	int	10			0
chat_invitations	guest_informed	tinyint	3			0
media_item	halign	char	10	√		Left
svy_360_appr	has_closed	int	10	√		0
cal_auth_token	hash	varchar	32
sahs_user	hash	varchar	20	√		null
tos_versions	hash	varchar	32	√		null
sahs_user	hash_end	datetime	19	√		null
history	hdate	datetime	19	√		null
page_history	hdate	datetime	19
content_object	header_page	int	10			0
svy_svy_qst	heading	varchar	4000	√		null
media_item	height	varchar	10	√		null
qpl_qst_flash	height	int	10			400
sahs_lm	height	smallint	5			650
svy_qst_text	height	int	10			5
obj_stat	hh	tinyint	3	√		null
obj_stat_log	hh	tinyint	3	√		null
obj_stat_tmp	hh	tinyint	3	√		null
tst_sequence	hidden	varchar	4000	√		null
conditions	hidden_status	tinyint	3	√		0
adm_set_templ_value	hide	tinyint	3	√		null
style_char	hide	tinyint	3			0
il_wiki_page	hide_adv_md	tinyint	3	√		0
adv_md_substitutions	hide_description	tinyint	3			0
adv_md_substitutions	hide_field_names	tinyint	3			0
content_object	hide_head_foot_print	tinyint	3			0
sahs_lm	hide_navig	varchar	1			n
sahs_sc13_sco	hide_obj_page	tinyint	3			0
map_area	highlight_class	varchar	8	√		null
map_area	highlight_mode	varchar	8	√		null
tst_tests	highscore_achieved_ts	int	10	√		0
tst_tests	highscore_anon	int	10	√		0
tst_tests	highscore_enabled	int	10	√		0
tst_tests	highscore_hints	int	10	√		0
tst_tests	highscore_own_table	int	10	√		0
tst_tests	highscore_percentage	int	10	√		0
tst_tests	highscore_score	int	10	√		0
tst_tests	highscore_top_num	int	10	√		0
tst_tests	highscore_top_table	int	10	√		0
tst_tests	highscore_wtime	int	10	√		0
tst_pass_result	hint_count	int	10	√		0
tst_result_cache	hint_count	int	10	√		0
tst_test_result	hint_count	int	10	√		0
tst_pass_result	hint_points	double	22	√		0
tst_result_cache	hint_points	double	22	√		0
tst_test_result	hint_points	double	22	√		0
content_object	hist_user_comments	char	1	√		n
loginname_history	history_date	int	10
usr_data	hobby	varchar	4000	√		null
cp_file	href	varchar	4000	√		null
cp_resource	href	varchar	4000	√		null
map_area	href	varchar	200	√		null
sc_resource	href	varchar	250	√		null
sc_resource_file	href	varchar	4000	√		null
link_check	http_status_code	int	10			0
ilinc_data	i_type	varchar	5	√		null
cal_auth_token	ical	longtext	2147483647	√		null
orgu_types	icon	varchar	256	√		null
adm_settings_template	id	int	10
cmi_interaction	id	varchar	255	√		null
cmi_objective	id	varchar	4000	√		null
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
didactic_tpl_a	id	int	10
didactic_tpl_sa	id	int	10
didactic_tpl_settings	id	int	10
ecs_course_assignments	id	int	10
ecs_crs_mapping_atts	id	int	10
ecs_events	id	int	10			0
exc_assignment	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			0
glossary_term	id	int	10			0
help_module	id	int	10			0
help_tooltip	id	int	10
history	id	int	10			0
il_bibl_attribute	id	int	10			0
il_bibl_data	id	int	10			0
il_bibl_entry	id	int	10			0
il_bibl_settings	id	int	10			0
il_blog	id	int	10			0
il_blog_posting	id	int	10			0
il_cld_data	id	int	10
il_component	id	char	10
il_custom_block	id	int	10			0
il_dcl_data	id	int	10
il_dcl_datatype	id	int	10
il_dcl_datatype_prop	id	int	10
il_dcl_field	id	int	10
il_dcl_field_prop	id	int	10
il_dcl_record	id	int	10
il_dcl_record_field	id	int	10
il_dcl_stloc1_value	id	int	10
il_dcl_stloc2_value	id	int	10
il_dcl_stloc3_value	id	int	10
il_dcl_table	id	int	10
il_dcl_view	id	int	10
il_event_handling	id	varchar	100
il_exc_team	id	int	10
il_external_feed_block	id	int	10			0
il_html_block	id	int	10			0
il_media_cast_data	id	int	10			0
il_new_item_grp	id	int	10			0
il_news_item	id	int	10			0
il_object_def	id	char	10
il_object_group	id	char	10
il_pluginslot	id	char	10
il_poll	id	int	10
il_poll_answer	id	int	10
il_rating_cat	id	int	10
il_verification	id	int	10
il_wiki_data	id	int	10			0
il_wiki_page	id	int	10			0
lm_data_transl	id	int	10
lm_menu	id	int	10			0
media_item	id	int	10			0
mep_data	id	int	10
mob_usage	id	int	10			0
note	id	int	10			0
notification	id	int	10
orgu_types	id	int	10			0
pg_amd_page_list	id	int	10			0
sahs_lm	id	int	10			0
sahs_sc13_sco	id	int	10
sahs_sc13_seq_seq	id	varchar	200	√		null
sahs_sc13_seq_templ	id	varchar	50	√		null
sahs_sc13_seq_templts	id	int	10			0
sc_resource_dependen	id	int	10			0
sc_resource_file	id	int	10			0
skl_level	id	int	10
skl_profile	id	int	10
skl_self_eval	id	int	10			0
sty_media_query	id	int	10			0
style_data	id	int	10			0
style_parameter	id	int	10			0
style_template	id	int	10
sysc_groups	id	int	10
sysc_tasks	id	int	10
tax_data	id	int	10			0
tos_versions	id	int	10			0
usr_ext_profile_page	id	int	10			0
usr_form_settings	id	varchar	50
usr_portfolio	id	int	10
usr_portfolio_page	id	int	10
xhtml_page	id	int	10			0
qpl_questionpool	id_questionpool	int	10			0
svy_qpl	id_questionpool	int	10			0
svy_qst_matrixrows	id_svy_qst_matrixrows	int	10			0
qpl_qst_cloze	identical_scoring	varchar	1	√		1
lng_data	identifier	varchar	60
sahs_sc13_seq_assign	identifier	varchar	50	√		null
sahs_sc13_seq_templts	identifier	varchar	50	√		null
sysc_tasks	identifier	varchar	64	√		null
sc_item	identifierref	varchar	200	√		null
sc_resource_dependen	identifierref	varchar	200	√		null
sahs_lm	ie_compatibility	varchar	1	√		null
sahs_lm	ie_force_render	varchar	1			n
il_dcl_datatype	ildb_type	varchar	256
dav_lock	ilias_owner	int	10			0
cache_clob	ilias_version	varchar	10	√		null
cache_text	ilias_version	varchar	10	√		null
page_history	ilias_version	varchar	20	√		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
il_poll	image	varchar	1000	√		null
openid_provider	image	smallint	5	√		null
payment_objects	image	varchar	255	√		null
qpl_qst_imagemap	image_file	varchar	100	√		null
qpl_qst_javaapplet	image_file	varchar	100	√		null
qpl_a_kprim	imagefile	varchar	255	√		null
qpl_a_mc	imagefile	varchar	1000	√		null
qpl_a_sc	imagefile	varchar	1000	√		null
il_bibl_settings	img	varchar	128	√		null
il_blog	img	varchar	255	√		null
usr_portfolio	img	varchar	255	√		null
il_wiki_data	imp_pages	tinyint	3	√		null
skl_skill_resource	imparting	tinyint	3			0
ecs_part_settings	import	tinyint	3
adv_md_record	import_id	varchar	64	√		null
adv_mdf_definition	import_id	varchar	32	√		null
ecs_server	import_id	int	10	√		0
glossary_term	import_id	varchar	50	√		null
lm_data	import_id	varchar	50	√		null
object_data	import_id	char	50	√		null
qpl_sol_sug	import_id	varchar	50	√		null
sahs_sc13_tree_node	import_id	varchar	50	√		null
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
svy_material	import_id	varchar	50	√		null
frm_posts	import_name	varchar	4000	√		null
frm_threads	import_name	varchar	4000	√		null
mail	import_name	varchar	4000	√		null
sahs_sc13_seq_obj	import_objective_id	varchar	200	√		null
ecs_part_settings	import_type	tinyint	3	√		null
ecs_part_settings	import_types	varchar	4000	√		null
crs_settings	important	varchar	4000	√		null
sahs_sc13_seq_item	importid	varchar	32	√		null
sahs_sc13_seq_seq	importid	varchar	32	√		null
sahs_sc13_seq_tree	importid	varchar	32	√		null
tst_active	importname	varchar	400	√		null
sahs_sc13_seq_item	importseqxml	longtext	2147483647	√		null
obj_lp_stat	in_progress	int	10	√		null
usr_data	inactivation_date	datetime	19	√		null
page_object	inactive_elements	tinyint	3	√		0
notification_channels	include	varchar	100
mail_options	incoming_type	tinyint	3	√		null
il_wiki_imp_pages	indent	tinyint	3
didactic_tpl_settings	info	varchar	4000	√		null
booking_object	info_file	varchar	500	√		null
history	info_params	varchar	4000	√		null
grp_settings	information	varchar	4000	√		null
cal_entries	informations	varchar	4000	√		null
il_object_def	inherit	tinyint	3			0
il_dcl_datatype_prop	inputformat	tinyint	3
personal_clipboard	insert_time	datetime	19	√		null
personal_pc_clipboard	insert_time	datetime	19	√		null
tst_tests	inst_fb_answer_fixation	tinyint	3	√		null
chatroom_admconfig	instance_id	int	10
tst_tests	instant_verification	varchar	1	√		0
usr_data	institution	varchar	80	√		null
exc_assignment	instruction	longtext	2147483647	√		null
exc_data	instruction	longtext	2147483647	√		null
cache_clob	int_key_1	int	10	√		null
cache_text	int_key_1	int	10	√		null
cache_clob	int_key_2	int	10	√		null
cache_text	int_key_2	int	10	√		null
copg_pc_def	int_links	tinyint	3			0
page_object	int_links	tinyint	3	√		0
wiki_stat_page	int_links	int	10
il_meta_educational	intended_end_user_role	varchar	16	√		null
sahs_lm	interactions	varchar	1			y
il_meta_educational	interactivity_level	varchar	16	√		null
il_meta_educational	interactivity_type	varchar	16	√		null
qpl_sol_sug	internal_link	varchar	50	√		null
svy_material	internal_link	varchar	50	√		null
feedback_items	interval_unit	tinyint	3	√		null
cal_recurrence_rules	intervall	int	10			0
il_qpl_qst_fq_var	intprecision	int	10			1
tst_tests	intro_enabled	tinyint	3	√		null
il_wiki_data	introduction	longtext	2147483647	√		null
svy_svy	introduction	longtext	2147483647	√		null
tst_tests	introduction	varchar	4000	√		null
svy_svy	invitation	varchar	1	√		0
svy_svy	invitation_mode	varchar	1	√		1
chat_invitations	invitation_time	int	10			0
svy_inv_usr	invited_user_id	int	10			0
il_meta_technical	ir	varchar	4000	√		null
il_meta_technical	ir_language	char	2	√		null
frm_posts	is_author_moderator	tinyint	3	√		null
frm_threads	is_closed	tinyint	3			0
usr_portfolio	is_default	tinyint	3	√		null
page_object	is_empty	tinyint	3			0
ecs_cmap_rule	is_filter	tinyint	3
loc_user_results	is_final	tinyint	3	√		0
il_dcl_field	is_locked	tinyint	3			0
cal_entries	is_milestone	tinyint	3			0
qpl_qst_imagemap	is_multiple_choice	tinyint	3			0
il_tag	is_offline	tinyint	3			0
content_object	is_online	char	1	√		n
file_based_lm	is_online	char	1	√		n
glossary	is_online	char	1	√		n
il_bibl_data	is_online	tinyint	3	√		null
il_cld_data	is_online	tinyint	3	√		null
il_dcl_data	is_online	tinyint	3	√		null
il_media_cast_data	is_online	tinyint	3	√		0
il_wiki_data	is_online	tinyint	3	√		0
usr_portfolio	is_online	tinyint	3	√		null
chatroom_prooms	is_public	tinyint	3	√		1
usr_data	is_self_registered	tinyint	3			0
il_dcl_viewdefinition	is_set	tinyint	3			0
payment_objects	is_special	tinyint	3			0
frm_threads	is_sticky	tinyint	3			0
il_dcl_field	is_unique	tinyint	3			0
il_dcl_table	is_visible	tinyint	3			1
ldap_role_assignments	isdn	tinyint	3			0
payment_currencies	iso_code	varchar	4	√		null
qpl_questionpool	isonline	varchar	1	√		0
svy_qpl	isonline	varchar	1	√		0
cp_item	isvisible	varchar	32	√		null
sc_item	isvisible	varchar	6	√		null
usr_search	item_filter	varchar	1000	√		null
item_group_item	item_group_id	int	10			0
crs_timings_planed	item_id	int	10			0
desktop_item	item_id	int	10			0
event_items	item_id	int	10			0
il_media_cast_data_ord	item_id	int	10
map_area	item_id	int	10			0
personal_clipboard	item_id	int	10			0
role_desktop_items	item_id	int	10			0
tax_node_assignment	item_id	int	10			0
ut_lp_collections	item_id	int	10			0
crs_start	item_ref_id	int	10			0
item_group_item	item_ref_id	int	10			0
tax_data	item_sorting	tinyint	3			0
role_desktop_items	item_type	char	16	√		null
tax_node_assignment	item_type	varchar	20
loc_settings	itest	int	10	√		null
cron_job	job_id	varchar	50
cron_job	job_result_code	varchar	64	√		null
cron_job	job_result_dur	int	10	√		null
cron_job	job_result_message	varchar	400	√		null
cron_job	job_result_status	tinyint	3	√		null
cron_job	job_result_ts	int	10	√		null
cron_job	job_result_type	tinyint	3	√		null
cron_job	job_result_user_id	int	10	√		null
cron_job	job_status	tinyint	3	√		null
cron_job	job_status_ts	int	10	√		null
cron_job	job_status_type	tinyint	3	√		null
cron_job	job_status_user_id	int	10	√		null
cp_package	jsdata	longtext	2147483647	√		null
tst_tests	keep_questions	tinyint	3			0
ecs_server	key_password	varchar	32	√		null
ecs_server	key_path	varchar	512	√		null
container_settings	keyword	char	40
data_cache	keyword	varchar	50
export_options	keyword	smallint	5
il_meta_keyword	keyword	varchar	4000	√		null
ldap_attribute_mapping	keyword	varchar	32
payment_settings	keyword	varchar	50
settings	keyword	varchar	50
svy_settings	keyword	varchar	40
usr_pref	keyword	char	40
il_meta_keyword	keyword_language	char	2	√		null
qpl_qst_essay	keyword_relation	varchar	3			any
il_blog	keywords	tinyint	3			1
qpl_qst_essay	keywords	varchar	4000	√		null
chat_user	kicked	tinyint	3	√		0
il_meta_relation	kind	char	16	√		null
tst_tests	kiosk	int	10			0
note	label	int	10			0
svy_qst_matrixrows	label	varchar	255	√		null
svy_question	label	varchar	255	√		null
copg_multilang_lang	lang	varchar	2
help_tooltip	lang	char	2			de
lm_data_transl	lang	varchar	2
mail_template	lang	varchar	5
orgu_types_trans	lang	varchar	4
page_history	lang	varchar	2			-
page_object	lang	varchar	2			-
lng_modules	lang_array	longtext	2147483647	√		null
object_translation	lang_code	char	2
object_translation	lang_default	tinyint	3			0
acc_access_key	lang_key	char	2
lng_data	lang_key	char	2
lng_modules	lang_key	char	2
glossary_term	language	char	2	√		null
il_md_cpr_selections	language	char	2	√		null
il_meta_language	language	char	2	√		null
il_meta_meta_data	language	char	2	√		null
crs_lm_history	last_access	int	10			0
lm_read_event	last_access	int	10			0
read_event	last_access	int	10	√		null
sahs_user	last_access	datetime	19	√		null
page_object	last_change	datetime	19	√		null
ut_lp_coll_manual	last_change	int	10			0
page_object	last_change_user	int	10	√		null
link_check	last_check	int	10			0
webr_items	last_check	int	10	√		null
chat_user	last_conn_timestamp	int	10	√		null
il_dcl_record	last_edit_by	int	10	√		null
tst_active	last_finished_pass	int	10	√		null
usr_data	last_login	datetime	19	√		null
notification	last_mail	datetime	19	√		null
usr_data	last_password_change	int	10			0
usr_session	last_remind_ts	int	10			0
sahs_user	last_status_change	datetime	19	√		null
cal_entries	last_update	datetime	19	√		null
glossary_term	last_update	datetime	19	√		null
il_dcl_record	last_update	datetime	19	√		null
lm_data	last_update	datetime	19	√		null
lm_data_transl	last_update	datetime	19	√		null
object_data	last_update	datetime	19	√		null
orgu_types	last_update	datetime	19	√		null
sahs_sc13_tree_node	last_update	datetime	19	√		null
search_command_queue	last_update	datetime	19	√		null
skl_self_eval	last_update	datetime	19
skl_self_eval_level	last_update	datetime	19	√		null
skl_tree_node	last_update	datetime	19	√		null
sysc_groups	last_update	datetime	19	√		null
sysc_tasks	last_update	datetime	19	√		null
tax_node	last_update	datetime	19	√		null
usr_data	last_update	datetime	19	√		null
webr_items	last_update	int	10			0
il_plugin	last_update_version	char	10	√		null
sahs_user	last_visited	varchar	255	√		null
usr_data	last_visited	longtext	2147483647	√		null
tst_active	lastindex	int	10			0
addressbook	lastname	varchar	40	√		null
usr_data	lastname	varchar	32	√		null
svy_finished	lastpage	int	10			0
cmi_interaction	latency	varchar	20	√		null
crs_items	latest_end	int	10			0
crs_settings	latitude	varchar	30	√		null
grp_settings	latitude	varchar	30	√		null
usr_data	latitude	varchar	30	√		null
cmi_node	launch_data	longtext	2147483647	√		null
lm_data	layout	varchar	100	√		null
svy_qst_matrix	layout	varchar	4000	√		null
page_layout	layout_id	int	10			0
content_object	layout_per_page	tinyint	3	√		null
cmi_node	learner_name	varchar	255	√		null
cmi_interaction	learner_response	longtext	2147483647	√		null
il_meta_educational	learning_resource_type	varchar	32	√		null
svy_times	left_page	int	10	√		null
svy_qst_matrix	legend	varchar	1	√		0
skl_assigned_material	level_id	int	10			0
skl_profile_level	level_id	int	10
skl_self_eval_level	level_id	int	10			0
skl_skill_resource	level_id	int	10			0
skl_user_has_level	level_id	int	10
skl_user_skill_level	level_id	int	10
svy_skill_threshold	level_id	int	10
bookmark_tree	lft	int	10			0
cp_tree	lft	int	10	√		null
ecs_cms_tree	lft	int	10	√		null
frm_posts_tree	lft	int	10			0
lm_tree	lft	int	10			0
mail_tree	lft	int	10			0
mep_tree	lft	int	10			0
sahs_sc13_seq_tree	lft	int	10	√		null
sahs_sc13_tree	lft	int	10			0
scorm_tree	lft	int	10			0
search_tree	lft	int	10			0
skl_tree	lft	int	10			0
tax_tree	lft	int	10			0
tree	lft	int	10			0
tree_workspace	lft	int	10			0
license_data	licenses	int	10			0
il_meta_lifecycle	lifecycle_status	varchar	16	√		null
reg_access_limit	limit_absolute	int	10	√		null
il_dcl_table	limit_end	datetime	19	√		null
reg_access_limit	limit_mode	char	16	√		absolute
loc_user_results	limit_perc	tinyint	3	√		0
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
il_dcl_table	limit_start	datetime	19	√		null
tst_tests	limit_users_enabled	tinyint	3	√		null
il_dcl_table	limited	tinyint	3			0
mail_options	linebreak	tinyint	3			0
webr_items	link_id	int	10			0
webr_params	link_id	int	10			0
lm_menu	link_ref_id	int	10	√		null
lm_menu	link_type	char	6	√		extern
map_area	link_type	char	3	√		null
il_bibl_overview_model	literature_type	varchar	32	√		null
crs_objective_lm	lm_ass_id	int	10			0
help_module	lm_id	int	10			0
lm_data	lm_id	int	10			0
lm_glossaries	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	char	1	√		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	√		null
addressbook_mlist	lmode	tinyint	3			1
tos_versions	lng	varchar	2	√		null
adv_md_values_location	loc_lat	double	22	√		null
adv_md_values_location	loc_long	double	22	√		null
cal_categories	loc_type	tinyint	3			1
adv_md_values_location	loc_zoom	tinyint	3	√		null
usr_data	loc_zoom	int	10			0
lng_data	local_change	datetime	19	√		null
rcat_settings	local_information	varchar	4000	√		null
remote_course_settings	local_information	varchar	4000	√		null
rfil_settings	local_information	varchar	4000	√		null
rglo_settings	local_information	varchar	4000	√		null
rgrp_settings	local_information	varchar	4000	√		null
rlm_settings	local_information	varchar	4000	√		null
rtst_settings	local_information	varchar	4000	√		null
rwik_settings	local_information	varchar	4000	√		null
sahs_lm	localization	varchar	2	√		null
cal_entries	location	varchar	4000	√		null
cmi_comment	location	varchar	255	√		null
cmi_node	location	varchar	255	√		null
event	location	varchar	4000	√		null
il_meta_location	location	varchar	4000	√		null
il_object_def	location	varchar	250	√		null
media_item	location	varchar	200	√		null
il_meta_location	location_type	varchar	16	√		null
media_item	location_type	char	10	√		LocalFile
crs_settings	location_zoom	int	10			0
grp_settings	location_zoom	int	10			0
il_log	log_level	int	10			0
addressbook	login	varchar	80	√		null
loginname_history	login	varchar	80
usr_data	login	varchar	80	√		null
usr_data	login_attempts	tinyint	3			0
ass_log	logtext	varchar	4000	√		null
crs_settings	longitude	varchar	30	√		null
grp_settings	longitude	varchar	30	√		null
usr_data	longitude	varchar	30	√		null
svy_relation	longname	varchar	20	√		null
qpl_a_cloze	lowerlimit	varchar	20	√		0
qpl_num_range	lowerlimit	varchar	20	√		0
ut_lp_collections	lpmode	tinyint	3	√		5
skl_skill_resource	ltrigger	tinyint	3			0
cmi_custom	lvalue	varchar	64
scorm_tracking	lvalue	varchar	64
mail	m_email	tinyint	3	√		null
mail_saved	m_email	tinyint	3	√		null
mail	m_message	longtext	2147483647	√		null
mail_saved	m_message	longtext	2147483647	√		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_obj_data	m_type	char	16	√		null
mail_saved	m_type	varchar	255	√		null
mail	mail_id	int	10			0
mail_attachment	mail_id	int	10			0
crs_settings	mail_members_type	tinyint	3	√		1
grp_settings	mail_members_type	tinyint	3	√		1
svy_360_rater	mail_sent	int	10	√		0
svy_svy	mailaddresses	varchar	2000	√		null
svy_svy	mailnotification	tinyint	3	√		null
tst_tests	mailnotification	tinyint	3	√		0
tst_tests	mailnottype	smallint	5			0
svy_svy	mailparticipantdata	varchar	4000	√		null
il_dcl_data	main_table_id	int	10
exc_assignment	mandatory	tinyint	3	√		1
tst_test_result	manual	tinyint	3			0
tst_manual_fb	manual_feedback_id	int	10			0
tst_rnd_quest_set_qpls	mapped_node_fi	int	10	√		null
tst_rnd_quest_set_qpls	mapped_tax_fi	int	10	√		null
ecs_container_mapping	mapping_id	int	10			0
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
ecs_container_mapping	mapping_type	tinyint	3			0
ecs_data_mapping	mapping_type	tinyint	3			0
ecs_container_mapping	mapping_value	varchar	255	√		null
event_participants	mark	longtext	2147483647	√		null
exc_mem_ass_status	mark	varchar	32	√		null
ut_lp_marks	mark	varchar	32	√		null
tst_mark	mark_id	int	10			0
frm_settings	mark_mod_posts	tinyint	3			0
tst_result_cache	mark_official	varchar	256
tst_result_cache	mark_short	varchar	256
tst_test_defaults	marks	longtext	2147483647	√		null
copg_multilang	master_lang	varchar	2
obj_content_master_lng	master_lang	varchar	2
aicc_units	mastery_score	int	10			0
sc_item	masteryscore	varchar	200	√		null
qpl_qst_essay	matchcondition	smallint	5			0
qpl_qst_matching	matching_mode	varchar	3	√		null
qpl_qst_matching	matching_type	varchar	1	√		1
svy_material	material_id	int	10			0
svy_material	material_title	varchar	255	√		null
svy_material	material_type	int	10	√		0
usr_data	matriculation	varchar	40	√		null
il_poll	max_answers	tinyint	3			1
sahs_lm	max_attempt	int	10	√		0
aicc_course	max_fields_cst	int	10	√		0
aicc_course	max_fields_ort	int	10	√		0
aicc_course	max_normal	tinyint	3	√		null
loc_tst_run	max_points	int	10	√		0
tst_result_cache	max_points	double	22			0
aicc_units	max_score	double	22	√		null
usr_session_stats	max_sessions	int	10	√		null
aicc_units	max_time_allowed	time	8	√		null
svy_qst_text	maxchars	int	10	√		null
qpl_qst_essay	maxnumofchars	int	10			0
qpl_qst_numeric	maxnumofchars	int	10			0
tst_pass_result	maxpoints	double	22			0
qpl_qst_fileupload	maxsize	double	22	√		null
sc_item	maxtimeallowed	varchar	30	√		null
usr_session_log	maxval	mediumint	7
tst_tests	mc_scoring	varchar	1	√		0
cmi_gobjective	measure	varchar	50	√		null
sahs_sc13_seq_seq	measuresatisfactionifactive	tinyint	3	√		null
cp_sequencing	measuresatisfactive	tinyint	3	√		null
cp_condition	measurethreshold	varchar	50	√		null
sahs_sc13_seq_cond	measurethreshold	varchar	50	√		null
mob_parameter	med_item_id	int	10			0
obj_lp_stat	mem_cnt	int	10	√		null
orgu_types_trans	member	varchar	32
ldap_rg_mapping	member_attribute	varchar	64	√		null
ldap_rg_mapping	member_isdn	tinyint	3			0
mep_tree	mep_id	int	10			0
chat_record_data	message	varchar	4000	√		null
chat_room_messages	message	varchar	4000	√		null
chatroom_history	message	varchar	4000
il_log	message	varchar	250	√		null
il_meta_annotation	meta_annotation_id	int	10			0
il_meta_classification	meta_classification_id	int	10			0
il_meta_contribute	meta_contribute_id	int	10			0
il_meta_meta_data	meta_data_scheme	char	16	√		null
il_meta_description	meta_description_id	int	10			0
il_meta_educational	meta_educational_id	int	10			0
il_meta_entity	meta_entity_id	int	10			0
il_meta_format	meta_format_id	int	10			0
il_meta_general	meta_general_id	int	10			0
il_meta_identifier_	meta_identifier__id	int	10			0
il_meta_identifier	meta_identifier_id	int	10			0
il_meta_keyword	meta_keyword_id	int	10			0
il_meta_language	meta_language_id	int	10			0
il_meta_lifecycle	meta_lifecycle_id	int	10			0
il_meta_location	meta_location_id	int	10			0
il_meta_meta_data	meta_meta_data_id	int	10			0
il_meta_relation	meta_relation_id	int	10			0
il_meta_requirement	meta_requirement_id	int	10			0
il_meta_rights	meta_rights_id	int	10			0
il_meta_tar	meta_tar_id	int	10			0
il_meta_taxon	meta_taxon_id	int	10			0
il_meta_taxon_path	meta_taxon_path_id	int	10			0
il_meta_technical	meta_technical_id	int	10			0
il_meta_lifecycle	meta_version	varchar	4000	√		null
ecs_cmap_rule	mid	int	10
ecs_cms_data	mid	int	10	√		null
ecs_course_assignments	mid	int	10
ecs_crs_mapping_atts	mid	int	10
ecs_import	mid	int	10			0
ecs_node_mapping_a	mid	int	10			0
ecs_part_settings	mid	int	10
ecs_remote_user	mid	int	10			0
rcat_settings	mid	int	10
remote_course_settings	mid	int	10			0
rfil_settings	mid	int	10
rglo_settings	mid	int	10
rgrp_settings	mid	int	10
rlm_settings	mid	int	10
rtst_settings	mid	int	10
rwik_settings	mid	int	10
ecs_community	mids	varchar	512	√		null
ldap_server_settings	migration	tinyint	3			0
usr_search	mime_filter	varchar	1000	√		null
exc_returned	mimetype	varchar	40	√		null
tst_mark	minimum_level	double	22			0
cp_rule	minimumcount	int	10	√		null
sahs_sc13_seq_rule	minimumcount	int	10	√		null
cp_rule	minimumpercent	varchar	50	√		null
sahs_sc13_seq_rule	minimumpercent	varchar	50	√		null
sahs_sc13_seq_obj	minnormalizedmeasure	varchar	50	√		null
cp_objective	minnormalmeasure	varchar	50	√		null
addressbook_mlist	ml_id	bigint	19			0
addressbook_mlist_ass	ml_id	bigint	19			0
obj_lp_stat	mm	tinyint	3
obj_stat	mm	tinyint	3	√		null
obj_stat_log	mm	tinyint	3	√		null
obj_stat_tmp	mm	tinyint	3	√		null
obj_type_stat	mm	tinyint	3
obj_user_stat	mm	tinyint	3
il_object_subobj	mmax	tinyint	3			0
il_news_item	mob_cnt_download	int	10			0
il_news_item	mob_cnt_play	int	10			0
il_news_item	mob_id	int	10	√		null
media_item	mob_id	int	10			0
page_layout	mod_portfolio	tinyint	3	√		null
page_layout	mod_scorm	tinyint	3	√		1
svy_svy	mode_360	tinyint	3			0
svy_svy	mode_360_results	tinyint	3			0
svy_svy	mode_360_self_appr	tinyint	3			0
svy_svy	mode_360_self_eval	tinyint	3			0
svy_svy	mode_360_self_rate	tinyint	3			0
svy_svy	mode_360_skill_service	tinyint	3			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
data_cache	module	varchar	50			common
il_log	module	varchar	50	√		null
lng_data	module	varchar	30
lng_modules	module	varchar	30
module_class	module	varchar	100	√		null
notification_listener	module	varchar	100
notification_usercfg	module	varchar	100
settings	module	varchar	50			common
help_map	module_id	int	10			0
help_tooltip	module_id	int	10			0
sahs_lm	module_version	int	10	√		1
sahs_user	module_version	smallint	5	√		null
qpl_a_mdef	morder	int	10
style_parameter	mq_id	int	10			0
sty_media_query	mquery	varchar	2000	√		null
chat_record_data	msg_time	int	10			0
cal_ch_group	multiple_assignments	tinyint	3
cache_clob	name	varchar	50
cache_text	name	varchar	50
copg_pc_def	name	varchar	40
dav_property	name	varchar	120
ecs_crs_mapping_atts	name	varchar	64	√		null
il_bibl_attribute	name	varchar	32	√		null
il_bibl_settings	name	varchar	50			-
il_component	name	varchar	200	√		null
il_object_group	name	varchar	200	√		null
il_plugin	name	varchar	40
il_pluginslot	name	varchar	200	√		null
ldap_server_settings	name	varchar	32	√		null
mob_parameter	name	varchar	50	√		null
openid_provider	name	varchar	128	√		null
page_editor_settings	name	varchar	30
payment_erp	name	varchar	32
shib_role_assignment	name	char	255	√		null
style_setting	name	varchar	30
style_template	name	varchar	30
table_templates	name	varchar	64
tst_test_defaults	name	varchar	255	√		null
webr_params	name	char	128	√		null
payment_statistic	name_extern	varchar	80	√		null
il_blog	nav_list_mon	smallint	5	√		0
il_blog	nav_list_post	smallint	5			10
il_blog	nav_mode	tinyint	3			1
il_blog	nav_order	varchar	255	√		null
qpl_questionpool	nav_taxonomy	int	10	√		null
svy_category	neutral	varchar	1	√		0
svy_qst_matrix	neutral_column_separator	varchar	1	√		1
container_sorting_set	new_items_order	tinyint	3			0
container_sorting_set	new_items_position	tinyint	3			1
wiki_page_template	new_pages	tinyint	3			0
wiki_stat_user	new_pages	int	10
payment_news	news_content	longtext	2147483647	√		null
il_news_read	news_id	int	10			0
payment_news	news_id	int	10			0
payment_news	news_title	varchar	200	√		null
content_object	no_glo_appendix	char	1	√		n
sahs_lm	no_menu	varchar	1			n
note	no_repository	tinyint	3	√		0
sahs_sc13_seq_item	nocopy	tinyint	3	√		null
acl_ws	node_id	int	10			0
dav_lock	node_id	int	10			0
dav_property	node_id	int	10			0
tax_node_assignment	node_id	int	10			0
usr_portf_acl	node_id	int	10			0
sahs_sc13_seq_item	nodelete	tinyint	3	√		null
cp_node	nodename	varchar	50	√		null
sahs_sc13_seq_node	nodename	varchar	50	√		null
sahs_sc13_seq_item	nomove	tinyint	3	√		null
il_poll	non_anon	tinyint	3			0
obj_lp_stat	not_attempted	int	10	√		null
feedback_results	note	longtext	2147483647	√		null
note	note_text	longtext	2147483647	√		null
exc_mem_ass_status	notice	varchar	4000	√		null
exc_members	notice	varchar	4000	√		null
cal_entries	notification	tinyint	3			0
il_dcl_data	notification	tinyint	3	√		null
obj_members	notification	tinyint	3			0
notification_types	notification_group	varchar	100
cal_notification	notification_id	int	10
frm_notification	notification_id	int	10			0
notification_data	notification_id	int	10
notification_queue	notification_id	int	10
notification_osd	notification_osd_id	int	10
booking_user	notification_sent	tinyint	3			0
frm_settings	notification_type	varchar	10	√		null
frm_posts	notify	tinyint	3			0
glossary_definition	nr	int	10			0
last_visited	nr	int	10			0
map_area	nr	int	10			0
media_item	nr	int	10			0
page_history	nr	int	10	√		null
sc_resource_dependen	nr	int	10	√		null
sc_resource_file	nr	int	10	√		null
skl_level	nr	smallint	5
booking_object	nr_items	smallint	5			1
svy_qst_mc	nr_max_answers	smallint	5	√		null
svy_qst_mc	nr_min_answers	smallint	5	√		null
qpl_questions	nr_of_tries	int	10			0
tst_tests	nr_of_tries	smallint	5			0
dav_property	ns	varchar	120			DAV:
xmlnestedset	ns_book_fk	int	10			0
xmlnestedsettmp	ns_book_fk	int	10
xmlnestedset	ns_l	int	10	√		null
xmlnestedsettmp	ns_l	int	10
xmlnestedset	ns_r	int	10	√		null
xmlnestedsettmp	ns_r	int	10
xmlnestedset	ns_tag_fk	int	10	√		null
xmlnestedsettmp	ns_tag_fk	int	10
xmlnestedset	ns_type	char	50	√		null
xmlnestedsettmp	ns_type	varchar	50
xmlnestedsettmp	ns_unique_id	varchar	32
booking_entry	num_bookings	int	10
wiki_stat_page	num_chars	bigint	19
conditions	num_obligatory	tinyint	3			0
ut_lp_collections	num_obligatory	int	10			0
wiki_stat	num_pages	int	10
wiki_stat_page	num_ratings	int	10
wiki_stat_page	num_words	int	10
content_object	numbering	char	1	√		n
ass_log	obj_fi	int	10			0
qpl_questionpool	obj_fi	int	10			0
qpl_questions	obj_fi	int	10			0
svy_qpl	obj_fi	int	10			0
svy_question	obj_fi	int	10			0
svy_svy	obj_fi	int	10			0
tst_tests	obj_fi	int	10			0
adv_md_obj_rec_select	obj_id	int	10
adv_md_values_date	obj_id	int	10			0
adv_md_values_datetime	obj_id	int	10			0
adv_md_values_float	obj_id	int	10			0
adv_md_values_int	obj_id	int	10			0
adv_md_values_location	obj_id	int	10			0
adv_md_values_text	obj_id	int	10			0
aicc_course	obj_id	int	10			0
aicc_object	obj_id	int	10			0
aicc_units	obj_id	int	10			0
booking_entry	obj_id	int	10
bookmark_data	obj_id	int	10			0
cal_categories	obj_id	int	10			0
cal_shared	obj_id	int	10			0
catch_write_events	obj_id	int	10			0
cmi_custom	obj_id	int	10			0
container_reference	obj_id	int	10			0
container_sorting	obj_id	int	10			0
container_sorting_bl	obj_id	int	10			0
container_sorting_set	obj_id	int	10			0
cp_package	obj_id	int	10			0
cp_suspend	obj_id	int	10	√		null
cp_tree	obj_id	int	10	√		null
crs_f_definitions	obj_id	int	10			0
crs_items	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_waiting_list	obj_id	int	10			0
dav_lock	obj_id	int	10			0
dav_property	obj_id	int	10			0
didactic_tpl_objs	obj_id	int	10
ecs_cms_data	obj_id	int	10			0
ecs_course_assignments	obj_id	int	10
ecs_export	obj_id	int	10			0
ecs_import	obj_id	int	10			0
ecs_node_mapping_a	obj_id	int	10	√		null
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
export_file_info	obj_id	int	10
export_options	obj_id	int	10
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
grp_settings	obj_id	int	10			0
history	obj_id	int	10			0
il_certificate	obj_id	int	10
il_dcl_table	obj_id	int	10
il_media_cast_data_ord	obj_id	int	10
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_tar	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_rating	obj_id	int	10			0
il_subscribers	obj_id	int	10			0
il_tag	obj_id	int	10			0
ilinc_data	obj_id	int	10			0
ilinc_registration	obj_id	int	10			0
license_data	obj_id	int	10			0
link_check	obj_id	int	10			0
link_check_report	obj_id	int	10			0
lm_data	obj_id	int	10			0
lm_read_event	obj_id	int	10			0
lo_access	obj_id	int	10			0
loc_settings	obj_id	int	10			0
mail_obj_data	obj_id	int	10			0
member_agreement	obj_id	int	10			0
mep_item	obj_id	int	10			0
note	obj_id	int	10			0
note_settings	obj_id	int	10			0
obj_content_master_lng	obj_id	int	10			0
obj_lp_stat	obj_id	int	10
obj_members	obj_id	int	10			0
obj_stat	obj_id	int	10
obj_stat_log	obj_id	int	10
obj_stat_tmp	obj_id	int	10
obj_user_data_hist	obj_id	int	10
obj_user_stat	obj_id	int	10
object_data	obj_id	int	10			0
object_description	obj_id	int	10			0
object_reference	obj_id	int	10			0
object_reference_ws	obj_id	int	10			0
object_translation	obj_id	int	10			0
preview_data	obj_id	int	10
rcat_settings	obj_id	int	10
read_event	obj_id	int	10			0
remote_course_settings	obj_id	int	10			0
rfil_settings	obj_id	int	10
rglo_settings	obj_id	int	10
rgrp_settings	obj_id	int	10
rlm_settings	obj_id	int	10
rtst_settings	obj_id	int	10
rwik_settings	obj_id	int	10
sahs_sc13_seq_course	obj_id	int	10			0
sahs_sc13_tree_node	obj_id	int	10			0
sahs_user	obj_id	int	10
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			0
scorm_tracking	obj_id	int	10			0
search_command_queue	obj_id	int	10			0
search_data	obj_id	int	10			0
skl_tree_node	obj_id	int	10			0
skl_usage	obj_id	int	10			0
style_usage	obj_id	int	10
svy_360_appr	obj_id	int	10			0
svy_360_rater	obj_id	int	10			0
tax_node	obj_id	int	10			0
tax_node_assignment	obj_id	int	10			0
tax_usage	obj_id	int	10			0
ut_lp_coll_manual	obj_id	int	10			0
ut_lp_collections	obj_id	int	10			0
ut_lp_marks	obj_id	int	10			0
ut_lp_settings	obj_id	int	10			0
ut_lp_user_status	obj_id	int	10			0
write_event	obj_id	int	10			0
adv_md_record_objs	obj_type	char	6
adv_md_substitutions	obj_type	varchar	4
cal_shared	obj_type	int	10			0
didactic_tpl_sa	obj_type	varchar	8
history	obj_type	varchar	8	√		null
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_tar	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_object_sub_type	obj_type	varchar	10
il_rating	obj_type	char	10
il_tag	obj_type	char	10
note	obj_type	varchar	10	√		null
note_settings	obj_type	varchar	10			-
obj_stat	obj_type	varchar	10
obj_stat_log	obj_type	varchar	10
obj_stat_tmp	obj_type	varchar	10
search_command_queue	obj_type	char	4
ut_lp_settings	obj_type	char	4	√		null
acl_ws	object_id	int	10			0
booking_reservation	object_id	int	10
chatroom_settings	object_id	int	10	√		0
usr_portf_acl	object_id	int	10			0
payment_statistic	object_title	varchar	128	√		null
tst_active	objective_container	int	10	√		null
cmi_gobjective	objective_id	varchar	255	√		null
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_p	objective_id	int	10			0
crs_objective_tst	objective_id	int	10			0
crs_objectives	objective_id	int	10			0
loc_rnd_qpl	objective_id	int	10			0
loc_tst_run	objective_id	int	10			0
loc_user_results	objective_id	int	10			0
cp_sequencing	objectivebycontent	tinyint	3	√		null
cp_objective	objectiveid	varchar	200	√		null
sahs_sc13_seq_obj	objectiveid	varchar	200	√		null
sahs_sc13_seq_seq	objectivemeasureweight	double	22	√		null
cp_sequencing	objectivemeasweight	double	22	√		null
sahs_lm	objectives	varchar	1			y
sahs_sc13_seq_seq	objectivesetbycontent	tinyint	3	√		null
cp_organization	objectivesglobtosys	tinyint	3	√		null
tst_pass_result	obligations_answered	tinyint	3			1
tst_result_cache	obligations_answered	tinyint	3			1
tst_tests	obligations_enabled	tinyint	3			0
conditions	obligatory	tinyint	3			1
svy_qst_oblig	obligatory	varchar	1	√		1
svy_question	obligatory	varchar	1	√		1
tst_test_question	obligatory	tinyint	3			0
tst_tests	offer_question_hints	tinyint	3			0
tst_mark	official_name	varchar	50	√		null
sahs_lm	offline_mode	varchar	1			n
sahs_user	offline_mode	varchar	8	√		null
sahs_lm	offline_zip_created	datetime	19	√		null
il_poll	online_status	tinyint	3			0
tst_tests	online_status	tinyint	3			0
ut_online	online_time	int	10			0
ecs_events	op	char	32	√		null
rbac_operations	op_order	smallint	5	√		null
sahs_lm	open_mode	tinyint	3			0
usr_session_stats	opened	int	10	√		null
il_meta_requirement	operating_system_name	varchar	16	√		null
rbac_operations	operation	char	32	√		null
conditions	operator	varchar	64	√		null
sahs_sc13_seq_cond	operator	varchar	50	√		null
il_meta_technical	opr	varchar	4000	√		null
il_meta_technical	opr_language	char	2	√		null
rbac_operations	ops_id	int	10			0
rbac_pa	ops_id	varchar	4000	√		null
rbac_ta	ops_id	smallint	5			0
rbac_templates	ops_id	int	10			0
qpl_qst_kprim	opt_label	varchar	32			right/wrong
copy_wizard_options	options	longtext	2147483647	√		null
il_meta_requirement	or_composite_id	int	10			0
il_wiki_imp_pages	ord	int	10
payment_statistic	order_date	int	10	√		null
exc_assignment	order_nr	int	10			0
glo_advmd_col_order	order_nr	int	10
personal_clipboard	order_nr	int	10			0
personal_pc_clipboard	order_nr	int	10	√		null
skl_tree_node	order_nr	int	10			0
sty_media_query	order_nr	int	10			0
tax_node	order_nr	int	10			0
tax_node_assignment	order_nr	int	10			0
usr_ext_profile_page	order_nr	int	10			0
usr_portfolio_page	order_nr	int	10
tst_dyn_quest_set_cfg	order_tax	int	10	√		null
tst_seq_qst_tracking	orderindex	int	10			0
qpl_qst_ordering	ordering_type	varchar	1	√		1
qpl_qst_horder	ordertext	varchar	2000	√		null
rcat_settings	organization	varchar	400	√		null
remote_course_settings	organization	varchar	4000	√		null
rfil_settings	organization	varchar	400	√		null
rglo_settings	organization	varchar	400	√		null
rgrp_settings	organization	varchar	400	√		null
rlm_settings	organization	varchar	400	√		null
rtst_settings	organization	varchar	400	√		null
rwik_settings	organization	varchar	400	√		null
orgu_data	orgu_id	int	10			0
orgu_data	orgu_type_id	int	10	√		null
orgu_types_trans	orgu_type_id	int	10
svy_qst_mc	orientation	varchar	1	√		0
svy_qst_sc	orientation	varchar	1	√		0
obj_members	origin	int	10	√		0
tst_rnd_quest_set_qpls	origin_node_fi	int	10	√		null
tst_rnd_quest_set_qpls	origin_tax_fi	int	10	√		null
obj_members	origin_ts	int	10	√		0
ass_log	original_fi	int	10	√		null
qpl_questions	original_id	int	10	√		null
svy_question	original_id	int	10	√		null
il_meta_requirement	os_max_version	char	255	√		null
il_meta_requirement	os_min_version	char	255	√		null
svy_phrase_cat	other	smallint	5			0
svy_qst_matrixrows	other	tinyint	3			0
svy_variable	other	smallint	5			0
svy_svy	outro	longtext	2147483647	√		null
il_blog	ov_post	smallint	5	√		0
booking_settings	ovlimit	tinyint	3	√		null
il_bibl_overview_model	ovm_id	int	10			0
ecs_community	own_id	int	10
svy_svy	own_results_mail	tinyint	3	√		0
svy_svy	own_results_view	tinyint	3	√		0
chat_rooms	owner	int	10			0
chatroom_prooms	owner	int	10			0
il_dcl_record	owner	int	10
object_data	owner	int	10			0
orgu_types	owner	int	10
qpl_questions	owner	int	10			0
svy_category	owner_fi	int	10			0
svy_phrase	owner_fi	int	10			0
svy_qblk	owner_fi	int	10			0
svy_question	owner_fi	int	10			0
il_cld_data	owner_id	bigint	19
il_disk_quota	owner_id	int	10
sahs_user	package_attempts	smallint	5	√		null
usr_search	page	tinyint	3			0
content_object	page_header	char	8	√		st_title
il_wiki_imp_pages	page_id	int	10
link_check	page_id	int	10			0
notification	page_id	int	10	√		0
page_anchor	page_id	int	10			0
page_history	page_id	int	10			0
page_object	page_id	int	10			0
page_question	page_id	int	10			0
page_style_usage	page_id	int	10
wiki_stat_page	page_id	int	10
wiki_stat_page_user	page_id	int	10
page_anchor	page_lang	varchar	2			-
page_question	page_lang	varchar	2			-
page_style_usage	page_lang	varchar	2			-
page_style_usage	page_nr	int	10
page_anchor	page_parent_type	varchar	10
page_question	page_parent_type	varchar	4	√		null
il_wiki_data	page_toc	tinyint	3	√		null
page_style_usage	page_type	char	10
media_item	param	varchar	2000	√		null
webr_params	param_id	int	10			0
xmlparam	param_name	char	50	√		null
xmlparam	param_value	char	255	√		null
style_parameter	parameter	varchar	100	√		null
cp_item	parameters	varchar	255	√		null
desktop_item	parameters	varchar	200	√		null
il_verification	parameters	varchar	1000	√		null
sc_item	parameters	varchar	4000	√		null
qpl_qst_flash	params	varchar	4000	√		null
qpl_qst_javaapplet	params	varchar	4000	√		null
bookmark_tree	parent	int	10	√		null
cp_tree	parent	int	10	√		null
ctrl_calls	parent	varchar	100	√		null
ctrl_structure	parent	longtext	2147483647	√		null
ecs_cms_tree	parent	int	10	√		null
il_object_subobj	parent	char	10
lm_tree	parent	int	10	√		null
mail_tree	parent	int	10	√		null
mep_tree	parent	int	10			0
personal_clipboard	parent	int	10			0
rbac_fa	parent	int	10			0
rbac_templates	parent	int	10			0
sahs_sc13_seq_tree	parent	int	10	√		null
sahs_sc13_tree	parent	int	10	√		null
scorm_tree	parent	int	10	√		null
search_tree	parent	int	10	√		null
skl_tree	parent	int	10	√		null
tax_tree	parent	int	10	√		null
tree	parent	int	10	√		null
tree_workspace	parent	int	10			0
chatroom_prooms	parent_id	varchar	2000
container_sorting	parent_id	int	10			0
copg_multilang	parent_id	int	10			0
copg_multilang_lang	parent_id	int	10			0
crs_items	parent_id	int	10			0
didactic_tpl_fp	parent_id	int	10
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_tar	parent_id	int	10	√		null
il_meta_taxon	parent_id	int	10	√		null
il_meta_taxon_path	parent_id	int	10	√		null
il_rating_cat	parent_id	int	10
page_history	parent_id	int	10	√		null
page_object	parent_id	int	10	√		null
write_event	parent_obj_id	int	10			0
frm_posts_tree	parent_pos	bigint	19			0
container_sorting	parent_type	varchar	5	√		null
copg_multilang	parent_type	varchar	10			0
copg_multilang_lang	parent_type	varchar	10			0
copg_pobj_def	parent_type	varchar	20
didactic_tpl_fp	parent_type	varchar	32	√		null
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_tar	parent_type	varchar	16	√		null
il_meta_taxon	parent_type	varchar	32	√		null
il_meta_taxon_path	parent_type	varchar	32	√		null
link_check	parent_type	varchar	8	√		null
page_history	parent_type	varchar	4
page_object	parent_type	varchar	4			lm
event_participants	participated	tinyint	3			0
event	participation	tinyint	3			0
tst_manual_fb	pass	int	10			0
tst_pass_result	pass	int	10			0
tst_result_cache	pass	int	10
tst_seq_qst_answstatus	pass	int	10			0
tst_seq_qst_checked	pass	int	10			0
tst_seq_qst_postponed	pass	int	10			0
tst_seq_qst_tracking	pass	int	10			0
tst_sequence	pass	int	10			0
tst_solutions	pass	int	10			0
tst_test_result	pass	int	10			0
tst_test_rnd_qst	pass	int	10			0
tst_times	pass	smallint	5			0
tst_tests	pass_deletion_allowed	int	10			0
exc_data	pass_mode	varchar	8			all
exc_data	pass_nr	int	10	√		null
tst_tests	pass_scoring	varchar	1	√		0
obj_members	passed	tinyint	3	√		null
page_qst_answer	passed	tinyint	3
tst_mark	passed	varchar	1	√		0
tst_result_cache	passed	int	10
crs_objectives	passes	smallint	5	√		0
usr_data	passwd	varchar	80	√		null
usr_data	passwd_enc_type	varchar	10	√		null
usr_data	passwd_salt	varchar	32	√		null
tst_tests	password	varchar	20	√		null
tst_tests	password_enabled	tinyint	3	√		null
cron_job	path	varchar	400	√		null
mail_attachment	path	varchar	4000	√		null
tree	path	varchar	4000	√		null
cmi_correct_response	pattern	varchar	255	√		null
didactic_tpl_fp	pattern	varchar	64	√		null
il_bibl_overview_model	pattern	varchar	512	√		null
didactic_tpl_fp	pattern_id	int	10
didactic_tpl_fp	pattern_sub_type	tinyint	3
didactic_tpl_fp	pattern_type	tinyint	3
payment_objects	pay_method	int	10			0
payment_statistic	payed	int	10			0
payment_coupons	pc_description	varchar	4000	√		null
payment_coupons	pc_from	date	10	√		null
payment_coupons	pc_from_enabled	tinyint	3			0
page_pc_usage	pc_id	int	10
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
copg_pc_def	pc_type	varchar	20
page_pc_usage	pc_type	varchar	30
payment_coupons	pc_type	char	8	√		fix
payment_coupons	pc_uses	int	10			0
payment_coupons	pc_value	double	22			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_obj	pco_pc_fk	bigint	19			0
exc_assignment_peer	pcomment	longtext	2147483647	√		null
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
exc_assignment	peer	tinyint	3			0
exc_assignment	peer_dl	int	10	√		0
exc_assignment	peer_file	tinyint	3	√		0
exc_assignment_peer	peer_id	int	10
exc_assignment	peer_min	smallint	5			0
exc_assignment	peer_prsl	tinyint	3	√		0
loc_rnd_qpl	percentage	int	10			0
ut_lp_marks	percentage	tinyint	3			0
sahs_user	percentage_completed	tinyint	3	√		null
ldap_attribute_mapping	perform_update	tinyint	3			0
il_poll	period	tinyint	3			0
il_poll	period_begin	int	10	√		0
il_poll	period_end	int	10	√		0
help_map	perm	varchar	20
payment_trustees	perm_coupons	tinyint	3			0
payment_trustees	perm_obj	int	10			0
payment_trustees	perm_stat	int	10	√		null
cp_package	persistprevattempts	int	10	√		null
usr_data	phone_home	varchar	40	√		null
usr_data	phone_mobile	varchar	40	√		null
usr_data	phone_office	varchar	40	√		null
svy_phrase_cat	phrase_category_id	int	10			0
svy_phrase_cat	phrase_fi	int	10			0
svy_phrase	phrase_id	int	10			0
qpl_a_mdef	picture	varchar	1000	√		null
qpl_a_mterm	picture	varchar	1000	√		null
crs_timings_planed	planed_end	int	10			0
crs_timings_planed	planed_start	int	10			0
il_news_item	playtime	varchar	8	√		null
qpl_qst_type	plugin	tinyint	3			0
shib_role_assignment	plugin	tinyint	3			0
svy_qtype	plugin	tinyint	3			0
il_plugin	plugin_id	varchar	20	√		null
ldap_role_assignments	plugin_id	int	10	√		null
shib_role_assignment	plugin_id	int	10			0
ctrl_classfile	plugin_path	varchar	250	√		null
payment_paymethods	pm_enabled	tinyint	3			0
payment_paymethods	pm_id	int	10			0
payment_paymethods	pm_title	varchar	60
payment_statistic	po_box	varchar	40	√		null
payment_objects	pobject_id	int	10			0
payment_prices	pobject_id	int	10			0
payment_shopping_cart	pobject_id	int	10			0
payment_statistic	pobject_id	int	10			0
il_qpl_qst_fq_res	points	double	22			0
page_qst_answer	points	double	22
qpl_a_cloze	points	double	22			0
qpl_a_cloze_combi_res	points	double	22	√		null
qpl_a_errortext	points	double	22			0
qpl_a_essay	points	double	22	√		null
qpl_a_imagemap	points	double	22			0
qpl_a_matching	points	double	22			0
qpl_a_mc	points	double	22			0
qpl_a_sc	points	double	22			0
qpl_a_textsubset	points	double	22			0
qpl_num_range	points	double	22			0
qpl_questions	points	double	22	√		null
tst_pass_result	points	double	22			0
tst_solutions	points	double	22	√		null
tst_test_result	points	double	22			0
qpl_a_imagemap	points_unchecked	double	22			0
qpl_a_mc	points_unchecked	double	22			0
qpl_qst_errortext	points_wrong	double	22			-1
il_poll_answer	poll_id	int	10
il_poll_vote	poll_id	int	10
ecs_server	polling_time	int	10	√		0
tst_rnd_quest_set_qpls	pool_fi	int	10			0
booking_object	pool_id	int	10	√		0
booking_schedule	pool_id	int	10
booking_settings	pool_offline	tinyint	3	√		null
tst_rnd_quest_set_qpls	pool_path	varchar	512	√		null
tst_rnd_quest_set_qpls	pool_quest_count	int	10	√		null
tst_rnd_quest_set_qpls	pool_title	varchar	128	√		null
svy_svy	pool_usage	tinyint	3	√		null
tst_tests	pool_usage	tinyint	3	√		null
ecs_server	port	smallint	5	√		1
usr_portfolio_page	portfolio_id	int	10
crs_start	pos	int	10	√		null
export_options	pos	int	10			0
il_media_cast_data_ord	pos	mediumint	7
il_new_item_grp	pos	smallint	5			0
il_poll_answer	pos	smallint	5
il_rating_cat	pos	smallint	5
frm_posts	pos_author_id	int	10			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_display_user_id	int	10			0
frm_posts_tree	pos_fk	bigint	19			0
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
adv_mdf_definition	position	int	10			0
container_sorting	position	int	10			0
crs_items	position	int	10	√		null
crs_objective_lm	position	int	10	√		0
crs_objectives	position	int	10			0
qpl_a_kprim	position	int	10			0
ecs_node_mapping_a	position_update	tinyint	3	√		null
frm_settings	post_activation	tinyint	3			0
booking_object	post_file	varchar	500	√		null
frm_user_read	post_id	int	10			0
booking_object	post_text	varchar	4000	√		null
tst_sequence	postponed	varchar	4000	√		null
il_blog	ppic	tinyint	3	√		null
usr_portfolio	ppic	tinyint	3	√		null
sc_item	prereq_type	varchar	200	√		null
sc_item	prerequisites	varchar	4000	√		null
glossary	pres_mode	varchar	10			table
frm_settings	preset_subject	tinyint	3			1
tst_dyn_quest_set_cfg	prev_quest_list_enabled	tinyint	3			0
cp_sequencing	preventactivation	tinyint	3	√		null
sahs_sc13_seq_seq	preventactivation	tinyint	3	√		null
style_template	preview	varchar	4000	√		null
payment_prices	price	double	22			0
payment_statistic	price	double	22			0
payment_prices	price_id	int	10			0
payment_shopping_cart	price_id	int	10			0
payment_prices	price_type	tinyint	3			1
sahs_sc13_seq_obj	primary_obj	tinyint	3	√		null
tst_tests	print_bs_with_res	tinyint	3			1
content_object	print_view_active	char	1	√		y
il_news_item	priority	int	10	√		1
chatroom_settings	private_rooms_enabled	int	10			0
tst_tests	processing_time	varchar	8	√		null
skl_profile_level	profile_id	int	10
skl_profile_user	profile_id	int	10
usr_data	profile_incomplete	int	10	√		0
content_object	progr_icons	tinyint	3			0
cmi_gobjective	progress_measure	varchar	50	√		null
cmi_node	progress_measure	double	22	√		null
cmi_objective	progress_measure	double	22	√		null
cp_item	progressweight	varchar	50	√		1.0
chatroom_proomaccess	proom_id	int	10
chatroom_prooms	proom_id	int	10
chatroom_psessions	proom_id	int	10
table_properties	property	varchar	20
rbac_fa	protected	char	1	√		n
ecs_server	protocol	tinyint	3	√		1
openid_provider	provider_id	int	10			0
payment_shopping_cart	psc_id	int	10			0
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_topics	pt_topic_changed	int	10			0
payment_topics	pt_topic_created	int	10			0
payment_objects	pt_topic_fk	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_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
lm_data	public_access	char	1	√		n
content_object	public_access_mode	char	8	√		complete
il_dcl_table	public_comments	int	10			0
il_media_cast_data	public_files	tinyint	3	√		0
content_object	public_html_file	varchar	50	√		null
glossary	public_html_file	varchar	50	√		null
booking_settings	public_log	tinyint	3	√		null
il_dcl_data	public_notes	tinyint	3	√		null
il_wiki_data	public_notes	tinyint	3	√		1
content_object	public_scorm_file	varchar	50	√		null
content_object	public_xml_file	varchar	50	√		null
glossary	public_xml_file	varchar	50	√		null
cp_auxilaryresource	purpose	varchar	255	√		null
il_meta_classification	purpose	varchar	32	√		null
media_item	purpose	char	20	√		Standard
usr_pwassist	pwassist_id	char	180
svy_quest_skill	q_id	int	10			0
svy_qblk_qst	qblk_qst_id	int	10			0
qpl_hints	qht_hint_id	int	10
qpl_hints	qht_hint_index	int	10
qpl_hints	qht_hint_points	double	22			0
qpl_hints	qht_hint_text	longtext	2147483647	√		null
qpl_hints	qht_question_fi	int	10
qpl_hint_tracking	qhtr_active_fi	int	10
qpl_hint_tracking	qhtr_hint_fi	int	10
qpl_hint_tracking	qhtr_pass	int	10
qpl_hint_tracking	qhtr_question_fi	int	10
qpl_hint_tracking	qhtr_track_id	int	10
loc_rnd_qpl	qp_seq	int	10			0
tst_rnd_cpy	qpl_fi	int	10
tst_rnd_qpl_title	qpl_fi	int	10
tst_rnd_qpl_title	qpl_title	varchar	1000
crs_objective_qst	qst_ass_id	int	10			0
tst_rnd_cpy	qst_fi	int	10
page_qst_answer	qst_id	int	10
loc_settings	qt_vis_all	tinyint	3	√		1
loc_settings	qt_vis_obj	tinyint	3	√		0
loc_settings	qtest	int	10	√		null
usr_search	query	longtext	2147483647	√		null
tst_rnd_quest_set_qpls	quest_amount	int	10	√		null
tst_rnd_quest_set_cfg	quest_amount_cfg_mode	varchar	16	√		null
tst_rnd_quest_set_cfg	quest_amount_per_test	int	10	√		null
tst_rnd_quest_set_cfg	quest_sync_timestamp	int	10			0
il_poll	question	varchar	1000	√		null
svy_qst_constraint	question_constraint_id	int	10			0
ass_log	question_fi	int	10	√		null
il_qpl_qst_fq_res	question_fi	int	10			0
il_qpl_qst_fq_res_unit	question_fi	int	10			0
il_qpl_qst_fq_ucat	question_fi	int	10			0
il_qpl_qst_fq_unit	question_fi	int	10			0
il_qpl_qst_fq_var	question_fi	int	10			0
qpl_a_cloze	question_fi	int	10			0
qpl_a_cloze_combi_res	question_fi	int	10
qpl_a_errortext	question_fi	int	10
qpl_a_essay	question_fi	int	10	√		null
qpl_a_imagemap	question_fi	int	10			0
qpl_a_kprim	question_fi	int	10			0
qpl_a_matching	question_fi	int	10			0
qpl_a_mc	question_fi	int	10			0
qpl_a_mdef	question_fi	int	10
qpl_a_mterm	question_fi	int	10			0
qpl_a_ordering	question_fi	int	10			0
qpl_a_sc	question_fi	int	10			0
qpl_a_textsubset	question_fi	int	10			0
qpl_fb_generic	question_fi	int	10			0
qpl_fb_specific	question_fi	int	10
qpl_num_range	question_fi	int	10			0
qpl_qst_cloze	question_fi	int	10			0
qpl_qst_errortext	question_fi	int	10
qpl_qst_essay	question_fi	int	10			0
qpl_qst_fileupload	question_fi	int	10			0
qpl_qst_flash	question_fi	int	10			0
qpl_qst_horder	question_fi	int	10			0
qpl_qst_imagemap	question_fi	int	10			0
qpl_qst_javaapplet	question_fi	int	10			0
qpl_qst_kprim	question_fi	int	10			0
qpl_qst_matching	question_fi	int	10			0
qpl_qst_mc	question_fi	int	10			0
qpl_qst_numeric	question_fi	int	10			0
qpl_qst_ordering	question_fi	int	10			0
qpl_qst_sc	question_fi	int	10			0
qpl_qst_textsubset	question_fi	int	10			0
qpl_sol_sug	question_fi	int	10			0
svy_answer	question_fi	int	10			0
svy_constraint	question_fi	int	10			0
svy_material	question_fi	int	10			0
svy_qblk_qst	question_fi	int	10			0
svy_qst_constraint	question_fi	int	10			0
svy_qst_matrix	question_fi	int	10			0
svy_qst_matrixrows	question_fi	int	10			0
svy_qst_mc	question_fi	int	10			0
svy_qst_metric	question_fi	int	10			0
svy_qst_oblig	question_fi	int	10			0
svy_qst_sc	question_fi	int	10			0
svy_qst_text	question_fi	int	10			0
svy_svy_qst	question_fi	int	10			0
svy_variable	question_fi	int	10			0
tst_manual_fb	question_fi	int	10			0
tst_qst_solved	question_fi	int	10			0
tst_seq_qst_answstatus	question_fi	int	10			0
tst_seq_qst_checked	question_fi	int	10			0
tst_seq_qst_postponed	question_fi	int	10			0
tst_seq_qst_tracking	question_fi	int	10			0
tst_skl_qst_assigns	question_fi	int	10			0
tst_solutions	question_fi	int	10			0
tst_test_question	question_fi	int	10			0
tst_test_result	question_fi	int	10			0
tst_test_rnd_qst	question_fi	int	10			0
crs_objective_qst	question_id	int	10			0
page_question	question_id	int	10			0
qpl_questions	question_id	int	10			0
svy_question	question_id	int	10			0
svy_qst_oblig	question_obligatory_id	int	10			0
tst_tests	question_set_type	varchar	32			FIXED_QUEST_SET
qpl_questions	question_text	longtext	2147483647	√		null
sahs_lm	question_tries	int	10	√		3
qpl_questions	question_type_fi	int	10			0
qpl_qst_type	question_type_id	int	10			0
svy_qblk_qst	questionblock_fi	int	10			0
svy_qblk	questionblock_id	int	10			0
qpl_questionpool	questioncount	int	10			0
tst_pass_result	questioncount	int	10			0
loc_tst_run	questions	varchar	1000	√		0
svy_question	questiontext	longtext	2147483647	√		null
svy_question	questiontype_fi	int	10			0
svy_qtype	questiontype_id	int	10			0
remote_course_settings	r_end	int	10			0
remote_course_settings	r_start	int	10			0
qpl_a_ordering	random_id	int	10			0
svy_qst_matrix	random_rows	varchar	1	√		0
cp_sequencing	randomizationtiming	varchar	50	√		null
sahs_sc13_seq_seq	randomizationtiming	varchar	50	√		null
qpl_num_range	range_id	int	10			0
il_qpl_qst_fq_res	range_max	double	22			0
il_qpl_qst_fq_var	range_max	double	22			0
il_qpl_qst_fq_res	range_max_txt	varchar	4000	√		null
il_qpl_qst_fq_var	range_max_txt	varchar	4000	√		null
il_qpl_qst_fq_res	range_min	double	22			0
il_qpl_qst_fq_var	range_min	double	22			0
il_qpl_qst_fq_res	range_min_txt	varchar	4000	√		null
il_qpl_qst_fq_var	range_min_txt	varchar	4000	√		null
booking_schedule	raster	int	10	√		null
content_object	rating	tinyint	3			0
file_data	rating	tinyint	3			0
il_dcl_data	rating	tinyint	3	√		null
il_rating	rating	int	10			0
il_wiki_data	rating	tinyint	3	√		0
il_wiki_page	rating	tinyint	3			0
il_wiki_data	rating_ext	tinyint	3			0
il_wiki_data	rating_new	tinyint	3			0
il_wiki_data	rating_overall	tinyint	3	√		0
content_object	rating_pages	tinyint	3	√		0
il_wiki_data	rating_side	tinyint	3			0
il_qpl_qst_fq_res	rating_sign	double	22			0.25
il_qpl_qst_fq_res	rating_simple	int	10			1
il_qpl_qst_fq_res	rating_unit	double	22			0.25
il_qpl_qst_fq_res	rating_value	double	22			0.25
il_verification	raw_data	longtext	2147483647	√		null
il_object_def	rbac	tinyint	3			0
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_tar	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
mail	rcp_bcc	longtext	2147483647	√		null
mail_saved	rcp_bcc	longtext	2147483647	√		null
mail	rcp_cc	longtext	2147483647	√		null
mail_saved	rcp_cc	longtext	2147483647	√		null
mail	rcp_to	longtext	2147483647	√		null
mail_saved	rcp_to	longtext	2147483647	√		null
tst_result_cache	reached_points	double	22			0
lm_read_event	read_count	int	10			0
obj_stat	read_count	int	10	√		null
obj_stat_log	read_count	int	10	√		null
obj_stat_tmp	read_count	int	10	√		null
read_event	read_count	int	10			0
wiki_stat_page_user	read_events	int	10			0
cp_datamap	read_shared_data	tinyint	3	√		1
sahs_sc13_seq_mapinfo	readnormalizedmeasure	tinyint	3	√		null
cp_mapinfo	readnormalmeasure	tinyint	3	√		null
cp_mapinfo	readsatisfiedstatus	tinyint	3	√		null
sahs_sc13_seq_mapinfo	readsatisfiedstatus	tinyint	3	√		null
adv_md_obj_rec_select	rec_id	int	10
orgu_types_adv_md_rec	rec_id	int	10
chat_record_data	record_data_id	int	10			0
il_dcl_stloc1_value	record_field_id	int	10
il_dcl_stloc2_value	record_field_id	int	10
il_dcl_stloc3_value	record_field_id	int	10
adv_md_record	record_id	tinyint	3			0
adv_md_record_objs	record_id	tinyint	3			0
adv_mdf_definition	record_id	int	10			0
chat_record_data	record_id	int	10			0
chat_records	record_id	int	10			0
il_dcl_record_field	record_id	int	10
tst_tests	redirection_mode	int	10			0
tst_tests	redirection_url	varchar	128	√		null
qpl_qst_ordering	reduced_points	double	22			0
conditions	ref_handling	tinyint	3			1
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
didactic_tpl_objs	ref_id	int	10			0
ecs_cmap_rule	ref_id	int	10
ecs_node_mapping_a	ref_id	int	10	√		null
export_options	ref_id	int	10
feedback_items	ref_id	int	10	√		0
il_news_subscription	ref_id	int	10			0
last_visited	ref_id	int	10			0
object_reference	ref_id	int	10			0
payment_coupons_obj	ref_id	bigint	19			0
payment_objects	ref_id	int	10			0
rbac_log	ref_id	int	10
rbac_pa	ref_id	int	10			0
cp_condition	referencedobjective	varchar	50	√		null
sahs_sc13_seq_cond	referencedobjective	varchar	50	√		null
usr_data	referral_comment	varchar	250	√		null
ldap_server_settings	referrals	int	10			0
crs_settings	reg_ac	varchar	32	√		null
grp_settings	reg_ac	varchar	32	√		null
crs_settings	reg_ac_enabled	tinyint	3
grp_settings	reg_ac_enabled	tinyint	3
reg_registration_codes	reg_enabled	tinyint	3			1
usr_data	reg_hash	char	32	√		null
event	reg_limit_users	int	10	√		0
event	reg_limited	tinyint	3	√		0
event	reg_type	smallint	5	√		0
event	reg_waiting_list	tinyint	3	√		0
event_participants	registered	tinyint	3			0
event	registration	tinyint	3			0
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
udf_definition	registration_visible	tinyint	3	√		0
svy_constraint	relation_fi	int	10			0
svy_relation	relation_id	int	10			0
chatroom_bans	remark	varchar	1000	√		null
crs_timings_usr_accept	remark	varchar	4000	√		null
license_data	remarks	longtext	2147483647	√		null
lng_data	remarks	varchar	250	√		null
svy_svy	reminder_end	datetime	19	√		null
svy_svy	reminder_frequency	smallint	5			0
svy_svy	reminder_last_sent	datetime	19	√		null
svy_svy	reminder_start	datetime	19	√		null
svy_svy	reminder_status	tinyint	3			0
svy_svy	reminder_target	tinyint	3			0
usr_session	remote_addr	varchar	50	√		null
rcat_settings	remote_link	varchar	400	√		null
remote_course_settings	remote_link	varchar	4000	√		null
rfil_settings	remote_link	varchar	400	√		null
rglo_settings	remote_link	varchar	400	√		null
rgrp_settings	remote_link	varchar	400	√		null
rlm_settings	remote_link	varchar	400	√		null
rtst_settings	remote_link	varchar	400	√		null
rwik_settings	remote_link	varchar	400	√		null
cal_categories	remote_pass	varchar	50	√		null
cal_categories	remote_sync	datetime	19	√		null
cal_categories	remote_url	varchar	500	√		null
cal_categories	remote_user	varchar	50	√		null
ecs_remote_user	remote_usr_id	char	50	√		null
ldap_role_assignments	remove_on_update	tinyint	3	√		null
shib_role_assignment	remove_on_update	tinyint	3			0
preview_data	render_date	datetime	19
page_object	render_md5	varchar	32	√		null
preview_data	render_status	varchar	20
page_object	rendered_content	longtext	2147483647	√		null
page_object	rendered_time	datetime	19	√		null
booking_schedule	rent_max	int	10	√		null
booking_schedule	rent_min	int	10	√		null
cp_sequencing	reorderchildren	tinyint	3	√		null
sahs_sc13_seq_seq	reorderchildren	tinyint	3	√		null
note	rep_obj_id	int	10			0
note_settings	rep_obj_id	int	10			0
skl_skill_resource	rep_ref_id	int	10
svy_qst_matrix	repeat_column_header	varchar	1	√		0
feedback_items	repeat_interval	int	10	√		null
tst_tests	reporting_date	varchar	14	√		null
il_object_def	repository	tinyint	3			1
tst_rnd_quest_set_cfg	req_pools_homo_scored	tinyint	3			0
adv_mdf_definition	required	tinyint	3			0
feedback_items	required	tinyint	3	√		0
il_dcl_field	required	tinyint	3
udf_definition	required	tinyint	3			0
cp_sequencing	requiredcompleted	varchar	50	√		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
cp_sequencing	requiredforsatisfied	varchar	50	√		null
sahs_sc13_seq_seq	requiredforsatisfied	varchar	50	√		null
cp_sequencing	requiredincomplete	varchar	50	√		null
cp_sequencing	requirednotsatisfied	varchar	50	√		null
sc_resource_dependen	res_id	int	10	√		null
sc_resource_file	res_id	int	10	√		null
tst_tests	reset_processing_time	tinyint	3			0
loc_settings	reset_results	tinyint	3	√		0
qpl_qst_mc	resize_images	varchar	1	√		0
qpl_qst_sc	resize_images	varchar	1	√		0
cp_dependency	resourceid	varchar	50	√		null
cp_item	resourceid	varchar	200	√		null
sc_resource	resourcetype	varchar	30	√		null
il_qpl_qst_fq_res	resprecision	int	10			0
content_object	restrict_forw_nav	tinyint	3			0
chatroom_settings	restrict_history	tinyint	3	√		0
acc_cache	result	longtext	2147483647	√		null
cmi_interaction	result	varchar	4000	√		null
il_qpl_qst_fq_res	result	varchar	255	√		null
il_qpl_qst_fq_res_unit	result	varchar	255	√		null
il_qpl_qst_fq_res	result_id	int	10			0
loc_user_results	result_perc	tinyint	3	√		0
il_poll	result_sort	tinyint	3			0
tst_tests	result_tax_filters	varchar	255	√		null
il_qpl_qst_fq_res	result_type	int	10			0
il_qpl_qst_fq_res_unit	result_unit_id	int	10			0
tst_tests	resultoutput	int	10			0
tst_tests	results_presentation	int	10			3
exc_mem_ass_status	returned	tinyint	3			0
exc_members	returned	tinyint	3			0
exc_returned	returned_id	int	10			0
bookmark_tree	rgt	int	10			0
cp_tree	rgt	int	10	√		null
ecs_cms_tree	rgt	int	10	√		null
frm_posts_tree	rgt	int	10			0
lm_tree	rgt	int	10			0
mail_tree	rgt	int	10			0
mep_tree	rgt	int	10			0
sahs_sc13_seq_tree	rgt	int	10	√		null
sahs_sc13_tree	rgt	int	10			0
scorm_tree	rgt	int	10			0
search_tree	rgt	int	10			0
skl_tree	rgt	int	10			0
tax_tree	rgt	int	10			0
tree	rgt	int	10			0
tree_workspace	rgt	int	10			0
ecs_cmap_rule	rid	int	10
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_rg_mapping	role	int	10			0
reg_er_assignments	role	int	10			0
reg_registration_codes	role	int	10	√		0
ldap_server_settings	role_bind_dn	varchar	255	√		null
ldap_server_settings	role_bind_pass	varchar	32	√		null
ldap_role_assignments	role_id	int	10			0
reg_access_limit	role_id	int	10			0
role_data	role_id	int	10			0
role_desktop_items	role_id	int	10			0
shib_role_assignment	role_id	int	10			0
role_desktop_items	role_item_id	int	10			0
reg_registration_codes	role_local	varchar	255	√		null
ldap_server_settings	role_sync_active	tinyint	3			0
didactic_tpl_alr	role_template_id	int	10	√		null
cp_sequencing	rollupobjectivesatis	tinyint	3	√		null
sahs_sc13_seq_seq	rollupobjectivesatisfied	tinyint	3	√		null
cp_sequencing	rollupprogcompletion	tinyint	3	√		null
sahs_sc13_seq_seq	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			0
chat_user	room_id	int	10			0
chatroom_bans	room_id	int	10
chatroom_history	room_id	int	10
chatroom_sessions	room_id	int	10
chatroom_settings	room_id	int	10
chatroom_uploads	room_id	int	10
chatroom_users	room_id	int	10
chatroom_settings	room_type	varchar	20
usr_search	root	int	10	√		1
ctrl_structure	root_class	varchar	40
il_cld_data	root_folder	varchar	255	√		null
il_cld_data	root_id	varchar	255	√		null
sahs_sc13_seq_item	rootlevel	tinyint	3			0
qpl_a_cloze_combi_res	row_id	int	10	√		0
svy_qst_matrix	row_images	varchar	1	√		0
svy_qst_matrix	row_separators	varchar	1	√		0
svy_answer	rowvalue	int	10			0
il_blog	rss_active	tinyint	3	√		0
cal_recurrence_rules	rule_id	int	10			0
ldap_role_assignments	rule_id	tinyint	3			0
shib_role_assignment	rule_id	int	10			0
cron_job	running_ts	int	10	√		null
cmi_custom	rvalue	varchar	255	√		null
scorm_tracking	rvalue	longtext	2147483647	√		null
sahs_sc13_seq_assign	sahs_sc13_tree_node_id	int	10			0
sahs_sc13_seq_item	sahs_sc13_tree_node_id	int	10			0
mail_template	sal_f	varchar	200	√		null
mail_template	sal_g	varchar	200	√		null
mail_template	sal_m	varchar	200	√		null
cmi_gobjective	satisfied	varchar	50	√		null
cp_objective	satisfiedbymeasure	tinyint	3	√		null
sahs_sc13_seq_obj	satisfiedbymeasure	tinyint	3	√		null
xhtml_page	save_content	longtext	2147483647	√		null
payment_erp	save_copy	int	10	√		0
payment_paymethods	save_usr_adr	tinyint	3			0
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
svy_phrase_cat	scale	int	10	√		null
svy_variable	scale	mediumint	7	√		null
cmi_node	scaled	double	22	√		null
cmi_objective	scaled	double	22	√		null
cmi_node	scaled_passing_score	double	22	√		null
booking_object	schedule_id	int	10	√		null
booking_settings	schedule_type	tinyint	3			1
cron_job	schedule_type	tinyint	3	√		null
cron_job	schedule_value	int	10	√		null
cmi_custom	sco_id	int	10			0
scorm_tracking	sco_id	int	10			0
cp_datamap	sco_node_id	int	10			0
sahs_user	sco_total_time_sec	int	10	√		null
cmi_objective	scope	varchar	16	√		null
dav_lock	scope	char	1	√		s
payment_settings	scope	varchar	50	√		null
cmi_gobjective	scope_id	int	10	√		null
tst_tests	score_cutting	varchar	1	√		0
cmi_gobjective	score_max	varchar	50	√		null
cmi_gobjective	score_min	varchar	50	√		null
qpl_qst_kprim	score_partsol	tinyint	3			0
cmi_gobjective	score_raw	varchar	50	√		null
tst_tests	score_reporting	tinyint	3			0
qpl_qst_ordering	scoring_type	mediumint	7			0
cp_resource	scormtype	varchar	32	√		null
sc_resource	scormtype	varchar	6	√		null
help_map	screen_id	varchar	100
help_map	screen_sub_id	varchar	100
ldap_server_settings	search_base	varchar	255	√		null
usr_search	search_result	longtext	2147483647	√		null
usr_search	search_type	tinyint	3			0
adv_mdf_definition	searchable	tinyint	3			0
udf_definition	searchable	tinyint	3			0
usr_data	sel_country	varchar	2	√		null
cp_sequencing	selectcount	int	10	√		null
sahs_sc13_seq_seq	selectcount	int	10	√		null
cal_auth_token	selection	int	10
cp_sequencing	selectiontiming	varchar	50	√		null
sahs_sc13_seq_seq	selectiontiming	varchar	50	√		null
skl_tree_node	self_eval	tinyint	3			0
skl_user_has_level	self_eval	tinyint	3			0
skl_user_skill_level	self_eval	tinyint	3			0
il_meta_educational	semantic_density	varchar	16	√		null
mail	send_time	datetime	19	√		null
mail	sender_id	int	10	√		null
notification_listener	sender_id	int	10
exc_mem_ass_status	sent	tinyint	3	√		null
exc_members	sent	tinyint	3	√		null
svy_anonymous	sent	smallint	5			0
exc_mem_ass_status	sent_time	datetime	19	√		null
exc_members	sent_time	datetime	19	√		null
sahs_lm	seq_exp_mode	tinyint	3	√		0
sahs_sc13_seq_cond	seqnodeid	int	10			0
sahs_sc13_seq_item	seqnodeid	int	10			0
sahs_sc13_seq_mapinfo	seqnodeid	int	10			0
sahs_sc13_seq_node	seqnodeid	int	10			0
sahs_sc13_seq_obj	seqnodeid	int	10			0
sahs_sc13_seq_rule	seqnodeid	int	10			0
sahs_sc13_seq_seq	seqnodeid	int	10			0
sahs_sc13_seq_templ	seqnodeid	int	10	√		null
il_qpl_qst_fq_unit	sequence	int	10			0
qpl_a_errortext	sequence	smallint	5			0
svy_phrase_cat	sequence	int	10			0
svy_qst_matrixrows	sequence	int	10			0
svy_svy_qst	sequence	int	10			0
svy_variable	sequence	int	10			0
tst_sequence	sequence	longtext	2147483647	√		null
tst_test_question	sequence	smallint	5			0
tst_test_rnd_qst	sequence	smallint	5			0
tst_rnd_quest_set_qpls	sequence_pos	int	10	√		null
tst_tests	sequence_settings	tinyint	3			0
sahs_lm	sequencing	varchar	1			y
cp_item	sequencingid	varchar	50	√		null
cp_organization	sequencingid	varchar	50	√		null
cp_sequencing	sequencingid	varchar	50	√		null
sahs_sc13_seq_item	sequencingid	varchar	50	√		null
sahs_sc13_seq_seq	sequencingid	varchar	50	√		null
sahs_sc13_seq_item	seqxml	longtext	2147483647	√		null
notification_data	serialized	varchar	4000
notification_osd	serialized	varchar	4000
ecs_server	server	varchar	255	√		null
ecs_cms_data	server_id	int	10	√		null
ecs_events	server_id	int	10			0
ecs_export	server_id	int	10			0
ecs_import	server_id	int	10			0
ecs_node_mapping_a	server_id	int	10			0
ecs_server	server_id	int	10			0
ldap_attribute_mapping	server_id	int	10			0
ldap_rg_mapping	server_id	int	10			0
ldap_role_assignments	server_id	int	10			0
ldap_server_settings	server_id	int	10			0
chatroom_admconfig	server_settings	varchar	2000
il_cld_data	service	varchar	255	√		null
service_class	service	varchar	100	√		null
il_request_token	session_id	varchar	100	√		null
payment_shopping_cart	session_id	varchar	80
usr_sess_istorage	session_id	varchar	80
usr_session	session_id	varchar	250
usr_session_stats_raw	session_id	varchar	80
crs_settings	session_limit	tinyint	3			0
crs_settings	session_next	bigint	19			-1
crs_settings	session_prev	bigint	19			-1
cmi_node	session_time	varchar	20	√		null
adm_set_templ_value	setting	varchar	40
il_block_setting	setting	varchar	40
payment_erps	settings	varchar	4000	√		null
usr_form_settings	settings	varchar	4000
page_editor_settings	settings_grp	varchar	10
svy_settings	settings_id	int	10
map_area	shape	varchar	20	√		null
cp_package	shared_data_global_to_system	tinyint	3	√		1
il_wiki_data	short	varchar	20	√		null
tst_mark	short_name	varchar	15	√		null
glossary_definition	short_text	varchar	4000	√		null
glossary_definition	short_text_dirty	int	10			0
svy_relation	shortname	varchar	2	√		null
page_object	show_activation_info	tinyint	3			0
file_based_lm	show_bib	tinyint	3	√		null
svy_qblk	show_blocktitle	varchar	1	√		null
tst_tests	show_cancel	varchar	1	√		1
tst_tests	show_examview_html	tinyint	3	√		null
tst_tests	show_examview_pdf	tinyint	3	√		null
tst_tests	show_grading_mark	tinyint	3	√		0
tst_tests	show_grading_status	tinyint	3	√		0
il_bibl_settings	show_in_list	tinyint	3	√		0
file_based_lm	show_lic	tinyint	3	√		null
tst_tests	show_marker	tinyint	3			0
crs_settings	show_members	tinyint	3			1
feedback_items	show_on	varchar	6	√		null
svy_svy	show_question_titles	varchar	1	√		1
tst_tests	show_question_titles	varchar	1	√		1
svy_qblk	show_questiontext	varchar	1	√		1
il_poll	show_results_as	tinyint	3			1
exc_data	show_submissions	tinyint	3			0
tst_tests	show_summary	int	10			0
glossary	show_tax	tinyint	3			0
qpl_questionpool	show_taxonomies	tinyint	3			0
tst_tests	showfinalstatement	int	10			0
tst_tests	showinfo	int	10			1
qpl_a_cloze	shuffle	varchar	1	√		1
qpl_qst_matching	shuffle	varchar	1	√		1
qpl_qst_mc	shuffle	varchar	1	√		1
qpl_qst_sc	shuffle	varchar	1	√		1
qpl_qst_kprim	shuffle_answers	tinyint	3			0
tst_tests	shuffle_questions	varchar	1	√		0
ecs_cmap_rule	sid	int	10
ecs_community	sid	int	10
ecs_course_assignments	sid	int	10
ecs_crs_mapping_atts	sid	int	10
ecs_data_mapping	sid	int	10
ecs_part_settings	sid	int	10
ecs_remote_user	sid	int	10			0
il_object_def	sideblock	tinyint	3			0
tst_tests	sign_submission	int	10			0
mail_options	signature	varchar	4000	√		null
svy_qst_matrix	singleline_row_caption	varchar	1	√		0
tst_skl_qst_assigns	skill_base_fi	int	10			0
tst_skl_thresholds	skill_base_fi	int	10			0
skl_assigned_material	skill_id	int	10			0
skl_level	skill_id	int	10
skl_self_eval_level	skill_id	int	10			0
skl_usage	skill_id	int	10			0
skl_user_has_level	skill_id	int	10
skl_user_skill_level	skill_id	int	10
tst_skl_thresholds	skill_level_fi	int	10			0
skl_personal_skill	skill_node_id	int	10			0
tst_skl_qst_assigns	skill_points	int	10			0
tst_tests	skill_service	tinyint	3	√		null
tst_skl_qst_assigns	skill_tref_fi	int	10			0
tst_skl_thresholds	skill_tref_fi	int	10			0
settings_deactivated_s	skin	varchar	100
syst_style_cat	skin_id	varchar	50
skl_templ_ref	skl_node_id	int	10			0
skl_tree	skl_tree_id	int	10			0
adl_shared_data	slm_id	int	10
aicc_object	slm_id	int	10			0
cp_datamap	slm_id	int	10
cp_node	slm_id	int	10	√		null
sahs_sc13_tree	slm_id	int	10			0
sahs_sc13_tree_node	slm_id	int	10			0
scorm_object	slm_id	int	10			0
scorm_tree	slm_id	int	10			0
usr_session_stats	slot_begin	int	10
usr_session_stats	slot_end	int	10
booking_schedule_slot	slot_id	tinyint	3
il_plugin	slot_id	char	10
booking_settings	slots_no	smallint	5	√		0
chat_smilies	smiley_id	int	10			0
chatroom_smilies	smiley_id	int	10			0
chat_smilies	smiley_keywords	varchar	100	√		null
chatroom_smilies	smiley_keywords	varchar	100	√		null
chat_smilies	smiley_path	varchar	200	√		null
chatroom_smilies	smiley_path	varchar	200	√		null
page_style_usage	sname	char	30	√		null
glossary	snippet_length	int	10			200
tst_solutions	solution_id	int	10			0
qpl_a_ordering	solution_order	smallint	5			0
exc_mem_ass_status	solved	tinyint	3	√		null
exc_members	solved	tinyint	3	√		null
tst_qst_solved	solved	tinyint	3			0
il_dcl_datatype	sort	smallint	5	√		0
container_sorting_set	sort_direction	tinyint	3			0
container_sorting_set	sort_mode	tinyint	3			0
tax_data	sorting_mode	int	10			0
il_media_cast_data	sortmode	tinyint	3	√		3
crs_settings	sortorder	int	10	√		null
il_meta_taxon_path	source	varchar	4000	√		null
copy_wizard_options	source_id	int	10			0
il_wiki_missing_page	source_id	int	10			0
int_link	source_id	int	10			0
int_link	source_lang	varchar	2			-
il_meta_taxon_path	source_language	char	2	√		null
tst_dyn_quest_set_cfg	source_qpl_fi	int	10			0
tst_dyn_quest_set_cfg	source_qpl_title	varchar	255	√		null
int_link	source_type	varchar	10
cmi_comment	sourceislms	tinyint	3	√		null
page_layout	special_page	tinyint	3	√		0
tst_tests	specific_feedback	int	10	√		0
lm_read_event	spent_seconds	int	10			0
obj_stat	spent_seconds	int	10	√		null
obj_stat_log	spent_seconds	int	10	√		null
obj_stat_tmp	spent_seconds	int	10	√		null
read_event	spent_seconds	int	10			0
benchmark	sql_stmt	longtext	2147483647	√		null
tos_versions	src	varchar	4000	√		null
il_disk_quota	src_obj_id	int	10
tst_test_rnd_qst	src_pool_def_fi	int	10	√		null
il_disk_quota	src_size	int	10
il_disk_quota	src_type	varchar	50
tos_versions	src_type	tinyint	3			0
il_request_token	stamp	datetime	19	√		null
style_data	standard	tinyint	3	√		0
il_news_item	start_date	datetime	19	√		null
tst_active	start_lock	varchar	128	√		null
chat_records	start_time	int	10			0
exc_assignment	start_time	int	10	√		null
usr_session_stats_raw	start_time	int	10
cal_entries	starta	datetime	19	√		null
svy_svy	startdate	varchar	14	√		null
tst_times	started	datetime	19	√		null
file_based_lm	startfile	varchar	200	√		null
event_appointment	starting_time	int	10			0
tst_tests	starting_time	varchar	14	√		null
tst_tests	starting_time_enabled	tinyint	3	√		null
il_wiki_data	startpage	varchar	200	√		null
feedback_items	starttime	int	10	√		0
svy_finished	state	varchar	1	√		0
frm_settings	statistics_enabled	tinyint	3			0
booking_reservation	status	smallint	5	√		null
cal_shared_status	status	int	10			0
cmi_gobjective	status	varchar	50	√		null
crs_objective_status	status	tinyint	3			0
ecs_cms_data	status	smallint	5			1
ecs_course_assignments	status	tinyint	3
exc_mem_ass_status	status	char	9	√		notgraded
exc_members	status	char	9	√		notgraded
il_wiki_contributor	status	int	10	√		null
loc_user_results	status	tinyint	3	√		0
payment_objects	status	int	10			0
sahs_user	status	tinyint	3	√		null
skl_tree_node	status	tinyint	3			0
skl_user_skill_level	status	tinyint	3
svy_svy	status	varchar	1	√		1
sysc_groups	status	tinyint	3			0
sysc_tasks	status	tinyint	3			0
tst_seq_qst_tracking	status	varchar	16	√		null
ut_lp_marks	status	tinyint	3			0
ut_lp_user_status	status	tinyint	3			0
ut_lp_marks	status_changed	datetime	19	√		null
skl_user_has_level	status_date	datetime	19
skl_user_skill_level	status_date	datetime	19
ut_lp_marks	status_dirty	tinyint	3			0
crs_settings	status_dt	tinyint	3	√		2
exc_mem_ass_status	status_time	datetime	19	√		null
exc_members	status_time	datetime	19	√		null
il_wiki_contributor	status_time	datetime	19	√		null
abstraction_progress	step	int	10
tst_solutions	step	int	10	√		null
tst_test_result	step	int	10	√		null
il_qpl_qst_fq_var	step_dim_max	int	10			0
il_qpl_qst_fq_var	step_dim_min	int	10			0
il_dcl_datatype	storage_location	int	10
adl_shared_data	store	longtext	2147483647	√		null
content_object	store_tries	tinyint	3			0
payment_statistic	street	varchar	40	√		null
usr_data	street	varchar	40	√		null
cp_organization	structure	varchar	200	√		null
sc_organization	structure	varchar	200	√		null
settings_deactivated_s	style	varchar	100
copg_pc_def	style_classes	tinyint	3			0
page_layout	style_id	int	10	√		0
sty_media_query	style_id	int	10			0
style_char	style_id	int	10			0
style_color	style_id	int	10
style_folder_styles	style_id	int	10			0
style_parameter	style_id	int	10			0
style_setting	style_id	int	10
style_template	style_id	int	10
style_usage	style_id	int	10
syst_style_cat	style_id	varchar	50
content_object	stylesheet	int	10			0
sahs_lm	stylesheet	int	10			0
page_style_usage	stype	varchar	30	√		null
crs_settings	sub_end	int	10	√		null
adv_md_values_date	sub_id	int	10			0
adv_md_values_datetime	sub_id	int	10			0
adv_md_values_float	sub_id	int	10			0
adv_md_values_int	sub_id	int	10			0
adv_md_values_location	sub_id	int	10			0
adv_md_values_text	sub_id	int	10			0
ecs_import	sub_id	varchar	64	√		null
search_command_queue	sub_id	int	10			0
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
il_rating	sub_obj_id	int	10			0
il_tag	sub_obj_id	int	10			0
last_visited	sub_obj_id	varchar	40	√		null
il_rating	sub_obj_type	char	10
il_tag	sub_obj_type	char	10
crs_settings	sub_password	varchar	32	√		null
chatroom_history	sub_room	int	10	√		0
crs_settings	sub_start	int	10	√		null
crs_waiting_list	sub_time	int	10			0
il_subscribers	sub_time	int	10			0
adv_md_obj_rec_select	sub_type	varchar	10			-
adv_md_record_objs	sub_type	varchar	10			-
adv_md_values_date	sub_type	varchar	10			-
adv_md_values_datetime	sub_type	varchar	10			-
adv_md_values_float	sub_type	varchar	10			-
adv_md_values_int	sub_type	varchar	10			-
adv_md_values_location	sub_type	varchar	10			-
adv_md_values_text	sub_type	varchar	10			-
crs_settings	sub_type	int	10	√		null
il_object_sub_type	sub_type	varchar	10
search_command_queue	sub_type	char	4	√		null
ecs_cmap_rule	subdir_type	tinyint	3
ut_lp_coll_manual	subitem_id	int	10			0
il_subscribers	subject	varchar	4000	√		null
mail_template	subject	varchar	200	√		null
note	subject	varchar	200	√		null
tst_active	submitted	tinyint	3			0
tst_active	submittimestamp	datetime	19	√		null
il_object_subobj	subobj	char	10
qpl_sol_sug	subquestion_index	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
adv_md_substitutions	substitution	longtext	2147483647	√		null
syst_style_cat	substyle	varchar	50
cal_entries	subtitle	char	64	√		null
payment_objects	subtype	varchar	10	√		null
svy_qst_matrix	subtype	int	10			0
svy_qst_metric	subtype	varchar	1	√		3
cmi_node	success_status	varchar	255	√		null
cmi_objective	success_status	varchar	32	√		null
qpl_sol_sug	suggested_solution_id	int	10			0
crs_items	suggestion_end	int	10			0
crs_items	suggestion_start	int	10			0
svy_anonymous	survey_fi	int	10			0
svy_finished	survey_fi	int	10			0
svy_inv_usr	survey_fi	int	10			0
svy_qblk_qst	survey_fi	int	10			0
svy_qst_constraint	survey_fi	int	10			0
svy_qst_oblig	survey_fi	int	10			0
svy_svy_qst	survey_fi	int	10			0
svy_quest_skill	survey_id	int	10			0
svy_skill_threshold	survey_id	int	10			0
svy_svy	survey_id	int	10			0
svy_anonymous	survey_key	varchar	32	√		null
svy_svy_qst	survey_question_id	int	10			0
cmi_node	suspend_data	longtext	2147483647	√		null
crs_settings	syllabus	varchar	4000	√		null
payment_currencies	symbol	varchar	4	√		null
ldap_server_settings	sync_on_login	tinyint	3			0
ldap_server_settings	sync_per_cron	tinyint	3			0
il_object_def	system	tinyint	3			0
aicc_object	system_id	varchar	50	√		null
aicc_units	system_vendor	varchar	4000	√		null
il_meta_technical	t_size	varchar	4000	√		null
adm_set_templ_hide_tab	tab_id	varchar	80
il_dcl_field	table_id	int	10
il_dcl_record	table_id	int	10
il_dcl_view	table_id	int	10
table_properties	table_id	varchar	30
abstraction_progress	table_name	varchar	100
il_tag	tag	varchar	100
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	√		null
xmltags	tag_pk	int	10			0
xmlvalue	tag_value	longtext	2147483647	√		null
xmlvalue	tag_value_pk	int	10			0
il_meta_tar	tar_language	char	2	√		null
il_meta_tar	tar_max	char	2	√		null
il_meta_tar	tar_min	char	2	√		null
bookmark_data	target	varchar	200	√		null
lm_menu	target	varchar	200	√		null
map_area	target	varchar	50	√		null
search_data	target	varchar	4000	√		null
webr_items	target	varchar	4000	√		null
map_area	target_frame	varchar	50	√		null
adl_shared_data	target_id	varchar	4000
cp_datamap	target_id	varchar	4000
int_link	target_id	int	10			0
int_link	target_inst	int	10			0
il_wiki_missing_page	target_name	varchar	200	√		null
booking_entry	target_obj_id	int	10	√		null
booking_obj_assignment	target_obj_id	int	10
conditions	target_obj_id	int	10			0
container_reference	target_obj_id	int	10			0
conditions	target_ref_id	int	10			0
conditions	target_type	varchar	8	√		null
int_link	target_type	varchar	4
cp_mapinfo	targetobjectiveid	varchar	255	√		null
sahs_sc13_seq_mapinfo	targetobjectiveid	varchar	50	√		null
tst_dyn_quest_set_cfg	tax_filter_enabled	tinyint	3			0
tax_node	tax_id	int	10			0
tax_node_assignment	tax_id	int	10			0
tax_usage	tax_id	int	10			0
tax_tree	tax_tree_id	int	10			0
tst_active	taxfilter	varchar	1024	√		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_exc_team_log	team_id	int	10
style_template	temp_type	varchar	30	√		null
skl_templ_ref	templ_id	int	10			0
page_style_usage	template	tinyint	3			0
adm_set_templ_hide_tab	template_id	int	10
adm_set_templ_value	template_id	int	10
didactic_tpl_alp	template_id	int	10
style_template_class	template_id	int	10
svy_svy	template_id	int	10	√		null
tst_tests	template_id	int	10	√		null
didactic_tpl_alp	template_type	tinyint	3
ecs_cms_data	term	varchar	255	√		null
glossary_term	term	varchar	200	√		null
qpl_a_mterm	term	varchar	1000	√		null
qpl_a_matching	term_fi	int	10			0
glossary_definition	term_id	int	10			0
qpl_a_mterm	term_id	int	10			0
tst_test_defaults	test_defaults_id	int	10			0
tst_active	test_fi	int	10			0
tst_dyn_quest_set_cfg	test_fi	int	10			0
tst_invited_user	test_fi	int	10			0
tst_mark	test_fi	int	10			0
tst_rnd_quest_set_cfg	test_fi	int	10			0
tst_rnd_quest_set_qpls	test_fi	int	10			0
tst_skl_qst_assigns	test_fi	int	10			0
tst_skl_thresholds	test_fi	int	10			0
tst_test_question	test_fi	int	10			0
loc_tst_run	test_id	int	10			0
tst_tests	test_id	int	10			0
crs_objective_tst	test_objective_id	int	10			0
ass_log	test_only	varchar	1	√		0
tst_test_question	test_question_id	int	10			0
tst_test_rnd_qst	test_random_question_id	int	10			0
tst_test_result	test_result_id	int	10			0
tos_versions	text	longtext	2147483647	√		null
feedback_items	text_answer	tinyint	3	√		0
qpl_a_errortext	text_correct	varchar	150	√		null
cache_clob	text_key_1	varchar	20	√		null
cache_text	text_key_1	varchar	20	√		null
cache_clob	text_key_2	varchar	20	√		null
cache_text	text_key_2	varchar	20	√		null
svy_material	text_material	varchar	4000	√		null
media_item	text_representation	varchar	4000	√		null
qpl_a_errortext	text_wrong	varchar	150
svy_answer	textanswer	varchar	4000	√		null
qpl_qst_cloze	textgap_rating	varchar	2	√		null
qpl_qst_essay	textgap_rating	varchar	2	√		null
qpl_qst_textsubset	textgap_rating	varchar	2	√		null
qpl_qst_errortext	textsize	double	22			100
qpl_qst_horder	textsize	double	22	√		null
frm_threads	thr_author_id	int	10			0
frm_threads	thr_date	datetime	19	√		null
frm_threads	thr_display_user_id	int	10			0
frm_posts_tree	thr_fk	bigint	19			0
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_notification	thread_id	int	10			0
frm_thread_access	thread_id	int	10			0
frm_user_read	thread_id	int	10			0
frm_settings	thread_rating	tinyint	3			0
frm_settings	thread_sorting	int	10			0
frm_threads	thread_sorting	int	10			0
svy_skill_threshold	threshold	int	10			0
tst_skl_thresholds	threshold	int	10			0
qpl_qst_matching	thumb_geometry	int	10			100
qpl_qst_ordering	thumb_geometry	int	10			100
qpl_qst_kprim	thumb_size	int	10	√		null
qpl_qst_mc	thumb_size	smallint	5	√		null
qpl_qst_sc	thumb_size	smallint	5	√		null
acc_cache	time	int	10			0
notification_osd	time_added	int	10
sahs_lm	time_from_lms	varchar	1			n
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_assignment	time_stamp	int	10	√		null
exc_data	time_stamp	int	10	√		null
cp_item	timelimitaction	varchar	30	√		null
sc_item	timelimitaction	varchar	30	√		null
booking_schedule_slot	times	varchar	50
tst_times	times_id	int	10			0
chatroom_bans	timestamp	int	10
chatroom_history	timestamp	int	10
chatroom_uploads	timestamp	int	10
lo_access	timestamp	datetime	19	√		null
crs_items	timing_end	int	10			0
crs_items	timing_start	int	10			0
crs_items	timing_type	tinyint	3	√		null
addressbook_mlist	title	varchar	255	√		null
adm_settings_template	title	varchar	100
adv_md_record	title	varchar	128	√		null
adv_mdf_definition	title	varchar	255	√		null
aicc_object	title	varchar	4000	√		null
booking_object	title	varchar	255
booking_schedule	title	varchar	255
bookmark_data	title	varchar	200	√		null
cal_categories	title	char	128	√		null
cal_ch_group	title	varchar	512	√		null
cal_entries	title	char	128	√		null
chat_records	title	varchar	255	√		null
chat_rooms	title	varchar	64	√		null
chatroom_prooms	title	varchar	200			0
cp_item	title	varchar	255	√		null
cp_manifest	title	varchar	255	√		null
cp_organization	title	varchar	255	√		null
crs_objectives	title	varchar	70	√		null
didactic_tpl_settings	title	varchar	64	√		null
ecs_cms_data	title	varchar	512	√		null
ecs_part_settings	title	varchar	255	√		null
ecs_server	title	varchar	128	√		null
event	title	varchar	70	√		null
exc_assignment	title	varchar	200	√		null
feedback_items	title	varchar	255	√		null
il_blog_posting	title	varchar	400	√		null
il_custom_block	title	varchar	200	√		null
il_dcl_datatype	title	varchar	256	√		null
il_dcl_datatype_prop	title	varchar	256	√		null
il_dcl_field	title	varchar	256	√		null
il_dcl_table	title	varchar	256	√		null
il_md_cpr_selections	title	varchar	128	√		null
il_meta_general	title	varchar	4000	√		null
il_news_item	title	varchar	200	√		null
il_rating_cat	title	varchar	100	√		null
il_wiki_page	title	varchar	200	√		null
lm_data	title	varchar	200	√		null
lm_data_transl	title	varchar	200	√		null
lm_menu	title	varchar	200	√		null
mail_obj_data	title	char	70	√		null
map_area	title	varchar	200	√		null
mep_item	title	varchar	128	√		null
notification_channels	title	varchar	100
notification_types	title	varchar	100
object_data	title	char	255	√		null
object_translation	title	varchar	128	√		null
page_layout	title	varchar	128	√		null
personal_clipboard	title	char	70	√		null
qpl_questions	title	varchar	100	√		null
sahs_sc13_tree_node	title	varchar	200	√		null
scorm_object	title	varchar	200	√		null
search_data	title	varchar	200	√		null
skl_level	title	varchar	200	√		null
skl_profile	title	varchar	200	√		null
skl_tree_node	title	varchar	200	√		null
svy_category	title	varchar	1000	√		null
svy_phrase	title	varchar	100	√		null
svy_qblk	title	varchar	4000	√		null
svy_qst_matrixrows	title	varchar	255	√		null
svy_question	title	varchar	100	√		null
svy_settings	title	varchar	400	√		null
tax_node	title	varchar	200	√		null
usr_data	title	varchar	32	√		null
usr_ext_profile_page	title	varchar	200	√		null
usr_portfolio_page	title	varchar	250
webr_items	title	varchar	127	√		null
tst_rnd_qpl_title	title_id	int	10
il_meta_general	title_language	char	2	√		null
tst_tests	title_output	varchar	1	√		0
container_reference	title_type	tinyint	3			1
ecs_node_mapping_a	title_update	tinyint	3	√		null
il_new_item_grp	titles	varchar	1000	√		null
ldap_server_settings	tls	int	10			0
content_object	toc_active	char	1	√		y
content_object	toc_mode	char	8	√		chapters
dav_lock	token	varchar	255
ecs_part_settings	token	tinyint	3	√		1
il_request_token	token	char	64	√		null
il_qpl_qst_fq_res	tolerance	double	22			0
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
skl_assigned_material	top_skill_id	int	10			0
skl_self_eval	top_skill_id	int	10			0
skl_self_eval_level	top_skill_id	int	10			0
frm_data	top_update	datetime	19	√		null
frm_data	top_usr_id	bigint	19			0
tos_acceptance_track	tosv_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
cmi_node	total_time	varchar	20	√		null
sahs_user	total_time_sec	int	10	√		null
didactic_tpl_a	tpl_id	int	10
didactic_tpl_objs	tpl_id	int	10
dbk_translations	tr_id	int	10			0
cp_sequencing	tracked	tinyint	3	√		null
sahs_sc13_seq_seq	tracked	tinyint	3	√		null
payment_statistic	transaction	char	64	√		null
payment_statistic	transaction_extern	char	64	√		null
il_object_def	translate	char	5	√		null
cal_entries	translation_type	tinyint	3			0
bookmark_tree	tree	int	10			0
ecs_cms_tree	tree	int	10			0
mail_tree	tree	int	10			0
search_tree	tree	int	10			0
tree	tree	int	10			0
tree_workspace	tree	int	10			0
ecs_cms_data	tree_id	int	10	√		null
sahs_sc13_seq_node	tree_node_id	int	10	√		null
ecs_node_mapping_a	tree_update	tinyint	3	√		null
skl_assigned_material	tref_id	int	10			0
skl_profile_level	tref_id	int	10			0
skl_self_eval_level	tref_id	int	10			0
skl_skill_resource	tref_id	int	10
skl_usage	tref_id	int	10			0
skl_user_has_level	tref_id	int	10			0
skl_user_skill_level	tref_id	int	10			0
svy_quest_skill	tref_id	int	10
svy_skill_threshold	tref_id	int	10
media_item	tried_thumb	char	1	√		n
loc_user_results	tries	tinyint	3	√		0
tst_active	tries	int	10			0
conditions	trigger_obj_id	int	10			0
skl_level	trigger_obj_id	int	10			0
skl_user_has_level	trigger_obj_id	int	10
skl_user_skill_level	trigger_obj_id	int	10
skl_user_has_level	trigger_obj_type	varchar	4	√		crs
skl_user_skill_level	trigger_obj_type	varchar	4	√		crs
conditions	trigger_ref_id	int	10			0
skl_level	trigger_ref_id	int	10			0
skl_user_has_level	trigger_ref_id	int	10
skl_user_skill_level	trigger_ref_id	int	10
skl_user_has_level	trigger_title	varchar	200	√		null
skl_user_skill_level	trigger_title	varchar	200	√		null
conditions	trigger_type	varchar	8	√		null
payment_trustees	trustee_id	int	10			0
page_qst_answer	try	tinyint	3
catch_write_events	ts	datetime	19	√		null
exc_returned	ts	datetime	19	√		null
tos_acceptance_track	ts	int	10			0
tos_versions	ts	int	10			0
usr_cron_mail_reminder	ts	int	10			0
wiki_stat	ts	datetime	19
wiki_stat_page	ts	datetime	19
wiki_stat_page_user	ts	datetime	19
wiki_stat_user	ts	datetime	19
write_event	ts	datetime	19			1970-01-01 00:00:00
wiki_stat	ts_day	char	10	√		null
wiki_stat_page	ts_day	char	10	√		null
wiki_stat_page_user	ts_day	char	10	√		null
wiki_stat_user	ts_day	char	10	√		null
wiki_stat	ts_hour	tinyint	3	√		null
wiki_stat_page	ts_hour	tinyint	3	√		null
wiki_stat_page_user	ts_hour	tinyint	3	√		null
wiki_stat_user	ts_hour	tinyint	3	√		null
tst_rnd_cpy	tst_fi	int	10
tst_rnd_qpl_title	tst_fi	int	10
loc_rnd_qpl	tst_id	int	10			0
crs_objective_tst	tst_limit	tinyint	3	√		null
crs_objective_tst	tst_limit_p	smallint	5			0
crs_objective_tst	tst_status	tinyint	3	√		null
loc_rnd_qpl	tst_type	tinyint	3			0
acl_ws	tstamp	int	10			0
ass_log	tstamp	int	10			0
booking_user	tstamp	int	10
exc_assignment_peer	tstamp	datetime	19	√		null
il_exc_team_log	tstamp	int	10
il_rating	tstamp	int	10	√		null
loc_user_results	tstamp	int	10	√		0
obj_stat	tstamp	int	10
obj_stat_log	tstamp	int	10	√		null
obj_stat_tmp	tstamp	int	10	√		null
qpl_a_cloze	tstamp	int	10			0
qpl_a_imagemap	tstamp	int	10			0
qpl_a_mc	tstamp	int	10			0
qpl_a_ordering	tstamp	int	10			0
qpl_a_sc	tstamp	int	10			0
qpl_a_textsubset	tstamp	int	10			0
qpl_fb_generic	tstamp	int	10			0
qpl_fb_specific	tstamp	int	10
qpl_num_range	tstamp	int	10			0
qpl_questionpool	tstamp	int	10			0
qpl_questions	tstamp	int	10			0
qpl_sol_sug	tstamp	int	10			0
svy_anonymous	tstamp	int	10			0
svy_answer	tstamp	int	10			0
svy_category	tstamp	int	10			0
svy_finished	tstamp	int	10			0
svy_inv_usr	tstamp	int	10			0
svy_material	tstamp	int	10			0
svy_phrase	tstamp	int	10			0
svy_qblk	tstamp	int	10			0
svy_qpl	tstamp	int	10			0
svy_qst_matrix	tstamp	int	10			0
svy_qst_oblig	tstamp	int	10			0
svy_question	tstamp	int	10			0
svy_relation	tstamp	int	10			0
svy_svy	tstamp	int	10			0
svy_svy_qst	tstamp	int	10			0
svy_variable	tstamp	int	10			0
tst_active	tstamp	int	10			0
tst_addtime	tstamp	bigint	19			0
tst_invited_user	tstamp	int	10			0
tst_manual_fb	tstamp	int	10			0
tst_mark	tstamp	int	10			0
tst_pass_result	tstamp	int	10			0
tst_result_cache	tstamp	int	10			0
tst_sequence	tstamp	int	10			0
tst_solutions	tstamp	int	10			0
tst_test_defaults	tstamp	int	10			0
tst_test_question	tstamp	int	10			0
tst_test_result	tstamp	int	10			0
tst_test_rnd_qst	tstamp	int	10			0
tst_tests	tstamp	int	10			0
tst_times	tstamp	int	10			0
usr_portf_acl	tstamp	int	10			0
usr_session_log	tstamp	int	10
help_tooltip	tt_id	varchar	200
help_tooltip	tt_text	varchar	4000	√		null
event	tutor_email	varchar	127	√		null
exc_usr_tutor	tutor_id	int	10			0
event	tutor_name	varchar	4000	√		null
svy_svy	tutor_ntf_reci	varchar	2000	√		null
svy_svy	tutor_ntf_status	tinyint	3			0
svy_svy	tutor_ntf_target	tinyint	3			0
event	tutor_phone	varchar	127	√		null
rbac_ta	typ_id	int	10			0
adm_settings_template	type	varchar	5
bookmark_data	type	varchar	4	√		null
cal_categories	type	tinyint	3			0
crs_objective_lm	type	char	6	√		null
dav_lock	type	char	1	√		w
desktop_item	type	varchar	4	√		null
didactic_tpl_settings	type	tinyint	3
ecs_events	type	char	32	√		null
exc_assignment	type	tinyint	3			1
il_bibl_entry	type	varchar	128	√		null
il_block_setting	type	varchar	20
il_component	type	char	10
il_custom_block	type	varchar	20	√		null
il_dcl_view	type	tinyint	3	√		null
il_event_handling	type	varchar	10
il_new_item_grp	type	tinyint	3			1
il_verification	type	varchar	100
last_visited	type	varchar	10
ldap_role_assignments	type	tinyint	3			0
lm_data	type	char	2	√		null
loc_settings	type	tinyint	3			0
loc_user_results	type	tinyint	3			0
mail_template	type	varchar	4
map_area	type	varchar	20	√		null
mep_item	type	varchar	10	√		null
note	type	int	10			0
notification	type	tinyint	3
notification_osd	type	varchar	100
obj_lp_stat	type	varchar	4
obj_type_stat	type	varchar	4
object_data	type	char	4	√		none
personal_clipboard	type	char	4
qpl_sol_sug	type	varchar	32	√		null
rbac_templates	type	char	5	√		null
sahs_sc13_seq_rule	type	varchar	50	√		null
sahs_sc13_tree_node	type	char	4	√		null
search_data	type	varchar	4	√		null
skl_tree_node	type	char	4	√		null
style_char	type	varchar	30
style_parameter	type	varchar	30	√		null
tax_node	type	char	4	√		null
usr_portfolio_page	type	tinyint	3			1
usr_session	type	int	10	√		null
usr_session_stats_raw	type	smallint	5
didactic_tpl_a	type_id	tinyint	3
orgu_types_adv_md_rec	type_id	int	10
notification_types	type_name	varchar	100
qpl_qst_type	type_tag	varchar	35	√		null
svy_qtype	type_tag	varchar	30	√		null
il_meta_tar	typical_age_range	varchar	4000	√		null
il_meta_educational	typical_learning_time	varchar	4000	√		null
exc_mem_ass_status	u_comment	varchar	4000	√		null
ut_lp_marks	u_comment	varchar	4000	√		null
ut_lp_settings	u_mode	tinyint	3			0
crs_groupings	unique_field	char	32	√		null
il_qpl_qst_fq_unit	unit	varchar	255	√		null
payment_currencies	unit	varchar	16
il_qpl_qst_fq_res	unit_fi	int	10			0
il_qpl_qst_fq_res_unit	unit_fi	int	10			0
il_qpl_qst_fq_var	unit_fi	int	10			0
il_qpl_qst_fq_unit	unit_id	int	10			0
payment_prices	unlimited_duration	tinyint	3			0
sahs_lm	unlimited_session	varchar	1			n
page_qst_answer	unlocked	tinyint	3			0
il_news_item	update_date	datetime	19	√		null
note	update_date	datetime	19	√		null
payment_news	update_date	datetime	19	√		null
frm_data	update_user	int	10			0
frm_posts	update_user	int	10			0
obj_user_data_hist	update_user	int	10
chatroom_uploads	upload_id	int	10
qpl_a_cloze	upperlimit	varchar	20	√		0
qpl_num_range	upperlimit	varchar	20	√		0
style_data	uptodate	tinyint	3	√		0
cp_manifest	uri	varchar	255	√		null
il_bibl_settings	url	varchar	128			-
ldap_rg_mapping	url	varchar	255	√		null
ldap_server_settings	url	varchar	255	√		null
link_check	url	varchar	255	√		null
openid_provider	url	varchar	512	√		null
payment_erp	url	varchar	255	√		null
file_usage	usage_hist_nr	int	10			0
mob_usage	usage_hist_nr	int	10			0
page_pc_usage	usage_hist_nr	int	10
file_usage	usage_id	int	10			0
mob_usage	usage_id	int	10			0
page_pc_usage	usage_id	int	10
file_usage	usage_lang	varchar	2			-
mob_usage	usage_lang	varchar	2			-
page_pc_usage	usage_lang	varchar	2			-
file_usage	usage_type	varchar	10
mob_usage	usage_type	varchar	10
page_pc_usage	usage_type	varchar	30
payment_erp	use_ean	int	10	√		0
svy_qst_mc	use_min_answers	tinyint	3			0
mail	use_placeholders	tinyint	3			0
mail_saved	use_placeholders	tinyint	3			0
tst_tests	use_previous_answers	varchar	1	√		1
cp_sequencing	usecurattemptobjinfo	tinyint	3	√		null
cp_sequencing	usecurattemptproginfo	tinyint	3	√		null
sahs_sc13_seq_seq	usecurrentattemptobjectiveinfo	tinyint	3	√		null
sahs_sc13_seq_seq	usecurrentattemptprogressinfo	tinyint	3	√		null
license_data	used	int	10			0
reg_registration_codes	used	int	10			0
usr_account_codes	used	int	10			0
ldap_server_settings	user_attribute	varchar	255	√		null
history	user_comment	longtext	2147483647	√		null
ass_log	user_fi	int	10			0
svy_finished	user_fi	int	10			0
svy_inv_usr	user_fi	int	10			0
tst_active	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
acc_user_access_key	user_id	int	10
addressbook	user_id	int	10			0
addressbook_mlist	user_id	bigint	19			0
adl_shared_data	user_id	int	10
booking_reservation	user_id	int	10
booking_user	user_id	int	10
bookmark_data	user_id	int	10			0
cal_auth_token	user_id	int	10
cal_categories_hidden	user_id	int	10			0
cal_ch_settings	user_id	int	10
cal_entry_responsible	user_id	int	10			0
cal_notification	user_id	int	10			0
chatroom_bans	user_id	int	10
chatroom_proomaccess	user_id	int	10
chatroom_psessions	user_id	int	10
chatroom_sessions	user_id	int	10
chatroom_uploads	user_id	int	10
chatroom_users	user_id	int	10
cmi_custom	user_id	int	10			0
cmi_gobjective	user_id	int	10	√		null
cmi_node	user_id	int	10			0
cp_suspend	user_id	int	10	√		null
crs_objective_status	user_id	int	10			0
crs_objective_status_p	user_id	int	10			0
desktop_item	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
il_block_setting	user_id	int	10			0
il_exc_team	user_id	int	10
il_exc_team_log	user_id	int	10
il_news_item	user_id	int	10	√		null
il_news_read	user_id	int	10			0
il_news_subscription	user_id	int	10			0
il_poll_vote	user_id	int	10
il_rating	user_id	int	10			0
il_request_token	user_id	int	10			0
il_tag	user_id	int	10			0
il_wiki_contributor	user_id	int	10			0
last_visited	user_id	int	10			0
loc_tst_run	user_id	int	10			0
loc_user_results	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
notification	user_id	int	10
page_history	user_id	int	10	√		null
page_qst_answer	user_id	int	10
payment_news	user_id	int	10			0
personal_clipboard	user_id	int	10			0
personal_pc_clipboard	user_id	int	10			0
rbac_log	user_id	int	10
sahs_user	user_id	int	10
scorm_tracking	user_id	int	10			0
search_data	user_id	int	10			0
skl_assigned_material	user_id	int	10			0
skl_personal_skill	user_id	int	10			0
skl_profile_user	user_id	int	10
skl_self_eval	user_id	int	10			0
skl_self_eval_level	user_id	int	10			0
skl_user_has_level	user_id	int	10
skl_user_skill_level	user_id	int	10
svy_360_appr	user_id	int	10			0
svy_360_rater	user_id	int	10			0
table_properties	user_id	int	10
table_templates	user_id	int	10
usr_ext_profile_page	user_id	int	10			0
usr_form_settings	user_id	int	10
usr_pwassist	user_id	int	10			0
usr_session	user_id	int	10			0
usr_session_log	user_id	int	10
usr_session_stats_raw	user_id	int	10
wiki_stat_page_user	user_id	int	10
wiki_stat_user	user_id	int	10
frm_notification	user_id_noti	int	10	√		null
svy_anonymous	user_key	varchar	40	√		null
ecs_server	user_rcp	varchar	512	√		null
ldap_server_settings	user_scope	tinyint	3			0
frm_notification	user_toggle_noti	tinyint	3			0
frm_settings	user_toggle_noti	tinyint	3			0
cal_notification	user_type	tinyint	3			0
chatroom_sessions	userdata	varchar	4000
chatroom_users	userdata	varchar	4000
cal_ch_group	usr_id	int	10
cal_registrations	usr_id	int	10
cal_shared_status	usr_id	int	10			0
catch_write_events	usr_id	int	10			0
chat_blocked	usr_id	int	10			0
chat_user	usr_id	int	10			0
crs_lm_history	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
ecs_course_assignments	usr_id	varchar	64	√		null
ecs_remote_user	usr_id	int	10			0
event_participants	usr_id	int	10			0
exc_mem_ass_status	usr_id	int	10
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
il_subscribers	usr_id	int	10			0
ilinc_registration	usr_id	int	10			0
link_check_report	usr_id	int	10			0
lm_read_event	usr_id	int	10			0
lo_access	usr_id	int	10			0
loginname_history	usr_id	int	10
member_agreement	usr_id	int	10			0
notification_listener	usr_id	int	10
notification_osd	usr_id	int	10
notification_queue	usr_id	int	10
notification_usercfg	usr_id	int	10
obj_members	usr_id	int	10			0
obj_user_data_hist	usr_id	int	10
payment_coupons	usr_id	int	10			0
payment_coupons_track	usr_id	int	10			0
rbac_ua	usr_id	int	10			0
read_event	usr_id	int	10			0
svy_settings	usr_id	int	10
tos_acceptance_track	usr_id	int	10			0
udf_clob	usr_id	int	10
udf_data	usr_id	int	10			0
udf_text	usr_id	int	10
usr_cron_mail_reminder	usr_id	int	10			0
usr_data	usr_id	int	10			0
usr_data_multi	usr_id	int	10			0
usr_pref	usr_id	int	10			0
usr_search	usr_id	int	10			0
ut_lp_coll_manual	usr_id	int	10			0
ut_lp_marks	usr_id	int	10			0
ut_lp_user_status	usr_id	int	10			0
ut_online	usr_id	int	10			0
write_event	usr_id	int	10			0
ilinc_registration	usr_text	varchar	255	√		null
skl_user_skill_level	valid	tinyint	3			0
webr_items	valid	tinyint	3			0
notification_osd	valid_until	int	10
notification_queue	valid_until	int	10
usr_account_codes	valid_until	varchar	10	√		null
adm_set_templ_value	value	varchar	4000	√		null
adv_md_values_date	value	date	10	√		null
adv_md_values_datetime	value	datetime	19	√		null
adv_md_values_float	value	double	22	√		null
adv_md_values_int	value	int	10	√		null
adv_md_values_text	value	varchar	4000	√		null
cache_clob	value	longtext	2147483647	√		null
cache_text	value	varchar	4000	√		null
conditions	value	varchar	64	√		null
container_settings	value	char	50	√		null
cp_hidelmsui	value	varchar	50	√		null
crs_user_data	value	varchar	4000	√		null
data_cache	value	longtext	2147483647	√		null
dav_property	value	varchar	4000	√		null
export_options	value	varchar	32	√		null
il_bibl_attribute	value	varchar	4000	√		null
il_block_setting	value	varchar	200	√		null
il_dcl_field_prop	value	varchar	256	√		null
il_dcl_stloc1_value	value	varchar	4000	√		null
il_dcl_stloc2_value	value	int	10	√		null
il_dcl_stloc3_value	value	datetime	19
ldap_attribute_mapping	value	varchar	255	√		null
lng_data	value	varchar	4000	√		null
mob_parameter	value	varchar	2000	√		null
orgu_types_trans	value	varchar	4000	√		null
page_editor_settings	value	varchar	30	√		null
payment_settings	value	longtext	2147483647	√		null
qpl_sol_sug	value	longtext	2147483647	√		null
settings	value	longtext	2147483647	√		null
shib_role_assignment	value	char	255	√		null
style_parameter	value	varchar	200	√		null
style_setting	value	varchar	30	√		null
svy_answer	value	double	22	√		null
svy_constraint	value	double	22			0
svy_settings	value	longtext	2147483647	√		null
table_properties	value	varchar	4000
table_templates	value	longtext	2147483647	√		null
udf_clob	value	longtext	2147483647	√		null
udf_text	value	varchar	4000	√		null
usr_data_multi	value	varchar	1000	√		null
usr_pref	value	varchar	4000	√		null
usr_sess_istorage	value	varchar	1000	√		null
webr_params	value	tinyint	3			0
svy_variable	value1	double	22	√		null
tst_solutions	value1	longtext	2147483647	√		null
svy_variable	value2	double	22	√		null
tst_solutions	value2	longtext	2147483647	√		null
il_qpl_qst_fq_var	variable	varchar	255	√		null
il_qpl_qst_fq_var	variable_id	int	10			0
svy_variable	variable_id	int	10			0
il_qpl_qst_fq_var	varprecision	int	10			0
payment_objects	vat_id	int	10			0
payment_vats	vat_id	int	10
payment_statistic	vat_rate	double	22			0
payment_vats	vat_rate	double	22			0
payment_vats	vat_title	varchar	255
payment_statistic	vat_unit	double	22			0
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
export_file_info	version	varchar	16	√		null
file_data	version	int	10	√		null
ldap_server_settings	version	int	10			0
rfil_settings	version	smallint	5			1
sc_manifest	version	varchar	200	√		null
il_meta_lifecycle	version_language	char	2	√		null
rfil_settings	version_tstamp	int	10	√		null
page_object	view_cnt	int	10	√		0
il_dcl_viewdefinition	view_id	int	10
crs_settings	view_mode	tinyint	3			0
grp_settings	view_mode	tinyint	3			6
il_dcl_table	view_own_records_perm	int	10			0
il_poll	view_results	tinyint	3			3
il_media_cast_data	viewmode	varchar	20	√		null
glossary	virtual	char	7	√		none
il_news_item	visibility	char	6	√		users
payment_news	visibility	varchar	8	√		users
crs_items	visible	tinyint	3			0
crs_timings_usr_accept	visible	tinyint	3			0
udf_definition	visible	tinyint	3			0
udf_definition	visible_lua	tinyint	3			0
frm_data	visits	int	10			0
frm_threads	visits	int	10			0
ut_lp_settings	visits	int	10	√		0
usr_sess_istorage	vkey	varchar	50
feedback_results	vote	int	10			0
feedback_items	votes	longtext	2147483647	√		null
feedback_results	votetime	int	10			0
payment_statistic	voucher	char	64	√		null
crs_settings	waiting_list	tinyint	3			1
grp_settings	waiting_list	tinyint	3			0
aicc_units	web_launch	varchar	255	√		null
webr_items	webr_id	int	10			0
webr_params	webr_id	int	10			0
cal_recurrence_rules	weekstart	char	2	√		null
cmi_interaction	weighting	double	22	√		null
media_item	width	varchar	10	√		null
qpl_qst_flash	width	int	10			550
sahs_lm	width	smallint	5			950
svy_qst_text	width	int	10			50
il_wiki_contributor	wiki_id	int	10			0
il_wiki_imp_pages	wiki_id	int	10
il_wiki_missing_page	wiki_id	int	10			0
il_wiki_page	wiki_id	int	10			0
wiki_page_template	wiki_id	int	10
wiki_stat	wiki_id	int	10
wiki_stat_page	wiki_id	int	10
wiki_stat_page_user	wiki_id	int	10
wiki_stat_user	wiki_id	int	10
qpl_questions	working_time	varchar	8	√		00:00:00
tst_pass_result	workingtime	int	10			0
il_object_def	workspace	tinyint	3			0
wiki_page_template	wpage_id	int	10
cal_shared	writable	tinyint	3	√		0
write_event	write_id	int	10			0
cp_datamap	write_shared_data	tinyint	3	√		1
sahs_sc13_seq_mapinfo	writenormalizedmeasure	tinyint	3	√		null
cp_mapinfo	writenormalmeasure	tinyint	3	√		null
cp_mapinfo	writesatisfiedstatus	tinyint	3	√		null
sahs_sc13_seq_mapinfo	writesatisfiedstatus	tinyint	3	√		null
role_data	wsp_disk_quota	int	10	√		null
object_reference_ws	wsp_id	int	10			0
skl_assigned_material	wsp_id	int	10			0
sc_manifest	xml_base	varchar	200	√		null
sc_resource	xml_base	varchar	200	√		null
sc_resources	xml_base	varchar	200	√		null
cp_package	xmldata	longtext	2147483647	√		null
copg_pc_def	xsl	tinyint	3			0
obj_lp_stat	yyyy	smallint	5
obj_stat	yyyy	smallint	5	√		null
obj_stat_log	yyyy	smallint	5	√		null
obj_stat_tmp	yyyy	smallint	5	√		null
obj_type_stat	yyyy	smallint	5
obj_user_stat	yyyy	smallint	5
payment_statistic	zipcode	varchar	40	√		null
usr_data	zipcode	varchar	10	√		null