I'm looking at creating the following scenario.
Am I correct in thinking I'll need 3 tables in my schema?
Template User TemplateUser
and define the relations within these?
Yes, you are correct. Examples: #1 #2