SchemaSpy Analysis of ilias5_2 - Columns◀  ilDoc Overview Generated by
SchemaSpy
Generated by SchemaSpy on Do Jul 11 21:24 GMT+01:00 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ilias5_2 contains 4471 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
acc_access_key access_key char 1  √  null
acc_access_key function_id int 10 0
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 0
acc_user_access_key user_id int 10 0
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 0
adl_shared_data store longtext 2147483647  √  null
adl_shared_data target_id varchar 4000
adl_shared_data user_id int 10 0
adm_set_templ_hide_tab tab_id varchar 80
adm_set_templ_hide_tab template_id int 10 0
adm_set_templ_value hide tinyint 3  √  null
adm_set_templ_value setting varchar 40
adm_set_templ_value template_id int 10 0
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 0
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 0
adv_md_obj_rec_select rec_id int 10 0
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  √ 
background_task cstep mediumint 7  √  null
background_task handler varchar 1000  √  null
background_task id int 10 0
background_task params varchar 4000  √  null
background_task start_date datetime 19  √  null
background_task status varchar 100  √  null
background_task steps mediumint 7 0
background_task user_id int 10 0
background_task_seq sequence int 10  √ 
badge_badge active tinyint 3 0
badge_badge conf varchar 4000  √  null
badge_badge crit varchar 4000  √  null
badge_badge descr varchar 4000  √  null
badge_badge id int 10 0
badge_badge image varchar 255  √  null
badge_badge parent_id int 10 0
badge_badge title varchar 255  √  null
badge_badge type_id varchar 255  √  null
badge_badge valid varchar 255  √  null
badge_badge_seq sequence int 10  √ 
badge_image_templ_type tmpl_id int 10 0
badge_image_templ_type type_id varchar 255
badge_image_template id int 10 0
badge_image_template image varchar 255  √  null
badge_image_template title varchar 255  √  null
badge_image_template_seq sequence int 10  √ 
badge_user_badge awarded_by int 10  √  null
badge_user_badge badge_id int 10 0
badge_user_badge pos smallint 5  √  null
badge_user_badge tstamp int 10 0
badge_user_badge user_id int 10 0
benchmark benchmark varchar 150  √  null
benchmark cdate datetime 19  √  null
benchmark duration double 22  √  null
benchmark id int 10 0
benchmark module varchar 150  √  null
benchmark sql_stmt longtext 2147483647  √  null
benchmark_seq sequence int 10  √ 
booking_entry booking_group int 10 0
booking_entry booking_id int 10 0
booking_entry deadline int 10 0
booking_entry num_bookings int 10 0
booking_entry obj_id int 10 0
booking_entry target_obj_id int 10  √  null
booking_entry_seq sequence int 10  √ 
booking_obj_assignment booking_id int 10 0
booking_obj_assignment target_obj_id int 10 0
booking_object booking_object_id int 10 0
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 0
booking_reservation date_from int 10 0
booking_reservation date_to int 10 0
booking_reservation group_id int 10  √  null
booking_reservation object_id int 10 0
booking_reservation status smallint 5  √  null
booking_reservation user_id int 10 0
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 0
booking_schedule deadline int 10  √  null
booking_schedule pool_id int 10 0
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 0
booking_schedule_slot day_id varchar 2
booking_schedule_slot slot_id tinyint 3 0
booking_schedule_slot times varchar 50
booking_settings booking_pool_id int 10 0
booking_settings ovlimit tinyint 3  √  null
booking_settings pool_offline tinyint 3  √  null
booking_settings public_log tinyint 3  √  null
booking_settings rsv_filter_period smallint 5  √  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 0
booking_user notification_sent tinyint 3 0
booking_user tstamp int 10 0
booking_user user_id int 10 0
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_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 0
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 0
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 0
cal_auth_token hash varchar 32
cal_auth_token ical longtext 2147483647  √  null
cal_auth_token selection int 10 0
cal_auth_token user_id int 10 0
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 0
cal_ch_group multiple_assignments tinyint 3 0
cal_ch_group title varchar 512  √  null
cal_ch_group usr_id int 10 0
cal_ch_group_seq sequence int 10  √ 
cal_ch_settings admin_id int 10 0
cal_ch_settings user_id int 10 0
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 0
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 0
cal_rec_exclusion excl_date date 10  √  null
cal_rec_exclusion excl_id int 10 0
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 0
cal_registrations dend int 10 0
cal_registrations dstart int 10 0
cal_registrations usr_id int 10 0
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 0
chatroom_admconfig server_settings varchar 2000
chatroom_admconfig_seq sequence int 10  √ 
chatroom_bans remark varchar 1000  √  null
chatroom_bans room_id int 10 0
chatroom_bans timestamp int 10 0
chatroom_bans user_id int 10 0
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 0
chatroom_proomaccess user_id int 10 0
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 0
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 0
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 0
chatroom_uploads timestamp int 10 0
chatroom_uploads upload_id int 10 0
chatroom_uploads user_id int 10 0
chatroom_uploads_seq sequence int 10  √ 
chatroom_users connected int 10 0
chatroom_users room_id int 10 0
chatroom_users user_id int 10 0
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 0
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 0
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 0
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 0
didactic_tpl_a tpl_id int 10 0
didactic_tpl_a type_id tinyint 3 0
didactic_tpl_a_seq sequence int 10  √ 
didactic_tpl_abr action_id int 10 0
didactic_tpl_abr filter_type tinyint 3 0
didactic_tpl_alp action_id int 10 0
didactic_tpl_alp filter_type tinyint 3 0
didactic_tpl_alp template_id int 10 0
didactic_tpl_alp template_type tinyint 3 0
didactic_tpl_alr action_id int 10 0
didactic_tpl_alr role_template_id int 10  √  null
didactic_tpl_en id int 10 0
didactic_tpl_en node int 10 0
didactic_tpl_fp parent_id int 10 0
didactic_tpl_fp parent_type varchar 32  √  null
didactic_tpl_fp pattern varchar 64  √  null
didactic_tpl_fp pattern_id int 10 0
didactic_tpl_fp pattern_sub_type tinyint 3 0
didactic_tpl_fp pattern_type tinyint 3 0
didactic_tpl_fp_seq sequence int 10  √ 
didactic_tpl_objs obj_id int 10 0
didactic_tpl_objs ref_id int 10 0
didactic_tpl_objs tpl_id int 10 0
didactic_tpl_sa id int 10 0
didactic_tpl_sa obj_type varchar 8
didactic_tpl_settings auto_generated tinyint 3 0
didactic_tpl_settings description varchar 512  √  null
didactic_tpl_settings enabled tinyint 3 0
didactic_tpl_settings exclusive_tpl tinyint 3 0
didactic_tpl_settings id int 10 0
didactic_tpl_settings info varchar 4000  √  null
didactic_tpl_settings title varchar 64  √  null
didactic_tpl_settings type tinyint 3 0
didactic_tpl_settings_seq sequence int 10  √ 
ecs_cmap_rule attribute varchar 64  √  null
ecs_cmap_rule create_subdir tinyint 3 0
ecs_cmap_rule directory varchar 64  √  null
ecs_cmap_rule filter varchar 512  √  null
ecs_cmap_rule is_filter tinyint 3 0
ecs_cmap_rule mid int 10 0
ecs_cmap_rule ref_id int 10 0
ecs_cmap_rule rid int 10 0
ecs_cmap_rule sid int 10 0
ecs_cmap_rule subdir_type tinyint 3 0
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 0
ecs_community cname varchar 255  √  null
ecs_community mids varchar 512  √  null
ecs_community own_id int 10 0
ecs_community sid int 10 0
ecs_container_mapping container_id int 10 0
ecs_container_mapping date_range_end int 10 0
ecs_container_mapping date_range_start int 10 0
ecs_container_mapping field_name varchar 255  √  null
ecs_container_mapping mapping_id int 10 0
ecs_container_mapping mapping_type tinyint 3 0
ecs_container_mapping mapping_value varchar 255  √  null
ecs_container_mapping_seq sequence int 10  √ 
ecs_course_assignments cms_id int 10 0
ecs_course_assignments cms_sub_id int 10  √  0
ecs_course_assignments id int 10 0
ecs_course_assignments mid int 10 0
ecs_course_assignments obj_id int 10 0
ecs_course_assignments sid int 10 0
ecs_course_assignments status tinyint 3 0
ecs_course_assignments usr_id varchar 64  √  null
ecs_course_assignments_seq sequence int 10  √ 
ecs_crs_mapping_atts id int 10 0
ecs_crs_mapping_atts mid int 10 0
ecs_crs_mapping_atts name varchar 64  √  null
ecs_crs_mapping_atts sid int 10 0
ecs_crs_mapping_atts_seq sequence int 10  √ 
ecs_data_mapping advmd_id int 10 0
ecs_data_mapping ecs_field varchar 32
ecs_data_mapping mapping_type tinyint 3 0
ecs_data_mapping sid int 10 0
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 0
ecs_part_settings export_types varchar 4000  √  null
ecs_part_settings import tinyint 3 0
ecs_part_settings import_type tinyint 3  √  null
ecs_part_settings import_types varchar 4000  √  null
ecs_part_settings mid int 10 0
ecs_part_settings sid int 10 0
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 0
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 0
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 0
exc_assignment_peer giver_id int 10 0
exc_assignment_peer pcomment longtext 2147483647  √  null
exc_assignment_peer peer_id int 10 0
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 tfeedback tinyint 3 7
exc_data time_stamp int 10  √  null
exc_idl ass_id int 10 0
exc_idl is_team tinyint 3 0
exc_idl member_id int 10 0
exc_idl tstamp int 10  √  0
exc_mem_ass_status ass_id int 10 0
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 0
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 1970-01-01 00:00:00
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 0
export_file_info version varchar 16  √  null
export_options export_id smallint 5 0
export_options keyword smallint 5 0
export_options obj_id int 10 0
export_options pos int 10 0
export_options ref_id int 10 0
export_options value varchar 32  √  null
feedback_items_seq sequence int 10  √ 
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_drafts_history draft_date datetime 19 1970-01-01 00:00:00
frm_drafts_history draft_id int 10 0
frm_drafts_history history_id int 10 0
frm_drafts_history post_message longtext 2147483647
frm_drafts_history post_subject varchar 4000
frm_drafts_history_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 1970-01-01 00:00:00
frm_posts_deleted deleted_id int 10 0
frm_posts_deleted forum_id int 10 0
frm_posts_deleted forum_title varchar 255
frm_posts_deleted is_thread_deleted tinyint 3 0
frm_posts_deleted obj_id int 10 0
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 1970-01-01 00:00:00
frm_posts_deleted post_message longtext 2147483647
frm_posts_deleted post_title varchar 255
frm_posts_deleted ref_id int 10 0
frm_posts_deleted thread_id int 10 0
frm_posts_deleted thread_title varchar 255
frm_posts_deleted_seq sequence int 10  √ 
frm_posts_drafts draft_id int 10 0
frm_posts_drafts forum_id bigint 19 0
frm_posts_drafts notify tinyint 3 0
frm_posts_drafts pos_display_usr_id int 10 0
frm_posts_drafts post_author_id int 10 0
frm_posts_drafts post_date datetime 19 1970-01-01 00:00:00
frm_posts_drafts post_id bigint 19 0
frm_posts_drafts post_message longtext 2147483647
frm_posts_drafts post_notify tinyint 3 0
frm_posts_drafts post_subject varchar 4000
frm_posts_drafts post_update datetime 19 1970-01-01 00:00:00
frm_posts_drafts post_user_alias varchar 255  √  null
frm_posts_drafts thread_id bigint 19 0
frm_posts_drafts update_user_id int 10 0
frm_posts_drafts_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 0
glo_advmd_col_order glo_id int 10 0
glo_advmd_col_order order_nr int 10 0
glo_glossaries glo_id int 10 0
glo_glossaries id int 10 0
glo_term_reference glo_id int 10 0
glo_term_reference term_id int 10 0
glossary downloads_active char 1  √  n
glossary glo_menu_active char 1  √  y
glossary id int 10 0
glossary is_online char 1  √  n
glossary pres_mode varchar 10 table
glossary public_html_file varchar 50  √  null
glossary public_xml_file varchar 50  √  null
glossary 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 0
grp_settings registration_enabled tinyint 3 0
grp_settings registration_end datetime 19  √  null
grp_settings registration_max_members int 10 0
grp_settings registration_mem_limit tinyint 3 0
grp_settings registration_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 show_members tinyint 3 1
grp_settings view_mode tinyint 3 6
grp_settings waiting_list tinyint 3 0
help_map chap int 10 0
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 0
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  √ 
iass_info_settings consultation_hours varchar 500  √  null
iass_info_settings contact varchar 100  √  null
iass_info_settings mails varchar 300  √  null
iass_info_settings obj_id int 10 0
iass_info_settings phone varchar 100  √  null
iass_info_settings responsibility varchar 100  √  null
iass_members examiner_id int 10  √  0
iass_members finalized tinyint 3 0
iass_members internal_note varchar 1000  √  null
iass_members learning_progress tinyint 3  √  0
iass_members notification_ts int 10 -1
iass_members notify tinyint 3 0
iass_members obj_id int 10 0
iass_members record varchar 1000  √  null
iass_members usr_id int 10 0
iass_settings content varchar 1000  √  null
iass_settings obj_id int 10 0
iass_settings record_template varchar 1000  √  null
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 1970-01-01 00:00:00
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 0
il_cld_data auth_complete tinyint 3  √  null
il_cld_data id int 10 0
il_cld_data is_online tinyint 3  √  null
il_cld_data owner_id bigint 19 0
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 0
il_dcl_data is_online tinyint 3  √  null
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 0
il_dcl_datatype ildb_type varchar 256
il_dcl_datatype sort smallint 5  √  0
il_dcl_datatype storage_location int 10 0
il_dcl_datatype title varchar 256  √  null
il_dcl_datatype_prop datatype_id int 10  √  null
il_dcl_datatype_prop id int 10 0
il_dcl_datatype_prop inputformat tinyint 3 0
il_dcl_datatype_prop title varchar 256  √  null
il_dcl_field datatype_id int 10 0
il_dcl_field description longtext 2147483647  √  null
il_dcl_field id int 10 0
il_dcl_field is_locked tinyint 3 0
il_dcl_field is_unique tinyint 3 0
il_dcl_field required tinyint 3 0
il_dcl_field table_id int 10 0
il_dcl_field title varchar 256  √  null
il_dcl_field_prop field_id bigint 19 0
il_dcl_field_prop id bigint 19 0
il_dcl_field_prop name varchar 4000
il_dcl_field_prop value varchar 4000  √  null
il_dcl_field_prop_b datatype_prop_id int 10 0
il_dcl_field_prop_b field_id int 10 0
il_dcl_field_prop_b id int 10 0
il_dcl_field_prop_b value varchar 256  √  null
il_dcl_field_prop_s_b sequence int 10 0
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 0
il_dcl_record last_edit_by int 10  √  null
il_dcl_record last_update datetime 19  √  null
il_dcl_record owner int 10 0
il_dcl_record table_id int 10 0
il_dcl_record_field field_id int 10 0
il_dcl_record_field id int 10 0
il_dcl_record_field record_id int 10 0
il_dcl_record_field_seq sequence int 10  √ 
il_dcl_record_seq sequence int 10  √ 
il_dcl_stloc1_value id int 10 0
il_dcl_stloc1_value record_field_id int 10 0
il_dcl_stloc1_value value varchar 4000  √  null
il_dcl_stloc1_value_seq sequence int 10  √ 
il_dcl_stloc2_value id int 10 0
il_dcl_stloc2_value record_field_id int 10 0
il_dcl_stloc2_value value int 10  √  null
il_dcl_stloc2_value_seq sequence int 10  √ 
il_dcl_stloc3_value id int 10 0
il_dcl_stloc3_value record_field_id int 10 0
il_dcl_stloc3_value value datetime 19 1970-01-01 00:00:00
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 0
il_dcl_table import_enabled tinyint 3 1
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 0
il_dcl_table public_comments int 10 0
il_dcl_table save_confirmation tinyint 3 0
il_dcl_table table_order bigint 19  √  null
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_tableview description varchar 128  √  null
il_dcl_tableview id bigint 19 0
il_dcl_tableview roles text 65535  √  null
il_dcl_tableview table_id bigint 19 0
il_dcl_tableview tableview_order bigint 19  √  null
il_dcl_tableview title varchar 128
il_dcl_tableview_seq sequence int 10  √ 
il_dcl_tfield_set exportable tinyint 3  √  null
il_dcl_tfield_set field varchar 128
il_dcl_tfield_set field_order bigint 19  √  null
il_dcl_tfield_set id bigint 19 0
il_dcl_tfield_set table_id bigint 19 0
il_dcl_tfield_set_seq sequence int 10  √ 
il_dcl_tview_set field varchar 128
il_dcl_tview_set filter_changeable tinyint 3  √  null
il_dcl_tview_set filter_value longtext 2147483647  √  null
il_dcl_tview_set id bigint 19 0
il_dcl_tview_set in_filter tinyint 3  √  null
il_dcl_tview_set tableview_id bigint 19 0
il_dcl_tview_set visible tinyint 3  √  null
il_dcl_tview_set_seq sequence int 10  √ 
il_dcl_view_seq sequence int 10  √ 
il_disk_quota owner_id int 10 0
il_disk_quota src_obj_id int 10 0
il_disk_quota src_size int 10 0
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 0
il_exc_team id int 10 0
il_exc_team user_id int 10 0
il_exc_team_log action tinyint 3 0
il_exc_team_log details varchar 500  √  null
il_exc_team_log log_id int 10 0
il_exc_team_log team_id int 10 0
il_exc_team_log tstamp int 10 0
il_exc_team_log user_id int 10 0
il_exc_team_log_seq sequence 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_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 0
il_media_cast_data_ord obj_id int 10 0
il_media_cast_data_ord pos mediumint 7 0
il_meta_annotation a_date longtext 2147483647  √  null
il_meta_annotation description longtext 2147483647  √  null
il_meta_annotation description_language char 2  √  null
il_meta_annotation entity longtext 2147483647  √  null
il_meta_annotation meta_annotation_id int 10 0
il_meta_annotation obj_id int 10  √  null
il_meta_annotation obj_type varchar 6  √  null
il_meta_annotation rbac_id int 10  √  null
il_meta_annotation_seq sequence int 10  √ 
il_meta_classification description varchar 4000  √  null
il_meta_classification description_language char 2  √  null
il_meta_classification meta_classification_id int 10 0
il_meta_classification obj_id int 10  √  null
il_meta_classification obj_type varchar 6  √  null
il_meta_classification purpose varchar 32  √  null
il_meta_classification rbac_id int 10  √  null
il_meta_classification_seq sequence int 10  √ 
il_meta_contribute c_date varchar 4000  √  null
il_meta_contribute meta_contribute_id int 10 0
il_meta_contribute obj_id int 10  √  null
il_meta_contribute obj_type varchar 6  √  null
il_meta_contribute parent_id int 10  √  null
il_meta_contribute parent_type varchar 32  √  null
il_meta_contribute rbac_id int 10  √  null
il_meta_contribute role varchar 32  √  null
il_meta_contribute_seq sequence int 10  √ 
il_meta_description description longtext 2147483647  √  null
il_meta_description description_language char 2  √  null
il_meta_description meta_description_id int 10 0
il_meta_description obj_id int 10  √  null
il_meta_description obj_type varchar 6  √  null
il_meta_description parent_id int 10  √  null
il_meta_description parent_type varchar 16  √  null
il_meta_description rbac_id int 10  √  null
il_meta_description_seq sequence int 10  √ 
il_meta_educational context varchar 16  √  null
il_meta_educational difficulty varchar 16  √  null
il_meta_educational intended_end_user_role varchar 16  √  null
il_meta_educational interactivity_level varchar 16  √  null
il_meta_educational interactivity_type varchar 16  √  null
il_meta_educational learning_resource_type varchar 32  √  null
il_meta_educational meta_educational_id int 10 0
il_meta_educational obj_id int 10  √  null
il_meta_educational obj_type varchar 6  √  null
il_meta_educational rbac_id int 10  √  null
il_meta_educational semantic_density varchar 16  √  null
il_meta_educational typical_learning_time varchar 4000  √  null
il_meta_educational_seq sequence int 10  √ 
il_meta_entity entity varchar 4000  √  null
il_meta_entity meta_entity_id int 10 0
il_meta_entity obj_id int 10  √  null
il_meta_entity obj_type varchar 6  √  null
il_meta_entity parent_id int 10  √  null
il_meta_entity parent_type varchar 16  √  null
il_meta_entity rbac_id int 10  √  null
il_meta_entity_seq sequence int 10  √ 
il_meta_format format varchar 255  √  null
il_meta_format meta_format_id int 10 0
il_meta_format obj_id int 10  √  null
il_meta_format obj_type varchar 6  √  null
il_meta_format rbac_id int 10  √  null
il_meta_format_seq sequence int 10  √ 
il_meta_general coverage varchar 4000  √  null
il_meta_general coverage_language char 2  √  null
il_meta_general general_structure varchar 16  √  null
il_meta_general meta_general_id int 10 0
il_meta_general obj_id int 10  √  null
il_meta_general obj_type varchar 6  √  null
il_meta_general rbac_id int 10  √  null
il_meta_general title varchar 4000  √  null
il_meta_general title_language char 2  √  null
il_meta_general_seq sequence int 10  √ 
il_meta_identifier catalog varchar 4000  √  null
il_meta_identifier entry varchar 4000  √  null
il_meta_identifier meta_identifier_id int 10 0
il_meta_identifier obj_id int 10  √  null
il_meta_identifier obj_type varchar 6  √  null
il_meta_identifier parent_id int 10  √  null
il_meta_identifier parent_type varchar 16  √  null
il_meta_identifier rbac_id int 10  √  null
il_meta_identifier_ catalog varchar 4000  √  null
il_meta_identifier_ entry varchar 4000  √  null
il_meta_identifier_ meta_identifier__id int 10 0
il_meta_identifier_ obj_id int 10  √  null
il_meta_identifier_ obj_type varchar 6  √  null
il_meta_identifier_ parent_id int 10  √  null
il_meta_identifier_ parent_type varchar 16  √  null
il_meta_identifier_ rbac_id int 10  √  null
il_meta_identifier__seq sequence int 10  √ 
il_meta_identifier_seq sequence int 10  √ 
il_meta_keyword keyword varchar 4000  √  null
il_meta_keyword keyword_language char 2  √  null
il_meta_keyword meta_keyword_id int 10 0
il_meta_keyword obj_id int 10  √  null
il_meta_keyword obj_type varchar 6  √  null
il_meta_keyword parent_id int 10  √  null
il_meta_keyword parent_type varchar 32  √  null
il_meta_keyword rbac_id int 10  √  null
il_meta_keyword_seq sequence int 10  √ 
il_meta_language language char 2  √  null
il_meta_language meta_language_id int 10 0
il_meta_language obj_id int 10  √  null
il_meta_language obj_type char 6  √  null
il_meta_language parent_id int 10  √  null
il_meta_language parent_type char 16  √  null
il_meta_language rbac_id int 10  √  null
il_meta_language_seq sequence int 10  √ 
il_meta_lifecycle lifecycle_status varchar 16  √  null
il_meta_lifecycle meta_lifecycle_id int 10 0
il_meta_lifecycle meta_version varchar 4000  √  null
il_meta_lifecycle obj_id int 10  √  null
il_meta_lifecycle obj_type varchar 6  √  null
il_meta_lifecycle rbac_id int 10  √  null
il_meta_lifecycle version_language char 2  √  null
il_meta_lifecycle_seq sequence int 10  √ 
il_meta_location location varchar 4000  √  null
il_meta_location location_type varchar 16  √  null
il_meta_location meta_location_id int 10 0
il_meta_location obj_id int 10  √  null
il_meta_location obj_type varchar 6  √  null
il_meta_location parent_id int 10  √  null
il_meta_location parent_type varchar 16  √  null
il_meta_location rbac_id int 10  √  null
il_meta_location_seq sequence int 10  √ 
il_meta_meta_data language char 2  √  null
il_meta_meta_data meta_data_scheme char 16  √  null
il_meta_meta_data meta_meta_data_id int 10 0
il_meta_meta_data obj_id int 10  √  null
il_meta_meta_data obj_type char 6  √  null
il_meta_meta_data rbac_id int 10  √  null
il_meta_meta_data_seq sequence int 10  √ 
il_meta_relation kind char 16  √  null
il_meta_relation meta_relation_id int 10 0
il_meta_relation obj_id int 10  √  null
il_meta_relation obj_type char 6  √  null
il_meta_relation rbac_id int 10  √  null
il_meta_relation_seq sequence int 10  √ 
il_meta_requirement browser_maximum_version char 255  √  null
il_meta_requirement browser_minimum_version char 255  √  null
il_meta_requirement browser_name varchar 32  √  null
il_meta_requirement meta_requirement_id int 10 0
il_meta_requirement obj_id int 10  √  null
il_meta_requirement obj_type varchar 6  √  null
il_meta_requirement operating_system_name varchar 16  √  null
il_meta_requirement or_composite_id int 10 0
il_meta_requirement os_max_version char 255  √  null
il_meta_requirement os_min_version char 255  √  null
il_meta_requirement parent_id int 10  √  null
il_meta_requirement parent_type varchar 16  √  null
il_meta_requirement rbac_id int 10  √  null
il_meta_requirement_seq sequence int 10  √ 
il_meta_rights costs char 3  √  null
il_meta_rights cpr_and_or char 3  √  null
il_meta_rights description varchar 4000  √  null
il_meta_rights description_language char 2  √  null
il_meta_rights meta_rights_id int 10 0
il_meta_rights obj_id int 10  √  null
il_meta_rights obj_type varchar 6  √  null
il_meta_rights rbac_id int 10  √  null
il_meta_rights_seq sequence int 10  √ 
il_meta_tar meta_tar_id int 10 0
il_meta_tar obj_id int 10  √  null
il_meta_tar obj_type varchar 6  √  null
il_meta_tar parent_id int 10  √  null
il_meta_tar parent_type varchar 16  √  null
il_meta_tar rbac_id int 10  √  null
il_meta_tar tar_language char 2  √  null
il_meta_tar tar_max char 2  √  null
il_meta_tar tar_min char 2  √  null
il_meta_tar typical_age_range varchar 4000  √  null
il_meta_tar_seq sequence int 10  √ 
il_meta_taxon meta_taxon_id int 10 0
il_meta_taxon obj_id int 10  √  null
il_meta_taxon obj_type varchar 6  √  null
il_meta_taxon parent_id int 10  √  null
il_meta_taxon parent_type varchar 32  √  null
il_meta_taxon rbac_id int 10  √  null
il_meta_taxon taxon varchar 4000  √  null
il_meta_taxon taxon_id varchar 4000  √  null
il_meta_taxon taxon_language char 2  √  null
il_meta_taxon_path meta_taxon_path_id int 10 0
il_meta_taxon_path obj_id int 10  √  null
il_meta_taxon_path obj_type varchar 6  √  null
il_meta_taxon_path parent_id int 10  √  null
il_meta_taxon_path parent_type varchar 32  √  null
il_meta_taxon_path rbac_id int 10  √  null
il_meta_taxon_path source varchar 4000  √  null
il_meta_taxon_path source_language char 2  √  null
il_meta_taxon_path_seq sequence int 10  √ 
il_meta_taxon_seq sequence int 10  √ 
il_meta_technical duration varchar 4000  √  null
il_meta_technical ir varchar 4000  √  null
il_meta_technical ir_language char 2  √  null
il_meta_technical meta_technical_id int 10 0
il_meta_technical obj_id int 10  √  null
il_meta_technical obj_type varchar 6  √  null
il_meta_technical opr varchar 4000  √  null
il_meta_technical opr_language char 2  √  null
il_meta_technical rbac_id int 10  √  null
il_meta_technical t_size varchar 4000  √  null
il_meta_technical_seq sequence int 10  √ 
il_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_html tinyint 3 0
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 update_user_id int 10 0
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 0
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 0
il_poll_answer poll_id int 10 0
il_poll_answer pos smallint 5 0
il_poll_answer_seq sequence int 10  √ 
il_poll_vote answer_id int 10 0
il_poll_vote poll_id int 10 0
il_poll_vote user_id int 10 0
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 0
il_rating_cat parent_id int 10 0
il_rating_cat pos smallint 5 0
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
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_translations description varchar 512  √  null
il_translations id int 10 0
il_translations id_type varchar 50
il_translations lang_code varchar 2
il_translations lang_default tinyint 3 0
il_translations title varchar 256  √  null
il_verification id int 10 0
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 0
il_wiki_imp_pages ord int 10 0
il_wiki_imp_pages page_id int 10 0
il_wiki_imp_pages wiki_id int 10 0
il_wiki_missing_page source_id int 10 0
il_wiki_missing_page target_name varchar 200
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 0
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 id 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
link_check_seq sequence int 10  √ 
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 0
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_log identifier varchar 60
lng_log module varchar 30
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 0
loginname_history login varchar 80
loginname_history usr_id int 10 0
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 500  √  null
mail_cron_orphaned folder_id int 10 0
mail_cron_orphaned mail_id int 10 0
mail_cron_orphaned ts_do_delete int 10 0
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 0
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
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 0
notification last_mail datetime 19  √  null
notification page_id int 10  √  0
notification type tinyint 3 0
notification user_id int 10 0
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 0
notification_data serialized varchar 4000
notification_data_seq sequence int 10  √ 
notification_listener disabled tinyint 3 0
notification_listener module varchar 100
notification_listener sender_id int 10 0
notification_listener usr_id int 10 0
notification_osd notification_osd_id int 10 0
notification_osd serialized varchar 4000
notification_osd time_added int 10 0
notification_osd type varchar 100
notification_osd usr_id int 10 0
notification_osd valid_until int 10 0
notification_osd visible_for int 10 0
notification_osd_seq sequence int 10  √ 
notification_queue notification_id int 10 0
notification_queue usr_id int 10 0
notification_queue valid_until int 10 0
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 0
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 0
obj_lp_stat failed int 10  √  null
obj_lp_stat fulldate int 10 0
obj_lp_stat in_progress int 10  √  null
obj_lp_stat mem_cnt int 10  √  null
obj_lp_stat mm tinyint 3 0
obj_lp_stat not_attempted int 10  √  null
obj_lp_stat obj_id int 10 0
obj_lp_stat type varchar 4
obj_lp_stat yyyy smallint 5 0
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 0
obj_stat hh tinyint 3 0
obj_stat mm tinyint 3 0
obj_stat obj_id int 10 0
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 0
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 log_id int 10 0
obj_stat_log mm tinyint 3  √  null
obj_stat_log obj_id int 10 0
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_log_seq sequence int 10  √ 
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 log_id int 10 0
obj_stat_tmp mm tinyint 3  √  null
obj_stat_tmp obj_id int 10 0
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 0
obj_type_stat fulldate int 10 0
obj_type_stat mm tinyint 3 0
obj_type_stat type varchar 4
obj_type_stat yyyy smallint 5 0
obj_user_data_hist editing_time datetime 19  √  null
obj_user_data_hist obj_id int 10 0
obj_user_data_hist update_user int 10 0
obj_user_data_hist usr_id int 10 0
obj_user_stat counter int 10  √  null
obj_user_stat dd tinyint 3 0
obj_user_stat fulldate int 10 0
obj_user_stat mm tinyint 3 0
obj_user_stat obj_id int 10 0
obj_user_stat yyyy smallint 5 0
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_del obj_id int 10 0
object_data_del title varchar 255  √  null
object_data_del tstamp int 10 0
object_data_del type char 4  √  null
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_path_storage obj_id bigint 19  √  null
orgu_path_storage path longtext 2147483647  √  null
orgu_path_storage ref_id bigint 19 0
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 0
orgu_types_adv_md_rec rec_id int 10 0
orgu_types_adv_md_rec type_id int 10 0
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 0
orgu_types_trans value varchar 4000  √  null
osc_activity conversation_id varchar 255
osc_activity is_closed tinyint 3 0
osc_activity timestamp bigint 19 0
osc_activity user_id int 10 0
osc_conversation id varchar 255
osc_conversation is_group tinyint 3 0
osc_conversation participants varchar 4000  √  null
osc_messages conversation_id varchar 255
osc_messages id varchar 255
osc_messages message longtext 2147483647  √  null
osc_messages timestamp bigint 19 0
osc_messages user_id int 10 0
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 1970-01-01 00:00:00
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 0
page_pc_usage pc_type varchar 30
page_pc_usage usage_hist_nr int 10 0
page_pc_usage usage_id int 10 0
page_pc_usage usage_lang varchar 2 -
page_pc_usage usage_type varchar 30
page_qst_answer passed tinyint 3 0
page_qst_answer points double 22 0
page_qst_answer qst_id int 10 0
page_qst_answer try tinyint 3 0
page_qst_answer unlocked tinyint 3 0
page_qst_answer user_id int 10 0
page_question page_id int 10 0
page_question page_lang varchar 2 -
page_question page_parent_type varchar 4
page_question question_id int 10 0
page_style_usage id int 10 0
page_style_usage page_id int 10 0
page_style_usage page_lang varchar 2 -
page_style_usage page_nr int 10 0
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
page_style_usage_seq sequence int 10  √ 
personal_clipboard insert_time datetime 19  √  null
personal_clipboard item_id int 10 0
personal_clipboard order_nr int 10 0
personal_clipboard parent int 10 0
personal_clipboard title char 70  √  null
personal_clipboard type char 4
personal_clipboard user_id int 10 0
personal_pc_clipboard content longtext 2147483647  √  null
personal_pc_clipboard insert_time datetime 19
personal_pc_clipboard order_nr int 10 0
personal_pc_clipboard user_id int 10 0
pg_amd_page_list data varchar 4000  √  null
pg_amd_page_list field_id int 10 0
pg_amd_page_list id int 10 0
pg_amd_page_list_seq sequence int 10  √ 
preview_data obj_id int 10 0
preview_data render_date datetime 19 1970-01-01 00:00:00
preview_data render_status varchar 20
prg_settings last_change datetime 19 1970-01-01 00:00:00
prg_settings lp_mode tinyint 3 0
prg_settings obj_id int 10 0
prg_settings points int 10 0
prg_settings status tinyint 3 0
prg_settings subtype_id int 10 0
prg_settings_seq sequence int 10  √ 
prg_translations id int 10 0
prg_translations lang varchar 4  √  null
prg_translations member varchar 32  √  null
prg_translations prg_type_id int 10  √  null
prg_translations value varchar 3500  √  null
prg_translations_seq sequence int 10  √ 
prg_type create_date datetime 19 1970-01-01 00:00:00
prg_type default_lang varchar 4  √  null
prg_type icon varchar 255  √  null
prg_type id int 10 0
prg_type last_update datetime 19  √  null
prg_type owner int 10  √  null
prg_type_adv_md_rec id int 10 0
prg_type_adv_md_rec rec_id int 10  √  null
prg_type_adv_md_rec type_id int 10  √  null
prg_type_adv_md_rec_seq sequence int 10  √ 
prg_type_seq sequence int 10  √ 
prg_usr_assignments id int 10 0
prg_usr_assignments last_change datetime 19 1970-01-01 00:00:00
prg_usr_assignments last_change_by int 10 0
prg_usr_assignments root_prg_id int 10 0
prg_usr_assignments usr_id int 10 0
prg_usr_assignments_seq sequence int 10  √ 
prg_usr_progress assignment_id int 10 0
prg_usr_progress completion_by int 10  √  null
prg_usr_progress id int 10 0
prg_usr_progress last_change datetime 19 1970-01-01 00:00:00
prg_usr_progress last_change_by int 10  √  null
prg_usr_progress points int 10 0
prg_usr_progress points_cur int 10 0
prg_usr_progress prg_id int 10 0
prg_usr_progress status tinyint 3 0
prg_usr_progress usr_id int 10 0
prg_usr_progress_seq sequence int 10  √ 
qpl_a_cloze answer_id int 10 0
qpl_a_cloze answertext varchar 1000  √  null
qpl_a_cloze aorder smallint 5 0
qpl_a_cloze cloze_type varchar 1  √  0
qpl_a_cloze gap_id smallint 5 0
qpl_a_cloze gap_size int 10 0
qpl_a_cloze lowerlimit varchar 20  √  0
qpl_a_cloze points double 22 0
qpl_a_cloze question_fi int 10 0
qpl_a_cloze shuffle varchar 1  √  1
qpl_a_cloze tstamp int 10 0
qpl_a_cloze upperlimit varchar 20  √  0
qpl_a_cloze_combi_res answer varchar 1000  √  null
qpl_a_cloze_combi_res best_solution tinyint 3  √  null
qpl_a_cloze_combi_res combination_id int 10 0
qpl_a_cloze_combi_res gap_fi int 10 0
qpl_a_cloze_combi_res points double 22  √  null
qpl_a_cloze_combi_res question_fi int 10 0
qpl_a_cloze_combi_res row_id int 10 0
qpl_a_cloze_seq sequence int 10  √ 
qpl_a_errortext answer_id int 10 0
qpl_a_errortext points double 22 0
qpl_a_errortext question_fi int 10 0
qpl_a_errortext sequence smallint 5 0
qpl_a_errortext text_correct varchar 150  √  null
qpl_a_errortext text_wrong varchar 150
qpl_a_errortext_seq sequence int 10  √ 
qpl_a_essay answer_id int 10 0
qpl_a_essay answertext varchar 1000  √  null
qpl_a_essay points double 22  √  null
qpl_a_essay question_fi int 10  √  null
qpl_a_essay_seq sequence int 10  √ 
qpl_a_imagemap answer_id int 10 0
qpl_a_imagemap answertext varchar 4000  √  null
qpl_a_imagemap aorder smallint 5 0
qpl_a_imagemap area varchar 20  √  null
qpl_a_imagemap coords varchar 4000  √  null
qpl_a_imagemap points double 22 0
qpl_a_imagemap points_unchecked double 22 0
qpl_a_imagemap question_fi int 10 0
qpl_a_imagemap tstamp int 10 0
qpl_a_imagemap_seq sequence int 10  √ 
qpl_a_kprim answertext varchar 1000  √  null
qpl_a_kprim correctness tinyint 3 0
qpl_a_kprim imagefile varchar 255  √  null
qpl_a_kprim position int 10 0
qpl_a_kprim question_fi int 10 0
qpl_a_lome answer_text varchar 1000  √  null
qpl_a_lome gap_number int 10 0
qpl_a_lome points double 22  √  null
qpl_a_lome position int 10 0
qpl_a_lome question_fi int 10 0
qpl_a_lome type int 10  √  null
qpl_a_matching answer_id int 10 0
qpl_a_matching definition_fi int 10 0
qpl_a_matching points double 22 0
qpl_a_matching question_fi int 10 0
qpl_a_matching term_fi int 10 0
qpl_a_matching_seq sequence int 10  √ 
qpl_a_mc answer_id int 10 0
qpl_a_mc answertext varchar 1000  √  null
qpl_a_mc aorder smallint 5 0
qpl_a_mc imagefile varchar 1000  √  null
qpl_a_mc points double 22 0
qpl_a_mc points_unchecked double 22 0
qpl_a_mc question_fi int 10 0
qpl_a_mc tstamp int 10 0
qpl_a_mc_seq sequence int 10  √ 
qpl_a_mdef def_id int 10 0
qpl_a_mdef definition varchar 1000  √  null
qpl_a_mdef ident int 10 0
qpl_a_mdef picture varchar 1000  √  null
qpl_a_mdef question_fi int 10 0
qpl_a_mdef_seq sequence int 10  √ 
qpl_a_mterm ident int 10  √  null
qpl_a_mterm picture varchar 1000  √  null
qpl_a_mterm question_fi int 10 0
qpl_a_mterm term varchar 1000  √  null
qpl_a_mterm term_id int 10 0
qpl_a_mterm_seq sequence int 10  √ 
qpl_a_ordering answer_id int 10 0
qpl_a_ordering answertext varchar 1000  √  null
qpl_a_ordering depth int 10 0
qpl_a_ordering position mediumint 7  √  null
qpl_a_ordering question_fi int 10 0
qpl_a_ordering random_id int 10 0
qpl_a_ordering solution_key smallint 5 0
qpl_a_ordering tstamp int 10 0
qpl_a_ordering_seq sequence int 10  √ 
qpl_a_sc answer_id int 10 0
qpl_a_sc answertext varchar 1000  √  null
qpl_a_sc aorder smallint 5 0
qpl_a_sc imagefile varchar 1000  √  null
qpl_a_sc points double 22 0
qpl_a_sc question_fi int 10 0
qpl_a_sc tstamp int 10 0
qpl_a_sc_seq sequence int 10  √ 
qpl_a_textsubset answer_id int 10 0
qpl_a_textsubset answertext varchar 1000  √  null
qpl_a_textsubset aorder smallint 5 0
qpl_a_textsubset points double 22 0
qpl_a_textsubset question_fi int 10 0
qpl_a_textsubset tstamp int 10 0
qpl_a_textsubset_seq sequence int 10  √ 
qpl_fb_generic correctness varchar 1  √  0
qpl_fb_generic feedback longtext 2147483647  √  null
qpl_fb_generic feedback_id int 10 0
qpl_fb_generic question_fi int 10 0
qpl_fb_generic tstamp int 10 0
qpl_fb_generic_seq sequence int 10  √ 
qpl_fb_specific answer int 10 0
qpl_fb_specific feedback longtext 2147483647  √  null
qpl_fb_specific feedback_id int 10 0
qpl_fb_specific question_fi int 10 0
qpl_fb_specific tstamp int 10 0
qpl_fb_specific_seq sequence int 10  √ 
qpl_hint_tracking qhtr_active_fi int 10 0
qpl_hint_tracking qhtr_hint_fi int 10 0
qpl_hint_tracking qhtr_pass int 10 0
qpl_hint_tracking qhtr_question_fi int 10 0
qpl_hint_tracking qhtr_track_id int 10 0
qpl_hint_tracking_seq sequence int 10  √ 
qpl_hints qht_hint_id int 10 0
qpl_hints qht_hint_index int 10 0
qpl_hints qht_hint_points double 22 0
qpl_hints qht_hint_text longtext 2147483647  √  null
qpl_hints qht_question_fi int 10 0
qpl_hints_seq sequence int 10  √ 
qpl_num_range aorder int 10 0
qpl_num_range lowerlimit varchar 20  √  0
qpl_num_range points double 22 0
qpl_num_range question_fi int 10 0
qpl_num_range range_id int 10 0
qpl_num_range tstamp int 10 0
qpl_num_range upperlimit varchar 20  √  0
qpl_num_range_seq sequence int 10  √ 
qpl_qst_cloze cloze_text longtext 2147483647  √  null
qpl_qst_cloze fixed_textlen int 10  √  null
qpl_qst_cloze identical_scoring varchar 1  √  1
qpl_qst_cloze question_fi int 10 0
qpl_qst_cloze textgap_rating varchar 2  √  null
qpl_qst_errortext errortext varchar 4000
qpl_qst_errortext points_wrong double 22 -1
qpl_qst_errortext question_fi int 10 0
qpl_qst_errortext textsize double 22 100
qpl_qst_essay keyword_relation varchar 3 any
qpl_qst_essay keywords varchar 4000  √  null
qpl_qst_essay matchcondition smallint 5 0
qpl_qst_essay maxnumofchars int 10 0
qpl_qst_essay question_fi int 10 0
qpl_qst_essay textgap_rating varchar 2  √  null
qpl_qst_fileupload allowedextensions varchar 255  √  null
qpl_qst_fileupload compl_by_submission tinyint 3 0
qpl_qst_fileupload maxsize double 22  √  null
qpl_qst_fileupload question_fi int 10 0
qpl_qst_flash applet varchar 150  √  null
qpl_qst_flash height int 10 400
qpl_qst_flash params varchar 4000  √  null
qpl_qst_flash question_fi int 10 0
qpl_qst_flash width int 10 550
qpl_qst_horder ordertext varchar 2000  √  null
qpl_qst_horder question_fi int 10 0
qpl_qst_horder textsize double 22  √  null
qpl_qst_imagemap image_file varchar 100  √  null
qpl_qst_imagemap is_multiple_choice tinyint 3 0
qpl_qst_imagemap question_fi int 10 0
qpl_qst_javaapplet image_file varchar 100  √  null
qpl_qst_javaapplet params varchar 4000  √  null
qpl_qst_javaapplet question_fi int 10 0
qpl_qst_kprim answer_type varchar 16 singleLine
qpl_qst_kprim custom_false varchar 255  √  null
qpl_qst_kprim custom_true varchar 255  √  null
qpl_qst_kprim feedback_setting int 10 1
qpl_qst_kprim opt_label varchar 32 right/wrong
qpl_qst_kprim question_fi int 10 0
qpl_qst_kprim score_partsol tinyint 3 0
qpl_qst_kprim shuffle_answers tinyint 3 0
qpl_qst_kprim thumb_size int 10  √  null
qpl_qst_lome answer_type varchar 16 singleLine
qpl_qst_lome feedback_setting int 10 1
qpl_qst_lome long_menu_text longtext 2147483647  √  null
qpl_qst_lome min_auto_complete tinyint 3  √  3
qpl_qst_lome question_fi int 10 0
qpl_qst_lome shuffle_answers tinyint 3 0
qpl_qst_matching matching_mode varchar 3  √  null
qpl_qst_matching matching_type varchar 1  √  1
qpl_qst_matching question_fi int 10 0
qpl_qst_matching shuffle varchar 1  √  1
qpl_qst_matching thumb_geometry int 10 100
qpl_qst_mc allow_images varchar 1  √  0
qpl_qst_mc feedback_setting tinyint 3 1
qpl_qst_mc question_fi int 10 0
qpl_qst_mc resize_images varchar 1  √  0
qpl_qst_mc selection_limit int 10  √  null
qpl_qst_mc shuffle varchar 1  √  1
qpl_qst_mc thumb_size smallint 5  √  null
qpl_qst_numeric maxnumofchars int 10 0
qpl_qst_numeric question_fi int 10 0
qpl_qst_ordering element_height int 10  √  null
qpl_qst_ordering ordering_type varchar 1  √  1
qpl_qst_ordering question_fi int 10 0
qpl_qst_ordering reduced_points double 22 0
qpl_qst_ordering scoring_type mediumint 7 0
qpl_qst_ordering thumb_geometry int 10 100
qpl_qst_sc allow_images varchar 1  √  0
qpl_qst_sc feedback_setting tinyint 3  √  2
qpl_qst_sc question_fi int 10 0
qpl_qst_sc resize_images varchar 1  √  0
qpl_qst_sc shuffle varchar 1  √  1
qpl_qst_sc thumb_size smallint 5  √  null
qpl_qst_skl_assigns eval_mode varchar 16  √  null
qpl_qst_skl_assigns obj_fi int 10 0
qpl_qst_skl_assigns question_fi int 10 0
qpl_qst_skl_assigns skill_base_fi int 10 0
qpl_qst_skl_assigns skill_points int 10 0
qpl_qst_skl_assigns skill_tref_fi int 10 0
qpl_qst_skl_sol_expr expression varchar 255
qpl_qst_skl_sol_expr order_index int 10 0
qpl_qst_skl_sol_expr points int 10 0
qpl_qst_skl_sol_expr question_fi int 10 0
qpl_qst_skl_sol_expr skill_base_fi int 10 0
qpl_qst_skl_sol_expr skill_tref_fi int 10 0
qpl_qst_textsubset correctanswers int 10  √  0
qpl_qst_textsubset question_fi int 10 0
qpl_qst_textsubset textgap_rating varchar 2  √  null
qpl_qst_type plugin tinyint 3 0
qpl_qst_type plugin_name varchar 40  √  null
qpl_qst_type question_type_id int 10 0
qpl_qst_type type_tag varchar 35  √  null
qpl_questionpool id_questionpool int 10 0
qpl_questionpool isonline varchar 1  √  0
qpl_questionpool nav_taxonomy int 10  √  null
qpl_questionpool obj_fi int 10 0
qpl_questionpool questioncount int 10 0
qpl_questionpool show_taxonomies tinyint 3 0
qpl_questionpool skill_service tinyint 3  √  null
qpl_questionpool tstamp int 10 0
qpl_questionpool_seq sequence int 10  √ 
qpl_questions add_cont_edit_mode varchar 16  √  null
qpl_questions author varchar 50  √  null
qpl_questions complete varchar 1  √  1
qpl_questions created int 10 0
qpl_questions description varchar 1000  √  null
qpl_questions external_id varchar 255  √  null
qpl_questions nr_of_tries int 10 0
qpl_questions obj_fi int 10 0
qpl_questions original_id int 10  √  null
qpl_questions owner int 10 0
qpl_questions points double 22  √  null
qpl_questions question_id int 10 0
qpl_questions question_text longtext 2147483647  √  null
qpl_questions question_type_fi int 10 0
qpl_questions title varchar 100  √  null
qpl_questions tstamp int 10 0
qpl_questions working_time varchar 8  √  00:00:00
qpl_questions_seq sequence int 10  √ 
qpl_sol_sug import_id varchar 50  √  null
qpl_sol_sug internal_link varchar 50  √  null
qpl_sol_sug question_fi int 10 0
qpl_sol_sug subquestion_index int 10 0
qpl_sol_sug suggested_solution_id int 10 0
qpl_sol_sug tstamp int 10 0
qpl_sol_sug type varchar 32  √  null
qpl_sol_sug value longtext 2147483647  √  null
qpl_sol_sug_seq sequence int 10  √ 
rbac_fa assign char 1  √  null
rbac_fa blocked tinyint 3 0
rbac_fa parent int 10 0
rbac_fa protected char 1  √  n
rbac_fa rol_id int 10 0
rbac_log action tinyint 3 0
rbac_log created int 10 0
rbac_log data longtext 2147483647  √  null
rbac_log log_id int 10 0
rbac_log ref_id int 10 0
rbac_log user_id int 10 0
rbac_log_seq sequence int 10  √ 
rbac_operations class char 16  √  null
rbac_operations description char 255  √  null
rbac_operations op_order smallint 5  √  null
rbac_operations operation char 32  √  null
rbac_operations ops_id int 10 0
rbac_operations_seq sequence int 10  √ 
rbac_pa ops_id varchar 4000  √  null
rbac_pa ref_id int 10 0
rbac_pa rol_id int 10 0
rbac_ta ops_id smallint 5 0
rbac_ta typ_id int 10 0
rbac_templates ops_id int 10 0
rbac_templates parent int 10 0
rbac_templates rol_id int 10 0
rbac_templates type char 5
rbac_ua rol_id int 10 0
rbac_ua usr_id int 10 0
rcat_settings local_information varchar 4000  √  null
rcat_settings mid int 10 0
rcat_settings obj_id int 10 0
rcat_settings organization varchar 400  √  null
rcat_settings remote_link varchar 400  √  null
read_event childs_read_count int 10 0
read_event childs_spent_seconds int 10 0
read_event first_access datetime 19  √  null
read_event last_access int 10  √  null
read_event obj_id int 10 0
read_event read_count int 10 0
read_event spent_seconds int 10 0
read_event usr_id int 10 0
reg_access_limit limit_absolute int 10  √  null
reg_access_limit limit_mode char 16  √  absolute
reg_access_limit limit_relative_d int 10  √  null
reg_access_limit limit_relative_m int 10  √  null
reg_access_limit limit_relative_y int 10  √  null
reg_access_limit role_id int 10 0
reg_er_assignments assignment_id int 10 0
reg_er_assignments domain varchar 128  √  null
reg_er_assignments role int 10 0
reg_er_assignments_seq sequence int 10  √ 
reg_registration_codes alimit varchar 50  √  null
reg_registration_codes alimitdt varchar 255  √  null
reg_registration_codes code varchar 50  √  null
reg_registration_codes code_id int 10 0
reg_registration_codes ext_enabled tinyint 3 0
reg_registration_codes generated_on int 10  √  0
reg_registration_codes reg_enabled tinyint 3 1
reg_registration_codes role int 10  √  0
reg_registration_codes role_local varchar 255  √  null
reg_registration_codes used int 10 0
reg_registration_codes_seq sequence int 10  √ 
remote_course_settings availability_type tinyint 3 0
remote_course_settings local_information varchar 4000  √  null
remote_course_settings mid int 10 0
remote_course_settings obj_id int 10 0
remote_course_settings organization varchar 4000  √  null
remote_course_settings r_end int 10 0
remote_course_settings r_start int 10 0
remote_course_settings remote_link varchar 4000  √  null
rfil_settings local_information varchar 4000  √  null
rfil_settings mid int 10 0
rfil_settings obj_id int 10 0
rfil_settings organization varchar 400  √  null
rfil_settings remote_link varchar 400  √  null
rfil_settings version smallint 5 1
rfil_settings version_tstamp int 10  √  null
rglo_settings availability_type tinyint 3 0
rglo_settings local_information varchar 4000  √  null
rglo_settings mid int 10 0
rglo_settings obj_id int 10 0
rglo_settings organization varchar 400  √  null
rglo_settings remote_link varchar 400  √  null
rgrp_settings availability_end int 10  √  null
rgrp_settings availability_start int 10  √  null
rgrp_settings availability_type tinyint 3 0
rgrp_settings local_information varchar 4000  √  null
rgrp_settings mid int 10 0
rgrp_settings obj_id int 10 0
rgrp_settings organization varchar 400  √  null
rgrp_settings remote_link varchar 400  √  null
rlm_settings availability_type tinyint 3 0
rlm_settings local_information varchar 4000  √  null
rlm_settings mid int 10 0
rlm_settings obj_id int 10 0
rlm_settings organization varchar 400  √  null
rlm_settings remote_link varchar 400  √  null
role_data allow_register tinyint 3 0
role_data assign_users tinyint 3  √  0
role_data auth_mode char 16  √  default
role_data disk_quota bigint 19 0
role_data role_id int 10 0
role_data wsp_disk_quota int 10  √  null
role_desktop_items item_id int 10 0
role_desktop_items item_type char 16  √  null
role_desktop_items role_id int 10 0
role_desktop_items role_item_id int 10 0
role_desktop_items_seq sequence int 10  √ 
rtst_settings availability_end int 10  √  null
rtst_settings availability_start int 10  √  null
rtst_settings availability_type tinyint 3 0
rtst_settings local_information varchar 4000  √  null
rtst_settings mid int 10 0
rtst_settings obj_id int 10 0
rtst_settings organization varchar 400  √  null
rtst_settings remote_link varchar 400  √  null
rwik_settings availability_type tinyint 3 0
rwik_settings local_information varchar 4000  √  null
rwik_settings mid int 10 0
rwik_settings obj_id int 10 0
rwik_settings organization varchar 400  √  null
rwik_settings remote_link varchar 400  √  null
sahs_lm api_adapter varchar 80  √  API
sahs_lm api_func_prefix varchar 20  √  LMS
sahs_lm auto_continue varchar 1 n
sahs_lm auto_last_visited varchar 1 y
sahs_lm auto_review varchar 3  √  n
sahs_lm auto_suspend varchar 1 n
sahs_lm c_online varchar 3  √  n
sahs_lm c_type varchar 10  √  null
sahs_lm check_values varchar 1 y
sahs_lm comments varchar 1 y
sahs_lm credit varchar 10  √  credit
sahs_lm debug varchar 1 n
sahs_lm debugpw varchar 50  √  n
sahs_lm default_lesson_mode varchar 8  √  normal
sahs_lm editable int 10 0
sahs_lm entry_page int 10 0
sahs_lm fourth_edition varchar 1 n
sahs_lm glossary int 10 0
sahs_lm height smallint 5 650
sahs_lm hide_navig varchar 1 n
sahs_lm id int 10 0
sahs_lm ie_compatibility varchar 1  √  null
sahs_lm ie_force_render varchar 1 n
sahs_lm interactions varchar 1 y
sahs_lm localization varchar 2  √  null
sahs_lm mastery_score tinyint 3  √  null
sahs_lm max_attempt int 10  √  0
sahs_lm module_version int 10  √  1
sahs_lm no_menu varchar 1 n
sahs_lm objectives varchar 1 y
sahs_lm offline_mode varchar 1 n
sahs_lm offline_zip_created datetime 19  √  null
sahs_lm open_mode tinyint 3 0
sahs_lm question_tries int 10  √  3
sahs_lm seq_exp_mode tinyint 3  √  0
sahs_lm sequencing varchar 1 y
sahs_lm stylesheet int 10 0
sahs_lm time_from_lms varchar 1 n
sahs_lm unlimited_session varchar 1 n
sahs_lm width smallint 5 950
sahs_sc13_sco hide_obj_page tinyint 3 0
sahs_sc13_sco id int 10 0
sahs_sc13_seq_assign identifier varchar 50  √  null
sahs_sc13_seq_assign sahs_sc13_tree_node_id int 10 0
sahs_sc13_seq_cond cond varchar 50  √  null
sahs_sc13_seq_cond measurethreshold varchar 50  √  null
sahs_sc13_seq_cond operator varchar 50  √  null
sahs_sc13_seq_cond referencedobjective varchar 50  √  null
sahs_sc13_seq_cond seqnodeid int 10 0
sahs_sc13_seq_course choice tinyint 3  √  1
sahs_sc13_seq_course flow tinyint 3  √  0
sahs_sc13_seq_course forwardonly tinyint 3  √  0
sahs_sc13_seq_course obj_id int 10 0
sahs_sc13_seq_item importid varchar 32  √  null
sahs_sc13_seq_item importseqxml longtext 2147483647  √  null
sahs_sc13_seq_item nocopy tinyint 3  √  null
sahs_sc13_seq_item nodelete tinyint 3  √  null
sahs_sc13_seq_item nomove tinyint 3  √  null
sahs_sc13_seq_item rootlevel tinyint 3 0
sahs_sc13_seq_item sahs_sc13_tree_node_id int 10 0
sahs_sc13_seq_item seqnodeid int 10 0
sahs_sc13_seq_item sequencingid varchar 50  √  null
sahs_sc13_seq_item seqxml longtext 2147483647  √  null
sahs_sc13_seq_mapinfo readnormalizedmeasure tinyint 3  √  null
sahs_sc13_seq_mapinfo readsatisfiedstatus tinyint 3  √  null
sahs_sc13_seq_mapinfo seqnodeid int 10 0
sahs_sc13_seq_mapinfo targetobjectiveid varchar 50  √  null
sahs_sc13_seq_mapinfo writenormalizedmeasure tinyint 3  √  null
sahs_sc13_seq_mapinfo writesatisfiedstatus tinyint 3  √  null
sahs_sc13_seq_node nodename varchar 50  √  null
sahs_sc13_seq_node seqnodeid int 10 0
sahs_sc13_seq_node tree_node_id int 10  √  null
sahs_sc13_seq_node_seq sequence int 10  √ 
sahs_sc13_seq_obj import_objective_id varchar 200  √  null
sahs_sc13_seq_obj minnormalizedmeasure varchar 50  √  null
sahs_sc13_seq_obj objectiveid varchar 200  √  null
sahs_sc13_seq_obj primary_obj tinyint 3  √  null
sahs_sc13_seq_obj satisfiedbymeasure tinyint 3  √  null
sahs_sc13_seq_obj seqnodeid int 10 0
sahs_sc13_seq_rule action varchar 50  √  null
sahs_sc13_seq_rule childactivityset varchar 50  √  null
sahs_sc13_seq_rule conditioncombination varchar 50  √  null
sahs_sc13_seq_rule minimumcount int 10  √  null
sahs_sc13_seq_rule minimumpercent varchar 50  √  null
sahs_sc13_seq_rule seqnodeid int 10 0
sahs_sc13_seq_rule type varchar 50  √  null
sahs_sc13_seq_templ id varchar 50
sahs_sc13_seq_templ seqnodeid int 10 0
sahs_sc13_seq_templts filename varchar 50  √  null
sahs_sc13_seq_templts id int 10 0
sahs_sc13_seq_templts identifier varchar 50  √  null
sahs_sc13_seq_templts_seq sequence int 10  √ 
sahs_sc13_seq_tree child int 10 0
sahs_sc13_seq_tree depth smallint 5  √  null
sahs_sc13_seq_tree importid varchar 32
sahs_sc13_seq_tree lft int 10  √  null
sahs_sc13_seq_tree parent int 10 0
sahs_sc13_seq_tree rgt int 10  √  null
sahs_sc13_tree child int 10 0
sahs_sc13_tree depth smallint 5 0
sahs_sc13_tree lft int 10 0
sahs_sc13_tree parent int 10 0
sahs_sc13_tree rgt int 10 0
sahs_sc13_tree slm_id int 10 0
sahs_sc13_tree_node create_date datetime 19  √  null
sahs_sc13_tree_node import_id varchar 50  √  null
sahs_sc13_tree_node last_update datetime 19  √  null
sahs_sc13_tree_node obj_id int 10 0
sahs_sc13_tree_node slm_id int 10 0
sahs_sc13_tree_node title varchar 200  √  null
sahs_sc13_tree_node type char 4  √  null
sahs_sc13_tree_node_seq sequence int 10  √ 
sahs_user first_access datetime 19  √  null
sahs_user hash varchar 20  √  null
sahs_user hash_end datetime 19  √  null
sahs_user last_access datetime 19  √  null
sahs_user last_status_change datetime 19  √  null
sahs_user last_visited varchar 255  √  null
sahs_user module_version smallint 5  √  null
sahs_user obj_id int 10 0
sahs_user offline_mode varchar 8  √  null
sahs_user package_attempts smallint 5  √  null
sahs_user percentage_completed tinyint 3  √  null
sahs_user sco_total_time_sec int 10  √  null
sahs_user status tinyint 3  √  null
sahs_user total_time_sec int 10  √  null
sahs_user user_id int 10 0
sc_item datafromlms longtext 2147483647  √  null
sc_item identifierref varchar 200  √  null
sc_item import_id varchar 200  √  null
sc_item isvisible varchar 6  √  null
sc_item masteryscore varchar 200  √  null
sc_item maxtimeallowed varchar 30  √  null
sc_item obj_id int 10 0
sc_item parameters varchar 4000  √  null
sc_item prereq_type varchar 200  √  null
sc_item prerequisites varchar 4000  √  null
sc_item timelimitaction varchar 30  √  null
sc_manifest import_id varchar 200  √  null
sc_manifest obj_id int 10 0
sc_manifest version varchar 200  √  null
sc_manifest xml_base varchar 200  √  null
sc_organization import_id varchar 200  √  null
sc_organization obj_id int 10 0
sc_organization structure varchar 200  √  null
sc_organizations default_organization varchar 200  √  null
sc_organizations obj_id int 10 0
sc_resource href varchar 250  √  null
sc_resource import_id varchar 200  √  null
sc_resource obj_id int 10 0
sc_resource resourcetype varchar 30  √  null
sc_resource scormtype varchar 6  √  null
sc_resource xml_base varchar 200  √  null
sc_resource_dependen id int 10 0
sc_resource_dependen identifierref varchar 200  √  null
sc_resource_dependen nr int 10  √  null
sc_resource_dependen res_id int 10  √  null
sc_resource_dependen_seq sequence int 10  √ 
sc_resource_file href varchar 4000  √  null
sc_resource_file id int 10 0
sc_resource_file nr int 10  √  null
sc_resource_file res_id int 10  √  null
sc_resource_file_seq sequence int 10  √ 
sc_resources obj_id int 10 0
sc_resources xml_base varchar 200  √  null
scorm_object c_type char 3  √  null
scorm_object obj_id int 10 0
scorm_object slm_id int 10 0
scorm_object title varchar 200  √  null
scorm_object_seq sequence int 10  √ 
scorm_tracking c_timestamp datetime 19  √  null
scorm_tracking lvalue varchar 64
scorm_tracking obj_id int 10 0
scorm_tracking rvalue longtext 2147483647  √  null
scorm_tracking sco_id int 10 0
scorm_tracking user_id int 10 0
scorm_tree child int 10 0
scorm_tree depth smallint 5 0
scorm_tree lft int 10 0
scorm_tree parent int 10  √  null
scorm_tree rgt int 10 0
scorm_tree slm_id int 10 0
search_command_queue command char 16  √  null
search_command_queue finished tinyint 3 0
search_command_queue last_update datetime 19  √  null
search_command_queue obj_id int 10 0
search_command_queue obj_type char 4
search_command_queue sub_id int 10 0
search_command_queue sub_type char 4  √  null
search_data obj_id int 10 0
search_data target varchar 4000  √  null
search_data title varchar 200  √  null
search_data type varchar 4  √  null
search_data user_id int 10 0
search_data_seq sequence int 10  √ 
service_class class varchar 100
service_class dir varchar 200  √  null
service_class service varchar 100  √  null
settings keyword varchar 50
settings module varchar 50 common
settings value longtext 2147483647  √  null
settings_deactivated_s skin varchar 100
settings_deactivated_s style varchar 100
shib_role_assignment add_on_update tinyint 3 0
shib_role_assignment name char 255  √  null
shib_role_assignment plugin tinyint 3 0
shib_role_assignment plugin_id int 10 0
shib_role_assignment remove_on_update tinyint 3 0
shib_role_assignment role_id int 10 0
shib_role_assignment rule_id int 10 0
shib_role_assignment value char 255  √  null
shib_role_assignment_seq sequence int 10  √ 
skl_assigned_material level_id int 10 0
skl_assigned_material skill_id int 10 0
skl_assigned_material top_skill_id int 10 0
skl_assigned_material tref_id int 10 0
skl_assigned_material user_id int 10 0
skl_assigned_material wsp_id int 10 0
skl_level creation_date datetime 19  √  null
skl_level description longtext 2147483647  √  null
skl_level id int 10 0
skl_level import_id varchar 50  √  null
skl_level nr smallint 5 0
skl_level skill_id int 10 0
skl_level title varchar 200  √  null
skl_level trigger_obj_id int 10 0
skl_level trigger_ref_id int 10 0
skl_level_seq sequence int 10  √ 
skl_personal_skill skill_node_id int 10 0
skl_personal_skill user_id int 10 0
skl_profile description varchar 4000  √  null
skl_profile id int 10 0
skl_profile title varchar 200  √  null
skl_profile_level base_skill_id int 10 0
skl_profile_level level_id int 10 0
skl_profile_level profile_id int 10 0
skl_profile_level tref_id int 10 0
skl_profile_seq sequence int 10  √ 
skl_profile_user profile_id int 10 0
skl_profile_user user_id int 10 0
skl_self_eval created datetime 19 1970-01-01 00:00:00
skl_self_eval id int 10 0
skl_self_eval last_update datetime 19 1970-01-01 00:00:00
skl_self_eval top_skill_id int 10 0
skl_self_eval user_id int 10 0
skl_self_eval_level last_update datetime 19  √  null
skl_self_eval_level level_id int 10 0
skl_self_eval_level skill_id int 10 0
skl_self_eval_level top_skill_id int 10 0
skl_self_eval_level tref_id int 10 0
skl_self_eval_level user_id int 10 0
skl_self_eval_seq sequence int 10  √ 
skl_skill_resource base_skill_id int 10 0
skl_skill_resource imparting tinyint 3 0
skl_skill_resource level_id int 10 0
skl_skill_resource ltrigger tinyint 3 0
skl_skill_resource rep_ref_id int 10 0
skl_skill_resource tref_id int 10 0
skl_templ_ref skl_node_id int 10 0
skl_templ_ref templ_id int 10 0
skl_tree child int 10 0
skl_tree depth smallint 5 0
skl_tree lft int 10 0
skl_tree parent int 10  √  null
skl_tree rgt int 10 0
skl_tree skl_tree_id int 10 0
skl_tree_node create_date datetime 19  √  null
skl_tree_node creation_date datetime 19  √  null
skl_tree_node import_id varchar 50  √  null
skl_tree_node last_update datetime 19  √  null
skl_tree_node obj_id int 10 0
skl_tree_node order_nr int 10 0
skl_tree_node self_eval tinyint 3 0
skl_tree_node status tinyint 3 0
skl_tree_node title varchar 200  √  null
skl_tree_node type char 4  √  null
skl_tree_node_seq sequence int 10  √ 
skl_usage obj_id int 10 0
skl_usage skill_id int 10 0
skl_usage tref_id int 10 0
skl_user_has_level level_id int 10 0
skl_user_has_level self_eval tinyint 3 0
skl_user_has_level skill_id int 10 0
skl_user_has_level status_date datetime 19 1970-01-01 00:00:00
skl_user_has_level tref_id int 10 0
skl_user_has_level trigger_obj_id int 10 0
skl_user_has_level trigger_obj_type varchar 4  √  crs
skl_user_has_level trigger_ref_id int 10 0
skl_user_has_level trigger_title varchar 200  √  null
skl_user_has_level user_id int 10 0
skl_user_skill_level level_id int 10 0
skl_user_skill_level self_eval tinyint 3 0
skl_user_skill_level skill_id int 10 0
skl_user_skill_level status tinyint 3 0
skl_user_skill_level status_date datetime 19 1970-01-01 00:00:00
skl_user_skill_level tref_id int 10 0
skl_user_skill_level trigger_obj_id int 10 0
skl_user_skill_level trigger_obj_type varchar 4  √  crs
skl_user_skill_level trigger_ref_id int 10 0
skl_user_skill_level trigger_title varchar 200  √  null
skl_user_skill_level unique_identifier varchar 80  √  null
skl_user_skill_level user_id int 10 0
skl_user_skill_level valid tinyint 3 0
sty_media_query id int 10 0
sty_media_query mquery varchar 2000  √  null
sty_media_query order_nr int 10 0
sty_media_query style_id int 10 0
sty_media_query_seq sequence int 10  √ 
style_char characteristic varchar 30
style_char hide tinyint 3 0
style_char style_id int 10 0
style_char type varchar 30
style_color color_code char 10  √  null
style_color color_name varchar 30 .
style_color style_id int 10 0
style_data active tinyint 3  √  1
style_data category int 10  √  null
style_data id int 10 0
style_data standard tinyint 3  √  0
style_data uptodate tinyint 3  √  0
style_folder_styles folder_id int 10 0
style_folder_styles style_id int 10 0
style_parameter class varchar 100  √  null
style_parameter custom tinyint 3 0
style_parameter id int 10 0
style_parameter mq_id int 10 0
style_parameter parameter varchar 100  √  null
style_parameter style_id int 10 0
style_parameter tag varchar 100  √  null
style_parameter type varchar 30  √  null
style_parameter value varchar 200  √  null
style_parameter_seq sequence int 10  √ 
style_setting name varchar 30
style_setting style_id int 10 0
style_setting value varchar 30  √  null
style_template id int 10 0
style_template name varchar 30
style_template preview varchar 4000  √  null
style_template style_id int 10 0
style_template temp_type varchar 30  √  null
style_template_class class char 30
style_template_class class_type char 30
style_template_class template_id int 10 0
style_template_seq sequence int 10  √ 
style_usage obj_id int 10 0
style_usage style_id int 10 0
svy_360_appr has_closed int 10  √  0
svy_360_appr obj_id int 10 0
svy_360_appr user_id int 10 0
svy_360_rater anonymous_id int 10 0
svy_360_rater appr_id int 10 0
svy_360_rater mail_sent int 10  √  0
svy_360_rater obj_id int 10 0
svy_360_rater user_id int 10 0
svy_anonymous anonymous_id int 10 0
svy_anonymous externaldata varchar 4000  √  null
svy_anonymous sent smallint 5 0
svy_anonymous survey_fi int 10 0
svy_anonymous survey_key varchar 32  √  null
svy_anonymous tstamp int 10 0
svy_anonymous user_key varchar 40  √  null
svy_anonymous_seq sequence int 10  √ 
svy_answer active_fi int 10 0
svy_answer answer_id int 10 0
svy_answer question_fi int 10 0
svy_answer rowvalue int 10 0
svy_answer textanswer text 65535  √  null
svy_answer tstamp int 10 0
svy_answer value double 22  √  null
svy_answer_seq sequence int 10  √ 
svy_category category_id int 10 0
svy_category defaultvalue varchar 1  √  0
svy_category neutral varchar 1  √  0
svy_category owner_fi int 10 0
svy_category title varchar 1000  √  null
svy_category tstamp int 10 0
svy_category_seq sequence int 10  √ 
svy_constraint conjunction smallint 5 0
svy_constraint constraint_id int 10 0
svy_constraint question_fi int 10 0
svy_constraint relation_fi int 10 0
svy_constraint value double 22 0
svy_constraint_seq sequence int 10  √ 
svy_finished anonymous_id varchar 32  √  null
svy_finished appr_id int 10  √  0
svy_finished finished_id int 10 0
svy_finished lastpage int 10 0
svy_finished state varchar 1  √  0
svy_finished survey_fi int 10 0
svy_finished tstamp int 10 0
svy_finished user_fi int 10 0
svy_finished_seq sequence int 10  √ 
svy_inv_usr invited_user_id int 10 0
svy_inv_usr survey_fi int 10 0
svy_inv_usr tstamp int 10 0
svy_inv_usr user_fi int 10 0
svy_inv_usr_seq sequence int 10  √ 
svy_material external_link varchar 500  √  null
svy_material file_material varchar 200  √  null
svy_material import_id varchar 50  √  null
svy_material internal_link varchar 50  √  null
svy_material material_id int 10 0
svy_material material_title varchar 255  √  null
svy_material material_type int 10  √  0
svy_material question_fi int 10 0
svy_material text_material varchar 4000  √  null
svy_material tstamp int 10 0
svy_material_seq sequence int 10  √ 
svy_phrase defaultvalue varchar 1  √  0
svy_phrase owner_fi int 10 0
svy_phrase phrase_id int 10 0
svy_phrase title varchar 100  √  null
svy_phrase tstamp int 10 0
svy_phrase_cat category_fi int 10 0
svy_phrase_cat other smallint 5 0
svy_phrase_cat phrase_category_id int 10 0
svy_phrase_cat phrase_fi int 10 0
svy_phrase_cat scale int 10  √  null
svy_phrase_cat sequence int 10 0
svy_phrase_cat_seq sequence int 10  √ 
svy_phrase_seq sequence int 10  √ 
svy_qblk owner_fi int 10 0
svy_qblk questionblock_id int 10 0
svy_qblk show_blocktitle varchar 1  √  null
svy_qblk show_questiontext varchar 1  √  1
svy_qblk title varchar 4000  √  null
svy_qblk tstamp int 10 0
svy_qblk_qst qblk_qst_id int 10 0
svy_qblk_qst question_fi int 10 0
svy_qblk_qst questionblock_fi int 10 0
svy_qblk_qst survey_fi int 10 0
svy_qblk_qst_seq sequence int 10  √ 
svy_qblk_seq sequence int 10  √ 
svy_qpl id_questionpool int 10 0
svy_qpl isonline varchar 1  √  0
svy_qpl obj_fi int 10 0
svy_qpl tstamp int 10 0
svy_qpl_seq sequence int 10  √ 
svy_qst_constraint constraint_fi int 10 0
svy_qst_constraint question_constraint_id int 10 0
svy_qst_constraint question_fi int 10 0
svy_qst_constraint survey_fi int 10 0
svy_qst_constraint_seq sequence int 10  √ 
svy_qst_matrix bipolar_adjective1 varchar 255  √  null
svy_qst_matrix bipolar_adjective2 varchar 255  √  null
svy_qst_matrix column_header_position varchar 1  √  0
svy_qst_matrix column_images varchar 1  √  0
svy_qst_matrix column_order varchar 1  √  0
svy_qst_matrix column_placeholders int 10 0
svy_qst_matrix column_separators varchar 1  √  0
svy_qst_matrix layout varchar 4000  √  null
svy_qst_matrix legend varchar 1  √  0
svy_qst_matrix neutral_column_separator varchar 1  √  1
svy_qst_matrix question_fi int 10 0
svy_qst_matrix random_rows varchar 1  √  0
svy_qst_matrix repeat_column_header varchar 1  √  0
svy_qst_matrix row_images varchar 1  √  0
svy_qst_matrix row_separators varchar 1  √  0
svy_qst_matrix singleline_row_caption varchar 1  √  0
svy_qst_matrix subtype int 10 0
svy_qst_matrix tstamp int 10 0
svy_qst_matrixrows id_svy_qst_matrixrows int 10 0
svy_qst_matrixrows label varchar 255  √  null
svy_qst_matrixrows other tinyint 3 0
svy_qst_matrixrows question_fi int 10 0
svy_qst_matrixrows sequence int 10 0
svy_qst_matrixrows title varchar 1000  √  null
svy_qst_matrixrows_seq sequence int 10  √ 
svy_qst_mc nr_max_answers smallint 5  √  null
svy_qst_mc nr_min_answers smallint 5  √  null
svy_qst_mc orientation varchar 1  √  0
svy_qst_mc question_fi int 10 0
svy_qst_mc use_min_answers tinyint 3 0
svy_qst_metric question_fi int 10 0
svy_qst_metric subtype varchar 1  √  3
svy_qst_oblig obligatory varchar 1  √  1
svy_qst_oblig question_fi int 10 0
svy_qst_oblig question_obligatory_id int 10 0
svy_qst_oblig survey_fi int 10 0
svy_qst_oblig tstamp int 10 0
svy_qst_oblig_seq sequence int 10  √ 
svy_qst_sc orientation varchar 1  √  0
svy_qst_sc question_fi int 10 0
svy_qst_text height int 10 5
svy_qst_text maxchars int 10  √  null
svy_qst_text question_fi int 10 0
svy_qst_text width int 10 50
svy_qtype plugin tinyint 3 0
svy_qtype questiontype_id int 10 0
svy_qtype type_tag varchar 30  √  null
svy_qtype_seq sequence int 10  √ 
svy_quest_skill base_skill_id int 10 0
svy_quest_skill q_id int 10 0
svy_quest_skill survey_id int 10 0
svy_quest_skill tref_id int 10 0
svy_question author varchar 100  √  null
svy_question complete varchar 1  √  0
svy_question created varchar 14  √  null
svy_question description varchar 200  √  null
svy_question label varchar 255  √  null
svy_question obj_fi int 10 0
svy_question obligatory varchar 1  √  1
svy_question original_id int 10  √  null
svy_question owner_fi int 10 0
svy_question question_id int 10 0
svy_question questiontext longtext 2147483647  √  null
svy_question questiontype_fi int 10 0
svy_question title varchar 100  √  null
svy_question tstamp int 10 0
svy_question_seq sequence int 10  √ 
svy_relation longname varchar 20  √  null
svy_relation relation_id int 10 0
svy_relation shortname varchar 2  √  null
svy_relation tstamp int 10 0
svy_relation_seq sequence int 10  √ 
svy_settings keyword varchar 40
svy_settings settings_id int 10 0
svy_settings title varchar 400  √  null
svy_settings usr_id int 10 0
svy_settings value longtext 2147483647  √  null
svy_settings_seq sequence int 10  √ 
svy_skill_threshold base_skill_id int 10 0
svy_skill_threshold level_id int 10 0
svy_skill_threshold survey_id int 10 0
svy_skill_threshold threshold int 10 0
svy_skill_threshold tref_id int 10 0
svy_svy anon_user_list tinyint 3  √  0
svy_svy anonymize varchar 1  √  0
svy_svy author varchar 50  √  null
svy_svy complete varchar 1  √  0
svy_svy confirmation_mail tinyint 3  √  null
svy_svy created int 10 0
svy_svy enddate varchar 14  √  null
svy_svy evaluation_access varchar 1  √  0
svy_svy introduction longtext 2147483647  √  null
svy_svy invitation varchar 1  √  0
svy_svy invitation_mode varchar 1  √  1
svy_svy mailaddresses varchar 2000  √  null
svy_svy mailnotification tinyint 3  √  null
svy_svy mailparticipantdata varchar 4000  √  null
svy_svy mode_360 tinyint 3 0
svy_svy mode_360_results tinyint 3 0
svy_svy mode_360_self_appr tinyint 3 0
svy_svy mode_360_self_eval tinyint 3 0
svy_svy mode_360_self_rate tinyint 3 0
svy_svy mode_360_skill_service tinyint 3 0
svy_svy obj_fi int 10 0
svy_svy outro longtext 2147483647  √  null
svy_svy own_results_mail tinyint 3  √  0
svy_svy own_results_view tinyint 3  √  0
svy_svy pool_usage tinyint 3  √  null
svy_svy reminder_end datetime 19  √  null
svy_svy reminder_frequency smallint 5 0
svy_svy reminder_last_sent datetime 19  √  null
svy_svy reminder_start datetime 19  √  null
svy_svy reminder_status tinyint 3 0
svy_svy reminder_target tinyint 3 0
svy_svy reminder_tmpl int 10  √  null
svy_svy show_question_titles varchar 1  √  1
svy_svy startdate varchar 14  √  null
svy_svy status varchar 1  √  1
svy_svy survey_id int 10 0
svy_svy template_id int 10  √  null
svy_svy tstamp int 10 0
svy_svy tutor_ntf_reci varchar 2000  √  null
svy_svy tutor_ntf_status tinyint 3 0
svy_svy tutor_ntf_target tinyint 3 0
svy_svy_qst heading varchar 4000  √  null
svy_svy_qst question_fi int 10 0
svy_svy_qst sequence int 10 0
svy_svy_qst survey_fi int 10 0
svy_svy_qst survey_question_id int 10 0
svy_svy_qst tstamp int 10 0
svy_svy_qst_seq sequence int 10  √ 
svy_svy_seq sequence int 10  √ 
svy_times entered_page int 10  √  null
svy_times finished_fi int 10 0
svy_times first_question int 10  √  null
svy_times id int 10 0
svy_times left_page int 10  √  null
svy_times_seq sequence int 10  √ 
svy_variable category_fi int 10 0
svy_variable other smallint 5 0
svy_variable question_fi int 10 0
svy_variable scale mediumint 7  √  null
svy_variable sequence int 10 0
svy_variable tstamp int 10 0
svy_variable value1 double 22  √  null
svy_variable value2 double 22  √  null
svy_variable variable_id int 10 0
svy_variable_seq sequence int 10  √ 
sysc_groups component char 16  √  null
sysc_groups id int 10 0
sysc_groups last_update datetime 19  √  null
sysc_groups status tinyint 3 0
sysc_groups_seq sequence int 10  √ 
sysc_tasks grp_id int 10 0
sysc_tasks id int 10 0
sysc_tasks identifier varchar 64  √  null
sysc_tasks last_update datetime 19  √  null
sysc_tasks status tinyint 3 0
sysc_tasks_seq sequence int 10  √ 
syst_style_cat category_ref_id int 10 0
syst_style_cat skin_id varchar 50
syst_style_cat style_id varchar 50
syst_style_cat substyle varchar 50
table_properties property varchar 20
table_properties table_id varchar 30
table_properties user_id int 10 0
table_properties value varchar 4000
table_templates context varchar 128
table_templates name varchar 64
table_templates user_id int 10 0
table_templates value longtext 2147483647  √  null
tax_data id int 10 0
tax_data item_sorting tinyint 3 0
tax_data sorting_mode int 10 0
tax_node create_date datetime 19  √  null
tax_node last_update datetime 19  √  null
tax_node obj_id int 10 0
tax_node order_nr int 10 0
tax_node tax_id int 10 0
tax_node title varchar 200  √  null
tax_node type char 4  √  null
tax_node_assignment component varchar 10
tax_node_assignment item_id int 10 0
tax_node_assignment item_type varchar 20
tax_node_assignment node_id int 10 0
tax_node_assignment obj_id int 10 0
tax_node_assignment order_nr int 10 0
tax_node_assignment tax_id int 10 0
tax_node_seq sequence int 10  √ 
tax_tree child int 10 0
tax_tree depth smallint 5 0
tax_tree lft int 10 0
tax_tree parent int 10  √  null
tax_tree rgt int 10 0
tax_tree tax_tree_id int 10 0
tax_usage obj_id int 10 0
tax_usage tax_id int 10 0
tos_acceptance_track tosv_id int 10 0
tos_acceptance_track ts int 10 0
tos_acceptance_track usr_id int 10 0
tos_acceptance_track_seq sequence int 10  √ 
tos_versions hash varchar 32  √  null
tos_versions id int 10 0
tos_versions lng varchar 2  √  null
tos_versions src varchar 4000  √  null
tos_versions src_type tinyint 3 0
tos_versions text longtext 2147483647  √  null
tos_versions ts int 10 0
tos_versions_seq sequence int 10  √ 
tree child int 10 0
tree depth smallint 5 0
tree lft int 10 0
tree parent int 10  √  null
tree path varchar 4000  √  null
tree rgt int 10 0
tree tree int 10 0
tree_workspace child int 10 0
tree_workspace depth smallint 5 0
tree_workspace lft int 10 0
tree_workspace parent int 10 0
tree_workspace rgt int 10 0
tree_workspace tree int 10 0
tst_active active_id int 10 0
tst_active anonymous_id varchar 5  √  null
tst_active answerstatusfilter varchar 16  √  null
tst_active importname varchar 400  √  null
tst_active last_finished_pass int 10  √  null
tst_active last_pmode varchar 16  √  null
tst_active last_started_pass int 10  √  null
tst_active lastindex int 10 0
tst_active objective_container int 10  √  null
tst_active start_lock varchar 128  √  null
tst_active submitted tinyint 3 0
tst_active submittimestamp datetime 19  √  null
tst_active taxfilter varchar 1024  √  null
tst_active test_fi int 10 0
tst_active tries int 10 0
tst_active tstamp int 10 0
tst_active user_fi int 10 0
tst_active_seq sequence int 10  √ 
tst_addtime active_fi bigint 19 0
tst_addtime additionaltime bigint 19 0
tst_addtime tstamp bigint 19 0
tst_dyn_quest_set_cfg answer_filter_enabled tinyint 3  √  null
tst_dyn_quest_set_cfg order_tax int 10  √  null
tst_dyn_quest_set_cfg source_qpl_fi int 10 0
tst_dyn_quest_set_cfg source_qpl_title varchar 255  √  null
tst_dyn_quest_set_cfg tax_filter_enabled tinyint 3 0
tst_dyn_quest_set_cfg test_fi int 10 0
tst_invited_user clientip varchar 255  √  null
tst_invited_user test_fi int 10 0
tst_invited_user tstamp int 10 0
tst_invited_user user_fi int 10 0
tst_manual_fb active_fi int 10 0
tst_manual_fb feedback longtext 2147483647  √  null
tst_manual_fb manual_feedback_id int 10 0
tst_manual_fb pass int 10 0
tst_manual_fb question_fi int 10 0
tst_manual_fb tstamp int 10 0
tst_manual_fb_seq sequence int 10  √ 
tst_mark mark_id int 10 0
tst_mark minimum_level double 22 0
tst_mark official_name varchar 50  √  null
tst_mark passed varchar 1  √  0
tst_mark short_name varchar 15  √  null
tst_mark test_fi int 10 0
tst_mark tstamp int 10 0
tst_mark_seq sequence int 10  √ 
tst_pass_result active_fi int 10 0
tst_pass_result answeredquestions int 10 0
tst_pass_result exam_id varchar 128  √  null
tst_pass_result hint_count int 10  √  0
tst_pass_result hint_points double 22  √  0
tst_pass_result maxpoints double 22 0
tst_pass_result obligations_answered tinyint 3 1
tst_pass_result pass int 10 0
tst_pass_result points double 22 0
tst_pass_result questioncount int 10 0
tst_pass_result tstamp int 10 0
tst_pass_result workingtime int 10 0
tst_qst_solved active_fi int 10 0
tst_qst_solved question_fi int 10 0
tst_qst_solved solved tinyint 3 0
tst_result_cache active_fi int 10 0
tst_result_cache failed int 10 0
tst_result_cache hint_count int 10  √  0
tst_result_cache hint_points double 22  √  0
tst_result_cache mark_official varchar 256
tst_result_cache mark_short varchar 256
tst_result_cache max_points double 22 0
tst_result_cache obligations_answered tinyint 3 1
tst_result_cache pass int 10 0
tst_result_cache passed int 10 0
tst_result_cache reached_points double 22 0
tst_result_cache tstamp int 10 0
tst_rnd_cpy copy_id int 10 0
tst_rnd_cpy qpl_fi int 10 0
tst_rnd_cpy qst_fi int 10 0
tst_rnd_cpy tst_fi int 10 0
tst_rnd_cpy_seq sequence int 10  √ 
tst_rnd_qpl_title qpl_fi int 10 0
tst_rnd_qpl_title qpl_title varchar 1000
tst_rnd_qpl_title title_id int 10 0
tst_rnd_qpl_title tst_fi int 10 0
tst_rnd_qpl_title_seq sequence int 10  √ 
tst_rnd_quest_set_cfg quest_amount_cfg_mode varchar 16  √  null
tst_rnd_quest_set_cfg quest_amount_per_test int 10  √  null
tst_rnd_quest_set_cfg quest_sync_timestamp int 10 0
tst_rnd_quest_set_cfg req_pools_homo_scored tinyint 3 0
tst_rnd_quest_set_cfg test_fi int 10 0
tst_rnd_quest_set_qpls def_id int 10 0
tst_rnd_quest_set_qpls mapped_node_fi int 10  √  null
tst_rnd_quest_set_qpls mapped_tax_fi int 10  √  null
tst_rnd_quest_set_qpls origin_node_fi int 10  √  null
tst_rnd_quest_set_qpls origin_tax_fi int 10  √  null
tst_rnd_quest_set_qpls pool_fi int 10 0
tst_rnd_quest_set_qpls pool_path varchar 512  √  null
tst_rnd_quest_set_qpls pool_quest_count int 10  √  null
tst_rnd_quest_set_qpls pool_title varchar 128  √  null
tst_rnd_quest_set_qpls quest_amount int 10  √  null
tst_rnd_quest_set_qpls sequence_pos int 10  √  null
tst_rnd_quest_set_qpls test_fi int 10 0
tst_rnd_quest_set_qpls_seq sequence int 10  √ 
tst_seq_qst_answstatus active_fi int 10 0
tst_seq_qst_answstatus correctness tinyint 3 0
tst_seq_qst_answstatus pass int 10 0
tst_seq_qst_answstatus question_fi int 10 0
tst_seq_qst_checked active_fi int 10 0
tst_seq_qst_checked pass int 10 0
tst_seq_qst_checked question_fi int 10 0
tst_seq_qst_optional active_fi int 10 0
tst_seq_qst_optional pass int 10 0
tst_seq_qst_optional question_fi int 10 0
tst_seq_qst_postponed active_fi int 10 0
tst_seq_qst_postponed cnt int 10 0
tst_seq_qst_postponed pass int 10 0
tst_seq_qst_postponed question_fi int 10 0
tst_seq_qst_tracking active_fi int 10 0
tst_seq_qst_tracking orderindex int 10 0
tst_seq_qst_tracking pass int 10 0
tst_seq_qst_tracking question_fi int 10 0
tst_seq_qst_tracking status varchar 16  √  null
tst_sequence active_fi int 10 0
tst_sequence ans_opt_confirmed tinyint 3 0
tst_sequence hidden varchar 4000  √  null
tst_sequence pass int 10 0
tst_sequence postponed varchar 4000  √  null
tst_sequence sequence longtext 2147483647  √  null
tst_sequence tstamp int 10 0
tst_skl_thresholds skill_base_fi int 10 0
tst_skl_thresholds skill_level_fi int 10 0
tst_skl_thresholds skill_tref_fi int 10 0
tst_skl_thresholds test_fi int 10 0
tst_skl_thresholds threshold int 10 0
tst_solutions active_fi int 10 0
tst_solutions authorized tinyint 3  √  1
tst_solutions pass int 10 0
tst_solutions points double 22  √  null
tst_solutions question_fi int 10 0
tst_solutions solution_id int 10 0
tst_solutions step int 10  √  null
tst_solutions tstamp int 10 0
tst_solutions value1 longtext 2147483647  √  null
tst_solutions value2 longtext 2147483647  √  null
tst_solutions_seq sequence int 10  √ 
tst_test_defaults defaults longtext 2147483647  √  null
tst_test_defaults marks longtext 2147483647  √  null
tst_test_defaults name varchar 255  √  null
tst_test_defaults test_defaults_id int 10 0
tst_test_defaults tstamp int 10 0
tst_test_defaults user_fi int 10 0
tst_test_defaults_seq sequence int 10  √ 
tst_test_question obligatory tinyint 3 0
tst_test_question question_fi int 10 0
tst_test_question sequence smallint 5 0
tst_test_question test_fi int 10 0
tst_test_question test_question_id int 10 0
tst_test_question tstamp int 10 0
tst_test_question_seq sequence int 10  √ 
tst_test_result active_fi int 10 0
tst_test_result answered tinyint 3 1
tst_test_result hint_count int 10  √  0
tst_test_result hint_points double 22  √  0
tst_test_result manual tinyint 3 0
tst_test_result pass int 10 0
tst_test_result points double 22 0
tst_test_result question_fi int 10 0
tst_test_result step int 10  √  null
tst_test_result test_result_id int 10 0
tst_test_result tstamp int 10 0
tst_test_result_seq sequence int 10  √ 
tst_test_rnd_qst active_fi int 10 0
tst_test_rnd_qst pass int 10 0
tst_test_rnd_qst question_fi int 10 0
tst_test_rnd_qst sequence smallint 5 0
tst_test_rnd_qst src_pool_def_fi int 10  √  null
tst_test_rnd_qst test_random_question_id int 10 0
tst_test_rnd_qst tstamp int 10 0
tst_test_rnd_qst_seq sequence int 10  √ 
tst_tests allowedusers int 10  √  null
tst_tests alloweduserstimegap int 10  √  null
tst_tests anonymity varchar 1  √  0
tst_tests answer_feedback varchar 1  √  0
tst_tests answer_feedback_points varchar 1  √  0
tst_tests author varchar 50  √  null
tst_tests autosave tinyint 3 0
tst_tests autosave_ival int 10 0
tst_tests broken tinyint 3  √  null
tst_tests certificate_visibility varchar 1  √  0
tst_tests char_selector_availability int 10 0
tst_tests char_selector_definition varchar 4000  √  null
tst_tests complete varchar 1  √  1
tst_tests count_system varchar 1  √  0
tst_tests created int 10 0
tst_tests customstyle varchar 128  √  null
tst_tests ects_a double 22 90
tst_tests ects_b double 22 65
tst_tests ects_c double 22 35
tst_tests ects_d double 22 10
tst_tests ects_e double 22 0
tst_tests ects_fx double 22  √  null
tst_tests ects_output varchar 1  √  0
tst_tests enable_archiving tinyint 3  √  null
tst_tests enable_examview tinyint 3  √  null
tst_tests enable_processing_time varchar 1  √  0
tst_tests enabled_view_mode varchar 20  √  0
tst_tests ending_time int 10 0
tst_tests ending_time_enabled tinyint 3  √  null
tst_tests examid_in_test_pass int 10 0
tst_tests examid_in_test_res int 10 0
tst_tests exportsettings int 10 0
tst_tests finalstatement varchar 4000  √  null
tst_tests fixed_participants varchar 1  √  0
tst_tests force_inst_fb tinyint 3  √  0
tst_tests forcejs int 10 0
tst_tests highscore_achieved_ts int 10  √  0
tst_tests highscore_anon int 10  √  0
tst_tests highscore_enabled int 10  √  0
tst_tests highscore_hints int 10  √  0
tst_tests highscore_own_table int 10  √  0
tst_tests highscore_percentage int 10  √  0
tst_tests highscore_score int 10  √  0
tst_tests highscore_top_num int 10  √  0
tst_tests highscore_top_table int 10  √  0
tst_tests highscore_wtime int 10  √  0
tst_tests inst_fb_answer_fixation tinyint 3  √  null
tst_tests instant_verification varchar 1  √  0
tst_tests intro_enabled tinyint 3  √  null
tst_tests introduction varchar 4000  √  null
tst_tests keep_questions tinyint 3 0
tst_tests kiosk int 10 0
tst_tests limit_users_enabled tinyint 3  √  null
tst_tests mailnotification tinyint 3  √  0
tst_tests mailnottype smallint 5 0
tst_tests mc_scoring varchar 1  √  0
tst_tests nr_of_tries smallint 5 0
tst_tests obj_fi int 10 0
tst_tests obligations_enabled tinyint 3 0
tst_tests offer_question_hints tinyint 3 0
tst_tests online_status tinyint 3 0
tst_tests pass_deletion_allowed int 10 0
tst_tests pass_scoring varchar 1  √  0
tst_tests pass_waiting varchar 15  √  null
tst_tests password varchar 20  √  null
tst_tests password_enabled tinyint 3  √  null
tst_tests pool_usage tinyint 3  √  null
tst_tests print_bs_with_res tinyint 3 1
tst_tests processing_time varchar 8  √  null
tst_tests question_set_type varchar 32 FIXED_QUEST_SET
tst_tests redirection_mode int 10 0
tst_tests redirection_url varchar 128  √  null
tst_tests reporting_date varchar 14  √  null
tst_tests reset_processing_time tinyint 3 0
tst_tests result_tax_filters varchar 255  √  null
tst_tests resultoutput int 10 0
tst_tests results_presentation int 10 3
tst_tests score_cutting varchar 1  √  0
tst_tests score_reporting tinyint 3 0
tst_tests sequence_settings tinyint 3 0
tst_tests show_cancel varchar 1  √  1
tst_tests show_examview_html tinyint 3  √  null
tst_tests show_examview_pdf tinyint 3  √  null
tst_tests show_grading_mark tinyint 3  √  0
tst_tests show_grading_status tinyint 3  √  0
tst_tests show_marker tinyint 3 0
tst_tests show_question_titles varchar 1  √  1
tst_tests show_summary int 10 0
tst_tests showfinalstatement int 10 0
tst_tests showinfo int 10 1
tst_tests shuffle_questions varchar 1  √  0
tst_tests sign_submission int 10 0
tst_tests skill_service tinyint 3  √  null
tst_tests specific_feedback int 10  √  0
tst_tests starting_time int 10 0
tst_tests starting_time_enabled tinyint 3  √  null
tst_tests template_id int 10  √  null
tst_tests test_id int 10 0
tst_tests title_output varchar 1  √  0
tst_tests tstamp int 10 0
tst_tests use_previous_answers varchar 1  √  1
tst_tests_seq sequence int 10  √ 
tst_times active_fi int 10 0
tst_times finished datetime 19  √  null
tst_times pass smallint 5 0
tst_times started datetime 19  √  null
tst_times times_id int 10 0
tst_times tstamp int 10 0
tst_times_seq sequence int 10  √ 
udf_clob field_id int 10 0
udf_clob usr_id int 10 0
udf_clob value longtext 2147483647  √  null
udf_data usr_id int 10 0
udf_definition certificate tinyint 3 0
udf_definition changeable tinyint 3 0
udf_definition changeable_lua tinyint 3 0
udf_definition course_export tinyint 3 0
udf_definition export tinyint 3 0
udf_definition field_id int 10 0
udf_definition field_name char 255  √  null
udf_definition field_type tinyint 3 0
udf_definition field_values longtext 2147483647  √  null
udf_definition group_export tinyint 3  √  0
udf_definition registration_visible tinyint 3  √  0
udf_definition required tinyint 3 0
udf_definition searchable tinyint 3 0
udf_definition visible tinyint 3 0
udf_definition visible_lua tinyint 3 0
udf_definition_seq sequence int 10  √ 
udf_text field_id int 10 0
udf_text usr_id int 10 0
udf_text value varchar 4000  √  null
user_action_activation action_comp varchar 30
user_action_activation action_type varchar 30
user_action_activation active tinyint 3 0
user_action_activation context_comp varchar 30
user_action_activation context_id varchar 30
usr_account_codes code varchar 50  √  null
usr_account_codes code_id int 10 0
usr_account_codes generated int 10  √  0
usr_account_codes used int 10 0
usr_account_codes valid_until varchar 10  √  null
usr_account_codes_seq sequence int 10  √ 
usr_cron_mail_reminder ts int 10 0
usr_cron_mail_reminder usr_id int 10 0
usr_data active int 10 0
usr_data agree_date datetime 19  √  null
usr_data approve_date datetime 19  √  null
usr_data auth_mode char 10  √  default
usr_data birthday date 10  √  null
usr_data city varchar 40  √  null
usr_data client_ip varchar 255  √  null
usr_data country varchar 40  √  null
usr_data create_date datetime 19  √  null
usr_data department varchar 80  √  null
usr_data email varchar 80  √  null
usr_data ext_account varchar 250  √  null
usr_data fax varchar 40  √  null
usr_data feed_hash varchar 32  √  null
usr_data firstname varchar 32  √  null
usr_data gender char 1  √  m
usr_data hobby varchar 4000  √  null
usr_data inactivation_date datetime 19  √  null
usr_data institution varchar 80  √  null
usr_data is_self_registered tinyint 3 0
usr_data last_login datetime 19  √  null
usr_data last_password_change int 10 0
usr_data last_update datetime 19  √  null
usr_data last_visited longtext 2147483647  √  null
usr_data lastname varchar 32  √  null
usr_data latitude varchar 30  √  null
usr_data loc_zoom int 10 0
usr_data login varchar 80  √  null
usr_data login_attempts tinyint 3 0
usr_data longitude varchar 30  √  null
usr_data matriculation varchar 40  √  null
usr_data passwd varchar 80  √  null
usr_data passwd_enc_type varchar 10  √  null
usr_data passwd_salt varchar 32  √  null
usr_data phone_home varchar 40  √  null
usr_data phone_mobile varchar 40  √  null
usr_data phone_office varchar 40  √  null
usr_data profile_incomplete int 10  √  0
usr_data referral_comment varchar 250  √  null
usr_data reg_hash char 32  √  null
usr_data sel_country varchar 2  √  null
usr_data street varchar 40  √  null
usr_data time_limit_from int 10  √  0
usr_data time_limit_message int 10  √  0
usr_data time_limit_owner int 10  √  0
usr_data time_limit_unlimited int 10  √  0
usr_data time_limit_until int 10  √  0
usr_data title varchar 32  √  null
usr_data usr_id int 10 0
usr_data zipcode varchar 10  √  null
usr_data_multi field_id varchar 255
usr_data_multi id int 10 0
usr_data_multi usr_id int 10 0
usr_data_multi value varchar 1000  √  null
usr_data_multi_seq sequence int 10  √ 
usr_ext_profile_page id int 10 0
usr_ext_profile_page order_nr int 10 0
usr_ext_profile_page title varchar 200  √  null
usr_ext_profile_page user_id int 10 0
usr_ext_profile_page_seq sequence int 10  √ 
usr_form_settings id varchar 50
usr_form_settings settings varchar 4000
usr_form_settings user_id int 10 0
usr_portf_acl extended_data varchar 200  √  null
usr_portf_acl node_id int 10 0
usr_portf_acl object_id int 10 0
usr_portf_acl tstamp int 10 0
usr_portfolio bg_color char 6  √  null
usr_portfolio font_color char 6  √  null
usr_portfolio id int 10 0
usr_portfolio img varchar 255  √  null
usr_portfolio is_default tinyint 3  √  null
usr_portfolio is_online tinyint 3  √  null
usr_portfolio ppic tinyint 3  √  null
usr_portfolio_page id int 10 0
usr_portfolio_page order_nr int 10 0
usr_portfolio_page portfolio_id int 10 0
usr_portfolio_page title varchar 250
usr_portfolio_page type tinyint 3 1
usr_portfolio_page_seq sequence int 10  √ 
usr_pref keyword char 40
usr_pref usr_id int 10 0
usr_pref value varchar 4000  √  null
usr_pwassist ctime int 10 0
usr_pwassist expires int 10 0
usr_pwassist pwassist_id char 180
usr_pwassist user_id int 10 0
usr_search checked longtext 2147483647  √  null
usr_search creation_filter varchar 1000  √  null
usr_search failed longtext 2147483647  √  null
usr_search item_filter varchar 1000  √  null
usr_search mime_filter varchar 1000  √  null
usr_search page tinyint 3 0
usr_search query longtext 2147483647  √  null
usr_search root int 10  √  1
usr_search search_result longtext 2147483647  √  null
usr_search search_type tinyint 3 0
usr_search usr_id int 10 0
usr_sess_istorage component_id varchar 30
usr_sess_istorage session_id varchar 80
usr_sess_istorage value varchar 1000  √  null
usr_sess_istorage vkey varchar 50
usr_session createtime int 10  √  null
usr_session ctime int 10 0
usr_session data longtext 2147483647  √  null
usr_session expires int 10 0
usr_session last_remind_ts int 10 0
usr_session remote_addr varchar 50  √  null
usr_session session_id varchar 250
usr_session type int 10  √  null
usr_session user_id int 10 0
usr_session_log maxval mediumint 7 0
usr_session_log tstamp int 10 0
usr_session_log user_id int 10 0
usr_session_stats active_avg int 10  √  null
usr_session_stats active_end int 10  √  null
usr_session_stats active_max int 10  √  null
usr_session_stats active_min int 10  √  null
usr_session_stats closed_expire int 10  √  null
usr_session_stats closed_idle int 10  √  null
usr_session_stats closed_idle_first int 10  √  null
usr_session_stats closed_limit int 10  √  null
usr_session_stats closed_login int 10  √  null
usr_session_stats closed_manual int 10  √  null
usr_session_stats closed_misc int 10  √  0
usr_session_stats max_sessions int 10  √  null
usr_session_stats opened int 10  √  null
usr_session_stats slot_begin int 10 0
usr_session_stats slot_end int 10 0
usr_session_stats_raw end_context smallint 5  √  null
usr_session_stats_raw end_time int 10  √  null
usr_session_stats_raw session_id varchar 80
usr_session_stats_raw start_time int 10 0
usr_session_stats_raw type smallint 5 0
usr_session_stats_raw user_id int 10 0
ut_lp_coll_manual completed tinyint 3 0
ut_lp_coll_manual last_change int 10 0
ut_lp_coll_manual obj_id int 10 0
ut_lp_coll_manual subitem_id int 10 0
ut_lp_coll_manual usr_id int 10 0
ut_lp_collections active tinyint 3 1
ut_lp_collections grouping_id int 10 0
ut_lp_collections item_id int 10 0
ut_lp_collections lpmode tinyint 3  √  5
ut_lp_collections num_obligatory int 10 0
ut_lp_collections obj_id int 10 0
ut_lp_defaults lp_mode tinyint 3 0
ut_lp_defaults type_id varchar 10
ut_lp_marks completed int 10 0
ut_lp_marks mark varchar 32  √  null
ut_lp_marks obj_id int 10 0
ut_lp_marks percentage tinyint 3 0
ut_lp_marks status tinyint 3 0
ut_lp_marks status_changed datetime 19  √  null
ut_lp_marks status_dirty tinyint 3 0
ut_lp_marks u_comment varchar 4000  √  null
ut_lp_marks usr_id int 10 0
ut_lp_settings obj_id int 10 0
ut_lp_settings obj_type char 4  √  null
ut_lp_settings u_mode tinyint 3 0
ut_lp_settings visits int 10  √  0
ut_lp_user_status additional_info varchar 4000  √  null
ut_lp_user_status obj_id int 10 0
ut_lp_user_status status tinyint 3 0
ut_lp_user_status usr_id int 10 0
ut_online access_time int 10 0
ut_online online_time int 10 0
ut_online usr_id int 10 0
webr_items active tinyint 3  √  null
webr_items create_date int 10 0
webr_items description varchar 4000  √  null
webr_items disable_check tinyint 3  √  null
webr_items internal tinyint 3  √  null
webr_items last_check int 10  √  null
webr_items last_update int 10 0
webr_items link_id int 10 0
webr_items target varchar 4000  √  null
webr_items title varchar 127  √  null
webr_items valid tinyint 3 0
webr_items webr_id int 10 0
webr_items_seq sequence int 10  √ 
webr_params link_id int 10 0
webr_params name char 128  √  null
webr_params param_id int 10 0
webr_params value tinyint 3 0
webr_params webr_id int 10 0
webr_params_seq sequence int 10  √ 
wfe_det_listening content varchar 255  √  null
wfe_det_listening context_id int 10  √  null
wfe_det_listening context_type varchar 30  √  null
wfe_det_listening detector_id int 10 0
wfe_det_listening listening_end int 10  √  null
wfe_det_listening listening_start int 10  √  null
wfe_det_listening subject_id int 10  √  null
wfe_det_listening subject_type varchar 30  √  null
wfe_det_listening type varchar 255  √  null
wfe_det_listening workflow_id int 10 0
wfe_det_listening_seq sequence int 10  √ 
wfe_startup_events content varchar 255  √  null
wfe_startup_events context_id int 10  √  null
wfe_startup_events context_type varchar 30  √  null
wfe_startup_events event_id int 10 0
wfe_startup_events subject_id int 10  √  null
wfe_startup_events subject_type varchar 30  √  null
wfe_startup_events type varchar 255  √  null
wfe_startup_events workflow_id varchar 60
wfe_startup_events_seq sequence int 10  √ 
wfe_static_inputs event_id int 10 0
wfe_static_inputs input_id int 10 0
wfe_static_inputs name varchar 255  √  null
wfe_static_inputs value longtext 2147483647  √  null
wfe_static_inputs_seq sequence int 10  √ 
wfe_workflows active int 10  √  null
wfe_workflows context_id int 10  √  null
wfe_workflows context_type varchar 30  √  null
wfe_workflows subject_id int 10  √  null
wfe_workflows subject_type varchar 30  √  null
wfe_workflows workflow_class varchar 255  √  null
wfe_workflows workflow_content varchar 255  √  null
wfe_workflows workflow_id int 10 0
wfe_workflows workflow_instance longtext 2147483647  √  null
wfe_workflows workflow_location varchar 255  √  null
wfe_workflows workflow_type varchar 255  √  null
wfe_workflows_seq sequence int 10  √ 
wiki_page_template add_to_page tinyint 3 0
wiki_page_template new_pages tinyint 3 0
wiki_page_template wiki_id int 10 0
wiki_page_template wpage_id int 10 0
wiki_stat avg_rating int 10 0
wiki_stat del_pages int 10 0
wiki_stat num_pages int 10 0
wiki_stat ts datetime 19 1970-01-01 00:00:00
wiki_stat ts_day char 10  √  null
wiki_stat ts_hour tinyint 3  √  null
wiki_stat wiki_id int 10 0
wiki_stat_page avg_rating int 10 0
wiki_stat_page deleted tinyint 3 0
wiki_stat_page ext_links int 10 0
wiki_stat_page footnotes int 10 0
wiki_stat_page int_links int 10 0
wiki_stat_page num_chars bigint 19 0
wiki_stat_page num_ratings int 10 0
wiki_stat_page num_words int 10 0
wiki_stat_page page_id int 10 0
wiki_stat_page ts datetime 19 1970-01-01 00:00:00
wiki_stat_page ts_day char 10  √  null
wiki_stat_page ts_hour tinyint 3  √  null
wiki_stat_page wiki_id int 10 0
wiki_stat_page_user changes int 10 0
wiki_stat_page_user page_id int 10 0
wiki_stat_page_user read_events int 10 0
wiki_stat_page_user ts datetime 19 1970-01-01 00:00:00
wiki_stat_page_user ts_day char 10  √  null
wiki_stat_page_user ts_hour tinyint 3  √  null
wiki_stat_page_user user_id int 10 0
wiki_stat_page_user wiki_id int 10 0
wiki_stat_user new_pages int 10 0
wiki_stat_user ts datetime 19 1970-01-01 00:00:00
wiki_stat_user ts_day char 10  √  null
wiki_stat_user ts_hour tinyint 3  √  null
wiki_stat_user user_id int 10 0
wiki_stat_user wiki_id int 10 0
wiki_user_html_export progress int 10 0
wiki_user_html_export start_ts datetime 19  √  null
wiki_user_html_export status tinyint 3 0
wiki_user_html_export usr_id int 10 0
wiki_user_html_export wiki_id int 10 0
write_event action varchar 8
write_event obj_id int 10 0
write_event parent_obj_id int 10 0
write_event ts datetime 19 1970-01-01 00:00:00
write_event usr_id int 10 0
write_event write_id int 10 0
write_event_seq sequence int 10  √ 
xhtml_page content longtext 2147483647  √  null
xhtml_page id int 10 0
xhtml_page save_content longtext 2147483647  √  null
xhtml_page_seq sequence int 10  √ 
xmlnestedset ns_book_fk int 10 0
xmlnestedset ns_id int 10 0
xmlnestedset ns_l int 10 0
xmlnestedset ns_r int 10 0
xmlnestedset ns_tag_fk int 10 0
xmlnestedset ns_type varchar 50
xmlnestedset_seq sequence int 10  √ 
xmlnestedsettmp ns_book_fk int 10 0
xmlnestedsettmp ns_id int 10 0
xmlnestedsettmp ns_l int 10 0
xmlnestedsettmp ns_r int 10 0
xmlnestedsettmp ns_tag_fk int 10 0
xmlnestedsettmp ns_type varchar 50
xmlnestedsettmp ns_unique_id varchar 32
xmlnestedsettmp_seq sequence int 10  √ 
xmlparam param_name char 50
xmlparam param_value char 255  √  null
xmlparam tag_fk int 10 0
xmltags tag_depth int 10 0
xmltags tag_name char 50  √  null
xmltags tag_pk int 10 0
xmltags_seq sequence int 10  √ 
xmlvalue tag_fk int 10 0
xmlvalue tag_value longtext 2147483647  √  null
xmlvalue tag_value_pk int 10 0
xmlvalue_seq sequence int 10  √