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.

Possible Duplicate:
Database schema documentation for the public data dump and Data Explorer
Which tools and technologies build the Stack Exchange Network?

I am a user on Stack Overflow, and I think every page that shows questions, display all tags and the questions. Are the tags saved in a tags table or are they included together with the questions table?

share|improve this question

marked as duplicate by Martijn Pieters, Manishearth, Shadow Wizard, Diago, Toon Krijthe Dec 19 '12 at 8:34

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

up vote 0 down vote accepted

See Database schema documentation for the public data dump and SEDE

The Posts table has a tags field. But there is also a separate PostTags table with PostId/TagId pairs, probably for faster searches.

The Tags table just contains the tag name, id and the total count of tags.

share|improve this answer
    
Thanks ... Manishearth, you are smart ! –  Michael Antonius Dec 19 '12 at 8:25

Not the answer you're looking for? Browse other questions tagged .