Multi-Models


#1

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:

global_resources
id
name
description

specific_resources
id
global_resource_id
Addition fields

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.