Revision history  [back]

Hello, if you are creating an importer script, it will be best if you use python calls like user.post_question(), that way all that will be taken care of automatically.

The tagnames field in the question table is a so called denormalized data - simply a copy of tag names associated with the question tags - directly in the question table. That way data loads faster - bypassing the relations to the tag records.

The question_tag table is a bridge table storing assignments of tags to questions and the tag table stores information about tags themselves.