erDiagram
    CHECKINMANAGER {
        FirstName String
        LastName String
        PersonalReference String
        CheckInManagerType String
        FullName String
        Id Guid
    }
    EMPLOYEEQUALIFICATIONHISTORY {
        ExpiryDate DateTimeOffset
        QualificationType String
        GradeAchieved String
        Subject String
        DateAchieved DateTimeOffset
        EmployeeId Guid
        Institute String
        Id Guid
        DateVerified DateTimeOffset
        UpdatedDate DateTimeOffset
        SubjectSpecialism String
    }
    OCCUPANCY {
        JobId Guid
        EndDate DateTimeOffset
        EmployeeId Guid
        Id Guid
        StartDate DateTimeOffset
    }
    CHECKIN {
        CheckInManagerType String
        ClosedDate DateTimeOffset
        OccupancyId Guid
        CheckInType String
        EmployeeId Guid
        Id Guid
        EmployeeCreated Boolean
        ManagerId Guid
        State String
        OtherAttendees String
        StarRating Int32
        CheckInDate DateTimeOffset
    }
    EMPLOYEETALENTPROFILE {
        ExpiryDate DateTimeOffset
        Level String
        EmployeeId Guid
        Institute String
        ProfileItemType String
        Id Guid
        DateVerified DateTimeOffset
        Type String
        ProfileItem String
        DateObtained DateTimeOffset
        SubjectSpecialism String
    }
    EMPLOYEE {
        FirstName String
        LastName String
        PersonalReference String
        FullName String
        Id Guid
    }
    JOB {
        ReferenceNumber String
        JobTitle String
        ActiveTo DateTimeOffset
        Id Guid
        ActiveFrom DateTimeOffset
    }
    JOBREQUIREMENT {
        JobId Guid
        Level String
        Id Guid
        Requirement String
        Type String
        RequirementType String
    }
    CHECKINPERFORMANCE {
        DepartmentId Guid
        Count Int64
        Name String
        Id Guid
        ParentStructureId Guid
    }
    EMPLOYEECOMPETENCYHISTORY {
        CompetencyType String
        ExpiryDate DateTimeOffset
        CompetencyLevelId Guid
        CompetencyId Guid
        EmployeeId Guid
        Id Guid
        DateVerified DateTimeOffset
        UpdatedDate DateTimeOffset
        CompetencyLevel String
        CompetencyName String
        DateObtained DateTimeOffset
    }
    EMPLOYEEMEMBERSHIPHISTORY {
        ExpiryDate DateTimeOffset
        MembershipNumber String
        Level String
        ProfessionalBody String
        EmployeeId Guid
        Id Guid
        DateVerified DateTimeOffset
        UpdatedDate DateTimeOffset
        DateObtained DateTimeOffset
    }
    Resource_Paths {
        employeeTalentProfiles URL
        employeeCompetencyHistories URL
        employeeQualificationHistories URL
        checkInPerformances URL
        checkInManagers URL
        employeeMembershipHistories URL
        employees URL
        jobRequirements URL
        checkIns URL
        jobs URL
        occupancies URL
    }
    EMPLOYEEQUALIFICATIONHISTORY o{--|| EMPLOYEE : Employee
    OCCUPANCY o{--|| EMPLOYEE : Employee
    OCCUPANCY o{--|| JOB : Job
    CHECKIN o{--|| EMPLOYEE : Employee
    CHECKIN o{--|| CHECKINMANAGER : CheckInManager
    EMPLOYEETALENTPROFILE o{--|| EMPLOYEE : Employee
    JOBREQUIREMENT o{--|| JOB : Job
    EMPLOYEECOMPETENCYHISTORY o{--|| EMPLOYEE : Employee
    EMPLOYEEMEMBERSHIPHISTORY o{--|| EMPLOYEE : Employee