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
cat_collection_protocol_aud.[CONSENTS_SOURCE_CP_ID] os_cp_workflows.[CP_ID]
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_message_settings_aud.[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_cpr_anticipated_spmns.[CPR_ID] os_cpr_recs.[CPR_ID]
os_cpr_cust_fields.[CPR_ID] os_cpr_recs.[CPR_ID]
os_cpr_extn_recs.[CPR_ID] os_cpr_recs.[CPR_ID]
os_dq_audit_settings_aud.[CP_ID] os_cp_workflows.[CP_ID]
os_forgot_password_tokens.[TOKEN] os_auth_tokens.[TOKEN]
os_participant_email_tmpls_aud.[CP_ID] os_cp_workflows.[CP_ID]
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_surveys_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]
os_workflow_cps_aud.[CP_ID] os_cp_workflows.[CP_ID]
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 33
catissue_import_queries_log 23
catissue_query_folders_aud 0
catissue_report_particip_rel 0
catissue_saved_queries_aud 23
catissue_spec_tag_items_aud 0
catissue_specimenlist_tags_aud 0
databasechangelog 2490
os_auth_credentials 0
os_cart_folder_carts_aud 0
os_cart_folder_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_message_settings_aud 0
os_cp_report_rcpts_aud 0
os_cp_report_settings_aud 0
os_cp_workflows_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_dq_audit_settings_aud 0
os_form_notif_user_grps_aud 0
os_import_forms_log 33
os_import_runner 0
os_import_workflows_log 9
os_order_items_aud 0
os_orders_aud 0
os_participant_email_tmpls_aud 0
os_print_rules_aud 0
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_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_sms_provider_cfg_props_aud 0
os_sms_provider_configs_aud 0
os_specimen_cart_folders_aud 0
os_specimen_kits_aud 0
os_specimen_request_items_aud 0
os_specimen_requests_aud 0
os_specimen_stats 0
os_spmn_lbl_print_settings_aud 0
os_spmn_list_shared_grps_aud 0
os_surveys_aud 0
os_user_group_users_aud 0
os_visit_clin_diagnoses_aud 0
os_wf_lab_user_groups_aud 0
os_wf_lib_task_notif_grps_aud 0
os_wf_lib_task_user_groups_aud 0
os_wf_lib_tasks_aud 11
os_wf_libraries_aud 0
os_wf_notif_user_groups_aud 0
os_wf_task_notif_groups_aud 0
os_wf_task_user_groups_aud 0
os_workflow_cps_aud 0
os_workflow_labs_aud 0
os_workflow_task_inputs_aud 15
os_workflow_tasks_aud 20
os_workflows_aud 8
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