Tables


SchemaSpy Analysis of strategus.results

Generated on Tue Oct 29 15:27 UTC 2024

Results data model

XML Representation
Insertion Order Deletion Order
TABLES 127
VIEWS 0
COLUMNS 1039
Constraints 0
Anomalies 1
Routines 0

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