Relationship for a table containing all Comments from the database

[Luthius]

Hello folks
I would like your assistance on how to design a good relationship between tables where we will have a table only for Comments that we will use for the whole system.Instead a field for comments on each table, I will have a table that will contain all the comments so I just need to do a relation between tables.
Find attached the image with the relationships I was imagining.
I created one table intermediate so can "receive" the Primary Keys as per table "demands".
With this we can have more tables and the comments will be related on this intermediate table. What do you think??? I need to find a way.

 

[xenou]

There's always advantages and disadvantages. I'd probably have a separate table for each type of note personally, but I've already said that It's up to you.

 

[Micron]

I'd probably have a separate table for each type of note personally, but I've already said that It's up to you.

Ditto - post #2.

 

[Luthius]

This is very interesting once we don't have a proper technical reason.

I think the best way is testing and monitor its performance.
Remember that along time entity-relationship models and new database techniques were developed. Who knows maybe we can have a big leap on this type of approach. Just kidding.