Tables


SchemaSpy Analysis of openspecimen

Generated on Thu Apr 03 14:02 IST 2025

XML Representation
Insertion Order Deletion Order
TABLES 413
VIEWS 32
COLUMNS 4010
Constraints 601
Anomalies 111
Routines 21

Database Properties

Database Type: MySQL - 8.0.41-0ubuntu0.20.04.1

Tables

Table / View Children Parents Columns Rows Type Comments
os_kit_specimens 0 12 2 0 Table
os_specimen_cart_folders 12 6 6 0 Table
os_cfg_settings 0 12 6 177 Table
os_dp_requirements 6 24 13 0 Table
os_workflow_instance_in_items 0 30 6 0 Table
os_wf_lab_user_groups_aud 0 0 4 0 Table
os_consent_statements_aud 0 0 9 0 Table
os_specimen_requests 18 30 18 0 Table
dyextn_id_seq 0 0 2 2 Table
os_dist_protocol_sites_aud 0 0 9 0 Table
os_shipments 24 42 22 0 Table
os_unhandled_exceptions 0 6 8 0 Table
catissue_st_cont_st_type_rel 0 6 2 0 Table
os_user_otp_details 0 7 7 0 Table
os_cart_folder_user_groups_aud 0 0 4 0 Table
os_participant_email_tmpls_aud 0 1 27 0 Table
cat_stor_cont_spec_types 0 0 2 0 Table
catissue_cp_req_specimen 28 72 38 0 Table
os_survey_instances 0 36 21 0 Table
os_auth_credentials 0 1 2 0 Table
os_published_cp_events 6 18 7 0 Table
catissue_frozen_event_param 0 18 8 0 Table
os_sched_jobs_notif_rcpts_aud 0 0 4 0 Table
os_cart_folder_user_groups 0 12 2 0 Table
os_export_jobs 6 6 8 0 Table
catissue_cell_spe_review_param 0 12 7 0 Table
os_surveys_aud 0 1 67 0 Table
catissue_coll_distribution_rel 0 12 2 0 Table
catissue_cp_site_roles 0 12 4 0 Table
os_cart_folder_carts_aud 0 0 4 0 Table
os_sms_provider_cfg_props_aud 0 0 5 0 Table
os_supply_vendors 8 0 3 0 Table
cat_collection_protocol_aud 0 7 100 0 Table
os_export_job_params 0 6 3 0 Table
os_import_forms_log 0 0 4 33 Table
os_dp_requirements_aud 0 0 25 0 Table
os_auto_freezer_providers 12 0 3 0 Table
os_spmn_lbl_print_settings_aud 0 1 11 0 Table
catissue_query_folders 18 6 5 1 Table
os_cfg_prop_allowed_values 0 6 2 0 Table
os_user_group_users_aud 0 0 4 0 Table
catissue_qfolder_share_setting 0 12 2 0 Table
catissue_report_xmlcontent 0 12 2 0 Table
os_cp_cust_fields 0 1 3 0 Table
os_user_notifications 0 12 5 0 Table
os_workflow_task_inputs 0 12 4 15 Table
os_wf_lib_task_user_groups_aud 0 0 4 0 Table
os_query_folder_user_grps_aud 0 0 4 0 Table
os_cp_workflows 21 6 2 0 Table
os_dpr_pathology_statuses 0 12 3 0 Table
os_supply_shipments 4 20 14 0 Table
catissue_specimenlist_tags 42 6 8 0 Table
os_print_rules 0 12 8 0 Table
catissue_form_context 24 7 11 33 Table
os_external_app_ids 6 0 5 0 Table
os_user_groups 102 6 5 0 Table
os_cpr_messaging_activities 0 12 11 0 Table
os_sched_cont_activities_aud 0 0 26 0 Table
os_staged_participant_races 0 12 3 0 Table
os_stor_container_dps_aud 0 6 4 0 Table
os_workflow_task_instances 18 18 7 0 Table
os_wf_task_notif_groups_aud 0 0 4 0 Table
os_dq_audit_settings 0 18 5 0 Table
catissue_distri_event_param 0 12 9 0 Table
os_specimen_cart_folders_aud 0 0 15 0 Table
catissue_distribution_spec_req 0 6 7 0 Table
os_notifications 6 6 7 0 Table
de_e_11003 0 0 2 0 Table
os_specimen_biohazards 0 12 3 0 Table
de_e_11002 0 0 2 0 Table
de_e_11001 0 0 22 0 Table
os_user_devices 0 6 4 0 Table
os_cpr_recs 7 48 32 0 Table
os_form_notif_user_grps 0 12 2 0 Table
os_form_notif_user_grps_aud 0 0 4 0 Table
os_print_rules_aud 0 0 17 0 Table
catissue_query_folder_queries 0 12 2 23 Table
os_shipments_aud 0 0 48 0 Table
catissue_site_cp 0 12 4 0 Table
catissue_form_record_entry 6 12 9 0 Table
os_participant_email_tmpls 0 18 13 0 Table
os_workflow_instance_params 0 6 3 0 Table
catissue_report_particip_rel 0 0 2 0 Table
os_data_backup_audit_logs 0 6 9 0 Table
os_container_transfer_events 6 36 19 0 Table
os_container_types_aud 0 0 27 19 Table
catissue_cp_req_specimen_aud 0 6 56 0 Table
catissue_site_cp_aud 0 6 9 0 Table
os_wf_lib_task_notif_groups 0 12 2 0 Table
os_auth_provider_props 0 6 3 0 Table
os_workflow_cps 0 12 2 0 Table
os_cp_group_cps 0 12 2 0 Table
os_cp_report_rcpts 0 12 2 0 Table
os_label_print_jobs 12 6 4 0 Table
catissue_query_audit_logs 0 12 10 0 Table
os_search_entity_keywords 0 0 6 8 Table
catissue_identified_report 0 18 3 0 Table
os_pv_props_aud 0 0 5 0 Table
cat_consent_tier_response_aud 0 6 10 0 Table
os_departments_aud 0 6 5 0 Table
rbac_roles_aud 0 0 8 0 Table
os_distribution_protocol_sites 0 18 4 0 Table
catissue_query_folders_aud 0 0 14 0 Table
os_pde_audit_logs 0 6 6 0 Table
os_surveys 6 12 33 0 Table
os_sched_cont_act_users 0 12 2 0 Table
os_visit_clin_diagnoses_aud 0 0 5 0 Table
os_container_activity_logs_aud 0 0 19 0 Table
catissue_container_position 0 18 3 0 Table
os_workflow_task_user_groups 0 12 2 0 Table
catissue_import_queries_log 0 0 5 23 Table
catissue_part_medical_id_aud 0 6 9 0 Table
dyextn_form_files 0 0 5 0 Table
os_cp_message_settings_aud 0 1 8 0 Table
dyextn_containers 24 0 9 23 Table
os_cp_catalog_settings 0 24 8 0 Table
os_participant_ethnicities 0 12 3 0 Table
os_cp_report_settings 6 12 7 0 Table
catissue_site_coordinators 0 12 2 0 Table
os_user_ui_states 0 6 2 0 Table
catissue_consent_tier_aud 0 6 11 0 Table
os_order_cust_fields 0 0 3 0 Table
os_shipment_containers_aud 0 0 10 0 Table
os_search_entity_ranks 0 0 3 12 Table
os_staged_part_ethnicities 0 12 3 0 Table
catissue_collection_protocol 240 18 52 0 Table
catissue_storage_container 30 12 6 0 Table
os_pooled_specimens 12 12 5 0 Table
catissue_report_filecontent 0 0 2 0 Table
os_specimen_type_units 0 30 6 4 Table
os_modules 6 0 3 9 Table
os_query_folder_queries_aud 0 0 4 7 Table
os_container_positions 0 30 16 0 Table
os_shipment_notify_users_aud 0 0 4 0 Table
os_specimen_requests_aud 0 1 39 0 Table
os_delete_spmn_events 0 12 6 0 Table
catissue_st_cont_coll_prot_rel 0 12 2 0 Table
os_user_group_users 0 12 2 0 Table
catissue_concept 0 0 4 0 Table
os_container_tasks_aud 0 0 9 0 Table
os_cp_allowed_dps_aud 0 1 4 0 Table
catissue_fluid_spe_event_param 0 12 6 0 Table
os_rev_entity_recs_tmp 0 0 5 0 Table
os_workflow_queue_items 0 18 6 0 Table
os_visit_extn_recs 0 0 3 0 Table
catissue_saved_queries 48 24 9 23 Table
catissue_container 18 0 7 0 Table
os_participant_ethnicities_aud 0 0 5 0 Table
os_label_print_file_items 0 12 5 0 Table
os_storage_containers 138 30 26 0 Table
os_cp_groups 18 0 4 0 Table
catissue_permissible_value_aud 0 0 16 88452 Table
catissue_fixed_event_param 0 18 8 0 Table
os_shipment_specimens 0 24 6 0 Table
os_wf_task_eff_user_groups 0 12 2 0 Table
catissue_permissible_value 364 12 8 91363 Table
os_stor_cont_spec_classes_aud 0 6 5 0 Table
catissue_coll_prot_reg 60 24 20 0 Table
os_orders 18 42 19 0 Table
os_container_activity_logs 0 24 9 0 Table
os_dist_invoices_aud 0 0 7 0 Table
os_spmn_cust_fields 0 0 3 0 Table
catissue_report_textcontent 0 12 2 0 Table
rbac_resources 12 0 2 15 Table
catissue_in_out_event_param 0 12 6 0 Table
catissue_pathology_report 30 6 6 0 Table
catissue_institution_aud 0 6 8 0 Table
os_cfg_props 12 6 7 167 Table
os_workflow_cps_aud 0 1 4 0 Table
os_upgrade_log 0 0 4 0 Table
os_stor_cont_comp_spec_types 0 12 3 0 Table
catissue_specimen_position 0 18 3 0 Table
os_delete_audit_logs 0 6 6 0 Table
os_revision_entities 0 6 2 0 Table
os_container_types 12 6 13 19 Table
os_saved_query_deps_aud 0 0 4 0 Table
catissue_transfer_event_param 0 12 18 0 Table
os_storage_containers_aud 0 6 55 0 Table
catissue_distribution_protocol 78 24 17 0 Table
os_staged_visits 6 6 15 0 Table
os_auto_freezer_provider_props 0 6 3 0 Table
os_workflow_task_notif_groups 0 12 2 0 Table
os_scheduled_jobs_notif_rcpts 0 12 2 0 Table
query_tags 12 6 3 0 Table
os_sched_job_shared_users_aud 0 0 4 0 Table
databasechangeloglock 0 0 4 0 Table
os_starred_items 0 0 4 0 Table
catissue_biohazard 6 0 5 0 Table
os_locks 0 0 4 0 Table
catissue_procedure_event_param 0 12 7 0 Table
os_label_print_job_items 0 6 13 0 Table
os_specimen_deposits 0 12 3 0 Table
catissue_base_shipment 0 24 11 0 Table
catissue_received_event_param 0 12 7 0 Table
os_stor_container_comp_dps 0 12 2 0 Table
catissue_coll_event_param 0 18 9 0 Table
catissue_stor_cont_spec_type 0 6 2 0 Table
catissue_specimen_hierarchy 0 12 2 0 Table
os_containers_hierarchy 0 12 2 0 Table
os_saved_query_deps 0 12 2 0 Table
os_wf_lib_task_notif_grps_aud 0 0 4 0 Table
catissue_quarantine_params 0 12 7 0 Table
rbac_roles 18 6 4 8 Table
catissue_tissue_req_specimen 0 6 1 0 Table
os_user_api_calls_log 0 18 9 25 Table
os_supply_shipment_items 0 8 2 0 Table
catissue_report_content 12 0 2 0 Table
os_stor_cont_spec_types_aud 0 6 5 0 Table
os_stor_container_cps_aud 0 6 4 0 Table
os_sms_provider_configs 12 12 8 0 Table
os_cp_group_form_notif_users 0 12 2 0 Table
catissue_form_context_aud 0 1 24 33 Table
os_published_cp_versions 6 0 2 0 Table
os_revisions 168 0 4 21 Table
rbac_permissions 0 12 3 0 Table
shared_specimenlist_tags 0 12 2 0 Table
os_specimen_biohazards_aud 0 6 5 0 Table
rbac_subject_roles_aud 0 1 13 0 Table
os_container_positions_aud 0 6 33 0 Table
os_workflow_task_inputs_aud 0 0 9 15 Table
os_container_store_lists 6 12 10 0 Table
os_cp_allowed_dps 0 12 2 0 Table
catissue_cde 6 0 5 29 Table
os_dist_invoices 6 6 3 0 Table
os_container_store_list_items 0 12 7 0 Table
key_seq_generator 0 0 4 0 Table
catissue_specimen_aud 0 6 66 0 Table
os_supply_locations 16 8 4 0 Table
catissue_box_scanner 0 0 3 0 Table
os_pde_notifs 6 12 5 0 Table
os_staged_part_medical_ids 0 6 4 0 Table
os_auth_tokens 4 12 4 0 Table
catissue_consent_tier 12 12 4 0 Table
os_auth_domains 6 6 4 1 Table
catissue_coll_prot_event_aud 0 6 25 0 Table
catissue_site_aud 0 6 19 0 Table
os_wf_libraries 6 12 7 1 Table
os_orders_aud 0 0 38 0 Table
os_specimen_kits_aud 0 1 17 0 Table
os_supply_type_notif_users 0 8 2 0 Table
os_supplies 8 28 17 0 Table
catissue_bulk_operation 0 0 5 0 Table
os_dq_query_comments 0 12 7 0 Table
os_cpr_extn_recs 0 1 3 0 Table
catissue_password 0 12 6 0 Table
os_supply_items 12 28 16 0 Table
os_consent_statements 12 0 4 0 Table
os_import_runner 0 0 2 0 Table
os_revision_entity_records 0 6 5 144 Table
catissue_spun_event_parameters 0 12 7 0 Table
catissue_specimen_event_param 0 12 6 0 Table
catissue_site_users 0 12 2 0 Table
os_dpr_pathology_statuses_aud 0 0 5 0 Table
os_form_data_entry_tokens 0 12 9 0 Table
os_wf_lib_task_user_groups 0 12 2 0 Table
os_supply_allowed_cps 0 8 2 0 Table
os_dp_consent_tiers_aud 0 0 9 0 Table
catissue_institution 42 0 3 0 Table
os_bulk_import_job_params 0 6 3 18 Table
os_spmn_external_ids 0 6 4 0 Table
catissue_deidentified_report 12 12 3 0 Table
catissue_clinical_diagnosis 0 6 3 0 Table
os_participant_cust_fields 0 0 4 0 Table
os_pde_notif_links 0 6 5 0 Table
shared_query_tags 0 12 2 0 Table
os_forgot_password_tokens 0 7 3 0 Table
os_stor_cont_comp_spec_classes 0 12 3 0 Table
os_cart_folder_carts 0 12 2 0 Table
os_participant_extn_recs 0 0 3 0 Table
os_workflow_task_deviations 0 30 8 0 Table
os_licenses 0 6 7 0 Table
catissue_thaw_event_parameters 0 12 6 0 Table
os_container_tasks 12 0 4 0 Table
catissue_coll_prot_reg_aud 0 6 32 0 Table
os_workflow_tasks_aud 0 0 40 20 Table
os_dist_services_aud 0 0 14 0 Table
catissue_coll_coordinators_aud 0 6 4 0 Table
catissue_site_coordinators_aud 0 6 4 0 Table
catissue_address 0 0 8 0 Table
catissue_external_identifier 0 6 4 0 Table
os_visit_clin_diagnoses 0 12 3 0 Table
os_dp_coordinators_aud 0 0 4 0 Table
catissue_participant 30 12 26 0 Table
os_query_folder_shared_groups 0 12 2 0 Table
rbac_role_access_list 6 12 3 68 Table
catissue_consent_tier_response 0 18 5 0 Table
rbac_role_access_list_ops 0 12 4 239 Table
os_workflow_labs 6 6 3 0 Table
catissue_race 0 12 3 0 Table
os_cp_group_forms 6 12 7 0 Table
os_cp_report_rcpts_aud 0 0 4 0 Table
os_published_cp_reviewers 0 12 2 0 Table
os_import_workflows_log 0 0 5 9 Table
os_scheduled_job_shared_users 0 12 2 0 Table
catissue_container_cps 0 6 2 0 Table
os_staged_visit_diagnoses 0 6 2 0 Table
cat_distribution_protocol_aud 0 0 36 0 Table
os_dist_invoice_items_aud 0 0 9 0 Table
os_scheduled_jobs 18 18 22 27 Table
rbac_role_access_list_aud 0 0 8 0 Table
os_wf_lib_tasks_aud 0 0 29 11 Table
os_departments 0 6 3 0 Table
catissue_specimen_biohz_rel 0 12 2 0 Table
os_workflow_instances 30 12 8 0 Table
os_wf_lab_user_groups 0 12 2 0 Table
query_tag_items 0 6 3 0 Table
os_cp_workflows_aud 0 1 6 0 Table
os_specimen_kits 6 24 8 0 Table
os_stor_cont_spec_classes 0 12 3 0 Table
os_cpr_anticipated_spmns 0 1 30 0 Table
os_locations_hierarchy 0 8 2 0 Table
os_stor_cont_spec_types 0 12 3 0 Table
os_child_spmn_events 6 12 6 0 Table
catissue_disposal_event_param 0 12 6 0 Table
os_auth_providers 12 0 3 0 Table
os_cpr_cust_fields 0 1 3 0 Table
cat_specimen_coll_group_aud 0 6 39 0 Table
os_dist_invoice_items 0 12 4 0 Table
os_wf_libraries_aud 0 0 16 0 Table
os_shipment_notify_users 0 12 2 0 Table
os_user_db_commands_log 0 6 6 0 Table
os_user_favorites 0 6 5 0 Table
os_dp_consent_tiers 0 12 4 0 Table
os_login_audit_logs 12 12 7 2 Table
catissue_stor_cont_spec_class 0 6 2 0 Table
os_ext_app_message_logs 0 0 11 0 Table
os_dq_audit_settings_aud 0 1 11 0 Table
os_wf_lib_tasks 18 6 13 11 Table
os_stor_container_dps 0 12 2 0 Table
os_workflow_labs_aud 0 0 8 0 Table
os_sms_provider_cfg_props 0 6 3 0 Table
os_workflow_notif_user_groups 0 12 2 0 Table
os_spmn_list_shared_grps_aud 0 0 4 0 Table
os_workflows_aud 0 0 33 8 Table
os_sched_cont_act_users_aud 0 0 4 0 Table
os_spmn_external_ids_aud 0 6 9 0 Table
os_staged_participants 24 12 16 0 Table
os_qc_errors_log 0 12 11 0 Table
os_cp_message_settings 0 18 3 0 Table
os_shipment_containers 6 18 5 0 Table
rbac_role_access_list_ops_aud 0 0 7 0 Table
catissue_report_queue 0 6 9 0 Table
os_supply_types 8 8 9 0 Table
catissue_tis_spe_event_param 0 18 11 0 Table
catissue_user_sites 0 12 2 0 Table
os_user_db_sessions 6 7 7 0 Table
catissue_part_medical_id 0 12 4 0 Table
catissue_site 176 24 12 0 Table
os_query_folder_users_aud 0 0 4 0 Table
os_workflows 36 12 14 8 Table
os_cont_transfer_evt_spmns 0 12 3 0 Table
os_participant_anon_events 0 12 4 0 Table
catissue_specimen 252 78 41 0 Table
databasechangelog 0 0 14 2490 Table
catissue_embedded_event_param 0 18 7 0 Table
os_cp_spmn_lbl_print_settings 0 6 5 0 Table
os_task_instance_out_items 0 36 8 0 Table
os_workflow_tasks 36 12 18 20 Table
os_stor_container_cps 0 12 2 0 Table
os_order_items_aud 0 0 31 0 Table
os_spmn_reserved_events 12 18 7 0 Table
os_shipment_specimens_aud 0 0 12 0 Table
os_pooled_specimen_items 0 12 2 0 Table
catissue_saved_queries_aud 0 1 15 23 Table
catissue_spec_tag_items 0 18 5 0 Table
catissue_report_section 0 0 6 0 Table
os_sms_provider_configs_aud 0 0 18 0 Table
os_order_items 0 24 15 0 Table
shared_specimenlist_tags_aud 0 0 4 0 Table
catissue_coll_coordinators 0 12 2 0 Table
os_wf_task_user_groups_aud 0 0 4 0 Table
os_specimen_list_shared_groups 0 12 2 0 Table
os_specimen_request_items 0 24 6 0 Table
dyextn_audit_events 0 0 9 0 Table
os_specimen_stats 0 0 12 0 Table
os_user_groups_aud 0 0 12 0 Table
catissue_participant_aud 0 6 42 0 Table
os_specimen_request_items_aud 0 0 13 0 Table
rbac_operations 12 0 2 7 Table
os_dq_queries 6 54 20 0 Table
catissue_coll_prot_event 34 24 16 0 Table
os_migrations 0 0 6 0 Table
catissue_user_cp 0 12 2 0 Table
catissue_race_aud 0 6 5 0 Table
os_cfg_settings_aud 0 0 13 12 Table
os_sched_cont_activities 12 12 12 0 Table
os_scheduled_jobs_aud 0 0 45 0 Table
os_spmn_extn_recs 0 0 3 0 Table
os_dist_services 6 12 7 0 Table
os_stor_container_comp_cps 0 12 2 0 Table
os_wf_task_instances_state 0 6 3 0 Table
os_bulk_import_jobs 6 6 18 9 Table
os_dp_coordinators 0 12 2 0 Table
catissue_review_params 0 12 7 0 Table
os_ext_app_id_props 0 6 3 0 Table
catissue_specimen_coll_group 66 48 35 0 Table
catissue_user_aud 0 6 51 0 Table
rbac_subject_roles 0 24 6 0 Table
catissue_consent_tier_status 0 6 5 0 Table
catissue_user 786 24 30 2 Table
catissue_mol_spe_review_param 0 12 12 0 Table
os_user_login_otps 0 6 5 0 Table
os_wf_notif_user_groups_aud 0 0 4 0 Table
os_visit_cust_fields 0 0 3 0 Table
catissue_spec_tag_items_aud 0 0 11 0 Table
catissue_specimenlist_tags_aud 0 0 21 0 Table
os_cp_report_settings_aud 0 1 16 0 Table
os_pvs_hierarchy 0 12 2 87904 Table
os_mobile_upload_jobs 0 12 8 0 Table
dyextn_containers_aud 0 0 11 21 Table
os_pv_props 0 6 3 61 Table
os_scheduled_job_runs 0 6 9 382 Table
catissue_abstract_position 12 0 5 0 Table
os_spmn_distributions_view 0 0 18 0 View
user_view 0 0 8 0 View
os_container_ancestors_view 0 0 2 0 View
os_specimen_positions_view 0 0 13 0 View
cp_coord_view 0 1 9 0 View
os_starred_cps_view 0 1 2 0 View
os_pooled_specimen_items_view 0 0 5 0 View
os_cpr_spmn_stats_view 0 0 5 0 View
os_specimen_shipments_view 0 0 24 0 View
os_spmn_resv_cancel_view 0 0 5 0 View
os_specimen_resv_view 0 0 4 0 View
os_checked_out_specimens_view 0 0 16 0 View
os_container_hierarchy_view 0 0 2 0 View
os_specimen_distribution_view 0 0 15 0 View
os_cpr_extn_recs_view 0 1 3 0 View
consent_tier_view 0 1 5 0 View
rbac_subject_access_view 0 1 6 0 View
os_cpr_cust_fields_view 0 1 3 0 View
os_spmn_reservations_view 0 0 5 0 View
os_cpr_visit_stats_view 0 0 5 0 View
specimen_shipments_view 0 0 12 0 View
specimen_biohazard_view 0 0 4 0 View
cpr_view 0 2 28 0 View
os_cont_traf_spmn_events_view 0 0 20 0 View
os_specimen_requests_view 0 0 10 0 View
os_task_deviation_events_view 0 0 9 0 View
os_spmn_coll_recv_details_view 0 0 12 0 View
os_ancestor_spmn_reqs_view 0 0 4 0 View
os_storage_cont_stats_view 0 0 3 0 View
os_specimen_carts_view 0 0 3 0 View
os_visit_cd_view 0 0 4 0 View
part_med_rec_view 0 0 4 0 View