I want to know your opinion and what should be the best approach for this case:
I have 2 tables: - clients; - suppliers;
I create 2 pages so that people leave feedback about the customer and the supplier. With this in mind, the created feedback table.
Now the question is which approach to choose:
1) Create one feedback table with two foreign keys (clientid and supplierid). With this approach, if they leave feedback with the customer, then the FK provider will be empty.
2) create 2 tables called clientfeedbacks and providersfeedback. With this approach, since each table will have only one FK, then the FK will not be empty.
Thank.
source
share