Harudooal

Tables (57)

All Evidence Sources (all_evidence_sources)

  • Mapping ID (mapping_id) — Foreign key → Health Nutrient Mappings.Mapping ID — NOT NULL
  • DOI (doi)
  • Priority Score (priority_score)

Calculation (calculation)

  • Question ID (question_id) — Foreign key → Question.Question ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Question.Dimension Code — NOT NULL
  • Direction (direction)
  • Reverse Coding (reverse_coded)
  • Weight (weight)
  • Equation (equation)

Clinical Applications (clinical_applications)

  • Name (name) — Primary key — NOT NULL
  • Recommended Forms (recommended_forms)
  • Dosage (dosage)
  • Duration (duration)
  • Evidence DOI (evidence_doi)
  • Note (note)
  • Benefits (benefits)
  • Nutrients ID (nutrients_id) — Foreign key → Nutrients HBTI 06.Nutrients ID — NOT NULL

Clinical Symptoms (clinical_symptoms)

  • Symptom ID (symptom_id) — Primary key — NOT NULL
  • Korean Symptom Name (symptom_name_ko)
  • Threshold (threshold)
  • Severity (severity)
  • Description (description)
  • Question ID (question_id) — Foreign key → Question_Nutrient.Question ID — NOT NULL
  • Nutrient ID (nutrient_id) — Foreign key → Question_Nutrient.Nutrient ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Question_Nutrient.Dimension Code — NOT NULL

Conflicts (conflicts)

  • Nutrients Name (nutrients_name) — Primary key — NOT NULL
  • Issue (issue)
  • Solution (solution)
  • Evidence (evidence)
  • Severity (severity)
  • Nutrients Name (nutrients_name2) — Foreign key → Intersections.Nutrients Name — NOT NULL

Daily Recommended Amount (daily_recommended_amount)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL
  • Unit (unit)
  • Adult Male (adult_male)
  • Adult Female (adult_female)
  • Pregnant (pregnant)
  • Elderly Male (elderly_male)
  • Elderly Female (elderly_female)

Dimension Metadata (dimension_metadata)

  • Dimension Code (dim_code) — Primary key — NOT NULL
  • Dimension Korean Name (dimension_name_ko) — NOT NULL
  • Dimension Name (dimension_name_en)
  • Description (description)

Dosage Guidelines (dosage_guidelines)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL
  • Starting Dose (starting_dose)
  • Target Dose (target_dose)
  • Maximum Dose (maximum_dose)

Drug Interactions (drug_interactions)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL
  • Drug (drug)
  • Effect (effect)
  • Management (management)

Evidence (evidence)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrient.Nutrient ID — NOT NULL
  • Study Population (study_population)
  • Study Region (study_region)
  • Sample Size (sample_size)
  • Study Design (study_design)
  • Intervention (intervention)
  • Outcome (outcome)
  • Effect Size (effect_size)
  • DOI (doi)
  • PMID (pmid)
  • Key Finding (key_finding)
  • Recommended Dosage (recommended_dosage)
  • Minimum Duration (minimum_duration)
  • Evidence Level (evidence_level)

Evidence HBTI 06 (evidence_hbti_06)

  • Ingredient ID (ingredient_id) — Foreign key → Ingredient Forms.Ingredient ID — NOT NULL
  • Type of Study (type_of_study)
  • DOI (doi)
  • PMID (pmid)
  • Year (year)
  • Title (title)
  • Finding (finding)

Expected Correlation (expected_correlation)

  • QID (qid)
  • Nutrient ID (nutrient_id) — Foreign key → Validation.Nutrient ID — NOT NULL

Food Sources (food_sources)

  • Food (food) — Primary key — NOT NULL
  • Amount per 100g (amount_per_100g)
  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL

General Considerations (general_considerations)

  • Nutrients ID (nutrients_id) — Foreign key → Nutrients HBTI 06.Nutrients ID — NOT NULL
  • Timing (timing)
  • Avoid with (avoid_with)
  • Synergies (synergies)
  • Cycling (cycling)
  • Storage (storage)
  • Notes (notes)

