I have the following tables:
Organization is the parent of both articles and templates.
On the articles index page, I display (by default) all templates for the organization.
Here's my problem. How do I add the ability to customize which templates are shown for each article?
I could create a ArticleTemplates table that has the following schema:
- included_on_article (boolean field that indicates if the template should be included on the article)
But then I see problems with this:
- Adding new records to ArticleTemplates seems clunky, as it would have to change every time a new template was added to the organization.
- As every article usually will have all templates, there will be a lot of records in ArticleTemplates that are the same.
Any better solutions?