Non-synonyms in concept_synonym table

[timchurches]

Forum link: https://forums.ohdsi.org/t/confused-by-select-from-concept-synonym-where-concept-id-40355052/12863

select * from concept_synonym where concept_id = 40355052

concept_id 40355052 in the concepts table is Keratosis follicularis (aka Darier’s disease). However there are rows for Milroy’s disease, Mongolian spots and various other unrelated conditions (and definitely non-synonymous) things in the concept_synonym table that also have a concept_id value of 40355052.

Another example:

select * from concept_synonym where concept_id == 40322471