HBTI 03 (hbti_03)

  • MID (mid) — Primary key — NOT NULL
  • Nutrients Name (nutrients_name) — Foreign key → Intersections.Nutrients Name — NOT NULL
  • Version (version)
  • Last Updated (last_updated)
  • Description (description)
  • Source (source)

Health Concerns (health_concerns)

  • Concern ID (concern_id) — Primary key — NOT NULL
  • Mapping ID (mapping_id) — Foreign key → Question Health Mappings.Mapping ID — NOT NULL
  • MID (mid) — Foreign key → Question Health Mappings.MID — NOT NULL
  • Priority (priority)
  • Weight (weight)
  • Korean Concern Name (concern_name_ko)
  • English Concern Name (concern_name_en)

Health Concerns Taxonomy (health_concerns_taxonomy)

  • Concern ID (concern_id) — Primary key — NOT NULL
  • Korean Concern Name (concern_name_ko)
  • English Concern Name (concern_name_en)
  • Category (category)
  • Description (description)
  • MID (mid) — Foreign key → Metadata HBTI 05.MID — NOT NULL
  • MID (mid2) — Foreign key → Metadata HBTI 07.MID — NOT NULL

Health Impact (health_impact)

  • Question ID (question_id) — Foreign key → Question.Question ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Question.Dimension Code — NOT NULL
  • Primary Aspects (primary_aspects)
  • Second Aspects (second_aspects)
  • Risk Indicators (risk_indicators)

Health Nutrient Mappings (health_nutrient_mappings)

  • Mapping ID (mapping_id) — Primary key — NOT NULL
  • Nutrient ID (nutrient_id) — Foreign key → Nutrients Taxonomy.Nutrient ID — NOT NULL
  • Concern ID (concern_id) — Foreign key → Health Concerns Taxonomy.Concern ID — NOT NULL
  • Recommendation Strength (recommendation_strength)
  • Confidence Score (confidence_score)
  • Evidence Count (evidence_count)
  • Recommended Dosage (recommended_dosage)
  • Minimum Duration (minimum_duration)
  • Mechanism (mechanism)
  • Synergies (synergies)
  • Contraindications (contraindications)
  • Korean Population Data (korean_population_data)

Ingredient Forms (ingredient_forms)

  • Ingredient ID (ingredient_id) — Primary key — NOT NULL
  • Nutrients ID (nutrients_id) — Foreign key → Nutrients HBTI 06.Nutrients ID — NOT NULL
  • Korean Ingredient Name (ingredient_name_ko)
  • English Ingredient Name (ingredient_name_en)
  • Form Type (form_type)
  • API Names (api_names)
  • API Note (api_note)
  • Biovailability (bioavailability)
  • Absorption Rate (absorption_rate)
  • Absorption Rate Unit (absorption_rate_unit)
  • Absorption Mechanism (absorption_mechanism)
  • Best for (best_for)
  • Advantages (advantages)
  • Disadvantages (disadvantages)
  • Timing (timing)
  • Take with (take_with)
  • Contraindications (contraindications)
  • Interactions (interactions)
  • Cost Tier (cost_tier)
  • Relative Cost (relative_cost)
  • Availability Score (availability_score)
  • Availability Note (availability_note)
  • Recommendation Priority (recommendation_priority)
  • Priority Reasoning (priority_reasoning)

Intersections (intersections)

  • Nutrients Name (nutrients_name) — Primary key — NOT NULL
  • Max Single Dose (max_single_dose)
  • Max Daily Dose (max_daily_dose)
  • Warnings (Field3)

Level (level)

  • Code (code)
  • Name (name)
  • Korean Name (name_ko)
  • Criteria (criteria)
  • Dimension Code (dim_code) — Foreign key → Type Assessment.Dimension Code — NOT NULL

MFDS Integration (mfds_integration)

  • MID (mid) — Foreign key → Metadata.MID — NOT NULL
  • Integrated (integrated)
  • API Service (api_service)
  • Total Categories Covered (total_categories_covered)
  • Missing Nutrients Added (missing_nutrients_added)
  • Consolidated to (consolidated_to)
  • Integration Date (integration_date)

