1
Everybody, good afternoon, everybody.
I’m modeling my database (Mysql) and a question has arisen. In the bank, among others, I have the following tables: Employees - Sectors - Subsidiaries
An Employee works OR in a Headquarters Sector OR in an Affiliate. I wanted to create a relationship between an attribute (local_de_work) table Functionary with the codes (id) table Sector OR TABLE Unity.
Is that possible? How would you do?
You put
OU
, but only for doubt, an employee can have HEADQUARTERS and BRANCH at the same time?– Max Rogério