By Anonymous - December 18, 2025

cancer schema

Go back to database start page

This schema contains tables related to cancer records.

== Tables: ==
* ahs_variables
* allcancers_tmp
* allmatchcodes
* analysis
* analysis_bak20130222
* analyticpeoplecancers
* autononmatchesmi
* autononmatchesmo
* autononmatchesny
* az_hormone_gleason
* azcanenonmatches
* barbaraslist
* barbaraslist1
* barbaraslist1_medrecreport
* barbaraslist1_medrecreport2
* barbaraslist1a
* barbaraslist1b
* barbaraslist_bak20130311
* barbaraslist_bak20140514
* barbaraslistadditions_nodates
* bl20120508
* breastcancer1212
* cancerdata
* cancerdata_ab1
* cancerdata_ak1
* cancerdata_ak2
* cancerdata_al1
* cancerdata_al1_csssf
* cancerdata_al2
* cancerdata_ar1
* cancerdata_ar2
* cancerdata_az1
* cancerdata_az1_matches
* cancerdata_az1_queries
* cancerdata_az2
* cancerdata_az2_bak
* cancerdata_az2_matches_auto
* cancerdata_az2_matches_manual
* cancerdata_az2_queries
* cancerdata_az3
* cancerdata_bc1
* cancerdata_ca1
* cancerdata_ca1_matches
* cancerdata_ca1_pilot
* cancerdata_ca1_queries
* cancerdata_ca1_removed_deletedfrompeopletable
* cancerdata_ca2
* cancerdata_ca2_bak
* cancerdata_ca2_matches_auto
* cancerdata_ca2_matches_manual
* cancerdata_ca2_queries
* cancerdata_ca3
* cancerdata_ca3_bak
* cancerdata_ca4
* cancerdata_ca4_unfiltered
* cancerdata_ca5
* cancerdata_ca5_unfiltered
* cancerdata_ca6
* cancerdata_ca7
* cancerdata_cancers
* cancerdata_co1
* cancerdata_co1_matches
* cancerdata_co1_prelim
* cancerdata_co2
* cancerdata_co2_matches
* cancerdata_co3
* cancerdata_co3_matches
* cancerdata_ct1
* cancerdata_ct2
* cancerdata_ct3
* cancerdata_ct3_linkagereport
* cancerdata_ct3_revisedlinks
* cancerdata_dc1
* cancerdata_dc2
* cancerdata_dc2_matches
* cancerdata_de1
* cancerdata_de2
* cancerdata_de2_matches
* cancerdata_final
* cancerdata_fl1
* cancerdata_fl1_backup
* cancerdata_fl2
* cancerdata_fl2_backup
* cancerdata_ga1
* cancerdata_hi1
* cancerdata_hi1_bad
* cancerdata_hi2
* cancerdata_ia1
* cancerdata_ia1_matches
* cancerdata_ia2
* cancerdata_id1
* cancerdata_id1_matches_auto
* cancerdata_id1_matches_manual
* cancerdata_id1_pilot
* cancerdata_id1_queries
* cancerdata_id2
* cancerdata_id2_bak
* cancerdata_id2_breast_hormone
* cancerdata_id2_matches_auto
* cancerdata_id2_matches_manual
* cancerdata_id2_prostate_gleason
* cancerdata_id2_queries
* cancerdata_id3
* cancerdata_il1
* cancerdata_il1_matches
* cancerdata_il2
* cancerdata_il2_matches
* cancerdata_in1
* cancerdata_in1_matches
* cancerdata_in1_old
* cancerdata_in2
* cancerdata_in2_linkedids
* cancerdata_in2_matches
* cancerdata_ks1
* cancerdata_ks1_old
* cancerdata_ks2
* cancerdata_ky1
* cancerdata_ky2
* cancerdata_la1
* cancerdata_ma1
* cancerdata_ma1_matches
* cancerdata_ma2
* cancerdata_ma3
* cancerdata_ma3_lbeesonlinkage
* cancerdata_ma3_revisedlinks
* cancerdata_matchcodeevaluation
* cancerdata_md1
* cancerdata_md2
* cancerdata_md2backup
* cancerdata_medrec1
* cancerdata_medrec2
* cancerdata_medrec3
* cancerdata_mi1
* cancerdata_mi1_matches_auto
* cancerdata_mi1_matches_manual
* cancerdata_mi1_queries
* cancerdata_mi2
* cancerdata_mi3
* cancerdata_mi3_matches
* cancerdata_mn1
* cancerdata_mn1_bak
* cancerdata_mn1_matches
* cancerdata_mn1_tmp
* cancerdata_mn2
* cancerdata_mn3
* cancerdata_mn3_matches
* cancerdata_mo1_matches_auto
* cancerdata_mo1_matches_manual
* cancerdata_mo1_queries
* cancerdata_mo2
* cancerdata_ms1
* cancerdata_ms2
* cancerdata_mt1_consent_received
* cancerdata_mt1_inprogress
* cancerdata_mt1_matches_auto
* cancerdata_mt1_queries
* cancerdata_mt1_special
* cancerdata_mt2
* cancerdata_nc1
* cancerdata_nc2
* cancerdata_nd1
* cancerdata_nd2
* cancerdata_ne1
* cancerdata_ne1_matches
* cancerdata_ne1_queries
* cancerdata_ne2
* cancerdata_ne3
* cancerdata_nh1
* cancerdata_nh1_links
* cancerdata_nh1_update
* cancerdata_nj1
* cancerdata_nj1_matches
* cancerdata_nj2
* cancerdata_nm1
* cancerdata_nv1
* cancerdata_nv1_bak
* cancerdata_nv1_matches
* cancerdata_nv1_tmp
* cancerdata_nv2
* cancerdata_ny1
* cancerdata_ny1_matches_auto
* cancerdata_ny1_matches_manual
* cancerdata_ny1_queries
* cancerdata_ny2
* cancerdata_ny3
* cancerdata_ny3_matches
* cancerdata_ny4
* cancerdata_ny5
* cancerdata_ny5_matches
* cancerdata_oh1
* cancerdata_oh1_matches
* cancerdata_oh2
* cancerdata_oh2_matches
* cancerdata_ok1
* cancerdata_ok1_matches
* cancerdata_ok2
* cancerdata_on1
* cancerdata_or1
* cancerdata_or1_matches_auto
* cancerdata_or1_matches_manual
* cancerdata_or1_pilot
* cancerdata_or1_queries
* cancerdata_or1_removed_deletedfrompeopletable
* cancerdata_or2
* cancerdata_or2_bak
* cancerdata_or2_hormone
* cancerdata_or2_matches_auto
* cancerdata_or2_matches_manual
* cancerdata_or2_queries
* cancerdata_or3
* cancerdata_or4
* cancerdata_pa1
* cancerdata_pa1_matches
* cancerdata_pa2
* cancerdata_ri1
* cancerdata_ri2
* cancerdata_sc1
* cancerdata_sc2
* cancerdata_sc3
* cancerdata_sc3_matches
* cancerdata_sd1
* cancerdata_stateofresidence
* cancerdata_tn1
* cancerdata_tx1
* cancerdata_tx2
* cancerdata_ut1
* cancerdata_ut1_bak
* cancerdata_ut1_matches_auto
* cancerdata_ut1_queries
* cancerdata_ut2
* cancerdata_va1
* cancerdata_va1_matches
* cancerdata_va2
* cancerdata_vt1
* cancerdata_vt1_matches
* cancerdata_vt1_raw
* cancerdata_vt2
* cancerdata_wa1
* cancerdata_wa1_bak
* cancerdata_wa1_matches_auto
* cancerdata_wa1_matches_manual
* cancerdata_wa1_queries
* cancerdata_wa2
* cancerdata_wa2_2008_2011
* cancerdata_wa2_2008_2011_update
* cancerdata_wa3
* cancerdata_wi1
* cancerdata_wv1
* cancerdata_wy1
* cancerdata_wy1_collaborativestaging
* cancerdata_wy1_matches
* cancerdata_wy2
* cancerident_hist3
* cancerident_hist3_old
* cancerident_primarysite
* cancerident_primarysite_old
* cancerinvestigation
* cancerlinkages
* cancerlinkages2
* cancerlinkages_bad
* cancerlinks_score35_45
* cancerlistsgiventobarbara
* cancerregistrypilot
* cancers_completeyears
* cancers_completeyears_20140508
* cancers_completeyears_20140508_info
* cancers_completeyears_20141007
* cancers_completeyears_20141007_info
* cancers_completeyears_20150415
* cancers_completeyears_20150415_info
* cancers_completeyears_20150422
* cancers_completeyears_20150422_info
* cancers_completeyears_20160616
* cancers_completeyears_20160616_info
* cancers_completeyears_20161025
* cancers_completeyears_20161025_info
* cancers_completeyears_20161027
* cancers_completeyears_20161027_info
* cancers_completeyears_20161028
* cancers_completeyears_20161028_info
* cancers_completeyears_20161219
* cancers_completeyears_20161219_info
* cancervalidityqids
* ccr_hhq_eval
* ccrdata1
* ccrdata2
* ccrmatches1
* ccrmatches2
* ccrnonmatches2
* ccrqueries2
* colorectalmorlich20200303
* dataforkansas
* dataforlinkage
* dtproperties
* excludemorphologies
* falsepositives
* falsepositives2
* hhq1_cancers_not_linked2
* manualnonmatchesmi
* manualnonmatchesmo
* manualnonmatchesny
* medicalrecords
* mssqltables
* prevalentcancers
* prevalentcancers_source
* sysconstraints
* syssegments