Measurement (measurement)

  • Question ID (question_id) — Foreign key → Question.Question ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Question.Dimension Code — NOT NULL
  • Measures (measures)
  • What to detect (what_to_detect)
  • Behavioral Indicator (behavioral_indicator)
  • Time Frame (time_frame)

Mechanism for Conditions (mechanism_for_conditions)

  • Name (name)
  • Content (content)
  • Ingredient ID (ingredient_id) — Foreign key → Ingredient Forms.Ingredient ID — NOT NULL

Metadata (metadata)

  • MID (mid) — Primary key — NOT NULL
  • Description (description)
  • Version (version)
  • Last Updated (last_updated)
  • Total Nutrients (total_nutrients)
  • Data Source (data_source)
  • Note (note)

Metadata HBTI 04 (metadata_hbti_04)

  • MID (mid) — Primary key — NOT NULL
  • Total Count (total_count)
  • Expected Count (expected_count)
  • API Service (api_service)
  • Data Source (data_source)

Metadata HBTI 05 (metadata_hbti_05)

  • MID (mid) — Primary key — NOT NULL
  • Version (version)
  • Last Updated (last_updated)
  • Description (description)
  • Data Source (data_source)
  • Evidence Quality (evidence_quality)
  • Total Mappings (total_mappings)
  • Unique Concerns (unique_concerns)
  • Unique Nutrients (unique_nutrients)
  • Average Evidence per Mapping (average_evidence_per_mapping)

Metadata HBTI 06 (metadata_hbti_06)

  • MID (mid) — Primary key — NOT NULL
  • Version (version)
  • Created (created)
  • Description (description)
  • Total Nutrients (total_nutrients)
  • Total Forms (total_forms)
  • Source (source)
  • Coverage (coverage)

Metadata HBTI 07 (metadata_hbti_07)

  • MID (mid) — Primary key — NOT NULL
  • Version (version)
  • Last Updated (last_updated)
  • Description (description)
  • Data Source (data_source)
  • Extraction Method (extraction_method)
  • Evidence Level (evidence_level)
  • Total Mappings (total_mappings)
  • Total Questions Covered (total_questions_covered)
  • Future Enhancements (future_enhancements)

Metadata HBTI 2 (metadata_hbti_2)

  • MID (mid) — Primary key — NOT NULL
  • Description (description)
  • Version (version)
  • Last Updated (last_updated)
  • Total Nutrients (total_nutrients)
  • Total Ingredient Variants (total_ingredient_variants)
  • Approach (approach)
  • Normalization (normalization)
  • Note (note)

Nutrient (nutrient)

  • Nutrient ID (nutrient_id) — Primary key — NOT NULL
  • Condition (condition)
  • Condition Basis (condition_basis)
  • Priority (priority)
  • Priority Score (priority_score)
  • Korean Reason (reason_ko)
  • Mechanism (mechanism)

Nutrients HBTI 06 (nutrients_hbti_06)

  • Nutrients ID (nutrients_id) — Primary key — NOT NULL
  • MID (mid) — Foreign key → Metadata HBTI 06.MID — NOT NULL
  • Korean Nutrients Name (nutrient_name_ko)
  • English Nutrient Name (nutrient_name_en)
  • Abbreviation (abbreviation)
  • Botanical Name (botanical_name)
  • Components (components)
  • Category (category)
  • Subcategory (subcategory)
  • Total API Variants (total_api_variants)
  • Total Product Occurrences (total_product_occurrences)
  • Market Status (market_status)
  • Deficiency Risk Factors (deficiency_risk_factors)

Nutrients Taxonomy (nutrients_taxonomy)

  • Nutrient ID (nutrient_id) — Primary key — NOT NULL
  • Korean Nutrient Name (nutrient_name_ko)
  • English Nutrient Name (nutrient_name_en)
  • Category (category)
  • Description (description)
  • MID (mid) — Foreign key → Metadata HBTI 05.MID — NOT NULL

