Database Properties
Database Type: PostgreSQL - 17.0 (Debian 17.0-1.pgdg120+1)
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_covariates_continuous | 0 | 6 | 16 | 0 | Table | CharacterizationModule: Continuous covariates |
sccs_covariate | 13 | 0 | 7 | 0 | Table | SelfControlledCaseSeriesModule: Covariate reference |
cd_temporal_analysis_ref | 1 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Temporal analysis reference |
sccs_covariate_analysis | 0 | 0 | 4 | 0 | Table | SelfControlledCaseSeriesModule: Covariate analysis |
cd_resolved_concepts | 0 | 0 | 4 | 0 | Table | CohortDiagnosticsModule: Resolved concepts |
cd_concept_relationship | 0 | 0 | 6 | 0 | Table | CohortDiagnosticsModule: Concept Relationship |
plp_diagnostic_participants | 0 | 0 | 5 | 0 | Table | PatientLevelPredictionModule: Diagnostic participants |
cd_index_event_breakdown | 0 | 1 | 7 | 0 | Table | CohortDiagnosticsModule: Index event breakdown |
plp_diagnostic_summary | 1 | 0 | 3 | 0 | Table | PatientLevelPredictionModule: Diagnostic summary |
cd_visit_context | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Visit context |
c_rechallenge_fail_case_series | 0 | 0 | 17 | 0 | Table | CharacterizationModule: Rechallenge fail case series |
cm_covariate_analysis | 1 | 0 | 3 | 0 | Table | CohortMethodModule: Covariate analysis reference |
plp_calibration_summary | 0 | 0 | 13 | 0 | Table | PatientLevelPredictionModule: Calibration summary |
ci_incidence_summary | 0 | 10 | 21 | 0 | Table | CohortIncidenceModule: Incidence rate/proportion summary |
cd_concept | 3 | 0 | 10 | 0 | Table | CohortDiagnosticsModule: Concept lookup table |
cm_kaplan_meier_dist | 0 | 0 | 14 | 0 | Table | CohortMethodModule: Kaplan Meier distribution |
plp_covariate_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: Covariate settings |
ci_tar_def | 2 | 0 | 6 | 0 | Table | CohortIncidenceModule: Time-at-risk definitions |
sccs_event_dep_observation | 0 | 1 | 6 | 0 | Table | SelfControlledCaseSeriesModule: Event-dependent observation diagnostic |
es_analysis | 0 | 0 | 4 | 0 | Table | EvidenceSynthesisModule: Analysis reference |
cg_cohort_count | 0 | 2 | 4 | 0 | Table | CohortGeneratorModule: Cohort counts |
cg_cohort_generation | 0 | 1 | 6 | 0 | Table | CohortGeneratorModule: Cohort generation times |
cd_cohort_count | 2 | 1 | 4 | 0 | Table | CohortDiagnosticsModule: Cohort counts |
cg_cohort_censor_stats | 0 | 0 | 3 | 0 | Table | CohortGeneratorModule: Cohort censor statistics |
cg_cohort_count_neg_ctrl | 0 | 0 | 4 | 0 | Table | CohortGeneratorModule: Negative control outcome cohort counts |
cd_temporal_covariate_value | 1 | 0 | 7 | 0 | Table | CohortDiagnosticsModule: Binary covariate values |
cd_relationship | 0 | 0 | 6 | 0 | Table | CohortDiagnosticsModule: Relationships |
c_dechallenge_rechallenge | 0 | 3 | 20 | 0 | Table | CharacterizationModule: Dechallenge rechallenge |
cg_cohort_definition | 17 | 0 | 8 | 0 | Table | CohortGeneratorModule: Cohort definitions |
plp_prediction_distribution | 0 | 0 | 13 | 0 | Table | PatientLevelPredictionModule: Prediction distribution |
sccs_diagnostics_summary | 4 | 8 | 14 | 0 | Table | SelfControlledCaseSeriesModule: Diagnostic summary |
c_cohort_counts | 0 | 0 | 15 | 0 | Table | CharacterizationModule: Cohort counts |
plp_model_settings | 0 | 0 | 3 | 0 | Table | PatientLevelPredictionModule: Model settings |
cd_concept_synonym | 0 | 0 | 3 | 0 | Table | CohortDiagnosticsModule: Concept synonym |
sccs_age_spanning | 0 | 1 | 5 | 0 | Table | SelfControlledCaseSeriesModule: Age spanning diagnostic |
cg_cohort_summary_stats | 0 | 2 | 5 | 0 | Table | CohortGeneratorModule: Cohort summary statistics |
sccs_exposure | 2 | 0 | 3 | 0 | Table | SelfControlledCaseSeriesModule: Exposure reference |
cd_orphan_concept | 0 | 3 | 6 | 0 | Table | CohortDiagnosticsModule: Orphan concept list |
cd_time_series | 0 | 0 | 18 | 0 | Table | CohortDiagnosticsModule: Time series information |
cd_incidence_rate | 0 | 2 | 8 | 0 | Table | CohortDiagnosticsModule: Incidence rate for Cohort Diagnostics |
plp_threshold_summary | 0 | 0 | 25 | 0 | Table | PatientLevelPredictionModule: Threshold summary |
cg_cohort_inclusion | 0 | 1 | 4 | 0 | Table | CohortGeneratorModule: Cohort inclusion information |
plp_feature_engineering_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: Feature engineering settings |
sccs_time_trend | 0 | 1 | 8 | 0 | Table | SelfControlledCaseSeriesModule: Time trend diagnostic |
plp_diagnostic_predictors | 0 | 0 | 5 | 0 | Table | PatientLevelPredictionModule: Diagnostic predictors |
plp_covariate_summary | 0 | 0 | 15 | 0 | Table | PatientLevelPredictionModule: Covariate summary |
plp_database_meta_data | 0 | 0 | 12 | 0 | Table | PatientLevelPredictionModule: CDM database metadata |
cm_covariate | 6 | 1 | 5 | 0 | Table | CohortMethodModule: Covariate reference |
c_settings | 6 | 3 | 12 | 0 | Table | CharacterizationModule: Settings |
cm_target_comparator_outcome | 3 | 0 | 5 | 0 | Table | CohortMethodModule: Target comparator outcome reference |
cg_cohort_inc_stats | 0 | 0 | 7 | 0 | Table | CohortGeneratorModule: Cohort inclusion statistics |
plp_cohort_definition | 0 | 0 | 5 | 0 | Table | PatientLevelPredictionModule: Cohort definitions |
cd_cohort_inc_result | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Cohort inclusion results |
sccs_era | 3 | 0 | 6 | 0 | Table | SelfControlledCaseSeriesModule: Era reference |
plp_tars | 0 | 0 | 5 | 0 | Table | PatientLevelPredictionModule: Time-at-risk settings |
cm_result | 1 | 3 | 27 | 0 | Table | CohortMethodModule: Study results for main effects |
es_sccs_diagnostics_summary | 0 | 0 | 13 | 0 | Table | EvidenceSynthesisModule: Self controlled case series diagnostics summary |
cd_cohort | 0 | 0 | 8 | 0 | Table | CohortDiagnosticsModule: Cohort details |
cd_cohort_inc_stats | 0 | 0 | 7 | 0 | Table | CohortDiagnosticsModule: Cohort inclusion statstics |
plp_model_designs | 1 | 2 | 12 | 0 | Table | PatientLevelPredictionModule: Model designs |
sccs_likelihood_profile | 0 | 0 | 6 | 0 | Table | SelfControlledCaseSeriesModule: Likelihood profile |
cd_cohort_inclusion | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Cohort inclusion info |
cd_vocabulary | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Vocabulary information |
es_cm_result | 0 | 0 | 26 | 0 | Table | EvidenceSynthesisModule: Cohort method results |
ci_target_def | 0 | 0 | 3 | 0 | Table | CohortIncidenceModule: Target cohort definitions |
cm_attrition | 0 | 0 | 9 | 0 | Table | CohortMethodModule: Attrition table |
cd_database | 0 | 0 | 6 | 0 | Table | CohortDiagnosticsModule: CDM database information for Cohort Diagnostics |
plp_diagnostic_outcomes | 0 | 0 | 6 | 0 | Table | PatientLevelPredictionModule: Diagnostic outcomes |
cm_covariate_balance | 0 | 4 | 17 | 0 | Table | CohortMethodModule: Covariate balance |
cd_subset_definition | 0 | 0 | 2 | 0 | Table | CohortDiagnosticsModule: Cohort subset definition |
ci_subgroup_def | 2 | 0 | 3 | 0 | Table | CohortIncidenceModule: Subgroup definitions |
c_cohort_details | 3 | 2 | 5 | 0 | Table | CharacterizationModule: Cohort details |
cm_preference_score_dist | 0 | 0 | 7 | 0 | Table | CohortMethodModule: Preference score distribution |
plp_population_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: Population settings |
database_meta_data | 17 | 1 | 13 | 0 | Table | Strategus: Metadata for each CDM database |
cd_concept_ancestor | 0 | 0 | 4 | 0 | Table | CohortDiagnosticsModule: Concept ancestor |
cm_likelihood_profile | 0 | 0 | 7 | 0 | Table | CohortMethodModule: Likelihood Profile |
es_sccs_result | 0 | 0 | 27 | 0 | Table | EvidenceSynthesisModule: Self controlled case series results |
c_analysis_ref | 0 | 0 | 9 | 0 | Table | CharacterizationModule: Analysis reference |
cg_cohort_inc_result | 0 | 1 | 5 | 0 | Table | CohortGeneratorModule: Cohort inclusion results |
sccs_time_to_event | 0 | 1 | 7 | 0 | Table | SelfControlledCaseSeriesModule: Time-to-event diagnostic |
cd_concept_sets | 2 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Concept sets |
plp_performances | 0 | 4 | 12 | 0 | Table | PatientLevelPredictionModule: Model performance |
cm_diagnostics_summary | 1 | 5 | 21 | 0 | Table | CohortMethodModule: Diagnostics summary |
plp_attrition | 0 | 0 | 6 | 0 | Table | PatientLevelPredictionModule: Attrition information |
plp_diagnostic_designs | 0 | 0 | 3 | 0 | Table | PatientLevelPredictionModule: Diagnostic designs |
c_time_to_event | 0 | 1 | 8 | 0 | Table | CharacterizationModule: Time to event |
cm_propensity_model | 1 | 0 | 6 | 0 | Table | CohortMethodModule: Propensity model |
cm_shared_covariate_balance | 0 | 4 | 16 | 0 | Table | CohortMethodModule: Shared covariate balance |
plp_tidy_covariates_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: Tidy covariate settings |
cd_temporal_time_ref | 0 | 0 | 3 | 0 | Table | CohortDiagnosticsModule: Temporal time reference |
cd_cohort_summary_stats | 0 | 0 | 5 | 0 | Table | CohortDiagnosticsModule: Cohort summary stats |
ci_target_outcome_ref | 0 | 0 | 3 | 0 | Table | CohortIncidenceModule: Target outcome cross reference |
cg_cohort_definition_neg_ctrl | 0 | 0 | 5 | 0 | Table | CohortGeneratorModule: Negative control outcome cohort definitions |
plp_models | 0 | 0 | 11 | 0 | Table | PatientLevelPredictionModule: Models |
cd_domain | 0 | 0 | 3 | 0 | Table | CohortDiagnosticsModule: Domain from the vocabulary |
ci_age_group_def | 2 | 0 | 5 | 0 | Table | CohortIncidenceModule: Age group definitions |
sccs_attrition | 0 | 1 | 10 | 0 | Table | SelfControlledCaseSeriesModule: Attrition table |
plp_sample_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: Sample settings |
sccs_censor_model | 0 | 0 | 6 | 0 | Table | SelfControlledCaseSeriesModule: Event-dependent observation censoring model |
sccs_spline | 0 | 1 | 6 | 0 | Table | SelfControlledCaseSeriesModule: Season, age, and calendar time splines |
cd_metadata | 0 | 0 | 4 | 0 | Table | CohortDiagnosticsModule: Metadata for the database and runtime environment used for Cohort Diagnostics |
plp_diagnostics | 0 | 3 | 4 | 0 | Table | PatientLevelPredictionModule: Diagnostics |
plp_demographic_summary | 0 | 0 | 13 | 0 | Table | PatientLevelPredictionModule: Demographic summary |
cd_temporal_covariate_value_dist | 0 | 0 | 14 | 0 | Table | CohortDiagnosticsModule: Continuous covariate values |
cm_interaction_result | 0 | 0 | 25 | 0 | Table | CohortMethodModule: Study results for interaction effects |
plp_plp_data_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: PLP data settings |
plp_evaluation_statistics | 0 | 0 | 4 | 0 | Table | PatientLevelPredictionModule: Evaluation statistics |
sccs_analysis | 2 | 0 | 3 | 0 | Table | SelfControlledCaseSeriesModule: Analysis reference |
sccs_result | 0 | 13 | 27 | 0 | Table | SelfControlledCaseSeriesModule: Results |
ci_outcome_def | 2 | 0 | 6 | 0 | Table | CohortIncidenceModule: Outcome cohort definitions |
plp_split_settings | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: Split settings |
c_covariate_ref | 6 | 0 | 8 | 0 | Table | CharacterizationModule: Covariate reference |
sccs_calendar_time_spanning | 0 | 1 | 6 | 0 | Table | SelfControlledCaseSeriesModule: Calendar time spanning diagnostic |
es_cm_diagnostics_summary | 0 | 0 | 14 | 0 | Table | EvidenceSynthesisModule: Cohort method diagnostics summary |
plp_cohorts | 0 | 1 | 3 | 0 | Table | PatientLevelPredictionModule: Cohort identifier reference |
sccs_exposures_outcome_set | 12 | 3 | 3 | 0 | Table | SelfControlledCaseSeriesModule: Exposure outcome set reference |
plp_database_details | 0 | 0 | 2 | 0 | Table | PatientLevelPredictionModule: CDM database details |
cm_follow_up_dist | 0 | 0 | 23 | 0 | Table | CohortMethodModule: Follow up distribution |
sccs_covariate_result | 0 | 8 | 7 | 0 | Table | SelfControlledCaseSeriesModule: Covariate results |
c_covariates | 0 | 7 | 9 | 0 | Table | CharacterizationModule: Binary covariates |
cd_included_source_concept | 0 | 1 | 7 | 0 | Table | CohortDiagnosticsModule: Included source concepts |
cd_cohort_relationships | 0 | 0 | 26 | 0 | Table | CohortDiagnosticsModule: Cohort relationships |
cd_temporal_covariate_ref | 0 | 2 | 4 | 0 | Table | CohortDiagnosticsModule: Covariate reference |
cg_cohort_subset_definition | 0 | 0 | 2 | 0 | Table | CohortGeneratorModule: Cohort subset definitions |
plp_recalibrations | 0 | 0 | 5 | 0 | Table | PatientLevelPredictionModule: Recalibrations |
cm_analysis | 1 | 2 | 3 | 0 | Table | CohortMethodModule: Analysis reference |