Advice on Taxonomy Structure

  • swcomm

    (@swcomm)


    8 years ago

    I’m really struggling with sussing this out. I have a CPT for Awards. Awards has a taxonomy for Award Type, and there are 5 types. Awards also has a taxonomy for the Year the award was given. I’ve just discovered that many of the individual award winners have actually won multiple awards in multiple years. Seems silly to have multiple posts for each of these winners, so easy to give them multiple Award Types, but I need that Year tax related to the specific Award Type won that year. Am I stuck with making the Year a child of Award Type, or each Award Type a child of Year? Some of these awards go back to 1944! Either way, that seems like an awful lot of duplication. Any thoughts are appreciated – thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    8 years ago

    I would suggest ditching the award year taxonomy and and record the year of each award through some kind of relational mechanism such as a custom table or through the meta data of the objects involved. Each year record would need to relate to both the CPT and the award term.

    Using object meta data is more WP-like, but more difficult to query due to the relational need. A custom table deviates more from what WP does, but it’s easier to query. The decision of meta or table would revolve around what sort of queries you may need to make.

    Thread Starter swcomm

    (@swcomm)

    8 years ago

    Thanks for this – I kind of came to the same conclusion, but I guess it didn’t occur to me that I could create a custom table. The queries are going to be fairly straightforward – I need to output all award winners by year for each award type; then probably mash up all the award types/years won for the individual posts.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Advice on Taxonomy Structure’ is closed to new replies.