Database Server

General Details

The vast majority of data is stored in a database server (MySQL) with access restricted by account management on the database server.

== Physical location ==
* Nichol Hall, in the server closet just outside the AHS-2 double-doors.
== Network location ==
* 151.112.25.18:3306
* can connect using JDBC driver or with software that support direct connections such as R Studio.

Database Schemas

* ahsmaster

* This is what was historically referred to as the "mailroom database."
* The names, addresses, phone numbers, emails, etc. for all of our subjects are the core of this schema.
* analysis

* This is generally where data in some stage of preparation for use by researchers goes.
* analysis_restore
* This is a restored backup, which was used when some of Fayth's data was lost/corrupted.
* Could be removed.
* arhs

* Clinic data for the Religion study, wave 1
* arhs2

* Clinic data for the Religion study, wave 2
* bcs
* Unused.
* biostorage

* This contains tracking data for laboratory sample storage.
* cancer

* Cancer data, mostly from the cancer registries, but also some of Barbara's work, are stored here.
* clinics

* Calibration and Pilot clinic data are stored here.
* hps

* HPS stands for Heart Pilot Study.
* This actually contains both the pilot and the heart study data.
* image

* All of the scanned data from physical questionnaires went straight into this database.
* lime
* Unused. This was for the online questionnaire prototype.
* nutrition

* Dietary data, such as nutrient data and write-in processing.
* sakila
* Example DB. Can be removed.
* sys
* Essential system DB that is used by MySQL. No need to access this.
* webquest
* This was created for processing data from the online questionnaire. I don't believe Miguel wants to continue using this.
* world
* Unused.