Sorry if the title is confusing but I couldn't think of a way to properly word this question without laying out what I am trying to do.
Basically I have 3 tables and I'm trying to figure out how to best relate them all given the constraint that each Template should have a region but necessarily doesn't have to country.
Template id name description country_id Country id name region_id Region id name
Two solutions that I've come up with but am not really satisfied with are:
add region specific country records to the country table that have no real country value but have a relationship to an existing region. For example:
name: North America
region: 1 -> North America
Solution 2 seems the simplest but I also feel like its not the most elegant solution because I am creating these "fake" country records.