View on GitHub

popsci-model

Population Sciences Data Commons data model

Population Sciences Data Commons Model

View model on GitHub Pages

Zoom to Node:

SVG file (in view above)

Additional model files

Perl demo demo age agelevel bmi_20 bmi_20c bmi_50 bmi_50c bmi_curc bmi_curr brothers demo_id educat height_f hispanic_f marital occupat race7 sex sisters state weight20_f weight50_f weight_f case case arm biosp_f case_id center plco_dx plco_dx_age rndyear demo->case demo_of_case ovar_hist ovar_hist breast_fh breast_fh_age breast_fh_cnt ca125_history fh_cancer mammo_history ovar_hist_id ovarsumm_fh ovarsumm_fh_age ovarsumm_fh_cnt papsmear_history pelvic_history usound_history ovar_hist->case ovar_hist_of_case nsaid_use nsaid_use asp asppd ibup ibuppd nsaid_use_id nsaid_use->case nsaid_use_of_case ovar_elig ovar_elig entryage_bq entryage_dhq entryage_dqx entryage_muq entryage_sqx entrydays_bq entrydays_dhq entrydays_dqx entrydays_muq entrydays_sqx osumm_eligible_bq osumm_eligible_dhq osumm_eligible_dqx osumm_eligible_muq osumm_eligible_sqx ovar_elig_id ovary_trial_flag ph_any_bq ph_any_dhq ph_any_dqx ph_any_muq ph_any_sqx ph_any_trial ph_first_cancer ph_first_cancer_age + 6 properties ovar_elig->case ovar_elig_of_case cohort cohort clinical_trials_gov_id cohort_description cohort_id cohort_title completion_date disease start_date clinical_trial clinical_trial clinical_trial_description clinical_trial_designation clinical_trial_id clinical_trial_long_name clinical_trial_short_name clinical_trial_type clinical_trials_gov_id dbgap_accession_number lead_organization principal_investigators cohort->clinical_trial cohort dqx dqx addsug_perc2015 cal_dairy cal_nondairy carb_alc carb_dairy carb_fruit carb_junk_food carb_other carb_other_grain carb_potato carb_soft_drink carb_veg carb_whole_grain dairyden dgvden2005 dqx_age dqx_compdays dqx_completed dqx_completedvalid dqx_id drinker dt_alc dt_alc_alc_drinks dt_alc_beer dt_alc_liquor + 912 properties dqx->case dqx_of_case breast_diag breast_diag bc_her2_stat bc_her2summ breast_cancer breast_candxdays breast_clinstage breast_clinstage_7e breast_clinstage_m breast_clinstage_n breast_clinstage_t breast_diag_id breast_has_mets breast_is_first_dx breast_mets_conflict breast_mets_conflict_source breast_mets_source breast_pathstage breast_pathstage_7e breast_pathstage_m breast_pathstage_n breast_pathstage_t breast_registry_stat_cat breast_stage breast_stage_7e breast_stage_m breast_stage_n + 6 properties breast_diag->case breast_diag_of_case ovar_mort ovar_mort d_dthosumm f_dthosumm ovar_mort_id ovar_mort->case ovar_mort_of_case colo_mort colo_mort colo_mort_id d_dthc f_dthc colo_mort->case colo_mort_of_case lung_regn lung_regn dual lung_regn_id queried_any_registry queried_any_registry_stat reconsent_outcome reconsent_outcome_days lung_regn->case lung_regn_of_case ovar_treat ovar_treat curative_chemoosumm curative_surgosumm ovar_treat_id primary_trtosumm primary_trtosumm_days ovar_treat->case ovar_treat_of_case comp comp bq_adminm bq_age bq_compdays bq_returned comp_id comp->case comp_of_case lung_mort lung_mort d_dthl f_dthl lung_mort_id lung_mort->case lung_mort_of_case colo_hist colo_hist colo_fh colo_fh_age colo_fh_cnt colorect_history colscrn_history fh_cancer stool_history surg_age surg_any surg_biopsy surg_prostatectomy surg_resection vasect_f vasecta colo_hist->case colo_hist_of_case breast_exit breast_exit breast_exit_id breast_exitage breast_exitdays breast_exitstat fstcan_exitage fstcan_exitdays fstcan_exitstat mortality_exitage mortality_exitdays mortality_exitstat breast_exit->case breast_exit_of_case case->cohort case_of_cohort colo_treat colo_treat colo_treat_id curative_chemoc curative_radc curative_resectc iaden_aden iaden_aden_days iaden_adv iaden_cohort iaden_dyspw iaden_exclusion iaden_protocol neoadjuvantc primary_trtc primary_trtc_days raden_cohort_group raden_exclusion colo_treat->case colo_treat_of_case pros_treat pros_treat curative_hormp curative_othp curative_prostp curative_radp neoadjuvantp primary_trtp primary_trtp_days pros_treat_id pros_treat->case pros_treat_of_case male_health_cond male_health_cond enlpros_f enlprosa infpros_f infprosa male_health_id prosprob_f urinate_f urinatea male_health_cond->case male_health_cond_of_case fem_health_cond fem_health_cond bbd bcontr_f bcontra bcontrt benign_ovcyst curhorm endometriosis fchilda fem_health_cond_id fmenstr horm_f horm_stat hyster_f hystera livec lmenstr menstrs menstrs_stat_type miscar ovariesr_f post_menopausal preg_f prega pregc stillb + 5 properties fem_health_cond->case fem_health_cond_of_case lung_diag lung_diag candxdaysl intstatl_cat lung_cancer lung_cancer_type lung_clinstage lung_clinstage_7e lung_clinstage_m lung_clinstage_n lung_clinstage_t lung_diag_id lung_grade lung_has_mets lung_histtype lung_histtype_cat lung_is_carcinoid lung_is_first_dx lung_mets_conflict lung_mets_conflict_source lung_mets_source lung_pathstage lung_pathstage_7e lung_pathstage_m lung_pathstage_n lung_pathstage_t lung_registry_stat_cat + 12 properties lung_diag->case lung_diag_of_case pros_exit pros_exit fstcan_exitage fstcan_exitdays fstcan_exitstat mortality_exitage mortality_exitdays mortality_exitstat pros_exit_id pros_exitage pros_exitdays pros_exitstat pros_exit->case pros_exit_of_case visit visit visit_id visit_year_from_index visit->case visit_of_case pros_elig pros_elig entryage_bq entryage_dhq entryage_dqx entryage_muq entryage_sqx entrydays_bq entrydays_dhq entrydays_dqx entrydays_muq entrydays_sqx ph_any_bq ph_any_dhq ph_any_dqx ph_any_muq ph_any_sqx ph_any_trial ph_first_cancer ph_first_cancer_age ph_pros_bq ph_pros_dhq ph_pros_dqx ph_pros_muq ph_pros_sqx ph_pros_trial pros_elig_id + 5 properties pros_elig->case pros_elig_of_case pros_screen pros_screen biopplink0 biopplink1 biopplink2 biopplink3 biopplink4 biopplink5 dre_days0 dre_days1 dre_days2 dre_days3 dre_result0 dre_result1 dre_result2 dre_result3 pros_mra_stat0 pros_mra_stat1 pros_mra_stat2 pros_mra_stat3 pros_mra_stat4 pros_mra_stat5 pros_screen_id psa_days0 psa_days1 psa_days2 psa_days3 + 15 properties pros_screen->case pros_screen_of_case lung_treat lung_treat curative_chemol curative_pneuml curative_radl curative_wsll lung_treat_id neoadjuvantl primary_trtl_nsc primary_trtl_nsc_days primary_trtl_small primary_trtl_small_days lung_treat->case lung_treat_of_case health_cond health_cond arthrit_f bronchit_f colon_comorbidity diabetes_f divertic_f emphys_f gallblad_f health_cond_id hearta_f hyperten_f liver_comorbidity osteopor_f polyps_f stroke_f health_cond->case health_cond_of_case ovar_regn ovar_regn dual osumm_registry_stat_cat ovar_regn_id queried_any_registry reconsent_outcome reconsent_outcome_days ovar_regn->case ovar_regn_of_case pros_hist pros_hist fh_cancer pros_fh pros_fh_age pros_fh_cnt pros_hist_id psa_history rectal_history surg_age surg_any surg_biopsy surg_prostatectomy surg_resection vasect_f vasecta pros_hist->case pros_hist_of_case pros_mort pros_mort d_dthp f_dthp pros_mort_id pros_mort->case pros_mort_of_case mort mort d_cancersite d_codeath_cat d_seer_death dth_days f_cancersite f_codeath_cat f_seer_death is_dead is_dead_with_cod mort_id mort->case mort_of_case lung_screen lung_screen biopllink0 biopllink1 biopllink2 biopllink3 lung_mra_stat0 lung_mra_stat1 lung_mra_stat2 lung_mra_stat3 lung_screen_id nlst_flag xry_days0 xry_days1 xry_days2 xry_days3 xry_prot xry_result0 xry_result1 xry_result2 xry_result3 lung_screen->case lung_screen_of_case lung_exit lung_exit fstcan_exitage fstcan_exitdays fstcan_exitstat lung_exit_id lung_exitage lung_exitdays lung_exitstat mortality_exitage mortality_exitdays mortality_exitstat lung_exit->case lung_exit_of_case dhq dhq addsug_perc2015_dhq age_dhq dairyden_dhq dgvden2005_dhq dhq_compdays dhq_completed dhq_completedvalid dhq_id drinker_dhq drinker_status_dhq dt_alc_alc_drinks_dhq dt_alc_beer_dhq dt_alc_dhq dt_alc_liquor_dhq dt_alc_wine_dhq dt_alphacarot_dhq dt_b12_dhq dt_b6_dhq dt_betacarot_dhq dt_betacarot_eq_dhq dt_betacry_dhq dt_betatoco_dhq dt_caffeine_dhq dt_cal_dhq dt_carb_dhq + 1085 properties dhq->case dhq_of_case pros_diag pros_diag candxdaysp dx_psa dx_psa_gap intstatp_cat pros_cancer pros_clinstage pros_clinstage_7e pros_clinstage_m pros_clinstage_n pros_clinstage_t pros_diag_id pros_gleason pros_gleason_biop pros_gleason_prost pros_gleason_source pros_grade pros_has_mets pros_histtype pros_is_first_dx pros_mets_conflict pros_mets_conflict_source pros_mets_source pros_pathstage pros_pathstage_7e pros_pathstage_m + 14 properties pros_diag->case pros_diag_of_case colo_screen colo_screen aden_count_eith0 aden_count_eith3 aden_count_eith35 aden_count_eith5 aden_count_left0 aden_count_left3 aden_count_left35 aden_count_left5 aden_count_rght0 aden_count_rght3 aden_count_rght35 aden_count_rght5 adeneith0 adeneith3 adeneith35 adeneith5 adeneith_days0 adeneith_days3 adeneith_days35 adeneith_days5 adenleft0 adenleft3 adenleft35 adenleft5 adenleft_days0 + 262 properties colo_screen->case colo_screen_of_case colo_diag colo_diag candxdaysc colo_cancer colo_cancer_type colo_clinstage colo_clinstage_7e colo_clinstage_m colo_clinstage_n colo_clinstage_t colo_diag_id colo_grade colo_has_mets colo_histtype colo_icdo2_tmrloc colo_is_first_dx colo_location colo_location_side colo_location_summary colo_mets_conflict colo_mets_conflict_source colo_mets_source colo_pathstage colo_pathstage_7e colo_pathstage_m colo_pathstage_n colo_pathstage_t + 14 properties colo_diag->case colo_diag_of_case breast_hist breast_hist breast_fh breast_fh_age breast_fh_cnt breast_hist_id breast_hist->case breast_hist_of_case lung_elig lung_elig entryage_bq entryage_dhq entryage_dqx entryage_muq entryage_sqx entrydays_bq entrydays_dhq entrydays_dqx entrydays_muq entrydays_sqx lung_elig_id lung_eligible_bq lung_eligible_dhq lung_eligible_dqx lung_eligible_muq lung_eligible_sqx ph_any_bq ph_any_dhq ph_any_dqx ph_any_muq ph_any_sqx ph_any_trial ph_first_cancer ph_first_cancer_age ph_lung_bq + 5 properties lung_elig->case lung_elig_of_case ovar_screen ovar_screen biopolink0 biopolink1 biopolink2 biopolink3 biopolink4 biopolink5 ca125_days0 ca125_days1 ca125_days2 ca125_days3 ca125_days4 ca125_days5 ca125_level0 ca125_level1 ca125_level2 ca125_level3 ca125_level4 ca125_level5 ca125_prot ca125_result0 ca125_result1 ca125_result2 ca125_result3 ca125_result4 ca125_result5 + 28 properties ovar_screen->case ovar_screen_of_case sqx sqx pack_years_bqelsesqx ph_any_sqx sqx_acetam sqx_acetam_freq sqx_acetam_yrs sqx_active sqx_active_comp sqx_actonel sqx_advil sqx_advise_quit sqx_aerobics sqx_aerobics_lev sqx_age sqx_aleve sqx_amt_smk sqx_any_fmed sqx_arthritisa sqx_aspirin sqx_aspirin_freq sqx_aspirin_str sqx_aspirin_yrs sqx_asthma sqx_asthmaa sqx_bald45 sqx_bextra + 203 properties sqx->case sqx_of_case breast_elig breast_elig breast_elig_id breast_eligible_bq breast_eligible_dhq breast_eligible_dqx breast_eligible_muq breast_eligible_sqx entryage_bq entryage_dhq entryage_dqx entryage_muq entryage_sqx entrydays_bq entrydays_dhq entrydays_dqx entrydays_muq entrydays_sqx ph_any_bq ph_any_dhq ph_any_dqx ph_any_muq ph_any_sqx ph_any_trial ph_breast_bq ph_breast_dhq ph_breast_dqx + 5 properties breast_elig->case breast_elig_of_case breast_regn breast_regn breast_regn_id queried_any_registry queried_any_registry_stat reconsent_outcome reconsent_outcome_days breast_regn->case breast_regn_of_case colo_regn colo_regn colo_regn_id dual queried_any_registry queried_any_registry_stat reconsent_outcome reconsent_outcome_days colo_regn->case colo_regn_of_case ovar_diag ovar_diag cancerosumm candxdaysosumm intstatosumm_cat osumm_cancer osumm_clinstage osumm_clinstage_7e osumm_clinstage_m osumm_clinstage_n osumm_clinstage_t osumm_has_mets osumm_is_first_dx osumm_mets_conflict osumm_mets_conflict_source osumm_mets_source osumm_pathstage osumm_pathstage_7e osumm_pathstage_m osumm_pathstage_n osumm_pathstage_t osumm_stage osumm_stage_7e osumm_stage_m osumm_stage_n osumm_stage_t osumm_summary_stage_enhanced + 6 properties ovar_diag->case ovar_diag_of_case file file file_description file_format file_id file_location file_name file_size file_status file_type md5sum uuid file->cohort file_of_cohort file->case file_of_case risk risk cig_stat cig_stop cig_years cigar cigpd_f fh_cancer filtered_f pack_years pipe risk_id rsmoker_f smokea_f smoked_f ssmokea_f risk->case risk_of_case ovar_exit ovar_exit fstcan_exitage fstcan_exitdays fstcan_exitstat mortality_exitage mortality_exitdays mortality_exitstat ovar_exit_id ovar_exitage ovar_exitdays ovar_exitstat ovar_exit->case ovar_exit_of_case breast_mort breast_mort breast_mort_id d_dth_breast f_dth_breast breast_mort->case breast_mort_of_case colo_elig colo_elig colo_elig_id colo_eligible_bq colo_eligible_dhq colo_eligible_dqx colo_eligible_muq colo_eligible_sqx entryage_bq entryage_dhq entryage_dqx entryage_muq entryage_sqx entrydays_bq entrydays_dhq entrydays_dqx entrydays_muq entrydays_sqx ph_any_bq ph_any_dhq ph_any_dqx ph_any_muq ph_any_sqx ph_any_trial ph_colo_bq ph_colo_dhq ph_colo_dqx + 5 properties colo_elig->case colo_elig_of_case lung_hist lung_hist fh_cancer lung_fh lung_fh_age lung_fh_cnt lung_hist_id surg_age surg_any surg_biopsy surg_prostatectomy surg_resection vasect_f vasecta xray_history lung_hist->case lung_hist_of_case pros_regn pros_regn dual pros_regn_id queried_any_registry queried_any_registry_stat reconsent_outcome reconsent_outcome_days pros_regn->case pros_regn_of_case colo_exit colo_exit colo_exit_id colo_exitage colo_exitdays colo_exitstat fstcan_exitage fstcan_exitdays fstcan_exitstat mortality_exitage mortality_exitdays mortality_exitstat colo_exit->case colo_exit_of_case