Hello! This is my first post here.

I'm struggling with where to put a attribute in my relationships.

I have tables
tblCommentList - holds comments made by Contacts
tjcComment_Contact - Junction table between Comment and Contact
Contacts - obvious?

Yes, I know i have some naming to fix.

I am implementing a system which will store all communication. Obviously a comment can be Transmitted by a Contact and Recieved by many Contacts.

Should I store the Transmitter (ie the foreign key for Contact - the person that made the communication) in tblCommentList or in tjxComment_Contact.

I will store Recipients in tjxComment_Contact.

ER Diagram attached below

Thank you very much for your thoughts!

Click image for larger version. 

Name:	2017-09-03_8-51-08.png 
Views:	1 
Size:	31.7 KB 
ID:	17426