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.
🌿
Herb
6,826
→
⚗️
Ingredient
44,598
→
🧬
Gene Target
15,695
→
🏥
Disease
30,467
→
🧪
Evidence
23,295
trials · metas · refs
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
HERB DB
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
莰梨; 文光果; 团糖二; 油刺果
📜 Related Formulas
6 · contains this herbJin Ci Shen Jiu Zheng Mixture
Jin Ci Shen Jiu Zheng He Ji
Kang Ai Fu Zheng Capsule
Kang Ai Fu Zheng Jiao Nang
Xian Ren Zhang Wei Kang Capsule
Xian Ren Zhang Wei Kang Jiao Nang
Xiao Pi He Wei Capsule
Xiao Pi He Wei Jiao Nang
Xiao Er Xiao Shi Kai Wei Granule
Xiao Er Xiao Shi Kai Wei Ke Li
Xue Zhi Ping Capsule
Xue Zhi Ping Jiao Nang
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_pinyinmatchingherbs.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