What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 128 Stack Exchange communities.

http://data.stackexchange.com/stackoverflow/query/new

**Tags**
Id
TagName

**TagSynonyms**
Id
SourceTagName
TargetTagName
AutoRenameCount

(There's no foreign key relation between the two)

I type sdk in Tags field in stackoverflow.
It shows iphone because iphone-sdk is a synonym for iphone (and SO obviously sort tag list by used-count)

Isn't having a foreign key to Tags instead of TargetTagName better than the shown schema to do the job(return the sorted tag-list)?

share|improve this question

You must log in to answer this question.

Browse other questions tagged .