Reference

Reference Data Model

Data Model

OtherEvergreenPublic
  • Employee table
    • Can reference self (managers and direct reports)
      • If manager is deleted set reference to NULL
    • One-to-One relationship with Contact Info
    • One-to-Many relationship with Tasks
    • Many-to-Many relationship with Meetings
  • Contact Info table
    • One-to-One relationship with Employee
    • Delete if Employee is deleted
  • Task table
    • Many-to-One relationship with Employee
    • set employeeId to Null if Employee is deleted
  • Meeting table
    • Many-to-Many relationship with Employee (via relationship table)
    • Remove Employee as attendee if Employee is deleted