I have a website called http://overmvp.com. On this site, there are multiple "Heroes". Each hero has been manually added to the database in a custom table.
With this, I need to create a guide. So for example, I would need to be able to create a guide for a specific "Hero". For that, I've created a custom post type called "Guides", and also a Taxonomy. In the Taxonomy, I've re-added all the "Heroes" that I've previously added in the database. (So they are not duplicated) So now, I can create a guide for a specific hero.
But now my problem is that I have to add more types to a guide. So for example, I want to show "Guides" of a specific type of "Hero". So I need to write down the type of that hero somewhere.
As with "Hero Types", I would also need to be able to mark them as, featured guide or things like that.
My first guess was to add a custom field to the Taxonomy, so for every hero, I would add the type of the hero, but I fell that I am duplicating the heroes, types, pretty much every information they have.
So is there another way I should incorporate the "Heroes" into my website, so I can use them in my custom post type directly and not duplicate them like I do ?
What are your thoughts on this?