Tables


SchemaSpy Analysis of openspecimen_demo

Generated on Wed Nov 16 13:04 IST 2022

XML Representation
Insertion Order Deletion Order
TABLES 376
VIEWS 31
COLUMNS 3479
Constraints 492
Anomalies 97
Routines 19

Database Properties

Database Type: MySQL - 8.0.27

Tables

Table / View Children Parents Columns Rows Type Comments
os_kit_specimens 0 4 2 0 Table
os_specimen_cart_folders 4 2 6 0 Table
os_cfg_settings 0 4 6 184 Table
os_dp_requirements 2 8 13 0 Table
catissue_procedure_event_param 0 4 7 0 Table
os_label_print_job_items 0 2 10 0 Table
os_specimen_deposits 0 4 3 0 Table
catissue_base_shipment 0 8 11 0 Table
os_consent_statements_aud 0 0 9 0 Table
os_specimen_requests 6 10 18 0 Table
catissue_received_event_param 0 4 7 0 Table
os_stor_container_comp_dps 0 4 2 0 Table
dyextn_id_seq 0 0 2 3 Table
os_dashboard_view_params 0 2 3 5 Table
os_dist_protocol_sites_aud 0 0 9 0 Table
catissue_coll_event_param 0 6 9 0 Table
catissue_stor_cont_spec_type 0 2 2 0 Table
os_shipments 8 10 17 0 Table
os_unhandled_exceptions 0 2 8 0 Table
catissue_st_cont_st_type_rel 0 2 2 0 Table
catissue_specimen_hierarchy 0 4 2 0 Table
os_dashlets_aud 0 0 9 0 Table
os_user_otp_details 0 3 7 0 Table
os_cart_folder_user_groups_aud 0 0 4 0 Table
os_containers_hierarchy 0 4 2 0 Table
cat_stor_cont_spec_types 0 0 2 0 Table
catissue_cp_req_specimen 8 24 36 0 Table
os_saved_query_deps 0 4 2 0 Table
os_auth_credentials 0 1 2 0 Table
os_published_cp_events 2 6 7 0 Table
catissue_frozen_event_param 0 6 8 0 Table
os_sched_jobs_notif_rcpts_aud 0 0 4 0 Table
os_cart_folder_user_groups 0 4 2 0 Table
os_export_jobs 2 2 7 0 Table
catissue_quarantine_params 0 4 7 0 Table
catissue_cell_spe_review_param 0 4 7 0 Table
rbac_roles 6 2 4 8 Table
catissue_tissue_req_specimen 0 2 1 0 Table
os_user_api_calls_log 0 6 9 0 Table
catissue_coll_distribution_rel 0 4 2 0 Table
catissue_report_content 4 0 2 0 Table
os_stor_cont_spec_types_aud 0 2 5 0 Table
os_stor_container_cps_aud 0 2 4 0 Table
catissue_cp_site_roles 0 4 4 0 Table
os_cart_folder_carts_aud 0 0 4 0 Table
os_cp_group_form_notif_users 0 4 2 0 Table
cat_collection_protocol_aud 0 2 88 0 Table
catissue_form_context_aud 0 1 24 34 Table
os_export_job_params 0 2 3 0 Table
os_published_cp_versions 2 0 2 0 Table
os_revisions 56 0 4 12 Table
rbac_permissions 0 4 3 0 Table
shared_specimenlist_tags 0 4 2 0 Table
os_specimen_biohazards_aud 0 2 5 0 Table
rbac_subject_roles_aud 0 1 13 0 Table
os_container_positions_aud 0 2 23 0 Table
os_import_forms_log 0 0 4 34 Table
os_container_store_lists 2 4 10 0 Table
os_dp_requirements_aud 0 0 25 0 Table
os_auto_freezer_providers 4 0 3 0 Table
os_cp_allowed_dps 0 4 2 0 Table
os_spmn_lbl_print_settings_aud 0 1 11 0 Table
catissue_cde 2 0 5 29 Table
catissue_query_folders 6 2 4 0 Table
os_cfg_prop_allowed_values 0 2 2 0 Table
os_user_group_users_aud 0 0 4 0 Table
catissue_qfolder_share_setting 0 4 2 0 Table
os_dist_invoices 2 2 3 0 Table
os_container_store_list_items 0 4 6 0 Table
key_seq_generator 0 0 4 0 Table
catissue_specimen_aud 0 2 63 0 Table
catissue_report_xmlcontent 0 4 2 0 Table
catissue_box_scanner 0 0 3 0 Table
os_cp_cust_fields 0 1 3 0 Table
os_user_notifications 0 4 5 0 Table
os_pde_notifs 2 4 5 0 Table
os_staged_part_medical_ids 0 2 4 0 Table
os_auth_tokens 4 4 4 0 Table
catissue_consent_tier 4 4 4 0 Table
os_auth_domains 2 2 4 1 Table
os_query_folder_user_grps_aud 0 0 4 0 Table
catissue_coll_prot_event_aud 0 2 25 0 Table
catissue_site_aud 0 2 19 0 Table
os_orders_aud 0 0 36 0 Table
os_cp_workflows 15 2 2 0 Table
os_dpr_pathology_statuses 0 4 3 0 Table
os_specimen_kits_aud 0 1 17 0 Table
catissue_specimenlist_tags 14 2 7 0 Table
catissue_bulk_operation 0 0 5 0 Table
os_print_rules 0 4 8 1 Table
catissue_form_context 10 3 11 31 Table
os_cpr_extn_recs 0 0 3 0 Table
os_external_app_ids 2 0 5 0 Table
os_user_groups 14 2 5 0 Table
catissue_password 0 4 6 0 Table
os_specimen_slide_event_recs 0 2 2 0 Table
os_consent_statements 4 0 4 0 Table
os_import_runner 0 0 2 1 Table
os_sched_cont_activities_aud 0 0 24 0 Table
os_revision_entity_records 0 2 5 92 Table
catissue_spun_event_parameters 0 4 7 0 Table
catissue_specimen_event_param 0 4 6 0 Table
os_staged_participant_races 0 4 3 0 Table
os_stor_container_dps_aud 0 2 4 0 Table
catissue_site_users 0 4 2 0 Table
os_dashlet_configs 2 0 8 15 Table
os_dpr_pathology_statuses_aud 0 0 5 0 Table
os_dashboards_aud 0 0 11 0 Table
os_form_data_entry_tokens 0 4 9 0 Table
catissue_distri_event_param 0 4 9 0 Table
os_specimen_cart_folders_aud 0 0 15 0 Table
catissue_distribution_spec_req 0 2 7 0 Table
os_dp_consent_tiers_aud 0 0 9 0 Table
os_notifications 2 2 7 0 Table
catissue_institution 14 0 3 0 Table
os_bulk_import_job_params 0 2 3 0 Table
os_spmn_external_ids 0 2 4 0 Table
catissue_deidentified_report 4 4 3 0 Table
de_e_11004 0 0 6 0 Table
de_e_11003 0 0 2 0 Table
os_specimen_biohazards 0 4 3 0 Table
catissue_clinical_diagnosis 0 2 3 0 Table
de_e_11002 0 0 2 0 Table
de_e_11001 0 0 22 0 Table
os_participant_cust_fields 0 0 4 0 Table
os_user_devices 0 2 4 0 Table
os_form_notif_user_grps 0 4 2 0 Table
os_form_notif_user_grps_aud 0 0 4 0 Table
os_pde_notif_links 0 2 5 0 Table
shared_query_tags 0 4 2 0 Table
os_print_rules_aud 0 0 17 1 Table
catissue_query_folder_queries 0 4 2 23 Table
os_forgot_password_tokens 0 3 3 0 Table
os_stor_cont_comp_spec_classes 0 4 3 0 Table
os_cart_folder_carts 0 4 2 0 Table
os_participant_extn_recs 0 0 3 0 Table
os_shipments_aud 0 0 38 0 Table
catissue_thaw_event_parameters 0 4 6 0 Table
os_container_tasks 4 0 4 0 Table
os_sc_spmn_requests 0 0 7 0 Table
catissue_coll_prot_reg_aud 0 2 30 0 Table
os_dist_services_aud 0 0 14 0 Table
os_specimen_arrays_aud 0 0 37 0 Table
catissue_site_cp 0 4 4 0 Table
catissue_coll_coordinators_aud 0 2 4 0 Table
catissue_site_coordinators_aud 0 2 4 0 Table
catissue_address 0 0 8 0 Table
catissue_external_identifier 0 2 4 0 Table
os_visit_clin_diagnoses 0 4 3 0 Table
catissue_form_record_entry 0 4 7 0 Table
os_dp_coordinators_aud 0 0 4 0 Table
catissue_participant 8 4 22 0 Table
os_query_folder_shared_groups 0 4 2 0 Table
rbac_role_access_list 2 4 3 76 Table
os_specimen_slide_cores_aud 0 0 4 0 Table
catissue_report_particip_rel 0 0 2 0 Table
os_data_backup_audit_logs 0 2 9 0 Table
os_container_transfer_events 2 12 19 0 Table
catissue_consent_tier_response 0 6 5 0 Table
os_container_types_aud 0 0 27 19 Table
rbac_role_access_list_ops 0 4 4 256 Table
catissue_cp_req_specimen_aud 0 2 52 0 Table
os_specimen_catalogs 6 8 16 1 Table
catissue_race 0 4 3 0 Table
os_cp_group_forms 2 4 7 0 Table
catissue_site_cp_aud 0 2 9 0 Table
os_cp_report_rcpts_aud 0 0 4 0 Table
os_published_cp_reviewers 0 4 2 0 Table
os_auth_provider_props 0 2 3 0 Table
os_specimen_array_cores_aud 0 0 16 0 Table
os_scheduled_job_shared_users 0 4 2 0 Table
os_cp_group_cps 0 4 2 0 Table
os_cp_report_rcpts 0 4 2 0 Table
catissue_container_cps 0 2 2 0 Table
os_staged_visit_diagnoses 0 2 2 0 Table
cat_distribution_protocol_aud 0 0 36 0 Table
os_dist_invoice_items_aud 0 0 9 0 Table
os_label_print_jobs 4 2 4 0 Table
catissue_query_audit_logs 0 4 10 20 Table
os_scheduled_jobs 6 6 22 21 Table
os_search_entity_keywords 0 0 6 8 Table
rbac_role_access_list_aud 0 0 8 0 Table
catissue_identified_report 0 6 3 0 Table
os_departments 0 2 3 0 Table
os_pv_props_aud 0 0 5 0 Table
cat_consent_tier_response_aud 0 2 10 0 Table
catissue_specimen_biohz_rel 0 4 2 0 Table
os_departments_aud 0 2 5 0 Table
rbac_roles_aud 0 0 8 0 Table
query_tag_items 0 2 3 0 Table
os_cp_workflows_aud 0 1 6 0 Table
os_distribution_protocol_sites 0 6 4 0 Table
os_specimen_kits 2 8 8 0 Table
catissue_query_folders_aud 0 0 12 2 Table
os_stor_cont_spec_classes 0 4 3 0 Table
os_dashlet_configs_aud 0 0 17 0 Table
os_pde_audit_logs 0 2 6 0 Table
os_cpr_anticipated_spmns 0 0 30 0 Table
os_stor_cont_spec_types 0 4 3 0 Table
os_child_spmn_events 2 4 6 0 Table
os_catalog_user_groups 0 4 2 0 Table
os_sched_cont_act_users 0 4 2 0 Table
os_visit_clin_diagnoses_aud 0 0 5 0 Table
catissue_disposal_event_param 0 4 6 0 Table
os_container_activity_logs_aud 0 0 19 0 Table
os_specimen_array_cores 2 4 7 0 Table
os_auth_providers 4 0 3 0 Table
catissue_container_position 0 6 3 0 Table
cat_specimen_coll_group_aud 0 2 39 0 Table
os_dist_invoice_items 0 4 4 0 Table
os_shipment_notify_users 0 4 2 0 Table
catissue_import_queries_log 0 0 5 23 Table
os_user_db_commands_log 0 2 6 0 Table
catissue_part_medical_id_aud 0 2 9 0 Table
dyextn_containers 8 0 9 24 Table
os_specimen_array_events 2 8 8 0 Table
os_specimen_gel_items_aud 0 0 9 0 Table
os_cp_catalog_settings 0 8 8 0 Table
os_specimen_arrays 4 6 18 0 Table
os_dp_consent_tiers 0 4 4 0 Table
os_participant_ethnicities 0 4 3 0 Table
os_cp_report_settings 2 4 7 0 Table
catissue_site_coordinators 0 4 2 0 Table
os_user_ui_states 0 2 2 0 Table
os_login_audit_logs 4 2 6 0 Table
catissue_consent_tier_aud 0 2 11 0 Table
catissue_stor_cont_spec_class 0 2 2 0 Table
os_specimen_slide_events 2 8 8 0 Table
os_dashboards 4 2 4 4 Table
os_ext_app_message_logs 0 0 11 0 Table
os_order_cust_fields 0 0 3 0 Table
os_search_entity_ranks 0 0 3 12 Table
os_shipment_containers_aud 0 0 10 0 Table
os_staged_part_ethnicities 0 4 3 0 Table
os_stor_container_dps 0 4 2 0 Table
catissue_collection_protocol 56 2 46 0 Table
os_specimen_slide_cores 0 4 2 0 Table
catissue_storage_container 10 4 6 0 Table
os_spmn_list_shared_grps_aud 0 0 4 0 Table
os_pooled_specimens 4 4 5 0 Table
os_sched_cont_act_users_aud 0 0 4 0 Table
os_specimen_array_event_recs 0 2 2 0 Table
catissue_report_filecontent 0 0 2 0 Table
os_dashboard_view_params_aud 0 0 6 0 Table
os_spmn_external_ids_aud 0 2 9 0 Table
os_modules 2 0 3 9 Table
os_query_folder_queries_aud 0 0 4 7 Table
os_container_positions 0 6 11 0 Table
os_shipment_notify_users_aud 0 0 4 0 Table
os_catalog_req_managers 0 4 2 1 Table
os_specimen_requests_aud 0 1 39 0 Table
os_staged_participants 8 4 16 0 Table
os_catalog_user_groups_aud 0 0 4 0 Table
os_delete_spmn_events 0 4 6 0 Table
os_shipment_containers 2 6 5 0 Table
rbac_role_access_list_ops_aud 0 0 7 0 Table
catissue_report_queue 0 2 9 0 Table
catissue_tis_spe_event_param 0 6 11 0 Table
catissue_user_sites 0 4 2 0 Table
os_user_db_sessions 2 3 7 0 Table
catissue_part_medical_id 0 4 4 0 Table
catissue_site 52 8 12 0 Table
catissue_st_cont_coll_prot_rel 0 4 2 0 Table
os_catalog_resources_aud 0 0 11 0 Table
os_query_folder_users_aud 0 0 4 0 Table
os_cont_transfer_evt_spmns 0 4 3 0 Table
os_participant_anon_events 0 4 4 0 Table
os_specimen_array_slides 4 0 4 0 Table
os_user_group_users 0 4 2 0 Table
catissue_concept 0 0 4 0 Table
os_container_tasks_aud 0 0 9 0 Table
catissue_specimen 76 26 40 0 Table
os_cp_allowed_dps_aud 0 1 4 0 Table
catissue_fluid_spe_event_param 0 4 6 0 Table
databasechangelog 0 0 14 2260 Table
os_rev_entity_recs_tmp 0 0 5 0 Table
catissue_embedded_event_param 0 6 7 0 Table
os_cp_spmn_lbl_print_settings 0 2 5 0 Table
os_visit_extn_recs 0 0 3 0 Table
catissue_saved_queries 20 8 9 23 Table
catissue_container 6 0 7 0 Table
os_stor_container_cps 0 4 2 0 Table
os_participant_ethnicities_aud 0 0 5 0 Table
os_label_print_file_items 0 4 5 0 Table
os_storage_containers 44 10 25 0 Table
os_order_items_aud 0 0 31 0 Table
os_spmn_reserved_events 4 6 7 0 Table
os_catalog_req_managers_aud 0 0 4 1 Table
os_cp_groups 6 0 4 0 Table
catissue_permissible_value_aud 0 0 16 90340 Table
os_dashlets 0 4 4 31 Table
catissue_fixed_event_param 0 6 8 0 Table
os_shipment_specimens_aud 0 0 12 0 Table
os_shipment_specimens 0 8 6 0 Table
os_pooled_specimen_items 0 4 2 0 Table
catissue_saved_queries_aud 0 1 15 23 Table
catissue_permissible_value 106 4 8 88392 Table
catissue_spec_tag_items 0 4 3 0 Table
catissue_report_section 0 0 6 0 Table
os_stor_cont_spec_classes_aud 0 2 5 0 Table
catissue_coll_prot_reg 8 8 19 0 Table
os_orders 6 14 18 0 Table
os_order_items 0 8 15 0 Table
os_container_activity_logs 0 8 9 0 Table
shared_specimenlist_tags_aud 0 0 4 0 Table
catissue_coll_coordinators 0 4 2 0 Table
os_specimen_list_shared_groups 0 4 2 0 Table
os_specimen_request_items 0 8 6 0 Table
dyextn_audit_events 0 0 9 0 Table
os_specimen_stats 0 0 12 0 Table
os_dist_invoices_aud 0 0 7 0 Table
os_specimen_gels 2 2 6 0 Table
os_spmn_cust_fields 0 0 3 0 Table
catissue_report_textcontent 0 4 2 0 Table
os_user_groups_aud 0 0 12 0 Table
rbac_resources 4 0 2 17 Table
catissue_in_out_event_param 0 4 6 0 Table
catissue_participant_aud 0 2 34 0 Table
os_specimen_request_items_aud 0 0 13 0 Table
rbac_operations 4 0 2 7 Table
os_specimen_gels_aud 0 0 14 0 Table
catissue_coll_prot_event 4 8 16 0 Table
catissue_pathology_report 10 2 6 0 Table
catissue_institution_aud 0 2 8 0 Table
os_migrations 0 0 6 0 Table
os_cfg_props 4 2 7 176 Table
catissue_user_cp 0 4 2 0 Table
os_upgrade_log 0 0 4 1 Table
catissue_race_aud 0 2 5 0 Table
os_cfg_settings_aud 0 0 13 12 Table
os_catalog_resources 0 2 4 0 Table
os_stor_cont_comp_spec_types 0 4 3 0 Table
os_sched_cont_activities 4 4 11 0 Table
os_scheduled_jobs_aud 0 0 45 0 Table
catissue_specimen_position 0 6 3 0 Table
os_spmn_extn_recs 0 0 3 0 Table
os_dist_services 2 4 7 0 Table
os_specimen_array_slides_aud 0 0 10 0 Table
os_stor_container_comp_cps 0 4 2 0 Table
os_bulk_import_jobs 2 2 17 0 Table
os_delete_audit_logs 0 2 6 0 Table
os_dp_coordinators 0 4 2 0 Table
catissue_review_params 0 4 7 0 Table
os_ext_app_id_props 0 2 3 0 Table
os_revision_entities 0 2 2 0 Table
catissue_specimen_coll_group 12 16 35 0 Table
catissue_user_aud 0 2 49 0 Table
os_container_types 4 2 13 19 Table
os_specimen_gel_items 0 4 4 0 Table
rbac_subject_roles 0 8 6 2 Table
catissue_consent_tier_status 0 2 5 0 Table
catissue_user 218 8 29 3 Table
os_saved_query_deps_aud 0 0 4 0 Table
catissue_mol_spe_review_param 0 4 12 0 Table
catissue_transfer_event_param 0 4 17 0 Table
os_visit_cust_fields 0 0 3 0 Table
catissue_specimenlist_tags_aud 0 0 19 0 Table
catissue_spec_tag_items_aud 0 0 7 0 Table
os_cp_report_settings_aud 0 1 16 0 Table
os_storage_containers_aud 0 2 52 0 Table
os_pvs_hierarchy 0 4 2 10423 Table
catissue_distribution_protocol 26 8 17 0 Table
os_staged_visits 2 2 15 0 Table
os_auto_freezer_provider_props 0 2 3 0 Table
os_mobile_upload_jobs 0 4 8 0 Table
dyextn_containers_aud 0 0 10 25 Table
os_scheduled_jobs_notif_rcpts 0 4 2 0 Table
query_tags 4 2 3 0 Table
os_sched_job_shared_users_aud 0 0 4 0 Table
os_specimen_catalogs_aud 0 0 35 1 Table
databasechangeloglock 0 0 4 1 Table
os_pv_props 0 2 3 65 Table
os_starred_items 0 0 4 0 Table
catissue_biohazard 2 0 5 0 Table
os_scheduled_job_runs 0 2 9 0 Table
catissue_abstract_position 4 0 5 0 Table
os_spmn_distributions_view 0 0 18 0 View
user_view 0 0 8 0 View
os_specimen_array_cores_view 0 0 8 0 View
os_container_ancestors_view 0 0 2 0 View
os_specimen_positions_view 0 0 9 0 View
cp_coord_view 0 1 9 0 View
os_spmn_gel_view 0 0 6 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 18 0 View
os_spmn_resv_cancel_view 0 0 5 0 View
os_specimen_resv_view 0 0 4 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 0 3 0 View
consent_tier_view 0 0 5 0 View
rbac_subject_access_view 0 1 6 0 View
os_cpr_cust_fields_view 0 0 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 1 28 0 View
os_cont_traf_spmn_events_view 0 0 20 0 View
os_specimen_requests_view 0 0 10 0 View
os_spmn_coll_recv_details_view 0 0 12 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