'Is it correct to keep the ids of different related tables in the database?
I have two different entities for employees and managers, but they have one common attribute, in the announcements table is it right even if I did not send any announcement to the employee or manager?
Solution 1:[1]
Yes it is,it is actually quite common.
What you got is a bridge table between employee and manager, and you added necessary column to the table, which enhance the bridge table.
If there is no relation ship between employee and manager, if you doun't sed announcement, then ther is no entry in the bridge table, you can chekc i the table if an employee never got such an announcement or how many he got
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | nbk |