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
il_custom_block.[context_obj_type] orgu_obj_type_settings.[obj_type]
il_custom_block.[context_sub_obj_type] orgu_obj_type_settings.[obj_type]
il_news_item.[context_obj_type] orgu_obj_type_settings.[obj_type]
il_news_item.[context_sub_obj_type] orgu_obj_type_settings.[obj_type]
il_request_token.[session_id] mail_tpl_ctx.[id]
lti2_context.[consumer_pk] lti2_consumer.[consumer_pk]
lti2_resource_link.[consumer_pk] lti2_consumer.[consumer_pk]
lti2_resource_link.[context_pk] lti2_context.[context_pk]
lti2_share_key.[resource_link_pk] lti2_resource_link.[resource_link_pk]
lti2_tool_proxy.[consumer_pk] lti2_consumer.[consumer_pk]
lti2_user_result.[resource_link_pk] lti2_resource_link.[resource_link_pk]
mail.[tpl_ctx_id] mail_tpl_ctx.[id]
mail_saved.[tpl_ctx_id] mail_tpl_ctx.[id]
note.[obj_type] orgu_obj_type_settings.[obj_type]
obj_stat.[obj_type] orgu_obj_type_settings.[obj_type]
obj_stat_log.[obj_type] orgu_obj_type_settings.[obj_type]
obj_stat_tmp.[obj_type] orgu_obj_type_settings.[obj_type]
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
Anomaly not detected

Tables that contain a single column

Table Column
addressbook_mlist_ass_seq
addressbook_mlist_seq
adm_settings_template_seq
adv_md_record_scope_seq
adv_md_record_seq
adv_mdf_definition_seq
aicc_object_seq
aicc_units_seq
ass_log_seq
background_task_seq
badge_badge_seq
badge_image_template_seq
benchmark_seq
booking_entry_seq
booking_object_seq
booking_reservation_group_seq
booking_reservation_seq
booking_schedule_seq
bookmark_data_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_ass_file_order_seq
exc_assignment_seq
exc_crit_cat_seq
exc_crit_seq
exc_returned_seq
feedback_items_seq
frm_data_seq
frm_drafts_history_seq
frm_notification_seq
frm_posts_deleted_seq
frm_posts_drafts_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_bt_bucket_seq
il_bt_task_seq
il_bt_value_seq
il_bt_value_to_task_seq
il_certificate
il_custom_block_seq
il_dcl_data_seq
il_dcl_field_prop_s_b
il_dcl_field_prop_seq
il_dcl_field_seq
il_dcl_record_field_seq
il_dcl_record_seq
il_dcl_sel_opts_seq
il_dcl_stloc1_value_seq
il_dcl_stloc2_value_seq
il_dcl_stloc3_value_seq
il_dcl_table_seq
il_dcl_tableview_seq
il_dcl_tfield_set_seq
il_dcl_tview_set_seq
il_dcl_view_seq
il_exc_team_log_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_orgu_authority_seq
il_orgu_op_contexts_seq
il_orgu_operations_seq
il_orgu_permissions_seq
il_orgu_positions_seq
il_orgu_ua_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
link_check_seq
lm_data_seq
lm_menu_seq
loc_tst_assignments_seq
lti2_consumer_seq
lti2_context_seq
lti2_resource_link_seq
lti2_tool_proxy_seq
lti2_user_result_seq
lti_ext_consumer_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
obj_stat_log_seq
object_data_seq
object_reference_seq
object_reference_ws_seq
openid_provider_seq
orgu_types_seq
page_layout_seq
page_style_usage_seq
pdfgen_conf_seq
pdfgen_map_seq
pdfgen_purposes_seq
pdfgen_renderer_avail_seq
pdfgen_renderer_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
saml_idp_settings_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
usr_starting_point_seq
webr_items_seq
webr_params_seq
wfe_det_listening_seq
wfe_startup_events_seq
wfe_static_inputs_seq
wfe_workflows_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