[wp-hackers] A "terms" table

[Ryan Boren]

On 4/15/07, Ryan Boren <ryan at boren.nu> wrote:
> > As for some of the bit and count fields currently causing grief, I would
> > argue the solution for that isn't a separate tags table, but a separate
> > table specifically for that type of data. In Drupal for this
> > infrastructure they have a term_data, term_hiercharchy, term_node,
> > term_relation, term_synonym, vocabulary, and vocabulary_node_types
> > tables. I think that might be a little more than we need, but there are
> > some concepts there we could pretty cleanly combine into a single extra
> > table that isn't called categories or tags, and will provide a good and
> > scalable foundation for years to come.
>
> The presence of category_parent and the count fields are the crux of
> my problem with the unified table.  They cause a lot of grief and kill
> any future-proofing you think you're getting by having a unified terms
> table.  If you're open to a new table for this information, I think I
> could get behind that.  I'll give it some thought.

For everyone's perusal, the drupal schema can be found here (scroll down):

http://cvs.drupal.org/viewcvs/drupal/drupal/modules/system/system.install?rev=1.92&view=markup

Taxonomy code:

http://cvs.drupal.org/viewcvs/drupal/drupal/modules/taxonomy/taxonomy.module?rev=1.351&view=markup