Because employees [EmployeeID] report to other Employees [ReportsTo]. An order belonging to another order hurts my brain.
Andy Gaskell
2009-08-22 02:03:44
Because employees [EmployeeID] report to other Employees [ReportsTo]. An order belonging to another order hurts my brain.
The EmployeeID
is probably being referred to by the ReportTo
field. For example, a given employee reports to another employee, using EmployeeID
as the reference.
The OrderID
does not point to the Order table because there are no other fields in the Order table that uses/refers to the OrderID
.