Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
addressbook_mlist.[user_id] il_gc_memcache_server.[id]
addressbook_mlist_ass.[usr_id] il_gc_memcache_server.[id]
frm_data.[top_usr_id] il_gc_memcache_server.[id]
il_cld_data.[owner_id] il_gc_memcache_server.[id]
il_event_handling.[id] mail_tpl_ctx.[id]
il_request_token.[session_id] mail_tpl_ctx.[id]
mail.[tpl_ctx_id] mail_tpl_ctx.[id]
mail_saved.[tpl_ctx_id] mail_tpl_ctx.[id]
payment_shopping_cart.[session_id] usr_session_stats_raw.[session_id]
qpl_hint_tracking.[qhtr_active_fi] tst_result_cache.[active_fi]
skl_user_has_level.[trigger_obj_type] adv_md_substitutions.[obj_type]
skl_user_skill_level.[trigger_obj_type] adv_md_substitutions.[obj_type]
svy_answer.[active_fi] tst_result_cache.[active_fi]
tst_manual_fb.[active_fi] tst_result_cache.[active_fi]
tst_solutions.[active_fi] tst_result_cache.[active_fi]
tst_test_result.[active_fi] tst_result_cache.[active_fi]
tst_test_rnd_qst.[active_fi] tst_result_cache.[active_fi]
tst_times.[active_fi] tst_result_cache.[active_fi]

Tables without indexes

Table Rows
copg_section_timings 0
ecs_part_settings 0
feedback_results 0
il_event_handling 78
il_exc_team_log 0
il_wiki_imp_pages 0
link_check 0
obj_stat_log 0
obj_stat_tmp 0
page_style_usage 0
skl_tree 1
style_template_class 0
usr_session_log 0

Tables that contain a single column

