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
catissue_form_context.[CP_ID] os_cp_workflows.[CP_ID]
catissue_form_context_aud.[CP_ID] os_cp_workflows.[CP_ID]
catissue_saved_queries_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_auth_credentials.[TOKEN] os_auth_tokens.[TOKEN]
os_cp_allowed_dps_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_cp_cust_fields.[CP_ID] os_cp_workflows.[CP_ID]
os_cp_report_settings_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_cp_workflows_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_forgot_password_tokens.[TOKEN] os_auth_tokens.[TOKEN]
os_specimen_kits_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_specimen_requests_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_spmn_lbl_print_settings_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_user_db_sessions.[TOKEN] os_auth_tokens.[TOKEN]
os_user_otp_details.[RESET_TOKEN] os_auth_tokens.[TOKEN]
rbac_subject_roles_aud.[CP_ID] os_cp_workflows.[CP_ID]

Tables without indexes

Table Rows
cat_distribution_protocol_aud 0
cat_stor_cont_spec_types 0
catissue_box_scanner 0
catissue_form_context_aud 34
catissue_import_queries_log 23
catissue_query_folders_aud 2
catissue_report_particip_rel 0
catissue_saved_queries_aud 23
catissue_spec_tag_items_aud 0
catissue_specimenlist_tags_aud 0
databasechangelog 2260
os_auth_credentials 0
os_cart_folder_carts_aud 0
os_cart_folder_user_groups_aud 0
os_catalog_req_managers_aud 1
os_catalog_resources_aud 0
os_catalog_user_groups_aud 0
os_cfg_settings_aud 12
os_consent_statements_aud 0
os_container_activity_logs_aud 0
os_container_tasks_aud 0
os_container_types_aud 19
os_cp_allowed_dps_aud 0
os_cp_report_rcpts_aud 0
os_cp_report_settings_aud 0
os_cp_workflows_aud 0
os_dashboard_view_params_aud 0
os_dashboards_aud 0
os_dashlet_configs_aud 0
os_dashlets_aud 0
os_dist_invoice_items_aud 0
os_dist_invoices_aud 0
os_dist_protocol_sites_aud 0
os_dist_services_aud 0
os_dp_consent_tiers_aud 0
os_dp_coordinators_aud 0
os_dp_requirements_aud 0
os_dpr_pathology_statuses_aud 0
os_form_notif_user_grps_aud 0
os_import_forms_log 34
os_import_runner 1
os_order_items_aud 0
os_orders_aud 0
os_print_rules_aud 1
os_pv_props_aud 0
os_query_folder_queries_aud 7
os_query_folder_user_grps_aud 0
os_query_folder_users_aud 0
os_saved_query_deps_aud 0
os_sc_spmn_requests 0
os_sched_cont_act_users_aud 0
os_sched_cont_activities_aud 0
os_sched_job_shared_users_aud 0
os_sched_jobs_notif_rcpts_aud 0
os_scheduled_jobs_aud 0
os_shipment_containers_aud 0
os_shipment_notify_users_aud 0
os_shipment_specimens_aud 0
os_shipments_aud 0
os_specimen_array_cores_aud 0
os_specimen_array_slides_aud 0
os_specimen_arrays_aud 0
os_specimen_cart_folders_aud 0
os_specimen_catalogs_aud 1
os_specimen_gel_items_aud 0
os_specimen_gels_aud 0
os_specimen_kits_aud 0
os_specimen_request_items_aud 0
os_specimen_requests_aud 0
os_specimen_slide_cores_aud 0
os_specimen_stats 0
os_spmn_lbl_print_settings_aud 0
os_spmn_list_shared_grps_aud 0
os_user_group_users_aud 0
os_visit_clin_diagnoses_aud 0
rbac_role_access_list_aud 0
rbac_role_access_list_ops_aud 0
rbac_roles_aud 0
rbac_subject_roles_aud 0
shared_specimenlist_tags_aud 0

Tables that contain a single column

Table Column
catissue_tissue_req_specimen

Tables with incrementing column names, potentially indicating denormalization

Table
de_e_11001

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

Table
Anomaly not detected