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

Qing Jin Shi

0
Clinical Trials
0
Meta-Analyses
0
PubMed References
🌿 All Herb data fields for Qing Jin Shi
🌿 Names
Pinyin Name
Qing Jin Shi
中文名 (Chinese)
青金石
Latin Name
Qing Jin Shi
🔗 External References
TCMID
3971
TCM-ID
1688
🔍 Raw view — every non-empty column on this row (18 fields)
name
Qing Jin Shi
chinese name
青金石
pinyin name
Qing Jin Shi
latin name
Qing Jin Shi
tcmid id
3971
herb id str
HERB004524
tcm id id
1688
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