Table Column
addressbook_mlist_ass_seq
addressbook_mlist_seq
adm_settings_template_seq
adv_md_record_seq
adv_mdf_definition_seq
aicc_object_seq
aicc_units_seq
ass_log_seq
booking_entry_seq
booking_object_seq
booking_reservation_group_seq
booking_reservation_seq
booking_schedule_seq
bookmark_data_seq
bookmark_social_bm_seq
cal_categories_seq
cal_ch_group_seq
cal_entries_seq
cal_notification_seq
cal_rec_exclusion_seq
cal_recurrence_rules_seq
chatroom_admconfig_seq
chatroom_history_seq
chatroom_prooms_seq
chatroom_psessions_seq
chatroom_sessions_seq
chatroom_settings_seq
chatroom_smilies_seq
chatroom_uploads_seq
cmi_comment_seq
cmi_correct_response_seq
cmi_interaction_seq
cmi_node_seq
cmi_objective_seq
conditions_seq
cp_node_seq
crs_archives_seq
crs_f_definitions_seq
crs_file_seq
crs_objective_lm_seq
crs_objective_qst_seq
crs_objective_tst_seq
crs_objectives_seq
crs_start_seq
didactic_tpl_a_seq
didactic_tpl_fp_seq
didactic_tpl_settings_seq
ecs_cmap_rule_seq
ecs_cms_data_seq
ecs_container_mapping_seq
ecs_course_assignments_seq
ecs_crs_mapping_atts_seq
ecs_events_seq
ecs_remote_user_seq
ecs_server_seq
event_appointment_seq
event_file_seq
event_seq
exc_assignment_seq
exc_crit_cat_seq
exc_crit_seq
exc_returned_seq
feedback_items_seq
frm_data_seq
frm_notification_seq
frm_posts_deleted_seq
frm_posts_seq
frm_posts_tree_seq
frm_threads_seq
glossary_definition_seq
glossary_term_seq
help_module_seq
help_tooltip_seq
history_seq
il_bibl_attribute_seq
il_bibl_entry_seq
il_bibl_settings_seq
il_blog_posting_seq
il_certificate
il_custom_block_seq
il_dcl_data_seq
il_dcl_field_prop_seq
il_dcl_field_seq
il_dcl_record_field_seq
il_dcl_record_seq
il_dcl_stloc1_value_seq
il_dcl_stloc2_value_seq
il_dcl_stloc3_value_seq
il_dcl_table_seq
il_dcl_view_seq
il_exc_team_seq
il_external_feed_block_seq
il_gc_memcache_server_seq
il_md_cpr_selections_seq
il_meta_annotation_seq
il_meta_classification_seq
il_meta_contribute_seq
il_meta_description_seq
il_meta_educational_seq
il_meta_entity_seq
il_meta_format_seq
il_meta_general_seq
il_meta_identifier__seq
il_meta_identifier_seq
il_meta_keyword_seq
il_meta_language_seq
il_meta_lifecycle_seq
il_meta_location_seq
il_meta_meta_data_seq
il_meta_relation_seq
il_meta_requirement_seq
il_meta_rights_seq
il_meta_tar_seq
il_meta_taxon_path_seq
il_meta_taxon_seq
il_meta_technical_seq
il_new_item_grp_seq
il_news_item_seq
il_poll_answer_seq
il_qpl_qst_fq_res_seq
il_qpl_qst_fq_res_unit_seq
il_qpl_qst_fq_ucat_seq
il_qpl_qst_fq_unit_seq
il_qpl_qst_fq_var_seq
il_rating_cat_seq
il_wiki_page_seq
ldap_rg_mapping_seq
ldap_role_assignments_seq
ldap_server_settings_seq
lm_data_seq
lm_menu_seq
loc_tst_assignments_seq
mail_man_tpl_seq
mail_obj_data_seq
mail_seq
media_item_seq
mep_item_seq
note_seq
notification_data_seq
notification_osd_seq
object_data_seq
object_reference_seq
object_reference_ws_seq
openid_provider_seq
orgu_types_seq
page_layout_seq
payment_coupons_codes_seq
payment_coupons_seq
payment_coupons_track_seq
payment_currencies_seq
payment_news_seq
payment_objects_seq
payment_paymethods_seq
payment_prices_seq
payment_shopping_cart_seq
payment_statistic_seq
payment_topics_seq
payment_vats_seq
pg_amd_page_list_seq
prg_settings_seq
prg_translations_seq
prg_type_adv_md_rec_seq
prg_type_seq
prg_usr_assignments_seq
prg_usr_progress_seq
qpl_a_cloze_seq
qpl_a_errortext_seq
qpl_a_essay_seq
qpl_a_imagemap_seq
qpl_a_matching_seq
qpl_a_mc_seq
qpl_a_mdef_seq
qpl_a_mterm_seq
qpl_a_ordering_seq
qpl_a_sc_seq
qpl_a_textsubset_seq
qpl_fb_generic_seq
qpl_fb_specific_seq
qpl_hint_tracking_seq
qpl_hints_seq
qpl_num_range_seq
qpl_questionpool_seq
qpl_questions_seq
qpl_sol_sug_seq
rbac_log_seq
rbac_operations_seq
reg_er_assignments_seq
reg_registration_codes_seq
role_desktop_items_seq
sahs_sc13_seq_node_seq
sahs_sc13_seq_templts_seq
sahs_sc13_tree_node_seq
sc_resource_dependen_seq
sc_resource_file_seq
scorm_object_seq
search_data_seq
shib_role_assignment_seq
skl_level_seq
skl_profile_seq
skl_self_eval_seq
skl_tree_node_seq
sty_media_query_seq
style_parameter_seq
style_template_seq
svy_anonymous_seq
svy_answer_seq
svy_category_seq
svy_constraint_seq
svy_finished_seq
svy_inv_usr_seq
svy_material_seq
svy_phrase_cat_seq
svy_phrase_seq
svy_qblk_qst_seq
svy_qblk_seq
svy_qpl_seq
svy_qst_constraint_seq
svy_qst_matrixrows_seq
svy_qst_oblig_seq
svy_qtype_seq
svy_question_seq
svy_relation_seq
svy_settings_seq
svy_svy_qst_seq
svy_svy_seq
svy_times_seq
svy_variable_seq
sysc_groups_seq
sysc_tasks_seq
tax_node_seq
tos_acceptance_track_seq
tos_versions_seq
tst_active_seq
tst_manual_fb_seq
tst_mark_seq
tst_rnd_cpy_seq
tst_rnd_qpl_title_seq
tst_rnd_quest_set_qpls_seq
tst_solutions_seq
tst_test_defaults_seq
tst_test_question_seq
tst_test_result_seq
tst_test_rnd_qst_seq
tst_tests_seq
tst_times_seq
udf_data
udf_definition_seq
usr_account_codes_seq
usr_data_multi_seq
usr_ext_profile_page_seq
usr_portfolio_page_seq
webr_items_seq
webr_params_seq
write_event_seq
xhtml_page_seq
xmlnestedset_seq
xmlnestedsettmp_seq
xmltags_seq
xmlvalue_seq

Tables with incrementing column names, potentially indicating denormalization

Table
cache_clob
cache_text
svy_qst_matrix
svy_variable
tst_solutions

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected