erDiagram
    DEPARTMENT {
        DepartmentName String
        DepartmentReferenceNumber String
        Id Guid
    }
    PERSONALGOALDEPARTMENT {
        GoalId Guid
        Distance Int32
        Stage String
        DepartmentId Guid
        CreatedDateTime DateTimeOffset
        Id Guid
    }
    PERSONALGOALJOB {
        GoalId Guid
        JobTitle String
        Id Guid
        JobReferenceNumber String
    }
    EMPLOYEE {
        PersonalReference String
        Name String
        Id Guid
    }
    PERSONALGOAL {
        IsOverdue Boolean
        Stage String
        Visibility String
        TargetDate DateTimeOffset
        CreatedDateTime DateTimeOffset
        EmployeeId Guid
        Id Guid
        CompletedDateTime DateTimeOffset
        DaysToComplete Int32
        Title String
        MeasurementMethod String
        UpdatedDateTime DateTimeOffset
    }
    Resource_Paths {
        personalGoalDepartments URL
        personalGoals URL
        personalGoalJobs URL
        departments URL
        employees URL
    }
    PERSONALGOALDEPARTMENT o{--|| DEPARTMENT : Department
    PERSONALGOALDEPARTMENT o{--|| PERSONALGOAL : PersonalGoal
    PERSONALGOALJOB o{--|| PERSONALGOAL : PersonalGoal
    PERSONALGOAL o{--|| EMPLOYEE : Employee