AlternativeMed
Relationship Graph Explorer

Follow the connections

Every herb, ingredient, formula, gene target, and disease — connected through real research. Search, pick a subject, and navigate the graph in any direction.

Plus 6,743 TCM formulas connecting herbs together
🌿 Herb

Roxburgh Rose

0
Clinical Trials
0
Meta-Analyses
0
PubMed References
🌿 All Herb data fields for Roxburgh Rose
🌿 Names
Pinyin Name
Ci Li
中文名 (Chinese)
刺梨
Latin Name
Fructus Rosae Roxburghii
English Name
Roxburgh Rose
Alias Names
莰梨; 文光果; 团糖二; 油刺果
☯ TCM Properties
Properties (性味)
Sweet; Sourastringent
Meridians (归经)
Spleen; Kidney; Stomach
Part Used
Fruit
🩺 Clinical Profile
Function (功能)
To fortify stomach, disperse food, check diarrhea.
Indication (主治)
Food accumulation distention and fullness, enteritis and diarrhea.
🔗 External References
TCMID
2426
🔍 Raw view — every non-empty column on this row (25 fields)
name
Roxburgh Rose
chinese name
刺梨
pinyin name
Ci Li
latin name
Fructus Rosae Roxburghii
english name
Roxburgh Rose
properties english
Sweet; Sourastringent
meridians english
Spleen; Kidney; Stomach
use part
Fruit
tcmid id
2426
herb id str
HERB000927
function text
To fortify stomach, disperse food, check diarrhea.
indication
Food accumulation distention and fullness, enteritis and diarrhea.
alias name
莰梨; 文光果; 团糖二; 油刺果
How relationships are computed
  • Clinical Trials / Meta-Analyses / References: direct foreign-key link via subject_entity_id (Phase 2d wireup)
  • Formula ↔ Herbs: text bridge via formulas.herbs_in_pinyin matching herbs.pinyin_name
  • Herb ↔ Ingredient: ACTIVE — direct link via herb_ingredients
  • Ingredient ↔ Target: ACTIVE — direct link via ingredient_targets
  • Target ↔ Disease: ACTIVE — direct link via target_health_topics
  • Herb → Target → Disease (full chemical spine): ACTIVE — joins all three link tables