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)