SchemaSpy Analysis of ilias5_1 - Columns◀  ilDoc Overview Generated by
SchemaSpy
Generated by SchemaSpy on Sa Aug 18 20:16 GMT+01:00 2018
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ilias5_1 contains 4481 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
abstraction_progress step int 10
abstraction_progress table_name varchar 100
acc_access_key access_key char 1  √  null
acc_access_key function_id int 10
acc_access_key lang_key char 2
acc_cache result longtext 2147483647  √  null
acc_cache time int 10 0
acc_cache user_id int 10 0
acc_user_access_key access_key char 1  √  null
acc_user_access_key function_id smallint 5
acc_user_access_key user_id int 10
acl_ws extended_data varchar 200  √  null
acl_ws node_id int 10 0
acl_ws object_id int 10 0
acl_ws tstamp int 10 0
addressbook_mlist changedate datetime 19  √  null
addressbook_mlist createdate datetime 19  √  null
addressbook_mlist description varchar 4000  √  null
addressbook_mlist lmode tinyint 3 1
addressbook_mlist ml_id bigint 19 0
addressbook_mlist title varchar 255  √  null
addressbook_mlist user_id bigint 19 0
addressbook_mlist_ass a_id bigint 19 0
addressbook_mlist_ass ml_id bigint 19 0
addressbook_mlist_ass usr_id bigint 19 0
addressbook_mlist_ass_seq sequence int 10  √ 
addressbook_mlist_seq sequence int 10  √ 
adl_shared_data cp_node_id int 10 0
adl_shared_data slm_id int 10
adl_shared_data store longtext 2147483647  √  null
adl_shared_data target_id varchar 4000
adl_shared_data user_id int 10
adm_set_templ_hide_tab tab_id varchar 80
adm_set_templ_hide_tab template_id int 10
adm_set_templ_value hide tinyint 3  √  null
adm_set_templ_value setting varchar 40
adm_set_templ_value template_id int 10
adm_set_templ_value value varchar 4000  √  null
adm_settings_template auto_generated tinyint 3  √  0
adm_settings_template description longtext 2147483647  √  null
adm_settings_template id int 10
adm_settings_template title varchar 100
adm_settings_template type varchar 5
adm_settings_template_seq sequence int 10  √ 
adv_md_obj_rec_select obj_id int 10
adv_md_obj_rec_select rec_id int 10
adv_md_obj_rec_select sub_type varchar 10 -
adv_md_record active tinyint 3 0
adv_md_record description varchar 4000  √  null
adv_md_record import_id varchar 64  √  null
adv_md_record parent_obj int 10  √  null
adv_md_record record_id tinyint 3 0
adv_md_record title varchar 128  √  null
adv_md_record_objs obj_type char 6
adv_md_record_objs optional tinyint 3 0
adv_md_record_objs record_id tinyint 3 0
adv_md_record_objs sub_type varchar 10 -
adv_md_record_seq sequence int 10  √ 
adv_md_substitutions hide_description tinyint 3 0
adv_md_substitutions hide_field_names tinyint 3 0
adv_md_substitutions obj_type varchar 4
adv_md_substitutions substitution longtext 2147483647  √  null
adv_md_values_date disabled tinyint 3 0
adv_md_values_date field_id int 10 0
adv_md_values_date obj_id int 10 0
adv_md_values_date sub_id int 10 0
adv_md_values_date sub_type varchar 10 -
adv_md_values_date value date 10  √  null
adv_md_values_datetime disabled tinyint 3 0
adv_md_values_datetime field_id int 10 0
adv_md_values_datetime obj_id int 10 0
adv_md_values_datetime sub_id int 10 0
adv_md_values_datetime sub_type varchar 10 -
adv_md_values_datetime value datetime 19  √  null
adv_md_values_float disabled tinyint 3 0
adv_md_values_float field_id int 10 0
adv_md_values_float obj_id int 10 0
adv_md_values_float sub_id int 10 0
adv_md_values_float sub_type varchar 10 -
adv_md_values_float value double 22  √  null
adv_md_values_int disabled tinyint 3 0
adv_md_values_int field_id int 10 0
adv_md_values_int obj_id int 10 0
adv_md_values_int sub_id int 10 0
adv_md_values_int sub_type varchar 10 -
adv_md_values_int value int 10  √  null
adv_md_values_location disabled tinyint 3 0
adv_md_values_location field_id int 10 0
adv_md_values_location loc_lat double 22  √  null
adv_md_values_location loc_long double 22  √  null
adv_md_values_location loc_zoom tinyint 3  √  null
adv_md_values_location obj_id int 10 0
adv_md_values_location sub_id int 10 0
adv_md_values_location sub_type varchar 10 -
adv_md_values_text disabled tinyint 3 0
adv_md_values_text field_id int 10 0
adv_md_values_text obj_id int 10 0
adv_md_values_text sub_id int 10 0
adv_md_values_text sub_type varchar 10 -
adv_md_values_text value varchar 4000  √  null
adv_mdf_definition description varchar 2000  √  null
adv_mdf_definition field_id int 10 0
adv_mdf_definition field_type tinyint 3 0
adv_mdf_definition field_values varchar 4000  √  null
adv_mdf_definition import_id varchar 32  √  null
adv_mdf_definition position int 10 0
adv_mdf_definition record_id int 10 0
adv_mdf_definition required tinyint 3 0
adv_mdf_definition searchable tinyint 3 0
adv_mdf_definition title varchar 255  √  null
adv_mdf_definition_seq sequence int 10  √ 
aicc_course c_level varchar 5  √  null
aicc_course course_creator varchar 255  √  null
aicc_course course_id varchar 50  √  null
aicc_course course_system varchar 50  √  null
aicc_course course_title varchar 255  √  null
aicc_course description longtext 2147483647  √  null
aicc_course max_fields_cst int 10  √  0
aicc_course max_fields_ort int 10  √  0
aicc_course max_normal tinyint 3  √  null
aicc_course obj_id int 10 0
aicc_course total_aus int 10 0
aicc_course total_blocks int 10 0
aicc_course total_complex_obj int 10  √  0
aicc_course total_objectives int 10  √  0
aicc_course version varchar 10  √  null
aicc_object c_type varchar 50  √  null
aicc_object description longtext 2147483647  √  null
aicc_object developer_id varchar 50  √  null
aicc_object obj_id int 10 0
aicc_object slm_id int 10 0
aicc_object system_id varchar 50  √  null
aicc_object title varchar 4000  √  null
aicc_object_seq sequence int 10  √ 
aicc_units au_password varchar 50  √  null
aicc_units c_type varchar 50  √  null
aicc_units command_line varchar 255  √  null
aicc_units core_vendor varchar 4000  √  null
aicc_units file_name varchar 255  √  null
aicc_units mastery_score int 10 0
aicc_units max_score double 22  √  null
aicc_units max_time_allowed time 8  √  null
aicc_units obj_id int 10 0
aicc_units system_vendor varchar 4000  √  null
aicc_units time_limit_action varchar 50  √  null
aicc_units web_launch varchar 255  √  null
aicc_units_seq sequence int 10  √ 
ass_log ass_log_id int 10 0
ass_log logtext varchar 4000  √  null
ass_log obj_fi int 10 0
ass_log original_fi int 10  √  null
ass_log question_fi int 10  √  null
ass_log ref_id int 10  √  null
ass_log test_only varchar 1  √  0
ass_log tstamp int 10 0
ass_log user_fi int 10 0
ass_log_seq sequence int 10  √ 
benchmark benchmark varchar 150  √  null
benchmark cdate datetime 19  √  null
benchmark duration double 22  √  null
benchmark module varchar 150  √  null
benchmark sql_stmt longtext 2147483647  √  null
booking_entry booking_group int 10 0
booking_entry booking_id int 10
booking_entry deadline int 10
booking_entry num_bookings int 10
booking_entry obj_id int 10
booking_entry target_obj_id int 10  √  null
booking_entry_seq sequence int 10  √ 
booking_obj_assignment booking_id int 10
booking_obj_assignment target_obj_id int 10
booking_object booking_object_id int 10
booking_object description varchar 1000  √  null
booking_object info_file varchar 500  √  null
booking_object nr_items smallint 5 1
booking_object pool_id int 10  √  0
booking_object post_file varchar 500  √  null
booking_object post_text varchar 4000  √  null
booking_object schedule_id int 10  √  null
booking_object title varchar 255
booking_object_seq sequence int 10  √ 
booking_reservation booking_reservation_id int 10
booking_reservation date_from int 10
booking_reservation date_to int 10
booking_reservation group_id int 10  √  null
booking_reservation object_id int 10
booking_reservation status smallint 5  √  null
booking_reservation user_id int 10
booking_reservation_group_seq sequence int 10  √ 
booking_reservation_seq sequence int 10  √ 
booking_schedule auto_break int 10  √  null
booking_schedule av_from int 10  √  null
booking_schedule av_to int 10  √  null
booking_schedule booking_schedule_id int 10
booking_schedule deadline int 10  √  null
booking_schedule pool_id int 10
booking_schedule raster int 10  √  null
booking_schedule rent_max int 10  √  null
booking_schedule rent_min int 10  √  null
booking_schedule title varchar 255
booking_schedule_seq sequence int 10  √ 
booking_schedule_slot booking_schedule_id int 10
booking_schedule_slot day_id varchar 2
booking_schedule_slot slot_id tinyint 3
booking_schedule_slot times varchar 50
booking_settings booking_pool_id int 10
booking_settings ovlimit tinyint 3  √  null
booking_settings pool_offline tinyint 3  √  null
booking_settings public_log tinyint 3  √  null
booking_settings schedule_type tinyint 3 1
booking_settings slots_no smallint 5  √  0
booking_user booking_message varchar 1024  √  null
booking_user entry_id int 10
booking_user notification_sent tinyint 3 0
booking_user tstamp int 10
booking_user user_id int 10
bookmark_data description varchar 255  √  null
bookmark_data obj_id int 10 0
bookmark_data target varchar 200  √  null
bookmark_data title varchar 200  √  null
bookmark_data type varchar 4  √  null
bookmark_data user_id int 10 0
bookmark_data_seq sequence int 10  √ 
bookmark_social_bm sbm_active tinyint 3  √  null
bookmark_social_bm sbm_icon varchar 200  √  null
bookmark_social_bm sbm_id int 10 0
bookmark_social_bm sbm_link varchar 200  √  null
bookmark_social_bm sbm_title varchar 50  √  null
bookmark_social_bm_seq sequence int 10  √ 
bookmark_tree child int 10 0
bookmark_tree depth smallint 5 0
bookmark_tree lft int 10 0
bookmark_tree parent int 10  √  null
bookmark_tree rgt int 10 0
bookmark_tree tree int 10 0
buddylist buddy_usr_id int 10 0
buddylist ts int 10 0
buddylist usr_id int 10 0
buddylist_requests buddy_usr_id int 10 0
buddylist_requests ignored tinyint 3 0
buddylist_requests ts int 10 0
buddylist_requests usr_id int 10 0
cache_clob component varchar 50
cache_clob entry_id varchar 50
cache_clob expire_time int 10
cache_clob ilias_version varchar 10  √  null
cache_clob int_key_1 int 10  √  null
cache_clob int_key_2 int 10  √  null
cache_clob name varchar 50
cache_clob text_key_1 varchar 20  √  null
cache_clob text_key_2 varchar 20  √  null
cache_clob value longtext 2147483647  √  null
cache_text component varchar 50
cache_text entry_id varchar 50
cache_text expire_time int 10
cache_text ilias_version varchar 10  √  null
cache_text int_key_1 int 10  √  null
cache_text int_key_2 int 10  √  null
cache_text name varchar 50
cache_text text_key_1 varchar 20  √  null
cache_text text_key_2 varchar 20  √  null
cache_text value varchar 4000  √  null
cal_auth_token c_time int 10 0
cal_auth_token calendar int 10
cal_auth_token hash varchar 32
cal_auth_token ical longtext 2147483647  √  null
cal_auth_token selection int 10
cal_auth_token user_id int 10
cal_cat_assignments cal_id int 10 0
cal_cat_assignments cat_id int 10 0
cal_categories cat_id int 10 0
cal_categories color char 8  √  null
cal_categories loc_type tinyint 3 1
cal_categories obj_id int 10 0
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
cal_categories title char 128  √  null
cal_categories type tinyint 3 0
cal_categories_hidden cat_id int 10 0
cal_categories_hidden user_id int 10 0
cal_categories_seq sequence int 10  √ 
cal_ch_group grp_id int 10
cal_ch_group multiple_assignments tinyint 3
cal_ch_group title varchar 512  √  null
cal_ch_group usr_id int 10
cal_ch_group_seq sequence int 10  √ 
cal_ch_settings admin_id int 10
cal_ch_settings user_id int 10
cal_entries auto_generated tinyint 3 0
cal_entries cal_id int 10 0
cal_entries completion int 10 0
cal_entries context_id int 10 0
cal_entries description varchar 4000  √  null
cal_entries enda datetime 19  √  null
cal_entries fullday tinyint 3 0
cal_entries informations varchar 4000  √  null
cal_entries is_milestone tinyint 3 0
cal_entries last_update datetime 19  √  null
cal_entries location varchar 4000  √  null
cal_entries notification tinyint 3 0
cal_entries starta datetime 19  √  null
cal_entries subtitle char 64  √  null
cal_entries title char 128  √  null
cal_entries translation_type tinyint 3 0
cal_entries_seq sequence int 10  √ 
cal_entry_responsible cal_id int 10 0
cal_entry_responsible user_id int 10 0
cal_notification cal_id int 10 0
cal_notification email varchar 64  √  null
cal_notification notification_id int 10
cal_notification user_id int 10 0
cal_notification user_type tinyint 3 0
cal_notification_seq sequence int 10  √ 
cal_rec_exclusion cal_id int 10
cal_rec_exclusion excl_date date 10  √  null
cal_rec_exclusion excl_id int 10
cal_rec_exclusion_seq sequence int 10  √ 
cal_recurrence_rules byday char 64  √  null
cal_recurrence_rules bymonth char 64  √  null
cal_recurrence_rules bymonthday char 64  √  null
cal_recurrence_rules bysetpos char 64  √  0
cal_recurrence_rules byweekno char 64  √  0
cal_recurrence_rules byyearday char 64  √  null
cal_recurrence_rules cal_id int 10 0
cal_recurrence_rules cal_recurrence int 10 0
cal_recurrence_rules freq_type char 20  √  null
cal_recurrence_rules freq_until_count int 10 0
cal_recurrence_rules freq_until_date datetime 19  √  null
cal_recurrence_rules intervall int 10 0
cal_recurrence_rules rule_id int 10 0
cal_recurrence_rules weekstart char 2  √  null
cal_recurrence_rules_seq sequence int 10  √ 
cal_registrations cal_id int 10
cal_registrations dend int 10 0
cal_registrations dstart int 10 0
cal_registrations usr_id int 10
cal_shared cal_id int 10 0
cal_shared create_date datetime 19  √  null
cal_shared obj_id int 10 0
cal_shared obj_type int 10 0
cal_shared writable tinyint 3  √  0
cal_shared_status cal_id int 10 0
cal_shared_status status int 10 0
cal_shared_status usr_id int 10 0
catch_write_events obj_id int 10 0
catch_write_events ts datetime 19  √  null
catch_write_events usr_id int 10 0
chatroom_admconfig client_settings varchar 1000
chatroom_admconfig default_config tinyint 3 0
chatroom_admconfig instance_id int 10
chatroom_admconfig server_settings varchar 2000
chatroom_admconfig_seq sequence int 10  √ 
chatroom_bans remark varchar 1000  √  null
chatroom_bans room_id int 10
chatroom_bans timestamp int 10
chatroom_bans user_id int 10
chatroom_history hist_id bigint 19 0
chatroom_history message varchar 4000  √  null
chatroom_history room_id int 10 0
chatroom_history sub_room int 10 0
chatroom_history timestamp int 10 0
chatroom_history_seq sequence int 10  √ 
chatroom_proomaccess proom_id int 10
chatroom_proomaccess user_id int 10
chatroom_prooms closed int 10  √  0
chatroom_prooms created int 10 0
chatroom_prooms is_public tinyint 3  √  1
chatroom_prooms owner int 10 0
chatroom_prooms parent_id int 10 0
chatroom_prooms proom_id int 10
chatroom_prooms title varchar 200 0
chatroom_prooms_seq sequence int 10  √ 
chatroom_psessions connected int 10 0
chatroom_psessions disconnected int 10 0
chatroom_psessions proom_id int 10 0
chatroom_psessions psess_id bigint 19 0
chatroom_psessions user_id int 10 0
chatroom_psessions_seq sequence int 10  √ 
chatroom_sessions connected int 10 0
chatroom_sessions disconnected int 10 0
chatroom_sessions room_id int 10 0
chatroom_sessions sess_id bigint 19 0
chatroom_sessions user_id int 10 0
chatroom_sessions userdata varchar 4000  √  null
chatroom_sessions_seq sequence int 10  √ 
chatroom_settings allow_anonymous tinyint 3  √  0
chatroom_settings allow_custom_usernames tinyint 3  √  0
chatroom_settings allow_private_rooms tinyint 3  √  0
chatroom_settings autogen_usernames varchar 50  √  Anonymous #
chatroom_settings display_past_msgs int 10 0
chatroom_settings enable_history tinyint 3  √  0
chatroom_settings object_id int 10  √  0
chatroom_settings private_rooms_enabled int 10 0
chatroom_settings restrict_history tinyint 3  √  0
chatroom_settings room_id int 10
chatroom_settings room_type varchar 20
chatroom_settings_seq sequence int 10  √ 
chatroom_smilies smiley_id int 10 0
chatroom_smilies smiley_keywords varchar 100  √  null
chatroom_smilies smiley_path varchar 200  √  null
chatroom_smilies_seq sequence int 10  √ 
chatroom_uploads filename varchar 200
chatroom_uploads filetype varchar 200
chatroom_uploads room_id int 10
chatroom_uploads timestamp int 10
chatroom_uploads upload_id int 10
chatroom_uploads user_id int 10
chatroom_uploads_seq sequence int 10  √ 
chatroom_users connected int 10
chatroom_users room_id int 10
chatroom_users user_id int 10
chatroom_users userdata varchar 4000
cmi_comment c_comment longtext 2147483647  √  null
cmi_comment c_timestamp datetime 19  √  null
cmi_comment cmi_comment_id int 10 0
cmi_comment cmi_node_id int 10  √  null
cmi_comment location varchar 255  √  null
cmi_comment sourceislms tinyint 3  √  null
cmi_comment_seq sequence int 10  √ 
cmi_correct_response cmi_correct_resp_id int 10 0
cmi_correct_response cmi_interaction_id int 10  √  null
cmi_correct_response pattern varchar 255  √  null
cmi_correct_response_seq sequence int 10  √ 
cmi_custom c_timestamp datetime 19  √  null
cmi_custom lvalue varchar 64
cmi_custom obj_id int 10 0
cmi_custom rvalue varchar 255  √  null
cmi_custom sco_id int 10 0
cmi_custom user_id int 10 0
cmi_gobjective completion_status varchar 50  √  null
cmi_gobjective measure varchar 50  √  null
cmi_gobjective objective_id varchar 253  √  null
cmi_gobjective progress_measure varchar 50  √  null
cmi_gobjective satisfied varchar 50  √  null
cmi_gobjective scope_id int 10  √  null
cmi_gobjective score_max varchar 50  √  null
cmi_gobjective score_min varchar 50  √  null
cmi_gobjective score_raw varchar 50  √  null
cmi_gobjective status varchar 50  √  null
cmi_gobjective user_id int 10  √  null
cmi_interaction c_timestamp varchar 20  √  null
cmi_interaction c_type varchar 32  √  null
cmi_interaction cmi_interaction_id int 10 0
cmi_interaction cmi_node_id int 10  √  null
cmi_interaction description longtext 2147483647  √  null
cmi_interaction id varchar 255  √  null
cmi_interaction latency varchar 20  √  null
cmi_interaction learner_response longtext 2147483647  √  null
cmi_interaction result varchar 4000  √  null
cmi_interaction weighting double 22  √  null
cmi_interaction_seq sequence int 10  √ 
cmi_node accesscount int 10  √  null
cmi_node accessduration varchar 20  √  null
cmi_node accessed varchar 20  √  null
cmi_node activityabsduration varchar 20  √  null
cmi_node activityattemptcount int 10  √  null
cmi_node activityexpduration varchar 20  √  null
cmi_node activityprogstatus tinyint 3  √  null
cmi_node additional_tables tinyint 3 0
cmi_node attemptabsduration varchar 20  √  null
cmi_node attemptcomplamount double 22  √  null
cmi_node attemptcomplstatus tinyint 3  √  null
cmi_node attemptexpduration varchar 20  √  null
cmi_node attemptprogstatus tinyint 3  √  null
cmi_node audio_captioning int 10  √  null
cmi_node audio_level double 22  √  null
cmi_node availablechildren varchar 255  √  null
cmi_node c_entry varchar 255  √  null
cmi_node c_exit varchar 255  √  null
cmi_node c_language varchar 5  √  null
cmi_node c_max double 22  √  null
cmi_node c_min double 22  √  null
cmi_node c_mode varchar 20  √  null
cmi_node c_raw double 22  √  null
cmi_node c_timestamp datetime 19  √  null
cmi_node cmi_node_id int 10 0
cmi_node completion double 22  √  null
cmi_node completion_status varchar 32  √  null
cmi_node completion_threshold varchar 32  √  null
cmi_node cp_node_id int 10 0
cmi_node created varchar 20  √  null
cmi_node credit varchar 32  √  null
cmi_node delivery_speed double 22  √  null
cmi_node launch_data longtext 2147483647  √  null
cmi_node learner_name varchar 255  √  null
cmi_node location varchar 255  √  null
cmi_node modified varchar 20  √  null
cmi_node progress_measure double 22  √  null
cmi_node scaled double 22  √  null
cmi_node scaled_passing_score double 22  √  null
cmi_node session_time varchar 20  √  null
cmi_node success_status varchar 255  √  null
cmi_node suspend_data longtext 2147483647  √  null
cmi_node total_time varchar 20  √  null
cmi_node user_id int 10 0
cmi_node_seq sequence int 10  √ 
cmi_objective c_max double 22  √  null
cmi_objective c_min double 22  √  null
cmi_objective c_raw double 22  √  null
cmi_objective cmi_interaction_id int 10  √  null
cmi_objective cmi_node_id int 10  √  null
cmi_objective cmi_objective_id int 10 0
cmi_objective completion_status varchar 32  √  null
cmi_objective description longtext 2147483647  √  null
cmi_objective id varchar 4000  √  null
cmi_objective progress_measure double 22  √  null
cmi_objective scaled double 22  √  null
cmi_objective scope varchar 16  √  null
cmi_objective success_status varchar 32  √  null
cmi_objective_seq sequence int 10  √ 
conditions condition_id int 10 0
conditions hidden_status tinyint 3  √  0
conditions num_obligatory tinyint 3 0
conditions obligatory tinyint 3 1
conditions operator varchar 64  √  null
conditions ref_handling tinyint 3 1
conditions target_obj_id int 10 0
conditions target_ref_id int 10 0
conditions target_type varchar 8  √  null
conditions trigger_obj_id int 10 0
conditions trigger_ref_id int 10 0
conditions trigger_type varchar 8  √  null
conditions value varchar 64  √  null
conditions_seq sequence int 10  √ 
container_reference obj_id int 10 0
container_reference target_obj_id int 10 0
container_reference title_type tinyint 3 1
container_settings id int 10 0
container_settings keyword char 40
container_settings value char 50  √  null
container_sorting child_id int 10 0
container_sorting obj_id int 10 0
container_sorting parent_id int 10 0
container_sorting parent_type varchar 5  √  null
container_sorting position int 10 0
container_sorting_bl block_ids varchar 4000  √  null
container_sorting_bl obj_id int 10 0
container_sorting_set new_items_order tinyint 3 0
container_sorting_set new_items_position tinyint 3 1
container_sorting_set obj_id int 10 0
container_sorting_set sort_direction tinyint 3 0
container_sorting_set sort_mode tinyint 3 0
content_object clean_frames char 1  √  n
content_object default_layout varchar 100  √  toc2win
content_object disable_def_feedback int 10 0
content_object downloads_active char 1  √  n
content_object downloads_public_active char 1  √  y
content_object footer_page int 10 0
content_object for_translation tinyint 3 0
content_object header_page int 10 0
content_object hide_head_foot_print tinyint 3 0
content_object hist_user_comments char 1  √  n
content_object id int 10 0
content_object is_online char 1  √  n
content_object layout_per_page tinyint 3  √  null
content_object lm_menu_active char 1  √  y
content_object no_glo_appendix char 1  √  n
content_object numbering char 1  √  n
content_object page_header char 8  √  st_title
content_object print_view_active char 1  √  y
content_object progr_icons tinyint 3 0
content_object public_access_mode char 8  √  complete
content_object public_html_file varchar 50  √  null
content_object public_scorm_file varchar 50  √  null
content_object public_xml_file varchar 50  √  null
content_object rating tinyint 3 0
content_object rating_pages tinyint 3  √  0
content_object restrict_forw_nav tinyint 3 0
content_object store_tries tinyint 3 0
content_object stylesheet int 10 0
content_object toc_active char 1  √  y
content_object toc_mode char 8  √  chapters
copg_multilang master_lang varchar 2
copg_multilang parent_id int 10 0
copg_multilang parent_type varchar 10 0
copg_multilang_lang lang varchar 2
copg_multilang_lang parent_id int 10 0
copg_multilang_lang parent_type varchar 10 0
copg_pc_def component varchar 40  √  null
copg_pc_def def_enabled tinyint 3  √  0
copg_pc_def directory varchar 40  √  null
copg_pc_def int_links tinyint 3 0
copg_pc_def name varchar 40
copg_pc_def pc_type varchar 20
copg_pc_def style_classes tinyint 3 0
copg_pc_def xsl tinyint 3 0
copg_pobj_def class_name varchar 80
copg_pobj_def component varchar 40  √  null
copg_pobj_def directory varchar 40  √  null
copg_pobj_def parent_type varchar 20
copg_section_timings page_id int 10
copg_section_timings parent_type varchar 10
copg_section_timings unix_ts int 10 0
copy_wizard_options copy_id int 10 0
copy_wizard_options options longtext 2147483647  √  null
copy_wizard_options source_id int 10 0
cp_auxilaryresource auxiliaryresourceid varchar 255  √  null
cp_auxilaryresource cp_node_id int 10 0
cp_auxilaryresource purpose varchar 255  √  null
cp_condition c_condition varchar 50  √  null
cp_condition c_operator varchar 50  √  null
cp_condition cp_node_id int 10 0
cp_condition measurethreshold varchar 50  √  null
cp_condition referencedobjective varchar 50  √  null
cp_datamap cp_node_id int 10 0
cp_datamap read_shared_data tinyint 3  √  1
cp_datamap sco_node_id int 10 0
cp_datamap slm_id int 10
cp_datamap target_id varchar 4000
cp_datamap write_shared_data tinyint 3  √  1
cp_dependency cp_node_id int 10 0
cp_dependency resourceid varchar 50  √  null
cp_file cp_node_id int 10 0
cp_file href varchar 4000  √  null
cp_hidelmsui cp_node_id int 10 0
cp_hidelmsui value varchar 50  √  null
cp_item completedbymeasure tinyint 3  √  0
cp_item completionthreshold varchar 50  √  1.0
cp_item cp_node_id int 10 0
cp_item datafromlms varchar 4000  √  null
cp_item id varchar 200  √  null
cp_item isvisible varchar 32  √  null
cp_item parameters varchar 255  √  null
cp_item progressweight varchar 50  √  1.0
cp_item resourceid varchar 200  √  null
cp_item sequencingid varchar 50  √  null
cp_item timelimitaction varchar 30  √  null
cp_item title varchar 255  √  null
cp_manifest base varchar 200  √  null
cp_manifest cp_node_id int 10 0
cp_manifest defaultorganization varchar 50  √  null
cp_manifest id varchar 200  √  null
cp_manifest title varchar 255  √  null
cp_manifest uri varchar 255  √  null
cp_manifest version varchar 200  √  null
cp_mapinfo cp_node_id int 10 0
cp_mapinfo readnormalmeasure tinyint 3  √  null
cp_mapinfo readsatisfiedstatus tinyint 3  √  null
cp_mapinfo targetobjectiveid varchar 255  √  null
cp_mapinfo writenormalmeasure tinyint 3  √  null
cp_mapinfo writesatisfiedstatus tinyint 3  √  null
cp_node cp_node_id int 10 0
cp_node nodename varchar 50  √  null
cp_node slm_id int 10  √  null
cp_node_seq sequence int 10  √ 
cp_objective c_primary tinyint 3  √  null
cp_objective cp_node_id int 10 0
cp_objective minnormalmeasure varchar 50  √  null
cp_objective objectiveid varchar 200  √  null
cp_objective satisfiedbymeasure tinyint 3  √  null
cp_organization cp_node_id int 10 0
cp_organization id varchar 200  √  null
cp_organization objectivesglobtosys tinyint 3  √  null
cp_organization sequencingid varchar 50  √  null
cp_organization structure varchar 200  √  null
cp_organization title varchar 255  √  null
cp_package activitytree longtext 2147483647  √  null
cp_package c_identifier varchar 255  √  null
cp_package c_settings varchar 255  √  null
cp_package created varchar 20  √  null
cp_package global_to_system tinyint 3 1
cp_package jsdata longtext 2147483647  √  null
cp_package modified varchar 20  √  null
cp_package obj_id int 10 0
cp_package persistprevattempts int 10  √  null
cp_package shared_data_global_to_system tinyint 3  √  1
cp_package xmldata longtext 2147483647  √  null
cp_resource base varchar 4000  √  null
cp_resource c_type varchar 30  √  null
cp_resource cp_node_id int 10 0
cp_resource href varchar 4000  √  null
cp_resource id varchar 200  √  null
cp_resource scormtype varchar 32  √  null
cp_rule action varchar 50  √  null
cp_rule c_type varchar 50  √  null
cp_rule childactivityset varchar 50  √  null
cp_rule conditioncombination varchar 50  √  null
cp_rule cp_node_id int 10 0
cp_rule minimumcount int 10  √  null
cp_rule minimumpercent varchar 50  √  null
cp_sequencing activityabsdurlimit varchar 20  √  null
cp_sequencing activityexpdurlimit varchar 20  √  null
cp_sequencing attemptabsdurlimit varchar 20  √  null
cp_sequencing attemptexpdurlimit varchar 20  √  null
cp_sequencing attemptlimit int 10  √  null
cp_sequencing begintimelimit varchar 20  √  null
cp_sequencing choice tinyint 3  √  null
cp_sequencing choiceexit tinyint 3  √  null
cp_sequencing completionbycontent tinyint 3  √  null
cp_sequencing constrainchoice tinyint 3  √  null
cp_sequencing cp_node_id int 10 0
cp_sequencing endtimelimit varchar 20  √  null
cp_sequencing flow tinyint 3  √  null
cp_sequencing forwardonly tinyint 3  √  null
cp_sequencing id varchar 200  √  null
cp_sequencing measuresatisfactive tinyint 3  √  null
cp_sequencing objectivebycontent tinyint 3  √  null
cp_sequencing objectivemeasweight double 22  √  null
cp_sequencing preventactivation tinyint 3  √  null
cp_sequencing randomizationtiming varchar 50  √  null
cp_sequencing reorderchildren tinyint 3  √  null
cp_sequencing requiredcompleted varchar 50  √  null
cp_sequencing requiredforsatisfied varchar 50  √  null
cp_sequencing requiredincomplete varchar 50  √  null
cp_sequencing requirednotsatisfied varchar 50  √  null
cp_sequencing rollupobjectivesatis tinyint 3  √  null
cp_sequencing rollupprogcompletion tinyint 3  √  null
cp_sequencing selectcount int 10  √  null
cp_sequencing selectiontiming varchar 50  √  null
cp_sequencing sequencingid varchar 50  √  null
cp_sequencing tracked tinyint 3  √  null
cp_sequencing usecurattemptobjinfo tinyint 3  √  null
cp_sequencing usecurattemptproginfo tinyint 3  √  null
cp_suspend data longtext 2147483647  √  null
cp_suspend obj_id int 10  √  null
cp_suspend user_id int 10  √  null
cp_tree child int 10 0
cp_tree depth int 10  √  null
cp_tree lft int 10  √  null
cp_tree obj_id int 10 0
cp_tree parent int 10  √  null
cp_tree rgt int 10  √  null
cron_job alive_ts int 10  √  null
cron_job class varchar 255  √  null
cron_job component varchar 200  √  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
cron_job path varchar 400  √  null
cron_job running_ts int 10  √  null
cron_job schedule_type tinyint 3  √  null
cron_job schedule_value int 10  √  null
crs_archives archive_date int 10  √  null
crs_archives archive_id int 10 0
crs_archives archive_lang varchar 16  √  null
crs_archives archive_name varchar 255  √  null
crs_archives archive_size int 10  √  null
crs_archives archive_type tinyint 3 0
crs_archives course_id int 10 0
crs_archives_seq sequence int 10  √ 
crs_f_definitions field_id int 10 0
crs_f_definitions field_name varchar 255  √  null
crs_f_definitions field_required tinyint 3 0
crs_f_definitions field_type tinyint 3 0
crs_f_definitions field_values longtext 2147483647  √  null
crs_f_definitions field_values_opt varchar 1000  √  null
crs_f_definitions obj_id int 10 0
crs_f_definitions_seq sequence int 10  √ 
crs_file course_id int 10 0
crs_file file_id int 10 0
crs_file file_name char 64  √  null
crs_file file_size int 10 0
crs_file file_type char 64  √  null
crs_file_seq sequence int 10  √ 
crs_groupings crs_grp_id int 10 0
crs_groupings crs_id int 10 0
crs_groupings crs_ref_id int 10 0
crs_groupings unique_field char 32  √  null
crs_items changeable tinyint 3 0
crs_items earliest_start int 10 0
crs_items latest_end int 10 0
crs_items obj_id int 10 0
crs_items parent_id int 10 0
crs_items position int 10  √  null
crs_items suggestion_end int 10 0
crs_items suggestion_start int 10 0
crs_items timing_end int 10 0
crs_items timing_start int 10 0
crs_items timing_type tinyint 3  √  null
crs_items visible tinyint 3 0
crs_lm_history crs_ref_id int 10 0
crs_lm_history last_access int 10 0
crs_lm_history lm_page_id int 10 0
crs_lm_history lm_ref_id int 10 0
crs_lm_history usr_id int 10 0
crs_objective_lm lm_ass_id int 10 0
crs_objective_lm obj_id int 10 0
crs_objective_lm objective_id int 10 0
crs_objective_lm position int 10  √  0
crs_objective_lm ref_id int 10 0
crs_objective_lm type char 6  √  null
crs_objective_lm_seq sequence int 10  √ 
crs_objective_qst obj_id int 10 0
crs_objective_qst objective_id int 10 0
crs_objective_qst qst_ass_id int 10 0
crs_objective_qst question_id int 10 0
crs_objective_qst ref_id int 10 0
crs_objective_qst_seq sequence int 10  √ 
crs_objective_status objective_id int 10 0
crs_objective_status status tinyint 3 0
crs_objective_status user_id int 10 0
crs_objective_status_p objective_id int 10 0
crs_objective_status_p user_id int 10 0
crs_objective_tst obj_id int 10 0
crs_objective_tst objective_id int 10 0
crs_objective_tst ref_id int 10 0
crs_objective_tst test_objective_id int 10 0
crs_objective_tst tst_limit tinyint 3  √  null
crs_objective_tst tst_limit_p smallint 5 0
crs_objective_tst tst_status tinyint 3  √  null
crs_objective_tst_seq sequence int 10  √ 
crs_objectives active tinyint 3  √  1
crs_objectives created int 10 0
crs_objectives crs_id int 10 0
crs_objectives description varchar 500  √  null
crs_objectives objective_id int 10 0
crs_objectives passes smallint 5  √  0
crs_objectives position int 10 0
crs_objectives title varchar 70  √  null
crs_objectives_seq sequence int 10  √ 
crs_settings abo tinyint 3  √  1
crs_settings activation_end int 10  √  null
crs_settings activation_start int 10  √  null
crs_settings activation_type tinyint 3 0
crs_settings archive_end int 10  √  null
crs_settings archive_start int 10  √  null
crs_settings archive_type int 10  √  null
crs_settings auto_notification tinyint 3 1
crs_settings auto_wait tinyint 3 0
crs_settings contact_consultation varchar 4000  √  null
crs_settings contact_email varchar 255  √  null
crs_settings contact_name varchar 255  √  null
crs_settings contact_phone varchar 255  √  null
crs_settings contact_responsibility varchar 255  √  null
crs_settings crs_end int 10  √  null
crs_settings crs_start int 10  √  null
crs_settings enable_course_map tinyint 3 0
crs_settings important varchar 4000  √  null
crs_settings latitude varchar 30  √  null
crs_settings leave_end int 10  √  null
crs_settings location_zoom int 10 0
crs_settings longitude varchar 30  √  null
crs_settings mail_members_type tinyint 3  √  1
crs_settings min_members smallint 5  √  null
crs_settings obj_id int 10 0
crs_settings reg_ac varchar 32  √  null
crs_settings reg_ac_enabled tinyint 3
crs_settings session_limit tinyint 3 0
crs_settings session_next bigint 19 -1
crs_settings session_prev bigint 19 -1
crs_settings show_members tinyint 3 1
crs_settings sortorder int 10  √  null
crs_settings status_dt tinyint 3  √  2
crs_settings sub_end int 10  √  null
crs_settings sub_limitation_type tinyint 3 0
crs_settings sub_max_members int 10  √  null
crs_settings sub_mem_limit tinyint 3 0
crs_settings sub_notify int 10  √  null
crs_settings sub_password varchar 32  √  null
crs_settings sub_start int 10  √  null
crs_settings sub_type int 10  √  null
crs_settings syllabus varchar 4000  √  null
crs_settings view_mode tinyint 3 0
crs_settings waiting_list tinyint 3 1
crs_start crs_id int 10 0
crs_start crs_start_id int 10 0
crs_start item_ref_id int 10 0
crs_start pos int 10  √  null
crs_start_seq sequence int 10  √ 
crs_timings_planed item_id int 10 0
crs_timings_planed planed_end int 10 0
crs_timings_planed planed_start int 10 0
crs_timings_planed usr_id int 10 0
crs_timings_usr_accept accept tinyint 3 0
crs_timings_usr_accept crs_id int 10 0
crs_timings_usr_accept remark varchar 4000  √  null
crs_timings_usr_accept usr_id int 10 0
crs_timings_usr_accept visible tinyint 3 0
crs_user_data field_id int 10 0
crs_user_data usr_id int 10 0
crs_user_data value varchar 4000  √  null
crs_waiting_list obj_id int 10 0
crs_waiting_list sub_time int 10 0
crs_waiting_list usr_id int 10 0
ctrl_calls child varchar 100
ctrl_calls comp_prefix varchar 50  √  null
ctrl_calls parent varchar 100
ctrl_classfile cid varchar 4  √  null
ctrl_classfile class varchar 100
ctrl_classfile comp_prefix varchar 50  √  null
ctrl_classfile filename varchar 250  √  null
ctrl_classfile plugin_path varchar 250  √  null
ctrl_structure call_node longtext 2147483647  √  null
ctrl_structure forward longtext 2147483647  √  null
ctrl_structure parent longtext 2147483647  √  null
ctrl_structure root_class varchar 40
data_cache keyword varchar 50
data_cache module varchar 50 common
data_cache value longtext 2147483647  √  null
dav_lock dav_owner varchar 200  √  null
dav_lock depth int 10 0
dav_lock expires int 10 0
dav_lock ilias_owner int 10 0
dav_lock node_id int 10 0
dav_lock obj_id int 10 0
dav_lock scope char 1  √  s
dav_lock token varchar 255
dav_lock type char 1  √  w
dav_property name varchar 120
dav_property node_id int 10 0
dav_property ns varchar 120 DAV:
dav_property obj_id int 10 0
dav_property value varchar 4000  √  null
dbk_translations id int 10 0
dbk_translations tr_id int 10 0
desktop_item item_id int 10 0
desktop_item parameters varchar 200  √  null
desktop_item type varchar 4  √  null
desktop_item user_id int 10 0
didactic_tpl_a id int 10
didactic_tpl_a tpl_id int 10
didactic_tpl_a type_id tinyint 3
didactic_tpl_a_seq sequence int 10  √ 
didactic_tpl_abr action_id int 10
didactic_tpl_abr filter_type tinyint 3
didactic_tpl_alp action_id int 10
didactic_tpl_alp filter_type tinyint 3
didactic_tpl_alp template_id int 10
didactic_tpl_alp template_type tinyint 3
didactic_tpl_alr action_id int 10
didactic_tpl_alr role_template_id int 10  √  null
didactic_tpl_fp parent_id int 10
didactic_tpl_fp parent_type varchar 32  √  null
didactic_tpl_fp pattern varchar 64  √  null
didactic_tpl_fp pattern_id int 10
didactic_tpl_fp pattern_sub_type tinyint 3
didactic_tpl_fp pattern_type tinyint 3
didactic_tpl_fp_seq sequence int 10  √ 
didactic_tpl_objs obj_id int 10
didactic_tpl_objs ref_id int 10 0
didactic_tpl_objs tpl_id int 10
didactic_tpl_sa id int 10
didactic_tpl_sa obj_type varchar 8
didactic_tpl_settings description varchar 512  √  null
didactic_tpl_settings enabled tinyint 3
didactic_tpl_settings id int 10
didactic_tpl_settings info varchar 4000  √  null
didactic_tpl_settings title varchar 64  √  null
didactic_tpl_settings type tinyint 3
didactic_tpl_settings_seq sequence int 10  √ 
ecs_cmap_rule attribute varchar 64  √  null
ecs_cmap_rule create_subdir tinyint 3
ecs_cmap_rule directory varchar 64  √  null
ecs_cmap_rule filter varchar 512  √  null
ecs_cmap_rule is_filter tinyint 3
ecs_cmap_rule mid int 10
ecs_cmap_rule ref_id int 10
ecs_cmap_rule rid int 10
ecs_cmap_rule sid int 10
ecs_cmap_rule subdir_type tinyint 3
ecs_cmap_rule_seq sequence int 10  √ 
ecs_cms_data cms_id varchar 512  √  null
ecs_cms_data deleted tinyint 3 0
ecs_cms_data mid int 10  √  null
ecs_cms_data obj_id int 10 0
ecs_cms_data server_id int 10  √  null
ecs_cms_data status smallint 5 1
ecs_cms_data term varchar 255  √  null
ecs_cms_data title varchar 512  √  null
ecs_cms_data tree_id int 10  √  null
ecs_cms_data_seq sequence int 10  √ 
ecs_cms_tree child int 10 0
ecs_cms_tree depth int 10  √  null
ecs_cms_tree lft int 10  √  null
ecs_cms_tree parent int 10  √  null
ecs_cms_tree rgt int 10  √  null
ecs_cms_tree tree int 10 0
ecs_community cid int 10
ecs_community cname varchar 255  √  null
ecs_community mids varchar 512  √  null
ecs_community own_id int 10
ecs_community sid int 10
ecs_container_mapping container_id int 10 0
ecs_container_mapping date_range_end int 10 0
ecs_container_mapping date_range_start int 10 0
ecs_container_mapping field_name varchar 255  √  null
ecs_container_mapping mapping_id int 10 0
ecs_container_mapping mapping_type tinyint 3 0
ecs_container_mapping mapping_value varchar 255  √  null
ecs_container_mapping_seq sequence int 10  √ 
ecs_course_assignments cms_id int 10
ecs_course_assignments cms_sub_id int 10  √  0
ecs_course_assignments id int 10
ecs_course_assignments mid int 10
ecs_course_assignments obj_id int 10
ecs_course_assignments sid int 10
ecs_course_assignments status tinyint 3
ecs_course_assignments usr_id varchar 64  √  null
ecs_course_assignments_seq sequence int 10  √ 
ecs_crs_mapping_atts id int 10
ecs_crs_mapping_atts mid int 10
ecs_crs_mapping_atts name varchar 64  √  null
ecs_crs_mapping_atts sid int 10
ecs_crs_mapping_atts_seq sequence int 10  √ 
ecs_data_mapping advmd_id int 10
ecs_data_mapping ecs_field varchar 32
ecs_data_mapping mapping_type tinyint 3 0
ecs_data_mapping sid int 10
ecs_events event_id int 10 0
ecs_events id int 10 0
ecs_events op char 32  √  null
ecs_events server_id int 10 0
ecs_events type char 32  √  null
ecs_events_seq sequence int 10  √ 
ecs_export econtent_id int 10 0
ecs_export obj_id int 10 0
ecs_export server_id int 10 0
ecs_import content_id varchar 255  √  null
ecs_import econtent_id varchar 512  √  null
ecs_import ecs_id int 10  √  0
ecs_import mid int 10 0
ecs_import obj_id int 10 0
ecs_import server_id int 10 0
ecs_import sub_id varchar 64  √  null
ecs_node_mapping_a cs_id int 10 0
ecs_node_mapping_a cs_root int 10 0
ecs_node_mapping_a mid int 10 0
ecs_node_mapping_a obj_id int 10  √  null
ecs_node_mapping_a position_update tinyint 3  √  null
ecs_node_mapping_a ref_id int 10  √  null
ecs_node_mapping_a server_id int 10 0
ecs_node_mapping_a title_update tinyint 3  √  null
ecs_node_mapping_a tree_update tinyint 3  √  null
ecs_part_settings cname varchar 255  √  null
ecs_part_settings dtoken tinyint 3 1
ecs_part_settings export tinyint 3
ecs_part_settings export_types varchar 4000  √  null
ecs_part_settings import tinyint 3
ecs_part_settings import_type tinyint 3  √  null
ecs_part_settings import_types varchar 4000  √  null
ecs_part_settings mid int 10
ecs_part_settings sid int 10
ecs_part_settings title varchar 255  √  null
ecs_part_settings token tinyint 3  √  1
ecs_remote_user eru_id int 10 0
ecs_remote_user mid int 10 0
ecs_remote_user remote_usr_id char 50  √  null
ecs_remote_user sid int 10 0
ecs_remote_user usr_id int 10 0
ecs_remote_user_seq sequence int 10  √ 
ecs_server active tinyint 3  √  0
ecs_server approval_rcp varchar 512  √  null
ecs_server auth_pass varchar 128  √  null
ecs_server auth_type tinyint 3  √  1
ecs_server auth_user varchar 32  √  null
ecs_server ca_cert_path varchar 512  √  null
ecs_server cert_serial varchar 32  √  null
ecs_server client_cert_path varchar 512  √  null
ecs_server duration int 10  √  0
ecs_server econtent_rcp varchar 512  √  null
ecs_server global_role int 10  √  0
ecs_server import_id int 10  √  0
ecs_server key_password varchar 32  √  null
ecs_server key_path varchar 512  √  null
ecs_server polling_time int 10  √  0
ecs_server port smallint 5  √  1
ecs_server protocol tinyint 3  √  1
ecs_server server varchar 255  √  null
ecs_server server_id int 10 0
ecs_server title varchar 128  √  null
ecs_server user_rcp varchar 512  √  null
ecs_server_seq sequence int 10  √ 
event description varchar 4000  √  null
event details varchar 4000  √  null
event event_id int 10 0
event location varchar 4000  √  null
event obj_id int 10 0
event participation tinyint 3 0
event reg_auto_wait tinyint 3 0
event reg_limit_users int 10  √  0
event reg_limited tinyint 3  √  0
event reg_min_users smallint 5  √  null
event reg_type smallint 5  √  0
event reg_waiting_list tinyint 3  √  0
event registration tinyint 3 0
event title varchar 70  √  null
event tutor_email varchar 127  √  null
event tutor_name varchar 4000  √  null
event tutor_phone varchar 127  √  null
event_appointment appointment_id int 10 0
event_appointment e_end datetime 19  √  null
event_appointment e_start datetime 19  √  null
event_appointment ending_time int 10 0
event_appointment event_id int 10 0
event_appointment fulltime tinyint 3 0
event_appointment starting_time int 10 0
event_appointment_seq sequence int 10  √ 
event_file event_id int 10 0
event_file file_id int 10 0
event_file file_name char 64  √  null
event_file file_size int 10 0
event_file file_type char 64  √  null
event_file_seq sequence int 10  √ 
event_items event_id int 10 0
event_items item_id int 10 0
event_participants e_comment longtext 2147483647  √  null
event_participants event_id int 10 0
event_participants mark longtext 2147483647  √  null
event_participants participated tinyint 3 0
event_participants registered tinyint 3 0
event_participants usr_id int 10 0
event_seq sequence int 10  √ 
exc_assignment deadline2 int 10  √  null
exc_assignment exc_id int 10
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
exc_assignment id int 10
exc_assignment instruction longtext 2147483647  √  null
exc_assignment mandatory tinyint 3  √  1
exc_assignment max_file tinyint 3  √  null
exc_assignment order_nr int 10 0
exc_assignment peer tinyint 3 0
exc_assignment peer_char smallint 5  √  null
exc_assignment peer_crit_cat int 10  √  null
exc_assignment peer_dl int 10  √  0
exc_assignment peer_file tinyint 3  √  0
exc_assignment peer_min smallint 5 0
exc_assignment peer_prsl tinyint 3  √  0
exc_assignment peer_rating tinyint 3 1
exc_assignment peer_text tinyint 3 1
exc_assignment peer_unlock tinyint 3 0
exc_assignment peer_valid tinyint 3 1
exc_assignment start_time int 10  √  null
exc_assignment team_tutor tinyint 3 0
exc_assignment time_stamp int 10  √  null
exc_assignment title varchar 200  √  null
exc_assignment type tinyint 3 1
exc_assignment_peer ass_id int 10
exc_assignment_peer giver_id int 10
exc_assignment_peer pcomment longtext 2147483647  √  null
exc_assignment_peer peer_id int 10
exc_assignment_peer tstamp datetime 19  √  null
exc_assignment_seq sequence int 10  √ 
exc_crit def varchar 4000  √  null
exc_crit descr varchar 1000  √  null
exc_crit id int 10 0
exc_crit parent int 10 0
exc_crit pos int 10 0
exc_crit required tinyint 3 0
exc_crit title varchar 255  √  null
exc_crit type varchar 255  √  null
exc_crit_cat id int 10 0
exc_crit_cat parent int 10 0
exc_crit_cat pos int 10 0
exc_crit_cat title varchar 255  √  null
exc_crit_cat_seq sequence int 10  √ 
exc_crit_seq sequence int 10  √ 
exc_data certificate_visibility tinyint 3 0
exc_data compl_by_submission tinyint 3 0
exc_data instruction longtext 2147483647  √  null
exc_data obj_id int 10 0
exc_data pass_mode varchar 8 all
exc_data pass_nr int 10  √  null
exc_data show_submissions tinyint 3 0
exc_data time_stamp int 10  √  null
exc_mem_ass_status ass_id int 10
exc_mem_ass_status feedback tinyint 3 0
exc_mem_ass_status feedback_time datetime 19  √  null
exc_mem_ass_status mark varchar 32  √  null
exc_mem_ass_status notice varchar 4000  √  null
exc_mem_ass_status returned tinyint 3 0
exc_mem_ass_status sent tinyint 3  √  null
exc_mem_ass_status sent_time datetime 19  √  null
exc_mem_ass_status solved tinyint 3  √  null
exc_mem_ass_status status char 9  √  notgraded
exc_mem_ass_status status_time datetime 19  √  null
exc_mem_ass_status u_comment varchar 4000  √  null
exc_mem_ass_status usr_id int 10
exc_members feedback tinyint 3 0
exc_members feedback_time datetime 19  √  null
exc_members notice varchar 4000  √  null
exc_members obj_id int 10 0
exc_members returned tinyint 3 0
exc_members sent tinyint 3  √  null
exc_members sent_time datetime 19  √  null
exc_members solved tinyint 3  √  null
exc_members status char 9  √  notgraded
exc_members status_time datetime 19  √  null
exc_members usr_id int 10 0
exc_returned ass_id int 10  √  null
exc_returned atext longtext 2147483647  √  null
exc_returned filename varchar 1000  √  null
exc_returned filetitle varchar 1000  √  null
exc_returned late tinyint 3 0
exc_returned mimetype varchar 150  √  null
exc_returned obj_id int 10 0
exc_returned returned_id int 10 0
exc_returned ts datetime 19  √  null
exc_returned user_id int 10 0
exc_returned_seq sequence int 10  √ 
exc_usr_tutor ass_id int 10 0
exc_usr_tutor download_time datetime 19  √  null
exc_usr_tutor obj_id int 10 0
exc_usr_tutor tutor_id int 10 0
exc_usr_tutor usr_id int 10 0
export_file_info create_date datetime 19
export_file_info export_type varchar 32
export_file_info file_name varchar 64
export_file_info filename varchar 64
export_file_info obj_id int 10
export_file_info version varchar 16  √  null
export_options export_id smallint 5
export_options keyword smallint 5
export_options obj_id int 10
export_options pos int 10 0
export_options ref_id int 10
export_options value varchar 32  √  null
feedback_items anonymous tinyint 3 1
feedback_items description longtext 2147483647  √  null
feedback_items endtime int 10  √  0
feedback_items fb_id int 10 0
feedback_items first_vote_best tinyint 3  √  0
feedback_items interval_unit tinyint 3  √  null
feedback_items obj_id int 10  √  0
feedback_items ref_id int 10  √  0
feedback_items repeat_interval int 10  √  null
feedback_items required tinyint 3  √  0
feedback_items show_on varchar 6  √  null
feedback_items starttime int 10  √  0
feedback_items text_answer tinyint 3  √  0
feedback_items title varchar 255  √  null
feedback_items votes longtext 2147483647  √  null
feedback_items_seq sequence int 10  √ 
feedback_results fb_id int 10 0
feedback_results note longtext 2147483647  √  null
feedback_results user_id int 10  √  null
feedback_results vote int 10 0
feedback_results votetime int 10 0
file_based_lm id int 10 0
file_based_lm is_online char 1  √  n
file_based_lm show_bib tinyint 3  √  null
file_based_lm show_lic tinyint 3  √  null
file_based_lm startfile varchar 200  √  null
file_data f_mode char 8  √  object
file_data file_id int 10 0
file_data file_name char 250  √  null
file_data file_size int 10 0
file_data file_type char 250  √  null
file_data rating tinyint 3 0
file_data version int 10  √  null
file_usage id int 10 0
file_usage usage_hist_nr int 10 0
file_usage usage_id int 10 0
file_usage usage_lang varchar 2 -
file_usage usage_type varchar 10
frm_data top_date datetime 19  √  null
frm_data top_description varchar 255  √  null
frm_data top_frm_fk bigint 19 0
frm_data top_last_post varchar 50  √  null
frm_data top_mods int 10 0
frm_data top_name varchar 255  √  null
frm_data top_num_posts int 10 0
frm_data top_num_threads int 10 0
frm_data top_pk bigint 19 0
frm_data top_update datetime 19  √  null
frm_data top_usr_id bigint 19 0
frm_data update_user int 10 0
frm_data visits int 10 0
frm_data_seq sequence int 10  √ 
frm_notification admin_force_noti tinyint 3 0
frm_notification frm_id int 10 0
frm_notification notification_id int 10 0
frm_notification thread_id int 10 0
frm_notification user_id int 10 0
frm_notification user_id_noti int 10  √  null
frm_notification user_toggle_noti tinyint 3 0
frm_notification_seq sequence int 10  √ 
frm_posts import_name varchar 4000  √  null
frm_posts is_author_moderator tinyint 3  √  null
frm_posts notify tinyint 3 0
frm_posts pos_activation_date datetime 19  √  null
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_cens_date datetime 19  √  null
frm_posts pos_date datetime 19  √  null
frm_posts pos_display_user_id int 10 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
frm_posts update_user int 10 0
frm_posts_deleted deleted_by varchar 255
frm_posts_deleted deleted_date datetime 19
frm_posts_deleted deleted_id int 10
frm_posts_deleted forum_id int 10
frm_posts_deleted forum_title varchar 255
frm_posts_deleted is_thread_deleted tinyint 3 0
frm_posts_deleted obj_id int 10
frm_posts_deleted pos_display_user_id int 10 0
frm_posts_deleted pos_usr_alias varchar 255  √  null
frm_posts_deleted post_date datetime 19
frm_posts_deleted post_message longtext 2147483647
frm_posts_deleted post_title varchar 255
frm_posts_deleted ref_id int 10
frm_posts_deleted thread_id int 10
frm_posts_deleted thread_title varchar 255
frm_posts_deleted_seq sequence int 10  √ 
frm_posts_seq sequence int 10  √ 
frm_posts_tree depth int 10 0
frm_posts_tree fpt_date datetime 19  √  null
frm_posts_tree fpt_pk bigint 19 0
frm_posts_tree lft int 10 0
frm_posts_tree parent_pos bigint 19 0
frm_posts_tree pos_fk bigint 19 0
frm_posts_tree rgt int 10 0
frm_posts_tree thr_fk bigint 19 0
frm_posts_tree_seq sequence int 10  √ 
frm_settings add_re_subject tinyint 3 0
frm_settings admin_force_noti tinyint 3 0
frm_settings anonymized tinyint 3 0
frm_settings default_view int 10 0
frm_settings file_upload_allowed tinyint 3 0
frm_settings mark_mod_posts tinyint 3 0
frm_settings notification_type varchar 10  √  null
frm_settings obj_id int 10 0
frm_settings post_activation tinyint 3 0
frm_settings preset_subject tinyint 3 1
frm_settings statistics_enabled tinyint 3 0
frm_settings thread_rating tinyint 3 0
frm_settings thread_sorting int 10 0
frm_settings user_toggle_noti tinyint 3 0
frm_thread_access access_last int 10 0
frm_thread_access access_old int 10 0
frm_thread_access access_old_ts datetime 19  √  null
frm_thread_access obj_id int 10 0
frm_thread_access thread_id int 10 0
frm_thread_access usr_id int 10 0
frm_threads avg_rating double 22 0
frm_threads import_name varchar 4000  √  null
frm_threads is_closed tinyint 3 0
frm_threads is_sticky tinyint 3 0
frm_threads thr_author_id int 10 0
frm_threads thr_date datetime 19  √  null
frm_threads thr_display_user_id int 10 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_threads thread_sorting int 10 0
frm_threads visits int 10 0
frm_threads_seq sequence int 10  √ 
frm_user_read obj_id int 10 0
frm_user_read post_id int 10 0
frm_user_read thread_id int 10 0
frm_user_read usr_id int 10 0
glo_advmd_col_order field_id int 10
glo_advmd_col_order glo_id int 10
glo_advmd_col_order order_nr int 10
glossary downloads_active char 1  √  n
glossary glo_menu_active char 1  √  y
glossary id int 10 0
glossary is_online char 1  √  n
glossary pres_mode varchar 10 table
glossary public_html_file varchar 50  √  null
glossary public_xml_file varchar 50  √  null
glossary show_tax tinyint 3 0
glossary snippet_length int 10 200
glossary virtual char 7  √  none
glossary_definition id int 10 0
glossary_definition nr int 10 0
glossary_definition short_text varchar 4000  √  null
glossary_definition short_text_dirty int 10 0
glossary_definition term_id int 10 0
glossary_definition_seq sequence int 10  √ 
glossary_term create_date datetime 19  √  null
glossary_term glo_id int 10 0
glossary_term id int 10 0
glossary_term import_id varchar 50  √  null
glossary_term language char 2  √  null
glossary_term last_update datetime 19  √  null
glossary_term term varchar 200  √  null
glossary_term_seq sequence int 10  √ 
grp_settings auto_wait tinyint 3 0
grp_settings enablemap tinyint 3 0
grp_settings grp_type tinyint 3 0
grp_settings information varchar 4000  √  null
grp_settings latitude varchar 30  √  null
grp_settings leave_end int 10  √  null
grp_settings location_zoom int 10 0
grp_settings longitude varchar 30  √  null
grp_settings mail_members_type tinyint 3  √  1
grp_settings obj_id int 10 0
grp_settings reg_ac varchar 32  √  null
grp_settings reg_ac_enabled tinyint 3
grp_settings registration_enabled tinyint 3 0
grp_settings registration_end datetime 19  √  null
grp_settings registration_max_members int 10 0
grp_settings registration_mem_limit tinyint 3 0
grp_settings registration_min_members smallint 5  √  null
grp_settings registration_password char 32  √  null
grp_settings registration_start datetime 19  √  null
grp_settings registration_type tinyint 3 0
grp_settings registration_unlimited tinyint 3 0
grp_settings view_mode tinyint 3 6
grp_settings waiting_list tinyint 3 0
help_map chap int 10
help_map component varchar 10
help_map module_id int 10 0
help_map perm varchar 20
help_map screen_id varchar 100
help_map screen_sub_id varchar 100
help_module id int 10 0
help_module lm_id int 10 0
help_module_seq sequence int 10  √ 
help_tooltip comp varchar 10
help_tooltip id int 10
help_tooltip lang char 2 de
help_tooltip module_id int 10 0
help_tooltip tt_id varchar 200
help_tooltip tt_text varchar 4000  √  null
help_tooltip_seq sequence int 10  √ 
history action varchar 20  √  null
history hdate datetime 19  √  null
history id int 10 0
history info_params varchar 4000  √  null
history obj_id int 10 0
history obj_type varchar 8  √  null
history user_comment longtext 2147483647  √  null
history usr_id int 10 0
history_seq sequence int 10  √ 
il_bibl_attribute entry_id int 10  √  null
il_bibl_attribute id int 10 0
il_bibl_attribute name varchar 32  √  null
il_bibl_attribute value varchar 4000  √  null
il_bibl_attribute_seq sequence int 10  √ 
il_bibl_data filename varchar 256  √  null
il_bibl_data id int 10 0
il_bibl_data is_online tinyint 3  √  null
il_bibl_entry data_id int 10  √  null
il_bibl_entry id int 10 0
il_bibl_entry type varchar 128  √  null
il_bibl_entry_seq sequence int 10  √ 
il_bibl_overview_model filetype varchar 8  √  null
il_bibl_overview_model literature_type varchar 32  √  null
il_bibl_overview_model ovm_id int 10 0
il_bibl_overview_model pattern varchar 512  √  null
il_bibl_settings id int 10 0
il_bibl_settings img varchar 128  √  null
il_bibl_settings name varchar 50 -
il_bibl_settings show_in_list tinyint 3  √  0
il_bibl_settings url varchar 128 -
il_bibl_settings_seq sequence int 10  √ 
il_block_setting block_id int 10 0
il_block_setting setting varchar 40
il_block_setting type varchar 20
il_block_setting user_id int 10 0
il_block_setting value varchar 200  √  null
il_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
il_blog approval tinyint 3  √  0
il_blog authors tinyint 3 1
il_blog bg_color char 6  √  null
il_blog font_color char 6  √  null
il_blog id int 10 0
il_blog img varchar 255  √  null
il_blog keywords tinyint 3 1
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
il_blog ov_post smallint 5  √  0
il_blog ppic tinyint 3  √  null
il_blog rss_active tinyint 3  √  0
il_blog_posting approved tinyint 3  √  0
il_blog_posting author int 10 0
il_blog_posting blog_id int 10 0
il_blog_posting created datetime 19
il_blog_posting id int 10 0
il_blog_posting title varchar 400  √  null
il_blog_posting_seq sequence int 10  √ 
il_certificate obj_id int 10
il_cld_data auth_complete tinyint 3  √  null
il_cld_data id int 10
il_cld_data is_online tinyint 3  √  null
il_cld_data owner_id bigint 19
il_cld_data root_folder varchar 255  √  null
il_cld_data root_id varchar 255  √  null
il_cld_data service varchar 255  √  null
il_component id char 10
il_component name varchar 200  √  null
il_component type char 10
il_custom_block context_obj_id int 10  √  null
il_custom_block context_obj_type varchar 10  √  null
il_custom_block context_sub_obj_id int 10  √  null
il_custom_block context_sub_obj_type varchar 10  √  null
il_custom_block id int 10 0
il_custom_block title varchar 200  √  null
il_custom_block type varchar 20  √  null
il_custom_block_seq sequence int 10  √ 
il_dcl_data approval tinyint 3  √  null
il_dcl_data id int 10
il_dcl_data is_online tinyint 3  √  null
il_dcl_data main_table_id int 10
il_dcl_data notification tinyint 3  √  null
il_dcl_data public_notes tinyint 3  √  null
il_dcl_data rating tinyint 3  √  null
il_dcl_data_seq sequence int 10  √ 
il_dcl_datatype id int 10
il_dcl_datatype ildb_type varchar 256
il_dcl_datatype sort smallint 5  √  0
il_dcl_datatype storage_location int 10
il_dcl_datatype title varchar 256  √  null
il_dcl_datatype_prop datatype_id int 10  √  null
il_dcl_datatype_prop id int 10
il_dcl_datatype_prop inputformat tinyint 3
il_dcl_datatype_prop title varchar 256  √  null
il_dcl_field datatype_id int 10
il_dcl_field description longtext 2147483647  √  null
il_dcl_field id int 10
il_dcl_field is_locked tinyint 3 0
il_dcl_field is_unique tinyint 3 0
il_dcl_field required tinyint 3
il_dcl_field table_id int 10
il_dcl_field title varchar 256  √  null
il_dcl_field_prop datatype_prop_id int 10
il_dcl_field_prop field_id int 10
il_dcl_field_prop id int 10
il_dcl_field_prop value varchar 256  √  null
il_dcl_field_prop_seq sequence int 10  √ 
il_dcl_field_seq sequence int 10  √ 
il_dcl_record create_date datetime 19  √  null
il_dcl_record id int 10
il_dcl_record last_edit_by int 10  √  null
il_dcl_record last_update datetime 19  √  null
il_dcl_record owner int 10
il_dcl_record table_id int 10
il_dcl_record_field field_id int 10
il_dcl_record_field id int 10
il_dcl_record_field record_id int 10
il_dcl_record_field_seq sequence int 10  √ 
il_dcl_record_seq sequence int 10  √ 
il_dcl_stloc1_value id int 10
il_dcl_stloc1_value record_field_id int 10
il_dcl_stloc1_value value varchar 4000  √  null
il_dcl_stloc1_value_seq sequence int 10  √ 
il_dcl_stloc2_value id int 10
il_dcl_stloc2_value record_field_id int 10
il_dcl_stloc2_value value int 10  √  null
il_dcl_stloc2_value_seq sequence int 10  √ 
il_dcl_stloc3_value id int 10
il_dcl_stloc3_value record_field_id int 10
il_dcl_stloc3_value value datetime 19
il_dcl_stloc3_value_seq sequence int 10  √ 
il_dcl_table add_perm tinyint 3 1
il_dcl_table default_sort_field_id varchar 16 0
il_dcl_table default_sort_field_order varchar 4 asc
il_dcl_table delete_by_owner tinyint 3 0
il_dcl_table delete_perm tinyint 3 1
il_dcl_table description varchar 4000  √  null
il_dcl_table edit_by_owner tinyint 3 1
il_dcl_table edit_perm tinyint 3 1
il_dcl_table export_enabled tinyint 3  √  null
il_dcl_table id int 10
il_dcl_table is_visible tinyint 3 1
il_dcl_table limit_end datetime 19  √  null
il_dcl_table limit_start datetime 19  √  null
il_dcl_table limited tinyint 3 0
il_dcl_table obj_id int 10
il_dcl_table public_comments int 10 0
il_dcl_table title varchar 256  √  null
il_dcl_table view_own_records_perm int 10 0
il_dcl_table_seq sequence int 10  √ 
il_dcl_view formtype tinyint 3  √  null
il_dcl_view id int 10
il_dcl_view table_id int 10
il_dcl_view type tinyint 3  √  null
il_dcl_view_seq sequence int 10  √ 
il_dcl_viewdefinition field varchar 255
il_dcl_viewdefinition field_order int 10
il_dcl_viewdefinition is_set tinyint 3 0
il_dcl_viewdefinition view_id int 10
il_disk_quota owner_id int 10
il_disk_quota src_obj_id int 10
il_disk_quota src_size int 10
il_disk_quota src_type varchar 50
il_event_handling component varchar 50
il_event_handling id varchar 100
il_event_handling type varchar 10
il_exc_team ass_id int 10
il_exc_team id int 10
il_exc_team user_id int 10
il_exc_team_log action tinyint 3
il_exc_team_log details varchar 500  √  null
il_exc_team_log team_id int 10
il_exc_team_log tstamp int 10
il_exc_team_log user_id int 10
il_exc_team_seq sequence int 10  √ 
il_external_feed_block feed_url varchar 250  √  null
il_external_feed_block id int 10 0
il_external_feed_block_seq sequence int 10  √ 
il_gc_memcache_server flush_needed tinyint 3  √  null
il_gc_memcache_server host varchar 256  √  null
il_gc_memcache_server id bigint 19 0
il_gc_memcache_server port bigint 19  √  null
il_gc_memcache_server status tinyint 3  √  null
il_gc_memcache_server weight smallint 5  √  null
il_gc_memcache_server_seq sequence int 10  √ 
il_html_block content varchar 4000  √  null
il_html_block id int 10 0
il_log created datetime 19  √  null
il_log log_level int 10 0
il_log message varchar 250  √  null
il_log module varchar 50  √  null
il_md_cpr_selections copyright longtext 2147483647  √  null
il_md_cpr_selections costs tinyint 3 0
il_md_cpr_selections cpr_restrictions tinyint 3 1
il_md_cpr_selections description longtext 2147483647  √  null
il_md_cpr_selections entry_id int 10 0
il_md_cpr_selections language char 2  √  null
il_md_cpr_selections title varchar 128  √  null
il_md_cpr_selections_seq sequence int 10  √ 
il_media_cast_data def_access tinyint 3  √  0
il_media_cast_data downloadable tinyint 3  √  0
il_media_cast_data id int 10 0
il_media_cast_data is_online tinyint 3  √  0
il_media_cast_data public_files tinyint 3  √  0
il_media_cast_data sortmode tinyint 3  √  3
il_media_cast_data viewmode varchar 20  √  null
il_media_cast_data_ord item_id int 10
il_media_cast_data_ord obj_id int 10
il_media_cast_data_ord pos mediumint 7
il_meta_annotation a_date longtext 2147483647  √  null
il_meta_annotation description longtext 2147483647  √  null
il_meta_annotation description_language char 2  √  null
il_meta_annotation entity longtext 2147483647  √  null
il_meta_annotation meta_annotation_id int 10 0
il_meta_annotation obj_id int 10  √  null
il_meta_annotation obj_type varchar 6  √  null
il_meta_annotation rbac_id int 10  √  null
il_meta_annotation_seq sequence int 10  √ 
il_meta_classification description varchar 4000  √  null
il_meta_classification description_language char 2  √  null
il_meta_classification meta_classification_id int 10 0
il_meta_classification obj_id int 10  √  null
il_meta_classification obj_type varchar 6  √  null
il_meta_classification purpose varchar 32  √  null
il_meta_classification rbac_id int 10  √  null
il_meta_classification_seq sequence int 10  √ 
il_meta_contribute c_date varchar 4000  √  null
il_meta_contribute meta_contribute_id int 10 0
il_meta_contribute obj_id int 10  √  null
il_meta_contribute obj_type varchar 6  √  null
il_meta_contribute parent_id int 10  √  null
il_meta_contribute parent_type varchar 32  √  null
il_meta_contribute rbac_id int 10  √  null
il_meta_contribute role varchar 32  √  null
il_meta_contribute_seq sequence int 10  √ 
il_meta_description description longtext 2147483647  √  null
il_meta_description description_language char 2  √  null
il_meta_description meta_description_id int 10 0
il_meta_description obj_id int 10  √  null
il_meta_description obj_type varchar 6  √  null
il_meta_description parent_id int 10  √  null
il_meta_description parent_type varchar 16  √  null
il_meta_description rbac_id int 10  √  null
il_meta_description_seq sequence int 10  √ 
il_meta_educational context varchar 16  √  null
il_meta_educational difficulty varchar 16  √  null
il_meta_educational intended_end_user_role varchar 16  √  null
il_meta_educational interactivity_level varchar 16  √  null
il_meta_educational interactivity_type varchar 16  √  null
il_meta_educational learning_resource_type varchar 32  √  null
il_meta_educational meta_educational_id int 10 0
il_meta_educational obj_id int 10  √  null
il_meta_educational obj_type varchar 6  √  null
il_meta_educational rbac_id int 10  √  null
il_meta_educational semantic_density varchar 16  √  null
il_meta_educational typical_learning_time varchar 4000  √  null
il_meta_educational_seq sequence int 10  √ 
il_meta_entity entity varchar 4000  √  null
il_meta_entity meta_entity_id int 10 0
il_meta_entity obj_id int 10  √  null
il_meta_entity obj_type varchar 6  √  null
il_meta_entity parent_id int 10  √  null
il_meta_entity parent_type varchar 16  √  null
il_meta_entity rbac_id int 10  √  null
il_meta_entity_seq sequence int 10  √ 
il_meta_format format varchar 255  √  null
il_meta_format meta_format_id int 10 0
il_meta_format obj_id int 10  √  null
il_meta_format obj_type varchar 6  √  null
il_meta_format rbac_id int 10  √  null
il_meta_format_seq sequence int 10  √ 
il_meta_general coverage varchar 4000  √  null
il_meta_general coverage_language char 2  √  null
il_meta_general general_structure varchar 16  √  null
il_meta_general meta_general_id int 10 0
il_meta_general obj_id int 10  √  null
il_meta_general obj_type varchar 6  √  null
il_meta_general rbac_id int 10  √  null
il_meta_general title varchar 4000  √  null
il_meta_general title_language char 2  √  null
il_meta_general_seq sequence int 10  √ 
il_meta_identifier catalog varchar 4000  √  null
il_meta_identifier entry varchar 4000  √  null
il_meta_identifier meta_identifier_id int 10 0
il_meta_identifier obj_id int 10  √  null
il_meta_identifier obj_type varchar 6  √  null
il_meta_identifier parent_id int 10  √  null
il_meta_identifier parent_type varchar 16  √  null
il_meta_identifier rbac_id int 10  √  null
il_meta_identifier_ catalog varchar 4000  √  null
il_meta_identifier_ entry varchar 4000  √  null
il_meta_identifier_ meta_identifier__id int 10 0
il_meta_identifier_ obj_id int 10  √  null
il_meta_identifier_ obj_type varchar 6  √  null
il_meta_identifier_ parent_id int 10  √  null
il_meta_identifier_ parent_type varchar 16  √  null
il_meta_identifier_ rbac_id int 10  √  null
il_meta_identifier__seq sequence int 10  √ 
il_meta_identifier_seq sequence int 10  √ 
il_meta_keyword keyword varchar 4000  √  null
il_meta_keyword keyword_language char 2  √  null
il_meta_keyword meta_keyword_id int 10 0
il_meta_keyword obj_id int 10  √  null
il_meta_keyword obj_type varchar 6  √  null
il_meta_keyword parent_id int 10  √  null
il_meta_keyword parent_type varchar 32  √  null
il_meta_keyword rbac_id int 10  √  null
il_meta_keyword_seq sequence int 10  √ 
il_meta_language language char 2  √  null
il_meta_language meta_language_id int 10 0
il_meta_language obj_id int 10  √  null
il_meta_language obj_type char 6  √  null
il_meta_language parent_id int 10  √  null
il_meta_language parent_type char 16  √  null
il_meta_language rbac_id int 10  √  null
il_meta_language_seq sequence int 10  √ 
il_meta_lifecycle lifecycle_status varchar 16  √  null
il_meta_lifecycle meta_lifecycle_id int 10 0
il_meta_lifecycle meta_version varchar 4000  √  null
il_meta_lifecycle obj_id int 10  √  null
il_meta_lifecycle obj_type varchar 6  √  null
il_meta_lifecycle rbac_id int 10  √  null
il_meta_lifecycle version_language char 2  √  null
il_meta_lifecycle_seq sequence int 10  √ 
il_meta_location location varchar 4000  √  null
il_meta_location location_type varchar 16  √  null
il_meta_location meta_location_id int 10 0
il_meta_location obj_id int 10  √  null
il_meta_location obj_type varchar 6  √  null
il_meta_location parent_id int 10  √  null
il_meta_location parent_type varchar 16  √  null
il_meta_location rbac_id int 10  √  null
il_meta_location_seq sequence int 10  √ 
il_meta_meta_data language char 2  √  null
il_meta_meta_data meta_data_scheme char 16  √  null
il_meta_meta_data meta_meta_data_id int 10 0
il_meta_meta_data obj_id int 10  √  null
il_meta_meta_data obj_type char 6  √  null
il_meta_meta_data rbac_id int 10  √  null
il_meta_meta_data_seq sequence int 10  √ 
il_meta_relation kind char 16  √  null
il_meta_relation meta_relation_id int 10 0
il_meta_relation obj_id int 10  √  null
il_meta_relation obj_type char 6  √  null
il_meta_relation rbac_id int 10  √  null
il_meta_relation_seq sequence int 10  √ 
il_meta_requirement browser_maximum_version char 255  √  null
il_meta_requirement browser_minimum_version char 255  √  null
il_meta_requirement browser_name varchar 32  √  null
il_meta_requirement meta_requirement_id int 10 0
il_meta_requirement obj_id int 10  √  null
il_meta_requirement obj_type varchar 6  √  null
il_meta_requirement operating_system_name varchar 16  √  null
il_meta_requirement or_composite_id int 10 0
il_meta_requirement os_max_version char 255  √  null
il_meta_requirement os_min_version char 255  √  null
il_meta_requirement parent_id int 10  √  null
il_meta_requirement parent_type varchar 16  √  null
il_meta_requirement rbac_id int 10  √  null
il_meta_requirement_seq sequence int 10  √ 
il_meta_rights costs char 3  √  null
il_meta_rights cpr_and_or char 3  √  null
il_meta_rights description varchar 4000  √  null
il_meta_rights description_language char 2  √  null
il_meta_rights meta_rights_id int 10 0
il_meta_rights obj_id int 10  √  null
il_meta_rights obj_type varchar 6  √  null
il_meta_rights rbac_id int 10  √  null
il_meta_rights_seq sequence int 10  √ 
il_meta_tar meta_tar_id int 10 0
il_meta_tar obj_id int 10  √  null
il_meta_tar obj_type varchar 6  √  null
il_meta_tar parent_id int 10  √  null
il_meta_tar parent_type varchar 16  √  null
il_meta_tar rbac_id int 10  √  null
il_meta_tar tar_language char 2  √  null
il_meta_tar tar_max char 2  √  null
il_meta_tar tar_min char 2  √  null
il_meta_tar typical_age_range varchar 4000  √  null
il_meta_tar_seq sequence int 10  √ 
il_meta_taxon meta_taxon_id int 10 0
il_meta_taxon obj_id int 10  √  null
il_meta_taxon obj_type varchar 6  √  null
il_meta_taxon parent_id int 10  √  null
il_meta_taxon parent_type varchar 32  √  null
il_meta_taxon rbac_id int 10  √  null
il_meta_taxon taxon varchar 4000  √  null
il_meta_taxon taxon_id varchar 4000  √  null
il_meta_taxon taxon_language char 2  √  null
il_meta_taxon_path meta_taxon_path_id int 10 0
il_meta_taxon_path obj_id int 10  √  null
il_meta_taxon_path obj_type varchar 6  √  null
il_meta_taxon_path parent_id int 10  √  null
il_meta_taxon_path parent_type varchar 32  √  null
il_meta_taxon_path rbac_id int 10  √  null
il_meta_taxon_path source varchar 4000  √  null
il_meta_taxon_path source_language char 2  √  null
il_meta_taxon_path_seq sequence int 10  √ 
il_meta_taxon_seq sequence int 10  √ 
il_meta_technical duration varchar 4000  √  null
il_meta_technical ir varchar 4000  √  null
il_meta_technical ir_language char 2  √  null
il_meta_technical meta_technical_id int 10 0
il_meta_technical obj_id int 10  √  null
il_meta_technical obj_type varchar 6  √  null
il_meta_technical opr varchar 4000  √  null
il_meta_technical opr_language char 2  √  null
il_meta_technical rbac_id int 10  √  null
il_meta_technical t_size varchar 4000  √  null
il_meta_technical_seq sequence int 10  √ 
il_new_item_grp id int 10 0
il_new_item_grp pos smallint 5 0
il_new_item_grp titles varchar 1000  √  null
il_new_item_grp type tinyint 3 1
il_new_item_grp_seq sequence int 10  √ 
il_news_item content longtext 2147483647  √  null
il_news_item content_is_lang_var tinyint 3  √  0
il_news_item content_long longtext 2147483647  √  null
il_news_item content_text_is_lang_var tinyint 3 0
il_news_item content_type char 5  √  text
il_news_item context_obj_id int 10  √  null
il_news_item context_obj_type varchar 10  √  null
il_news_item context_sub_obj_id int 10  √  null
il_news_item context_sub_obj_type varchar 10  √  null
il_news_item creation_date datetime 19  √  null
il_news_item end_date datetime 19  √  null
il_news_item id int 10 0
il_news_item mob_cnt_download int 10 0
il_news_item mob_cnt_play int 10 0
il_news_item mob_id int 10  √  null
il_news_item playtime varchar 8  √  null
il_news_item priority int 10  √  1
il_news_item start_date datetime 19  √  null
il_news_item title varchar 200  √  null
il_news_item update_date datetime 19  √  null
il_news_item user_id int 10  √  null
il_news_item visibility char 6  √  users
il_news_item_seq sequence int 10  √ 
il_news_read news_id int 10 0
il_news_read user_id int 10 0
il_news_subscription ref_id int 10 0
il_news_subscription user_id int 10 0
il_object_def administration tinyint 3 0
il_object_def allow_copy tinyint 3 0
il_object_def allow_link tinyint 3 0
il_object_def amet tinyint 3 0
il_object_def checkbox tinyint 3 0
il_object_def class_name varchar 200  √  null
il_object_def component varchar 200  √  null
il_object_def default_pos int 10 0
il_object_def default_pres_pos int 10 0
il_object_def devmode tinyint 3 0
il_object_def export tinyint 3 0
il_object_def grp char 10  √  null
il_object_def id char 10
il_object_def inherit tinyint 3 0
il_object_def location varchar 250  √  null
il_object_def rbac tinyint 3 0
il_object_def repository tinyint 3 1
il_object_def sideblock tinyint 3 0
il_object_def system tinyint 3 0
il_object_def translate char 5  √  null
il_object_def workspace tinyint 3 0
il_object_group default_pres_pos int 10 0
il_object_group id char 10
il_object_group name varchar 200  √  null
il_object_sub_type amet tinyint 3 0
il_object_sub_type obj_type varchar 10
il_object_sub_type sub_type varchar 10
il_object_subobj mmax tinyint 3 0
il_object_subobj parent char 10
il_object_subobj subobj char 10
il_plugin active tinyint 3  √  null
il_plugin component_name varchar 90
il_plugin component_type char 10
il_plugin db_version int 10 0
il_plugin last_update_version char 10  √  null
il_plugin name varchar 40
il_plugin plugin_id varchar 20  √  null
il_plugin slot_id char 10
il_pluginslot component varchar 200
il_pluginslot id char 10
il_pluginslot name varchar 200  √  null
il_poll id int 10
il_poll image varchar 1000  √  null
il_poll max_answers tinyint 3 1
il_poll non_anon tinyint 3 0
il_poll online_status tinyint 3 0
il_poll period tinyint 3 0
il_poll period_begin int 10  √  0
il_poll period_end int 10  √  0
il_poll question varchar 1000  √  null
il_poll result_sort tinyint 3 0
il_poll show_results_as tinyint 3 1
il_poll view_results tinyint 3 3
il_poll_answer answer varchar 1000  √  null
il_poll_answer id int 10
il_poll_answer poll_id int 10
il_poll_answer pos smallint 5
il_poll_answer_seq sequence int 10  √ 
il_poll_vote answer_id int 10
il_poll_vote poll_id int 10
il_poll_vote user_id int 10
il_qpl_qst_fq_res formula longtext 2147483647  √  null
il_qpl_qst_fq_res points double 22 0
il_qpl_qst_fq_res question_fi int 10 0
il_qpl_qst_fq_res range_max double 22 0
il_qpl_qst_fq_res range_max_txt varchar 4000  √  null
il_qpl_qst_fq_res range_min double 22 0
il_qpl_qst_fq_res range_min_txt varchar 4000  √  null
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_qpl_qst_fq_res resprecision int 10 0
il_qpl_qst_fq_res result varchar 255  √  null
il_qpl_qst_fq_res result_id int 10 0
il_qpl_qst_fq_res result_type int 10 0
il_qpl_qst_fq_res tolerance double 22 0
il_qpl_qst_fq_res unit_fi int 10 0
il_qpl_qst_fq_res_seq sequence int 10  √ 
il_qpl_qst_fq_res_unit question_fi int 10 0
il_qpl_qst_fq_res_unit result varchar 255  √  null
il_qpl_qst_fq_res_unit result_unit_id int 10 0
il_qpl_qst_fq_res_unit unit_fi int 10 0
il_qpl_qst_fq_res_unit_seq sequence int 10  √ 
il_qpl_qst_fq_ucat category varchar 255  √  null
il_qpl_qst_fq_ucat category_id int 10 0
il_qpl_qst_fq_ucat question_fi int 10 0
il_qpl_qst_fq_ucat_seq sequence int 10  √ 
il_qpl_qst_fq_unit baseunit_fi int 10 0
il_qpl_qst_fq_unit category_fi int 10 0
il_qpl_qst_fq_unit factor double 22 0
il_qpl_qst_fq_unit question_fi int 10 0
il_qpl_qst_fq_unit sequence int 10 0
il_qpl_qst_fq_unit unit varchar 255  √  null
il_qpl_qst_fq_unit unit_id int 10 0
il_qpl_qst_fq_unit_seq sequence int 10  √ 
il_qpl_qst_fq_var intprecision int 10 1
il_qpl_qst_fq_var question_fi int 10 0
il_qpl_qst_fq_var range_max double 22 0
il_qpl_qst_fq_var range_max_txt varchar 4000  √  null
il_qpl_qst_fq_var range_min double 22 0
il_qpl_qst_fq_var range_min_txt varchar 4000  √  null
il_qpl_qst_fq_var step_dim_max int 10 0
il_qpl_qst_fq_var step_dim_min int 10 0
il_qpl_qst_fq_var unit_fi int 10 0
il_qpl_qst_fq_var variable varchar 255  √  null
il_qpl_qst_fq_var variable_id int 10 0
il_qpl_qst_fq_var varprecision int 10 0
il_qpl_qst_fq_var_seq sequence int 10  √ 
il_rating category_id int 10 0
il_rating obj_id int 10 0
il_rating obj_type char 10
il_rating rating int 10 0
il_rating sub_obj_id int 10 0
il_rating sub_obj_type char 10
il_rating tstamp int 10  √  null
il_rating user_id int 10 0
il_rating_cat description varchar 1000  √  null
il_rating_cat id int 10
il_rating_cat parent_id int 10
il_rating_cat pos smallint 5
il_rating_cat title varchar 100  √  null
il_rating_cat_seq sequence int 10  √ 
il_request_token session_id varchar 100  √  null
il_request_token stamp datetime 19  √  null
il_request_token token char 64  √  null
il_request_token user_id int 10 0
il_subscribers obj_id int 10 0
il_subscribers sub_time int 10 0
il_subscribers subject varchar 4000  √  null
il_subscribers usr_id int 10 0
il_tag is_offline tinyint 3 0
il_tag obj_id int 10 0
il_tag obj_type char 10
il_tag sub_obj_id int 10 0
il_tag sub_obj_type char 10
il_tag tag varchar 100
il_tag user_id int 10 0
il_verification id int 10
il_verification parameters varchar 1000  √  null
il_verification raw_data longtext 2147483647  √  null
il_verification type varchar 100
il_wac_secure_path checking_class varchar 256  √  null
il_wac_secure_path component_directory varchar 256  √  null
il_wac_secure_path in_sec_folder tinyint 3  √  null
il_wac_secure_path path varchar 64
il_wiki_contributor status int 10  √  null
il_wiki_contributor status_time datetime 19  √  null
il_wiki_contributor user_id int 10 0
il_wiki_contributor wiki_id int 10 0
il_wiki_data empty_page_templ tinyint 3 1
il_wiki_data id int 10 0
il_wiki_data imp_pages tinyint 3  √  null
il_wiki_data introduction longtext 2147483647  √  null
il_wiki_data is_online tinyint 3  √  0
il_wiki_data link_md_values tinyint 3  √  0
il_wiki_data page_toc tinyint 3  √  null
il_wiki_data public_notes tinyint 3  √  1
il_wiki_data 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
il_wiki_data rating_side tinyint 3 0
il_wiki_data short varchar 20  √  null
il_wiki_data startpage varchar 200  √  null
il_wiki_imp_pages indent tinyint 3
il_wiki_imp_pages ord int 10
il_wiki_imp_pages page_id int 10
il_wiki_imp_pages wiki_id int 10
il_wiki_missing_page source_id int 10 0
il_wiki_missing_page target_name varchar 200  √  null
il_wiki_missing_page wiki_id int 10 0
il_wiki_page blocked tinyint 3  √  null
il_wiki_page hide_adv_md tinyint 3  √  0
il_wiki_page id int 10 0
il_wiki_page rating tinyint 3 0
il_wiki_page title varchar 200  √  null
il_wiki_page wiki_id int 10 0
il_wiki_page_seq sequence int 10  √ 
int_link source_id int 10 0
int_link source_lang varchar 2 -
int_link source_type varchar 10
int_link target_id int 10 0
int_link target_inst int 10 0
int_link target_type varchar 4
item_group_item item_group_id int 10 0
item_group_item item_ref_id int 10 0
itgr_data hide_title tinyint 3 0
itgr_data id int 10
last_visited goto_link varchar 1000  √  null
last_visited nr int 10 0
last_visited ref_id int 10 0
last_visited sub_obj_id varchar 40  √  null
last_visited type varchar 10
last_visited user_id int 10 0
ldap_attribute_mapping keyword varchar 32
ldap_attribute_mapping perform_update tinyint 3 0
ldap_attribute_mapping server_id int 10 0
ldap_attribute_mapping value varchar 255  √  null
ldap_rg_mapping dn varchar 255  √  null
ldap_rg_mapping mapping_id int 10 0
ldap_rg_mapping mapping_info varchar 4000  √  null
ldap_rg_mapping mapping_info_type tinyint 3 1
ldap_rg_mapping member_attribute varchar 64  √  null
ldap_rg_mapping member_isdn tinyint 3 0
ldap_rg_mapping role int 10 0
ldap_rg_mapping server_id int 10 0
ldap_rg_mapping url varchar 255  √  null
ldap_rg_mapping_seq sequence int 10  √ 
ldap_role_assignments add_on_update tinyint 3  √  null
ldap_role_assignments att_name varchar 255  √  null
ldap_role_assignments att_value varchar 255  √  null
ldap_role_assignments attribute varchar 32  √  null
ldap_role_assignments dn varchar 1000  √  null
ldap_role_assignments isdn tinyint 3 0
ldap_role_assignments plugin_id int 10  √  null
ldap_role_assignments remove_on_update tinyint 3  √  null
ldap_role_assignments role_id int 10 0
ldap_role_assignments rule_id tinyint 3 0
ldap_role_assignments server_id int 10 0
ldap_role_assignments type tinyint 3 0
ldap_role_assignments_seq sequence int 10  √ 
ldap_server_settings active int 10 0
ldap_server_settings authentication tinyint 3 1
ldap_server_settings authentication_type tinyint 3 0
ldap_server_settings base_dn varchar 255  √  null
ldap_server_settings bind_pass varchar 32  √  null
ldap_server_settings bind_type int 10 0
ldap_server_settings bind_user varchar 255  √  null
ldap_server_settings filter varchar 512  √  null
ldap_server_settings group_attribute varchar 64  √  null
ldap_server_settings group_dn varchar 255  √  null
ldap_server_settings group_filter varchar 255  √  null
ldap_server_settings group_member varchar 255  √  null
ldap_server_settings group_memberisdn tinyint 3 0
ldap_server_settings group_name varchar 255  √  null
ldap_server_settings group_optional tinyint 3 0
ldap_server_settings group_scope tinyint 3 0
ldap_server_settings group_user_filter varchar 255  √  null
ldap_server_settings migration tinyint 3 0
ldap_server_settings name varchar 32  √  null
ldap_server_settings referrals int 10 0
ldap_server_settings role_bind_dn varchar 255  √  null
ldap_server_settings role_bind_pass varchar 32  √  null
ldap_server_settings role_sync_active tinyint 3 0
ldap_server_settings search_base varchar 255  √  null
ldap_server_settings server_id int 10 0
ldap_server_settings sync_on_login tinyint 3 0
ldap_server_settings sync_per_cron tinyint 3 0
ldap_server_settings tls int 10 0
ldap_server_settings url varchar 255  √  null
ldap_server_settings user_attribute varchar 255  √  null
ldap_server_settings user_scope tinyint 3 0
ldap_server_settings username_filter varchar 255  √  null
ldap_server_settings version int 10 0
ldap_server_settings_seq sequence int 10  √ 
license_data licenses int 10 0
license_data obj_id int 10 0
license_data remarks longtext 2147483647  √  null
license_data used int 10 0
link_check http_status_code int 10 0
link_check last_check int 10 0
link_check obj_id int 10 0
link_check page_id int 10 0
link_check parent_type varchar 8  √  null
link_check url varchar 255  √  null
link_check_report obj_id int 10 0
link_check_report usr_id int 10 0
lm_data active char 1  √  y
lm_data create_date datetime 19  √  null
lm_data import_id varchar 50  √  null
lm_data last_update datetime 19  √  null
lm_data layout varchar 100  √  null
lm_data lm_id int 10 0
lm_data obj_id int 10 0
lm_data public_access char 1  √  n
lm_data title varchar 200  √  null
lm_data type char 2  √  null
lm_data_seq sequence int 10  √ 
lm_data_transl create_date datetime 19  √  null
lm_data_transl id int 10
lm_data_transl lang varchar 2
lm_data_transl last_update datetime 19  √  null
lm_data_transl title varchar 200  √  null
lm_glossaries glo_id int 10 0
lm_glossaries lm_id int 10 0
lm_menu active char 1  √  n
lm_menu id int 10 0
lm_menu link_ref_id int 10  √  null
lm_menu link_type char 6  √  extern
lm_menu lm_id int 10 0
lm_menu target varchar 200  √  null
lm_menu title varchar 200  √  null
lm_menu_seq sequence int 10  √ 
lm_read_event last_access int 10 0
lm_read_event obj_id int 10 0
lm_read_event read_count int 10 0
lm_read_event spent_seconds int 10 0
lm_read_event usr_id int 10 0
lm_tree child int 10 0
lm_tree depth smallint 5 0
lm_tree lft int 10 0
lm_tree lm_id int 10 0
lm_tree parent int 10  √  null
lm_tree rgt int 10 0
lng_data identifier varchar 60
lng_data lang_key char 2
lng_data local_change datetime 19  √  null
lng_data module varchar 30
lng_data remarks varchar 250  √  null
lng_data value varchar 4000  √  null
lng_modules lang_array longtext 2147483647  √  null
lng_modules lang_key char 2
lng_modules module varchar 30
lo_access lm_id int 10 0
lo_access lm_title varchar 200  √  null
lo_access obj_id int 10 0
lo_access timestamp datetime 19  √  null
lo_access usr_id int 10 0
loc_rnd_qpl container_id int 10 0
loc_rnd_qpl objective_id int 10 0
loc_rnd_qpl percentage int 10 0
loc_rnd_qpl qp_seq int 10 0
loc_rnd_qpl tst_id int 10 0
loc_rnd_qpl tst_type tinyint 3 0
loc_settings it_start tinyint 3  √  1
loc_settings it_type tinyint 3  √  5
loc_settings itest int 10  √  null
loc_settings obj_id int 10 0
loc_settings passed_obj_mode tinyint 3  √  1
loc_settings qt_start tinyint 3  √  1
loc_settings qt_type tinyint 3  √  1
loc_settings qt_vis_all tinyint 3  √  1
loc_settings qt_vis_obj tinyint 3  √  0
loc_settings qtest int 10  √  null
loc_settings reset_results tinyint 3  √  0
loc_settings type tinyint 3 0
loc_tst_assignments assignment_id int 10 0
loc_tst_assignments assignment_type tinyint 3 0
loc_tst_assignments container_id int 10 0
loc_tst_assignments objective_id int 10 0
loc_tst_assignments tst_ref_id int 10 0
loc_tst_assignments_seq sequence int 10  √ 
loc_tst_run container_id int 10 0
loc_tst_run max_points int 10  √  0
loc_tst_run objective_id int 10 0
loc_tst_run questions varchar 1000  √  0
loc_tst_run test_id int 10 0
loc_tst_run user_id int 10 0
loc_user_results course_id int 10 0
loc_user_results is_final tinyint 3  √  0
loc_user_results limit_perc tinyint 3  √  0
loc_user_results objective_id int 10 0
loc_user_results result_perc tinyint 3  √  0
loc_user_results status tinyint 3  √  0
loc_user_results tries tinyint 3  √  0
loc_user_results tstamp int 10  √  0
loc_user_results type tinyint 3 0
loc_user_results user_id int 10 0
log_components component_id varchar 20
log_components log_level int 10  √  null
loginname_history history_date int 10
loginname_history login varchar 80
loginname_history usr_id int 10
mail attachments longtext 2147483647  √  null
mail folder_id int 10 0
mail import_name varchar 4000  √  null
mail m_email tinyint 3  √  null
mail m_message longtext 2147483647  √  null
mail m_status varchar 16  √  null
mail m_subject varchar 255  √  null
mail m_type varchar 255  √  null
mail mail_id int 10 0
mail rcp_bcc longtext 2147483647  √  null
mail rcp_cc longtext 2147483647  √  null
mail rcp_to longtext 2147483647  √  null
mail send_time datetime 19  √  null
mail sender_id int 10  √  null
mail tpl_ctx_id varchar 100  √  null
mail tpl_ctx_params longblob 2147483647  √  null
mail use_placeholders tinyint 3 0
mail user_id int 10 0
mail_attachment mail_id int 10 0
mail_attachment path varchar 4000  √  null
mail_cron_orphaned folder_id int 10
mail_cron_orphaned mail_id int 10
mail_cron_orphaned ts_do_delete int 10
mail_man_tpl context varchar 100
mail_man_tpl lang varchar 2
mail_man_tpl m_message longtext 2147483647  √  null
mail_man_tpl m_subject varchar 255  √  null
mail_man_tpl title varchar 255
mail_man_tpl tpl_id int 10 0
mail_man_tpl_seq sequence int 10  √ 
mail_obj_data m_type char 16  √  null
mail_obj_data obj_id int 10 0
mail_obj_data title char 70  √  null
mail_obj_data user_id int 10 0
mail_obj_data_seq sequence int 10  √ 
mail_options cronjob_notification tinyint 3 0
mail_options incoming_type tinyint 3  √  null
mail_options linebreak tinyint 3 0
mail_options signature varchar 4000  √  null
mail_options user_id int 10 0
mail_saved attachments longtext 2147483647  √  null
mail_saved m_email tinyint 3  √  null
mail_saved m_message longtext 2147483647  √  null
mail_saved m_subject varchar 255  √  null
mail_saved m_type varchar 255  √  null
mail_saved rcp_bcc longtext 2147483647  √  null
mail_saved rcp_cc longtext 2147483647  √  null
mail_saved rcp_to longtext 2147483647  √  null
mail_saved tpl_ctx_id varchar 100  √  null
mail_saved tpl_ctx_params longblob 2147483647  √  null
mail_saved use_placeholders tinyint 3 0
mail_saved user_id int 10 0
mail_seq sequence int 10  √ 
mail_template att_file varchar 400  √  null
mail_template body longtext 2147483647  √  null
mail_template lang varchar 5
mail_template sal_f varchar 200  √  null
mail_template sal_g varchar 200  √  null
mail_template sal_m varchar 200  √  null
mail_template subject varchar 200  √  null
mail_template type varchar 4
mail_tpl_ctx class varchar 100
mail_tpl_ctx component varchar 100
mail_tpl_ctx id varchar 100
mail_tpl_ctx path varchar 4000  √  null
mail_tree child int 10 0
mail_tree depth smallint 5 0
mail_tree lft int 10 0
mail_tree parent int 10  √  null
mail_tree rgt int 10 0
mail_tree tree int 10 0
map_area coords varchar 200  √  null
map_area highlight_class varchar 8  √  null
map_area highlight_mode varchar 8  √  null
map_area href varchar 200  √  null
map_area item_id int 10 0
map_area link_type char 3  √  null
map_area nr int 10 0
map_area shape varchar 20  √  null
map_area target varchar 50  √  null
map_area target_frame varchar 50  √  null
map_area title varchar 200  √  null
map_area type varchar 20  √  null
media_item caption varchar 3000  √  null
media_item format varchar 200  √  null
media_item halign char 10  √  Left
media_item height varchar 10  √  null
media_item id int 10 0
media_item location varchar 200  √  null
media_item location_type char 10  √  LocalFile
media_item mob_id int 10 0
media_item nr int 10 0
media_item param varchar 2000  √  null
media_item purpose char 20  √  Standard
media_item text_representation varchar 4000  √  null
media_item tried_thumb char 1  √  n
media_item width varchar 10  √  null
media_item_seq sequence int 10  √ 
member_agreement acceptance_time int 10 0
member_agreement accepted tinyint 3 0
member_agreement obj_id int 10 0
member_agreement usr_id int 10 0
member_noti nmode tinyint 3 0
member_noti ref_id int 10 0
member_noti_user ref_id int 10 0
member_noti_user status tinyint 3 0
member_noti_user user_id int 10 0
mep_data default_height int 10  √  null
mep_data default_width int 10  √  null
mep_data for_translation tinyint 3 0
mep_data id int 10
mep_item foreign_id int 10  √  null
mep_item import_id varchar 50  √  null
mep_item obj_id int 10 0
mep_item title varchar 128  √  null
mep_item type varchar 10  √  null
mep_item_seq sequence int 10  √ 
mep_tree child int 10 0
mep_tree depth smallint 5 0
mep_tree lft int 10 0
mep_tree mep_id int 10 0
mep_tree parent int 10 0
mep_tree rgt int 10 0
mob_parameter med_item_id int 10 0
mob_parameter name varchar 50  √  null
mob_parameter value varchar 2000  √  null
mob_usage id int 10 0
mob_usage usage_hist_nr int 10 0
mob_usage usage_id int 10 0
mob_usage usage_lang varchar 2 -
mob_usage usage_type varchar 10
module_class class varchar 100
module_class dir varchar 200  √  null
module_class module varchar 100  √  null
note author int 10 0
note creation_date datetime 19  √  null
note id int 10 0
note label int 10 0
note no_repository tinyint 3  √  0
note note_text longtext 2147483647  √  null
note obj_id int 10 0
note obj_type varchar 10  √  null
note rep_obj_id int 10 0
note subject varchar 200  √  null
note type int 10 0
note update_date datetime 19  √  null
note_seq sequence int 10  √ 
note_settings activated tinyint 3 0
note_settings obj_id int 10 0
note_settings obj_type varchar 10 -
note_settings rep_obj_id int 10 0
notification id int 10
notification last_mail datetime 19  √  null
notification page_id int 10  √  0
notification type tinyint 3
notification user_id int 10
notification_channels channel_name varchar 100
notification_channels class varchar 100
notification_channels config_type varchar 30
notification_channels description varchar 4000
notification_channels include varchar 100
notification_channels title varchar 100
notification_data notification_id int 10
notification_data serialized varchar 4000
notification_data_seq sequence int 10  √ 
notification_listener disabled tinyint 3
notification_listener module varchar 100
notification_listener sender_id int 10
notification_listener usr_id int 10
notification_osd notification_osd_id int 10
notification_osd serialized varchar 4000
notification_osd time_added int 10
notification_osd type varchar 100
notification_osd usr_id int 10
notification_osd valid_until int 10
notification_osd visible_for int 10 0
notification_osd_seq sequence int 10  √ 
notification_queue notification_id int 10
notification_queue usr_id int 10
notification_queue valid_until int 10
notification_types config_type varchar 30
notification_types description varchar 100
notification_types notification_group varchar 100
notification_types title varchar 100
notification_types type_name varchar 100
notification_usercfg channel varchar 100
notification_usercfg module varchar 100
notification_usercfg usr_id int 10
obj_content_master_lng master_lang varchar 2
obj_content_master_lng obj_id int 10 0
obj_lp_stat completed int 10  √  null
obj_lp_stat dd tinyint 3
obj_lp_stat failed int 10  √  null
obj_lp_stat fulldate int 10
obj_lp_stat in_progress int 10  √  null
obj_lp_stat mem_cnt int 10  √  null
obj_lp_stat mm tinyint 3
obj_lp_stat not_attempted int 10  √  null
obj_lp_stat obj_id int 10
obj_lp_stat type varchar 4
obj_lp_stat yyyy smallint 5
obj_members admin tinyint 3  √  0
obj_members blocked tinyint 3 0
obj_members contact tinyint 3  √  0
obj_members member smallint 5  √  0
obj_members notification tinyint 3 0
obj_members obj_id int 10 0
obj_members origin int 10  √  0
obj_members origin_ts int 10  √  0
obj_members passed tinyint 3  √  null
obj_members tutor tinyint 3  √  0
obj_members usr_id int 10 0
obj_stat childs_read_count int 10  √  null
obj_stat childs_spent_seconds int 10  √  null
obj_stat dd tinyint 3  √  null
obj_stat hh tinyint 3  √  null
obj_stat mm tinyint 3  √  null
obj_stat obj_id int 10
obj_stat obj_type varchar 10
obj_stat read_count int 10  √  null
obj_stat spent_seconds int 10  √  null
obj_stat yyyy smallint 5  √  null
obj_stat_log childs_read_count int 10  √  null
obj_stat_log childs_spent_seconds int 10  √  null
obj_stat_log dd tinyint 3  √  null
obj_stat_log hh tinyint 3  √  null
obj_stat_log mm tinyint 3  √  null
obj_stat_log obj_id int 10
obj_stat_log obj_type varchar 10
obj_stat_log read_count int 10  √  null
obj_stat_log spent_seconds int 10  √  null
obj_stat_log tstamp int 10  √  null
obj_stat_log yyyy smallint 5  √  null
obj_stat_tmp childs_read_count int 10  √  null
obj_stat_tmp childs_spent_seconds int 10  √  null
obj_stat_tmp dd tinyint 3  √  null
obj_stat_tmp hh tinyint 3  √  null
obj_stat_tmp mm tinyint 3  √  null
obj_stat_tmp obj_id int 10
obj_stat_tmp obj_type varchar 10
obj_stat_tmp read_count int 10  √  null
obj_stat_tmp spent_seconds int 10  √  null
obj_stat_tmp tstamp int 10  √  null
obj_stat_tmp yyyy smallint 5  √  null
obj_type_stat cnt_deleted int 10  √  null
obj_type_stat cnt_objects int 10  √  null
obj_type_stat cnt_references int 10  √  null
obj_type_stat dd tinyint 3
obj_type_stat fulldate int 10
obj_type_stat mm tinyint 3
obj_type_stat type varchar 4
obj_type_stat yyyy smallint 5
obj_user_data_hist editing_time datetime 19  √  null
obj_user_data_hist obj_id int 10
obj_user_data_hist update_user int 10
obj_user_data_hist usr_id int 10
obj_user_stat counter int 10  √  null
obj_user_stat dd tinyint 3
obj_user_stat fulldate int 10
obj_user_stat mm tinyint 3
obj_user_stat obj_id int 10
obj_user_stat yyyy smallint 5
object_data create_date datetime 19  √  null
object_data description char 128  √  null
object_data import_id char 50  √  null
object_data last_update datetime 19  √  null
object_data obj_id int 10 0
object_data owner int 10 0
object_data title char 255  √  null
object_data type char 4  √  none
object_data_seq sequence int 10  √ 
object_description description longtext 2147483647  √  null
object_description obj_id int 10 0
object_reference deleted datetime 19  √  null
object_reference obj_id int 10 0
object_reference ref_id int 10 0
object_reference_seq sequence int 10  √ 
object_reference_ws deleted datetime 19  √  null
object_reference_ws obj_id int 10 0
object_reference_ws wsp_id int 10 0
object_reference_ws_seq sequence int 10  √ 
object_translation description varchar 4000  √  null
object_translation lang_code char 2
object_translation lang_default tinyint 3 0
object_translation obj_id int 10 0
object_translation title varchar 128  √  null
openid_provider enabled tinyint 3  √  null
openid_provider image smallint 5  √  null
openid_provider name varchar 128  √  null
openid_provider provider_id int 10 0
openid_provider url varchar 512  √  null
openid_provider_seq sequence int 10  √ 
orgu_data orgu_id int 10 0
orgu_data orgu_type_id int 10  √  null
orgu_types create_date datetime 19  √  null
orgu_types default_lang varchar 4
orgu_types icon varchar 256  √  null
orgu_types id int 10 0
orgu_types last_update datetime 19  √  null
orgu_types owner int 10
orgu_types_adv_md_rec rec_id int 10
orgu_types_adv_md_rec type_id int 10
orgu_types_seq sequence int 10  √ 
orgu_types_trans lang varchar 4
orgu_types_trans member varchar 32
orgu_types_trans orgu_type_id int 10
orgu_types_trans value varchar 4000  √  null
page_anchor anchor_name varchar 120
page_anchor page_id int 10 0
page_anchor page_lang varchar 2 -
page_anchor page_parent_type varchar 10
page_editor_settings name varchar 30
page_editor_settings settings_grp varchar 10
page_editor_settings value varchar 30  √  null
page_history content longtext 2147483647  √  null
page_history hdate datetime 19
page_history ilias_version varchar 20  √  null
page_history lang varchar 2 -
page_history nr int 10  √  null
page_history page_id int 10 0
page_history parent_id int 10  √  null
page_history parent_type varchar 4
page_history user_id int 10  √  null
page_layout active tinyint 3  √  0
page_layout content longtext 2147483647  √  null
page_layout description varchar 255  √  null
page_layout layout_id int 10 0
page_layout mod_portfolio tinyint 3  √  null
page_layout mod_scorm tinyint 3  √  1
page_layout special_page tinyint 3  √  0
page_layout style_id int 10  √  0
page_layout title varchar 128  √  null
page_layout_seq sequence int 10  √ 
page_object activation_end datetime 19  √  null
page_object activation_start datetime 19  √  null
page_object active tinyint 3 1
page_object content longtext 2147483647  √  null
page_object create_user int 10  √  null
page_object created datetime 19  √  null
page_object edit_lock_ts int 10 0
page_object edit_lock_user int 10  √  null
page_object inactive_elements tinyint 3  √  0
page_object int_links tinyint 3  √  0
page_object is_empty tinyint 3 0
page_object lang varchar 2 -
page_object last_change datetime 19  √  null
page_object last_change_user int 10  √  null
page_object page_id int 10 0
page_object parent_id int 10  √  null
page_object parent_type varchar 4 lm
page_object render_md5 varchar 32  √  null
page_object rendered_content longtext 2147483647  √  null
page_object rendered_time datetime 19  √  null
page_object show_activation_info tinyint 3 0
page_object view_cnt int 10  √  0
page_pc_usage pc_id int 10
page_pc_usage pc_type varchar 30
page_pc_usage usage_hist_nr int 10
page_pc_usage usage_id int 10
page_pc_usage usage_lang varchar 2 -
page_pc_usage usage_type varchar 30
page_qst_answer passed tinyint 3
page_qst_answer points double 22
page_qst_answer qst_id int 10
page_qst_answer try tinyint 3
page_qst_answer unlocked tinyint 3 0
page_qst_answer user_id int 10
page_question page_id int 10 0
page_question page_lang varchar 2 -
page_question page_parent_type varchar 4  √  null
page_question question_id int 10 0
page_style_usage page_id int 10
page_style_usage page_lang varchar 2 -
page_style_usage page_nr int 10
page_style_usage page_type char 10
page_style_usage sname char 30  √  null
page_style_usage stype varchar 30  √  null
page_style_usage template tinyint 3 0
payment_coupons pc_description varchar 4000  √  null
payment_coupons pc_from date 10  √  null
payment_coupons pc_from_enabled tinyint 3 0
payment_coupons pc_last_change_usr_id int 10 0
payment_coupons pc_last_changed datetime 19  √  null
payment_coupons pc_pk bigint 19 0
payment_coupons pc_till date 10  √  null
payment_coupons pc_till_enabled tinyint 3 0
payment_coupons pc_title varchar 255  √  null
payment_coupons pc_type char 8  √  fix