Data Model

Diagram

erDiagram


    FactTimeSheetEntry {
        time Hours
        str TaskName
        dec HoursPlanned
    }

    FactTimeSheetEntry }o--|| DimCalendar: Date
    FactTimeSheetEntry }o--o| DimLeave: LeaveID
    FactTimeSheetEntry }o--|| DimEmployee: EmployeeID 
    FactTimeSheetEntry }o--o| DimPartner: PartnerID
    FactTimeSheetEntry }o--o| DimTask: TaskID
    FactTimeSheetEntry }o--o| DimProject: ProjectID

    FactTaskEstimate {
        dec TotalHoursPlanned
    }

    FactTaskEstimate }o--|| DimPartner: PartnerID
    FactTaskEstimate }o--|| DimTask: TaskID
    FactTaskEstimate }o--|| DimProject: ProjectID

    DimCalendar {
        date Date
        etc etc
    } 

    DimLeave {
        date DateFrom
        date DateTo
        int employeeID "There is one entry per leave per employee"
    } 

    DimEmployee {
        str Name
        str DepartmentName
        dec ContractedHours
    }


    DimPartner {
        str PartnerName
    } 



    DimProject {
        str ProjectName
        str GroupName
    }

    DimTask {
        str TaskName
        hours TotalHoursPlanned
        str TaskTypeName
        str ManagerName
        int Sequence "The display order"
    }