Nutrients_HBTI_01 (nutrients_hbti_01)

  • Nutrient ID (nutrient_id) — Primary key — NOT NULL
  • Korean Name (name_ko)
  • English Name (name_en)
  • Category (category)
  • Subcategory (subcategory)
  • Description (description)
  • Functions (functions)
  • Deficiency Symptoms (deficiency_symptoms)
  • Optimal Form (optimal_form)
  • Overdose Symptoms (overdose_symptoms)
  • Contraindications (contraindications)
  • Syngergistic Nutrients (syngergistic_nutrients)
  • MID (mid) — Foreign key → Metadata.MID — NOT NULL

Nutrients_HBTI_02 (nutrients_hbti_02)

  • Nutrients ID (nutrients_id) — Primary key — NOT NULL
  • MID (mid) — Foreign key → Metadata HBTI 2.MID — NOT NULL
  • Korean Name (name_ko)
  • API Ingredient Names (api_ingredient_names)
  • Total Variants (total_variants)
  • Total Occurrences (total_occurrences)

Parts (parts)

  • PID (pid) — Primary key — NOT NULL
  • MID (mid) — Foreign key → Metadata.MID — NOT NULL
  • Nutrients (nutrients)
  • Source (source)
  • Original File (original_file)

Pharmacokinetics (pharmacokinetics)

  • Ingredient ID (ingredient_id) — Foreign key → Ingredient Forms.Ingredient ID — NOT NULL
  • TMAX (tmax)
  • Half Life (half_life)
  • Cmax Withanolide A (cmax_withanolide_a)
  • Bioavailability_Note (bioavailability_note)

Primary Evidence (primary_evidence)

  • Mapping ID (mapping_id) — Foreign key → Health Nutrient Mappings.Mapping ID — NOT NULL
  • Condition Basis (condition_basis)
  • DOI (doi)
  • PMID (pmid)
  • Study Design (study_design)
  • Sample Size (sample_size)
  • Outcome (outcome)
  • Effect Size (effect_size)
  • Key Finding (key_finding)
  • Evidence Level (evidence_level)

Products (product)

  • Prdlst Report No (prdlst_report_no) — Primary key — NOT NULL
  • SHAP (shap)
  • PRMS DT (prms_dt)
  • Last Updated Date (last_updt_dtm)
  • Product SHAP CD NM (prdt_shap_cd_nm)
  • LCNS NO (lcns_no)
  • CRET DTM (cret_dtm)
  • Prdlst NM (prdlst_nm)
  • IFTKN ATNT MATR CN (iftkn_atnt_matr_cn)
  • BSSH NM (bssh_nm)
  • STDR STND (stdr_stnd)
  • DISPOS (dispos)
  • Primary Fnclty (primary_fnclty)
  • POG DAYCNT (pog_daycnt)
  • CSTDY MTHD (cstdy_mthd)
  • NTK MTHD (ntk_mthd)
  • RAWMTRL NM (rawmtrl_nm)
  • MID (mid) — Foreign key → Metadata HBTI 04.MID — NOT NULL

Question (question)

  • Question ID (question_id) — Primary key — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Dimension Metadata.Dimension Code — NOT NULL
  • Question Number (question_number)
  • Subcategory (subcategory)
  • Korean Subcategory (subcategory_korean)
  • Question (question_en)
  • Korean Question (question_ko)
  • Korean Short Question (question_short_ko)
  • Help Text (help_text)

Question Health Mappings (quesion_health_mappings)

  • Mapping ID (mapping_id) — Primary key — NOT NULL
  • MID (mid) — Foreign key → Metadata HBTI 07.MID — NOT NULL
  • Dimension (dimension)
  • Question ID (question_id)
  • Korean Question Short (question_short_ko)
  • Condition (condition)
  • Condition Basis (condition_basis)
  • Source Nutrient HInts (source_nutrient_hints)
  • Extraction Method (extraction_method)
  • Matched Keywords (matched_keywords)
  • Direct Clinical Evidence (direct_clinical_evidence)
  • Epidemiological Data (epidemiological_data)
  • Expert Guidelines (expert_guidelines)

