Open SomethingSexy opened 10 years ago
Also open it up to allow multiple manufacturers per collectible.
By opening this up to allow for multiple manufacturers we will need to figure out what to with the categorgy/series stuff. It cannot be tied to manufacturer anymore.
For now I am thinking it gets converted over to be under platform and then existing categories are put under platform. If a category other than root exists, it is copied over under platform, otherwise it is deleted.
Instead of it being manufacturers it should be a company. That way we can add multiple to a collectible who can do different things. If two companies work on a collectible, one produces it and one designs it, etc.
Convert all current manufacturers to company structure.
Collectibles_company table will have link to company, collectible and role they played for this collectible (manufacturer, producer, designer, etc).
We would also remove all restrictions that a company has with tied to collectible types and brands, these should all be independent anyway.