Hi,
I think there is no need to save "tid" field in the {faq_weights} table, instead we can acquire it from joining {node} and {term_node} tables. this way we also can store "weight" field in {faq_questions} table a save a noticeable amount of disk space.
are you agree?

Comments

stella’s picture

stella commented
Status: Active » Closed (works as designed)

No, I'm afraid that is needed as a question can appear in more than one category (i.e. be associated with more than one term) and have different weights in each category. Removing the tid field from the faq_weights table would break that functionality.