I’m not sure what the best approach to this is:
I have two tables in the DB, one is say global_resources, and the other
is specific_resources. The global_resources table is going to be a
global set of resources that can be used on any project. The
specific_resources link to the global, and have additional fields. So
basically you can drag a resource (global) to a project, or add a new
one. If you’re adding a new one, and it doesn’t exist in the
global_resources table, it needs to be added there, and the
specific_resources table as well.
Here’s the structure of the tables:
I’m not sure how the best way to setup the view, models, and the
controllers to save the resources in the right spots.
Any help you can provide is greatly appreciated.