Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg120+2)
Schema results
The tables in the results data model are grouped using a unique prefix for each Strategus module. For example, the CharacterizationModule results tables all start with “c_”.
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| c_analysis_ref | 0 | 0 | 9 | 0 | Table | CharacterizationModule: Analysis reference |
| c_cohort_counts | 0 | 0 | 15 | 0 | Table | CharacterizationModule: Cohort counts |
| c_cohort_details | 3 | 2 | 5 | 0 | Table | CharacterizationModule: Cohort details |
| c_covariate_ref | 6 | 0 | 8 | 0 | Table | CharacterizationModule: Covariate reference |
| c_covariates | 0 | 7 | 9 | 0 | Table | CharacterizationModule: Binary covariates |
| c_covariates_continuous | 0 | 6 | 16 | 0 | Table | CharacterizationModule: Continuous covariates |
| c_dechallenge_rechallenge | 0 | 3 | 20 | 0 | Table | CharacterizationModule: Dechallenge rechallenge |
| c_rechallenge_fail_case_series | 0 | 0 | 17 | 0 | Table | CharacterizationModule: Rechallenge fail case series |
| c_settings | 6 | 3 | 12 | 0 | Table | CharacterizationModule: Settings |
| c_time_to_event | 0 | 1 | 8 | 0 | Table | CharacterizationModule: Time to event |
| cd_cohort | 0 | 0 | 8 | 0 | Table | CohortDiagnosticsModule: Cohort details |
| cd_cohort_count | 2 | 1 | 4 | 0 | Table | CohortDiagnosticsModule: Cohort counts |
| cd_cohort_inc_result | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Cohort inclusion results |
| cd_cohort_inc_stats | 0 | 0 | 7 | 0 | Table | CohortDiagnosticsModule: Cohort inclusion statstics |
| cd_cohort_inclusion | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Cohort inclusion info |
| cd_cohort_relationships | 0 | 0 | 26 | 0 | Table | CohortDiagnosticsModule: Cohort relationships |
| cd_cohort_summary_stats | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Cohort summary stats |
| cd_concept | 3 | 0 | 10 | 0 | Table | CohortDiagnosticsModule: Concept lookup table |
| cd_concept_ancestor | 0 | 0 | 4 | 0 | Table | CohortDiagnosticsModule: Concept ancestor |
| cd_concept_relationship | 0 | 0 | 6 | 0 | Table | CohortDiagnosticsModule: Concept Relationship |
| cd_concept_sets | 2 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Concept sets |
| cd_concept_synonym | 0 | 0 | 3 | 0 | Table | CohortDiagnosticsModule: Concept synonym |
| cd_database | 0 | 0 | 6 | 0 | Table | CohortDiagnosticsModule: CDM database information for Cohort Diagnostics |
| cd_domain | 0 | 0 | 3 | 0 | Table | CohortDiagnosticsModule: Domain from the vocabulary |
| cd_incidence_rate | 0 | 2 | 8 | 0 | Table | CohortDiagnosticsModule: Incidence rate for Cohort Diagnostics |
| cd_included_source_concept | 0 | 1 | 7 | 0 | Table | CohortDiagnosticsModule: Included source concepts |
| cd_index_event_breakdown | 0 | 1 | 7 | 0 | Table | CohortDiagnosticsModule: Index event breakdown |
| cd_metadata | 0 | 0 | 4 | 0 | Table | CohortDiagnosticsModule: Metadata for the database and runtime environment used for Cohort Diagnostics |
| cd_orphan_concept | 0 | 3 | 6 | 0 | Table | CohortDiagnosticsModule: Orphan concept list |
| cd_relationship | 0 | 0 | 6 | 0 | Table | CohortDiagnosticsModule: Relationships |
| cd_resolved_concepts | 0 | 0 | 4 | 0 | Table | CohortDiagnosticsModule: Resolved concepts |
| cd_subset_definition | 0 | 0 | 2 | 0 | Table | CohortDiagnosticsModule: Cohort subset definition |
| cd_temporal_analysis_ref | 1 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Temporal analysis reference |
| cd_temporal_covariate_ref | 0 | 2 | 4 | 0 | Table | CohortDiagnosticsModule: Covariate reference |
| cd_temporal_covariate_value | 1 | 0 | 7 | 0 | Table | CohortDiagnosticsModule: Binary covariate values |
| cd_temporal_covariate_value_dist | 0 | 0 | 14 | 0 | Table | CohortDiagnosticsModule: Continuous covariate values |
| cd_temporal_time_ref | 0 | 0 | 3 | 0 | Table | CohortDiagnosticsModule: Temporal time reference |
| cd_time_series | 0 | 0 | 18 | 0 | Table | CohortDiagnosticsModule: Time series information |
| cd_visit_context | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Visit context |
| cd_vocabulary | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Vocabulary information |
| cg_cohort_censor_stats | 0 | 0 | 3 | 0 | Table | CohortGeneratorModule: Cohort censor statistics |
| cg_cohort_count | 0 | 2 | 4 | 0 | Table | CohortGeneratorModule: Cohort counts |
| cg_cohort_count_neg_ctrl | 0 | 0 | 4 | 0 | Table | CohortGeneratorModule: Negative control outcome cohort counts |
| cg_cohort_definition | 15 | 0 | 8 | 0 | Table | CohortGeneratorModule: Cohort definitions |
| cg_cohort_definition_neg_ctrl | 0 | 0 | 5 | 0 | Table | CohortGeneratorModule: Negative control outcome cohort definitions |
| cg_cohort_generation | 0 | 1 | 6 | 0 | Table | CohortGeneratorModule: Cohort generation times |
| cg_cohort_inc_result | 0 | 1 | 5 | 0 | Table | CohortGeneratorModule: Cohort inclusion results |
| cg_cohort_inc_stats | 0 | 0 | 7 | 0 | Table | CohortGeneratorModule: Cohort inclusion statistics |
| cg_cohort_inclusion | 0 | 1 | 4 | 0 | Table | CohortGeneratorModule: Cohort inclusion information |
| cg_cohort_subset_definition | 0 | 0 | 2 | 0 | Table | CohortGeneratorModule: Cohort subset definitions |