Form Definitions

Most of the forms used by the PHR system are defined in the database:

• the forms table
• the field_descriptions table
• the db_table_descriptions table
• the db_field_descriptions table
• the sample_texts table

Content Lists

These tables provide the content for lists of drugs, medical problems, vaccines, answers to questions such as gender, ethnicity, etc. Basically anything that is displayed as a list of choices for the user.

• the answer_lists table
• the answers table
• the classifications table
• the clinical_maps table
• the data_classes table
• the drug_name_route_codes table
• the drug_name_routes table
• the drug_routes table
• the drug_strength_forms table
• the gopher_term_synonyms table
• the gopher_terms table
• the gopher_terms_mplus_hts table
• the gopher_to_meshes table
• the icd9_codes table
• the list_answers table
• the list_descriptions table
• the list_details table
• the loinc_items table
• the loinc_names table
• the loinc_panels table
• the loinc_units table
• the mplus_drugs table
• the routes table
• the rxhub_frequencies table
• the rxnorm_relations table
• the rxnorm_to_mplus_drugs table
• the rxterms_ingredients table
• the text_list_items table
• the text_lists table
• the text_templates table
• the united_heath_frequencies table
• the vaccines table
• the word_synonyms table
• the versions table

Rules Tables

These tables support the rules system that triggers various reminders and other actions based on the current data for a profile.

• the rules table
• the rule_action_descriptions table
• the rule_actions table
• the rule_cases table
• the rule_db_field_dependencies table
• the rule_dependenices table
• the rule_fetch_conditions table
• the rule_fetches table
• the rule_field_dependencies table
• the rule_labels table
• the rule_sets table
• the rules_forms table
• the loinc_field_rules table
• the forms_rule_sets table
• the expression_conditions table
• the field_conditions table
• the field_expression table
• the comparison_operators table
• the comparison_operators_predefined_fields table
• the predefined_conditions table
• the predefined_expressions table

Validation Tables

These tables support code that validates data entered by a user.

• the field_validation_conditions table
• the field_validations table
• the regex_validators table

Miscellaneous Support Tables

• the schema_migrations table
• the auto_increments table
• the action_params table
• the class_cache_versions table
• the installation_changes table
• the predefined_fields table
• the form_builder_maps table

User Management Tables

• the locks table
• the users table
• the open_id_auth_associations table
• the open_id_auth_nonces table
• the sessions table
• the user_preferences table
• the question_answers table
• the two_factors table
• the userid_guess_trials table
• the email_verifications table

Profile Management Tables

• the profiles table
• the profiles_users table
• the deleted_profiles table
• the share_invitations table

Profile Health Data Tables

• the phrs table
• the phr_allergies table
• the phr_doctor_questions table
• the phr_drugs table
• the phr_immunizations table
• the phr_conditions table
• the phr_surgical_histories table
• the phr_medical_contacts table
• the phr_notes table
• the obr_orders table
• the obx_observations table
• the hist_phrs table
• the hist_phr_allergies table
• the hist_phr_doctor_questions table
• the hist_phr_drugs table
• the hist_phr_immunizations table
• the hist_phr_conditions table
• the hist_phr_surgical_histories table
• the hist_phr_medical_contacts table
• the hist_phr_notes table
• the hist_obr_orders table
• the hist_obx_observations table
• the latest_obx_records table

Reminders Tables

• the date_reminders table
• the health_reminders table
• the reviewed_reminders table
• the reminder_options table
• the hist_date_reminders table
• the hist_reminder_options table

User Actions Tracking Tables

• the autosave_tmps table
• the system_errors table
• the audits table
• the usage_stats table
• the research_data table
• the page_load_times table
• the data_edits table