There are several options:
1) One table Employees with relationship to itself, thus able to
contain a hierarchy of employees.
2) Three tables, OrganizationUnits, Positions, Employess, with
relationships as:
- Employees --- are employed in one or more --- Positions
- OrganizationUnits --- offers
Hi All,
Apologies if this has been answered multiple times before but I can't
seem to find a post which answers this question in full rather than
just a subset of it.
Problem: An employee has zero or more managers and at the same time,
might be managing zero or more employees.
Example: CEO
I have recently worked through a similar problem. I'm building a site
to manage characters, and the organizational structure of a military
unit in a game I run in my spare time. In my case i wanted to have
one table to store all of the organizational levels (I called them
divisions), with a
