Database Properties
Database Type: PostgreSQL - 17.6 (Debian 17.6-1.pgdg13+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 | 6 | 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 |
| tp_cdm_source_info | 0 | 0 | 12 | 0 | Table | TreatmentPatternsModule: CDM source information |
| tp_counts_year | 0 | 0 | 6 | 0 | Table | TreatmentPatternsModule: Year counts |
| 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 | 24 | 0 | Table | SelfControlledCaseSeriesModule: Diagnostic summary |
| c_cohort_counts | 0 | 0 | 15 | 0 | Table | CharacterizationModule: Cohort counts |
| tp_analyses | 0 | 0 | 2 | 0 | Table | TreatmentPatternsModule: List of analyses |
| 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 | 12 | 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 |
| tp_treatment_pathways | 0 | 0 | 9 | 0 | Table | TreatmentPatternsModule: Treatment pathways |
| tp_attrition | 0 | 0 | 9 | 0 | Table | TreatmentPatternsModule: Treatment patterns attrition |
| 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 | 7 | 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 |
| tp_summary_event_duration | 0 | 0 | 14 | 0 | Table | TreatmentPatternsModule: Summary event duration |
| 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 |
| tp_metadata | 0 | 0 | 7 | 0 | Table | TreatmentPatternsModule: Metadata |
| 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 |
| tp_counts_age | 0 | 0 | 6 | 0 | Table | TreatmentPatternsModule: Age counts |
| 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 |
| tp_counts_sex | 0 | 0 | 6 | 0 | Table | TreatmentPatternsModule: Sex counts |
| 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 |
| tp_arguments | 0 | 0 | 3 | 0 | Table | TreatmentPatternsModule: List of analysis arguments |
| c_covariates | 0 | 7 | 9 | 0 | Table | CharacterizationModule: Binary covariates |
| cd_included_source_concept | 0 | 1 | 7 | 0 | Table | CohortDiagnosticsModule: Included source concepts |
| cd_temporal_covariate_ref | 0 | 2 | 5 | 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 |