I’m building a website that has a section for programs within the organization. The content within these pages is mostly the same as content in the rest of the site. The difference is that they have categories used for sorting and have some additional information such as a profile image.
In addition to standard content, programs will have news and other types of content associated with them.
I was planning on creating a table for ‘programs’ that contained the extra information, but keep the program static content within the ‘pages’ table along with other static content. There will be multiple pages for each program.
Abbreviated Diagram
pages
id
title
parent
program_id (default:0 or none)
content
programs
id
pages_id
title
profile_image
category
Is there any better way to do this? Should program pages be separate from regular static pages. When I think out other tasks, like assigning permissions, it creates complications either way.