image schema
Go back to database start page
This schema contains tables related to scanned data from various paper forms.
== Tables: ==
* agesresolved
* allhospcancers
* allstates
* alumnilist
* archive_part1a
* archive_part1b
* archive_part2a
* archive_part2b
* archive_v2part1a
* archive_v2part1b
* archive_v2part2a
* archive_v2part2b
* archive_v2part3a
* archive_v2part3b
* archive_v3part1a
* archive_v3part1b
* archive_v3part2a
* archive_v3part2b
* archive_v3part3a
* archive_v3part3b
* arhs
* arhs2
* arhs3
* arhs_degarth
* arhs_degdisk
* arhs_fibromyalgia
* arhs_iadl
* arhs_medicalhistory
* arhs_medicalhistorybackup
* arhs_medications_black
* arhs_psymrs_part1a
* arhs_psymrs_part1b
* arhs_raw
* arhs_rheumatoid
* arhs_sciatica
* arhsv2
* backpage_tiff_images
* backpage_tiff_info
* backpages
* badimages
* biomf
* biomm
* bp_ids
* bp_ids1
* bp_ids2
* cancerfrequencywithfrasersinput
* cancerlinks_score35_45
* cancerregistrypilot
* cancerswithfrasersinput
* cancerswithfrasersinput-queries
* cancerswithfrasersinput_final
* census
* cereal_redo
* chfshortforma
* chfshortformb
* churchcontactinfo
* clipping
* contact
* daom_tape4100
* dataentry_arhs_medications
* dataentry_arhs_medications2
* dataentry_arhs_medications2backup
* dataentry_arhs_medicationsbackup
* dataentry_arhs_medicationsfix
* dataentry_baseline_otherfish
* dataentry_baseline_othersweets
* dataentry_pastoroccup
* datasubsettracker
* debuglevel
* deletedlithos
* denormalized_duplicatedetection_data
* dictionary
* dietarypatternforall
* dietarypatterns_generic
* dob_check
* doublecheck
* duplicateerrors
* errorcorrectionlithos
* errorlist
* errorlistmissedscan
* errors
* errorshistory
* errorstatus
* errortype
* fal
* field_update_history
* foodfreqdist
* fou_marked_with_response
* getcompletedfordoublecheck
* getcurrenttasks
* getstatuses
* hbp_forpatti
* hh1_missingentry1
* hh1_missingentry2
* hh2_extrahosp
* hh2_missingentry1
* hh2_missingentry2
* hh2_writeinentry1
* hh2_writeinentry2
* hh3_extrahosp
* hh3_missingentry1
* hh3_missingentry2
* hh3_writeinentry_barbara
* hh3_writeinentry_combined
* hh3_writeinentry_sonja
* hh3_writeinentry_student
* hh4_extrahosp
* hh4_extratumor
* hh4_missingentry1
* hh4_missingentry2
* hh_extrahosp
* hh_extratumor
* hhcancers
* hhf_lookup_aid
* hhf_lookup_qid
* hhq1
* hhq1_0_fix
* hhq1_2_fix
* hhq1_hospduetocancer
* hhq1_ids
* hhq1_revised
* hhq1_revised_hospitalizations
* hhq1_revised_hospredundant
* hhq2
* hhq2_ids
* hhq2_revised
* hhq2_revised_bak201804
* hhq2_revised_hospitalizations
* hhq2typed
* hhq2typed_1stentry
* hhq2typed_2ndentry
* hhq3
* hhq3_dataentry
* hhq3_dataentry1
* hhq3_dataentry2
* hhq3_dataentry3
* hhq3_dataentry4
* hhq3_dataentry5
* hhq3_dataentry6
* hhq3_revised
* hhq3_revised_bak201804
* hhq3_revised_hospitalizations
* hhq3_revised_hospitalizations_bak
* hhq4
* hhq4_bak20150904
* hhq4b
* hhq5
* hhq5_bak20150910
* hhq5_datashifterror
* hhq6
* hhq_extrahospstays
* hhq_mailings
* hospquest
* hospv3test
* icd_codes
* imageid
* kcalids
* labelocr
* labelocr_words
* labelocr_words_detail
* linkageinfo
* litho_pixeldecoder
* litho_pixeldecoderv1
* litho_pixeldecoderv2
* litho_pixeldecoderv3
* litholist
* litholistmissedscan
* llumc_dementia
* llumc_parkinsons
* llumc_stroke
* medicaressns2022
* missedmarksneedingcorrection
* missinghhentry_1c
* missingness
* mssqltables
* mt_consent_mailing
* n2a_20120102
* n2a_20120301
* n2a_20120326
* n2a_20120918
* n2b_20120102
* n2b_20120301
* n2b_20120326
* n2c_20120411
* n2c_20121107
* n2c_release4_20110725
* needresolution
* null_corrections
* nulldatainparts
* nulls201502
* nulls_in_parts
* occupations_bpetersen
* office_tiffnumber_v1
* office_tiffnumber_v2
* office_tiffnumber_v3
* officeuse_v1
* officeuse_v2
* officeuse_v3
* officeuselist
* overlap_premark_white
* part1_20150126a
* part1_20150126b
* part1_bak20150623a
* part1_bak20150623b
* part1_nulls
* part1_originala
* part1_originalb
* part1_unmodifieda
* part1_unmodifiedb
* part1_zerocounts
* part1a
* part1b
* part1baka
* part1bakb
* part1historya
* part1historyb
* part2_20150126a
* part2_20150126b
* part2_bak20150623a
* part2_bak20150623b
* part2_nulls
* part2_originala
* part2_originalb
* part2_zerocounts
* part2a
* part2b
* part2bak20171211a
* part2bak20171211b
* part2baka
* part2bakb
* part2historya
* part2historyb
* part_table_nulls
* pixel_v2part1
* pixel_v2part2
* pixel_v2part3
* pixel_v3part1
* pixel_v3part2
* pixel_v3part3
* pixelmapentriesv1
* pixelmapentriesv2
* pixelmapentriesv3
* prevalentskincancer
* prevchf
* prostate_notadvanced
* qid_hhqid_link
* qids_arhs_scanneroutput_imported
* qids_arhs_scanneroutput_notimported
* qids_backpage_scanneroutput_imported
* qids_backpage_scanneroutput_notimported
* qids_hhq2_scanneroutput_imported
* qids_hhq2_scanneroutput_notimported
* qids_inparts_missingpeople
* qids_preedit
* qids_readytoscan
* qids_rescue
* qids_scanneroutput_imported
* qids_scanneroutput_notimported
* qrage
* qrage_fromparttables
* qrage_fromsectiontables
* racecodes
* racecodes_black_loose
* racecodes_black_strict
* range
* range_arhs
* rangearhs_iadl
* rangearhs_medicalhistory
* rangebackpage
* rangehhq1_unfinished
* rangehhq2
* rangehhq3
* rangehhq4
* rangehhq5
* rangehhq6
* rangememorytest
* rangenames
* rangeshortform
* reservedlitho
* saturationinfo
* saturationinfo2
* saturationinfo3
* saturationinfo4
* saturationinfo_bp
* saturationinfo_v1
* saturationtest
* scannermisseditems
* scanneroutput_baseline
* sherzai_dementia_links
* sherzai_fmo_ahs2_links
* sherzai_parkinsons_links
* sherzai_stroke_links
* shortform2a
* shortform2b
* shortform_olda
* shortform_oldb
* shortform_oldbutslightlynewera
* shortform_oldbutslightlynewerb
* shortform_oldfoodidsa
* shortform_oldfoodidsb
* shortforma
* shortformb
* shortquesttranslated
* socialsecuritynumbers
* soyblank
* soyblank2
* squids
* ssn
* ssn_final
* status5alithos
* statushistory
* studentcorrections_childbirthbreastfed
* studentcorrections_childbirthbreastfed2
* studentcorrections_childbirthweights
* studentcorrections_childbirthyear3e_bak
* studentcorrections_childbirthyear_20111031
* studentcorrections_childbirthyearfirstentry
* studentcorrections_childbirthyearfirstentry_bak20140110
* studentcorrections_childbirthyearsecondentry
* studentcorrections_childbirthyearsecondentry_bak20140110
* studentcorrections_childbirthyearthirdentry
* studentcorrections_combohormone
* studentcorrections_dob
* studentcorrections_dobfirstentry
* studentcorrections_drinking
* studentcorrections_estrogen
* studentcorrections_ethyou_asterisks
* studentcorrections_ethyou_final
* studentcorrections_ethyou_firstentry
* studentcorrections_ethyou_secondentry
* studentcorrections_height
* studentcorrections_heightfirstentry
* studentcorrections_heightsecondentry
* studentcorrections_hysterectomy
* studentcorrections_log
* studentcorrections_log_old_datesofbirth
* studentcorrections_log_old_height
* studentcorrections_log_old_weight
* studentcorrections_log_old_workzip
* studentcorrections_menopause
* studentcorrections_oophorectomy
* studentcorrections_progesterone
* studentcorrections_smoking
* studentcorrections_ssn_firstentry
* studentcorrections_ssn_secondentry
* studentcorrections_sunexposure
* studentcorrections_waisthip_firstentry
* studentcorrections_weight
* studentcorrections_weight2
* studentcorrections_workzip
* studentcorrections_yearslocal
* studentcorrections_yearssinceretirement
* subjectidlink
* subjectsfromruforfraser2
* sysconstraints
* syssegments
* temp4
* tenpct
* tenpct_completed
* tenpct_nfa
* tenpct_notbegun
* tenpct_notcompletable
* testpixellithodecoder
* testtifflithoscandetail
* tiff_bp_qids
* tiff_qids_arhs
* tiff_qids_bp
* tiff_qids_hhq2
* tiff_qids_mainquestv1
* tiff_qids_mainquestv2
* tiff_qids_mainquestv3
* tiff_qids_shortquest
* tiff_shortquest_uids
* tiffdirs
* tiffgrid_qnames_hh4
* tiffgrid_qnames_hh5
* tiffgridpixelrange
* tiffgridpixels
* tiffgridqnames
* tiffgridqnamesbak
* tiffpixelscan_faintresponses
* tiffpixelscan_questions_b5
* tiffpixelscan_questions_b5_corrections
* tiffpixelscan_responses
* tiffpixelscan_responses_a1
* tiffpixelscan_responses_a1_bak
* tiffpixelscan_responses_a2
* tiffpixelscan_responses_a2_bak
* tiffpixelscan_responses_a3
* tiffpixelscan_responses_a3_bak
* tiffpixelscan_responses_a4
* tiffpixelscan_responses_a4_bak
* tiffpixelscan_responses_a5
* tiffpixelscan_responses_a5_bak
* tiffpixelscan_responses_a6
* tiffpixelscan_responses_a6_bak
* tiffpixelscan_responses_a7
* tiffpixelscan_responses_a7_bak
* tiffpixelscan_responses_b1
* tiffpixelscan_responses_b10
* tiffpixelscan_responses_b10_bak
* tiffpixelscan_responses_b11
* tiffpixelscan_responses_b11_bak
* tiffpixelscan_responses_b12
* tiffpixelscan_responses_b12_bak
* tiffpixelscan_responses_b13
* tiffpixelscan_responses_b13_bak
* tiffpixelscan_responses_b14
* tiffpixelscan_responses_b14_bak
* tiffpixelscan_responses_b15
* tiffpixelscan_responses_b15_bak
* tiffpixelscan_responses_b1_bak
* tiffpixelscan_responses_b2
* tiffpixelscan_responses_b2_bak
* tiffpixelscan_responses_b3
* tiffpixelscan_responses_b3_bak
* tiffpixelscan_responses_b4
* tiffpixelscan_responses_b4_bak
* tiffpixelscan_responses_b5
* tiffpixelscan_responses_b5_bak
* tiffpixelscan_responses_b6
* tiffpixelscan_responses_b6_bak
* tiffpixelscan_responses_b7
* tiffpixelscan_responses_b7_bak
* tiffpixelscan_responses_b8
* tiffpixelscan_responses_b8_bak
* tiffpixelscan_responses_b9
* tiffpixelscan_responses_b9_bak
* tiffpixelscan_responses_c1
* tiffpixelscan_responses_c1_bak
* tiffpixelscan_responses_c2
* tiffpixelscan_responses_c2_bak
* tiffpixelscan_responses_d1
* tiffpixelscan_responses_d1_bak
* tiffpixelscan_responses_d2
* tiffpixelscan_responses_d2_bak
* tiffpixelscan_responses_d3
* tiffpixelscan_responses_d3_bak
* tiffpixelscan_responses_d4
* tiffpixelscan_responses_d4_bak
* tiffpixelscan_responses_d5
* tiffpixelscan_responses_d5_bak
* tiffpixelscan_responses_d6
* tiffpixelscan_responses_d6_bak
* tiffpixelscan_responses_d7
* tiffpixelscan_responses_d7_bak
* tiffpixelscan_responses_d8
* tiffpixelscan_responses_d8_bak
* tiffpixelscan_responses_e1
* tiffpixelscan_responses_e1_bak
* tiffpixelscan_responses_e2
* tiffpixelscan_responses_e2_bak
* tiffpixelscan_responses_e3
* tiffpixelscan_responses_e3_bak
* tiffpixelscan_responses_e4
* tiffpixelscan_responses_e4_bak
* tiffpixelscan_responses_e5
* tiffpixelscan_responses_e5_bak
* tiffpixelscan_responses_e6
* tiffpixelscan_responses_e6_bak
* tiffpixelscan_responses_e7
* tiffpixelscan_responses_e7_bak
* tiffpixelscan_responses_f1
* tiffpixelscan_responses_f10
* tiffpixelscan_responses_f10_bak
* tiffpixelscan_responses_f1_bak
* tiffpixelscan_responses_f2
* tiffpixelscan_responses_f2_bak
* tiffpixelscan_responses_f3
* tiffpixelscan_responses_f3_bak
* tiffpixelscan_responses_f4
* tiffpixelscan_responses_f4_bak
* tiffpixelscan_responses_f5
* tiffpixelscan_responses_f5_bak
* tiffpixelscan_responses_f6
* tiffpixelscan_responses_f6_bak
* tiffpixelscan_responses_f7
* tiffpixelscan_responses_f7_bak
* tiffpixelscan_responses_f8
* tiffpixelscan_responses_f8_bak
* tiffpixelscan_responses_f9
* tiffpixelscan_responses_f9_bak
* tiffpixelscan_responses_hh4
* tiffpixelscan_responses_hh5
* tiffpixelscan_responses_x
* tiffpixelscan_summary_b5
* tiffpixelscan_summary_hh4
* tiffpixelscan_summary_hh5
* tiffsaturation
* tiffsquids
* tmp_qid_hhqid
* tmparhssubjsel
* tmparhssubjsel2
* tmpaz2
* tmpbackpagelist
* tmpbaselinecancer
* tmpndsexports
* tmpndsexportscomp
* tmpnullsinparts
* tmpsex
* twopageerrorpairings
* twopagetiffdirs1
* twopagetiffdirs2
* twopagetiffdirs3
* twopagetiffdirs4
* twopagetiffdirs5
* twopagetiffdirs6
* twopagetiffdirs7
* twopagev2e6
* uerrorlist
* ulitholist
* v2part1
* v2part1_20150126
* v2part1_bak20150623
* v2part1_nulls
* v2part1_original
* v2part1_unmodified
* v2part1bak
* v2part1historya
* v2part1historyb
* v2part2
* v2part2_20150126
* v2part2_bak20150623
* v2part2_nulls
* v2part2_original
* v2part2bak
* v2part2historya
* v2part2historyb
* v2part3
* v2part3_20150126
* v2part3_bak20150623
* v2part3_nulls
* v2part3_original
* v2part3bak
* v2part3bak20171211
* v2part3historya
* v2part3historyb
* v3part1
* v3part1_20150126
* v3part1_bak20150623
* v3part1_nulls
* v3part1_original
* v3part1_unmodified
* v3part1bak
* v3part1historya
* v3part1historyb
* v3part2
* v3part2_20150126
* v3part2_bak20150623
* v3part2_nulls
* v3part2_original
* v3part2bak
* v3part2historya
* v3part2historyb
* v3part3
* v3part3_20150126
* v3part3_bak20150623
* v3part3_nulls
* v3part3_original
* v3part3bak
* v3part3bak20171211
* v3part3historya
* v3part3historyb
* wrapped_rand_view
* writeinfreq