clinics schema
Go back to database start page
This schema contains tables related to the Calibration and Pilot clinics.
== Tables: ==
* allclinicsubjects
* bcs_containerinfo
* bcs_containers
* bcs_samples
* bcs_samples_bak20150123
* bcs_storage
* bcs_subjects
* bloodids
* calibrationextrainformation
* calibrationfielddata
* calibrationsubjects
* campmeeting
* chuloc
* clinicspreadsheets2018
* clinictrips
* dataset20071023
* delete_viewintroall_p
* delete_viewintroselected_p
* dfoodids
* dr
* dtproperties
* eachrecall
* fielddata
* fielddata_calibration
* fielddata_pilot
* fielddatabackup
* fielddatabackup2
* ifur0506lomalinda
* ifurllu0801aupdate
* ifurllu2_081105
* jackys429
* jackyslist20081031
* jackysqredata
* jackyssunexposuredata
* jackyssunexposuredata2
* jackysvegestatus
* labs
* labs_adipose_carotenoids_fa_ucla_adipose_carotenoids
* labs_adipose_carotenoids_fa_ucla_adipose_fatty_acid
* labs_adipose_carotenoids_fa_ucla_ascorbic_acid
* labs_adipose_carotenoids_fa_ucla_creatinine
* labs_adipose_carotenoids_fa_ucla_ferritin_pth
* labs_adipose_carotenoids_fa_ucla_plasma_carotenoids
* labs_adipose_carotenoids_fa_ucla_rbc_folate
* labs_blood_125_2oh_vit_d3
* labs_blood_25_oh
* labs_carot_fin_566_samppth_121108_plasma_6475_12211
* labs_carot_fin_data_566_samppth_121108_pth_results_17_3000
* labs_carotenoid_first_257_091908
* labs_carotenoids_final_data_566_samplespth_121108_plasma_17_3301
* labs_carotenoids_final_data_566_samplespth_121108_plasma_6475_1
* labs_carotenoids_final_data_566_samplespth_121108_pth_results_2
* labs_carotenoids_final_data_800_pt_results
* labs_carotenoids_plasma_final
* labs_data_summary_adipose_carotenoids
* labs_data_summary_ascorbic_acid
* labs_data_summary_creatinine
* labs_data_summary_entire_study_inventory
* labs_data_summary_ferritin_pth
* labs_data_summary_plasma_carotenoids
* labs_data_summary_rbc_folate
* labs_fer_combined
* labs_ferr_crp_201705
* labs_holotc
* labs_ifpl_lomalinda0612
* labs_ifur0506lomalinda
* labs_ifurllu0801a
* labs_ifurllu0801aupdate
* labs_ifurllu2_081105
* labs_ifurllu_combined
* labs_ipt_12242008
* labs_isothiocyanate
* labs_masterlist
* labs_methyl_histidine_loma_linda
* labs_na_k
* labs_plasma_carotenoids_12242008
* labs_plasma_carotenoidsl_ferritin_vitc_ucla_ascorbic_acid
* labs_plasma_carotenoidsl_ferritin_vitc_ucla_ferritin_pth
* labs_plasma_carotenoidsl_ferritin_vitc_ucla_plasma_carotenoids
* labs_pth_combined
* labs_serumvitaminb12
* labs_solserum_ferrrec_201705
* labs_specialty_lab_randomsampleset100
* labs_sucrose_and_fructose
* labs_urine_flavonoids_first_100_submit_091908
* labs_urine_id_links
* labs_urine_isoflavone_and_lignans_results_060605
* labs_vb12_eh_2017
* location
* mssqltables
* nds_drs
* paf_ah
* par
* par_activities
* par_activities_backup20141120
* par_audio
* par_backup20141120
* par_enumeration
* par_summary
* pilotfielddata
* pilotsubjects
* racecodes
* rbc_calibration_05032024
* remaining_rbc_20240126
* remainingserum20200713
* seruminventory201808
* sohd
* subjects
* sunexposurev2
* sunexposurev22
* sunexposurev3
* supportsubstudysubstudies
* supportsubstudysubstudiesbak
* sysconstraints
* syssegments
* tarnfayth202409
* telomereid
* tempfindreplacements
* tempintakevalues
* tmp
* tmp_bc_qid_squid
* tmpca
* tmpcadiet
* tmpcarotenoid
* tmpcasupp
* tmpdairyfat
* tmpdairypro
* tmpdrsfromru
* tmpfat
* tmpfol
* tmpkcal
* tmpkcal100
* tmpkcal20070625
* tmpkcal20070928
* tmpmfa
* tmpmg
* tmpnutri1
* tmpp182
* tmpp183
* tmpp183old
* tmpp204
* tmpp205
* tmpp226
* tmppeanuts
* tmppeanutsold
* tmppfa
* tmppro100
* tmpru
* tmpseeds
* tmpsfa
* tmpshortqids
* tmpsoypro
* tmpsqlithos
* tmpsubjectsvddiet_sq
* tmptreenuts
* tmpvc
* tmpvddiet
* tmpvdhits_m
* tmpvdhits_sq
* tmpvdsupp
* viewintroselected
* viewintrotest
* vitd25oh
* vwintrosubjects