Here's the scenario:
- A writer about celebrity gossip posts a node (article) on a Drupal website.
- I have a module that scans the article and automatically creates taxonomy fields based on celebrity names posted in the article.
- These taxonomy "terms" are based on a firstname/lastname list of celebrities that will be high-volume and perpetually growing.
- This list of celebrities will have various fields to render in-depth profiles of the celebrities
- Content nodes can have multiple celebrities attached to it.
- Celebrity nodes can be attached to multiple content nodes.
Here are my assumptions:
- The ever-increasing volume of celebrities and their atypical field requirements make it necessary to create a table specifically for celebrities.
- The taxonomy-to-node relationships are really nothing more than node_id and celebrity_id in a relationship table.
- While writers can tag an article automatically with my module, they will likely need to sometimes add additional celebrities due to misspellings or scanning errors, thus the celebrity firstname and lastname will need to be a part of the tagging process.
- Due to name changes, misspellings, etc, we don't want to use celebrity firstnames and lastnames as unique IDs
So, here are my questions:
- Is there a module already built that renders this functionality?
- Is there a module already built that helps create a taxonomy that can represent a relationship between a node and entities in a custom table, not just a taxonomy table?
- Is this functionality already present in a Drupal distribution somewhere?
- Should I create a custom module to solve this problem (i.e. I won't be re-inventing the wheel)?