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_ass.[ml_id] addressbook_mlist.[ml_id]
payment_shopping_cart.[session_id] usr_session_stats_raw.[session_id]
skl_user_has_level.[trigger_obj_type] adv_md_substitutions.[obj_type]
skl_user_skill_level.[trigger_obj_type] adv_md_substitutions.[obj_type]

Tables that contain a single column

Table Column
addressbook_mlist_ass_seq
addressbook_mlist_seq
addressbook_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
chat_record_data_seq
chat_records_seq
chat_room_messages_seq
chat_rooms_seq
chat_smilies_seq
chatroom_admconfig_seq
chatroom_prooms_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_server_seq
event_appointment_seq
event_file_seq
event_seq
exc_assignment_seq
exc_returned_seq
feedback_items_seq
frm_data_seq
frm_notification_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_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_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
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
org_unit_data_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
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_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
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_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_ext_profile_page_seq
usr_portfolio_page_seq
ut_access_seq
webr_items_seq
webr_params_seq
write_event_seq
xhtml_page_seq
xmltags_seq
xmlvalue_seq

Tables with incrementing column names, potentially indicating denormalization

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

Table
Anomaly not detected