I have a table called 'notes', on this table I need to track who made that note, but the problem is that the creator of the note can be a user stored in one of three possible tables:

> 
> users
>  leads
>  managers
> 
> 
> 

I have though of simply create three fields on 'notes' to represent the three possible relations: note.user, note.lead, note.manager

With this approach I would be forced to create three table joins when requesting the notes to gather the creators information, and I don't think that is the way to go, so I would like to hear your ideas or comments and what would be the best approach on this.