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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.