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

Spriferida Fossil

0
Clinical Trials
0
Meta-Analyses
0
PubMed References
🌿 All Herb data fields for Spriferida Fossil
🌿 Names
Pinyin Name
Shi Yan
中文名 (Chinese)
石燕
Latin Name
Fossilia Spiriferis
English Name
Spriferida Fossil
Alias Names
石燕子; 大石燕; 燕子石
☯ TCM Properties
Properties (性味)
Salty; Cool
Meridians (归经)
Kidney; Bladder
Part Used
Fossil
🩺 Clinical Profile
Function (功能)
Clear damp-heatdisinhibit urineeliminate eye screens
Indication (主治)
Gonorrhea; Inconvenience in urination; Under wet tropical conditions; Blood in urine and constipation; Intestinal wind and hemorrhoids leakage;
🔗 External References
TCMID
3196
TCM-ID
1957
🔍 Raw view — every non-empty column on this row (26 fields)
name
Spriferida Fossil
chinese name
石燕
pinyin name
Shi Yan
latin name
Fossilia Spiriferis
english name
Spriferida Fossil
properties english
Salty; Cool
meridians english
Kidney; Bladder
use part
Fossil
tcmid id
3196
herb id str
HERB005097
function text
Clear damp-heatdisinhibit urineeliminate eye screens
indication
Gonorrhea; Inconvenience in urination; Under wet tropical conditions; Blood in urine and constipation; Intestinal wind and hemorrhoids leakage;
tcm id id
1957
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