I have a number of solutions for this problem but want to choose the correct one and hope to hear a consensus of what experts think one having one table (Notes) which can have references to many tables.
So imagine you have a Company, User and Trade table. Users belong to companies and trades belong to users which is all well laid out. Now, I have to resolve the issue of how to resolve Notes because each of those tables can have notes. So you can have notes for a person and/or company and/or trades.
What is the best way to implement this?
Oracle 12c with millions of rows per year with a minimum of 7 years activity.
Any help is GREATLY appreciated.
Thanks in advance,