Question_Nutrient (question_nutrient)

  • Question ID (question_id) — Foreign key → Question.Question ID — NOT NULL
  • Nutrient ID (nutrient_id) — Foreign key → Nutrient.Nutrient ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Question.Dimension Code — NOT NULL

Recommendation Summary (recommendation_summary)

  • Nutrients ID (nutrients_id) — Foreign key → Nutrients HBTI 06.Nutrients ID — NOT NULL
  • Best Overall (best_overall)
  • Best Value (best_value)
  • Most Available Korea (most_available_korea)
  • For Stress (for_stress)
  • For Sleep (for_sleep)
  • For Performance (for_performance)
  • Avoid (avoid)

Requires (requires)

  • Nutrients Name (nutrients_name) — Primary key — NOT NULL
  • Reason (reason)
  • Evidence (evidence)
  • Dosage (dosage)
  • Severity (severity)
  • Note (note)
  • Nutrients Name (nutrients_name2) — Foreign key → Intersections.Nutrients Name — NOT NULL

Response Options (response_options)

  • Question ID (question_id) — Foreign key → Question.Question ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Question.Dimension Code — NOT NULL
  • Value (value)
  • Korean Label (label_ko)
  • Description (description)
  • Score Contribution (score_contribution)

Risk Indicator (risk_indicator)

  • Question ID (question_id) — Foreign key → Health Impact.Question ID — NOT NULL
  • Dimension Code (dim_code) — Foreign key → Health Impact.Dimension Code — NOT NULL
  • Low Score (low_score)
  • High Score (high_score)

Scoring (scoring)

  • Dimension Code (dim_code) — Foreign key → Dimension Metadata.Dimension Code — NOT NULL
  • Total Questions (total_questions)
  • Max Score (max_score)
  • Min Score (min_score)
  • Threshold (threshold)

Side Effects (side_effects)

  • Ingredient ID (ingredient_id) — Foreign key → Ingredient Forms.Ingredient ID — NOT NULL
  • Common (common)
  • Rare (rare)
  • Serious (serious)

Standardization (standardization)

  • Ingredient ID (ingredient_id) — Foreign key → Ingredient Forms.Ingredient ID — NOT NULL
  • Withanolides Content (withanolides_content)
  • Withanolides Unit (withanolides_unit)
  • Extraction Ratio (extraction_ratio)
  • Method (method)

Supplement Forms (supplement_forms)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL
  • Form (form)
  • Bioavailability (bioavailability)
  • Best for (best_for)
  • Side Effects Minimal (side_effects_minimal)
  • Note (note)

Timing (timing)

  • Nutrient ID (nutrient_id) — Foreign key → Dosage Guidelines.Nutrient ID — NOT NULL
  • For Sleep (for_sleep)
  • For Stress (for_stress)
  • With Meals (with_meals)

Timing_HBTI_03 (timing_hbti_03)

  • Nutrients Name (nutrients_name) — Foreign key → Intersections.Nutrients Name — NOT NULL
  • Preferred (preferred)
  • Avoid (avoid)
  • Split Dose (split_dose)
  • Best Times (best_times)

Type Assessment (type_assessment)

  • Dimension Code (dim_code) — Foreign key → Scoring.Dimension Code — NOT NULL

Upper Limit (upper_limit)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL
  • Unit (unit)
  • Adult (adult)
  • Note (note)

Usage in HBTI (usage_in_hbti)

  • Nutrient ID (nutrient_id) — Foreign key → Nutrients_HBTI_01.Nutrient ID — NOT NULL
  • Usage Count (usage_count)
  • Questions Used (questions_used)
  • Primary Indications (primary_indications)
  • Importance (importance)

Validation (validation)

  • Nutrient ID (nutrient_id) — Foreign key → Evidence.Nutrient ID — NOT NULL
  • Cross Check Questions (cross_check_questions)