Skip to content

ACUITY DB acuity schema tables

Kantemir Tvorogov edited this page Aug 9, 2023 · 1 revision

All useful tables of acuity DB schema except result and mapping tables and tables managed by third party libraries (for them, there are special pages) are listed here.

Cohort editor saved filters

  • saved_filter
  • saved_filter_dataset
  • saved_filter_instance
  • saved_filter_permission

Logging data

These tables are used by audit-logger module of VASecurity.

  • log_arg
  • log_operation

Reports data

These data are written by different reporting services in AdminUI as reports about performed job.

  • report_data_alert
  • report_data_field
  • report_data_summary
  • report_data_table
  • report_data_value
  • report_exceptions

Audit data

  • map_audit - table for AdminUI audit data

Util data

Static data mostly used by VAHub for result data presentation.

  • util_country_code_lookup
  • util_ctcg_lookup
  • util_deployment_env_props
  • util_ecg_evaluation_lookup
  • util_ecg_significant_lookup
  • util_email_details
  • util_labcode_dictionary
  • util_labcode_lookup
  • util_labcode_synonym
  • util_labctcg_lookup
  • util_mutation_type_dictionary
  • util_mutation_type_synonym
  • util_recist_response_lookup
Clone this wiki locally