Data Model

Diagram

erDiagram


    FactWorkLog {
        time Hours "worklogs/list.timeSpent"
        str date
        str comment
        key HourlyRateCode 
    }

    FactWorkLog }o--|| DimCalendar: WorkLogDate
    FactWorkLog }o--o| DimIssue: IssueID
    FactWorkLog }o--|| DimUser: UserID 
    FactWorkLog }o--o| DimProject: ProjetctID
    FactWorkLog }o--o| DimHourlyRate: RateCode
    FactWorkLog }o--o| DimIssueType: IssueTypeID
    FactWorkLog }o--o| DimAccount: AccountName

    DimCalendar {
        date Date
        etc etc
    } 

    DimIssue {
        id IssueID "search.issues.id"
        key IssueKey "search.issues.key"
        str Description "search.issues.resolution.description"
        code IssueType "search.issuetype"
        str IssueStatus "search.status"
        date DueDate "search.duedate"
        date StartDate 
        date GoogleDate 
        date Verzenddatum
    }

    DimIssueType {
        id Id
        str AccountName "excel"
        str PriceType "excel"
        str Division "excel"
        str IssueType "excel"
        str Uurtarief "excel"
    }

    DimHourlyRate{
       key RoleCode "hourlyrates.excel"
       str RoleName "hourlyrates.excel"
       int HourlyRate "hourlyrates.excel"
    }

    DimUser {
        id AccountID "users/search.accountId"
        str UserName "users/search.displayName"
        str UserGroups "users.expand.groups"
        str AccountType "users/search.accountType"
    }


    DimProject {
        id ProjectID "project.id"
        str ProjectName "project.name"
        str ProjectKey "project.key"
        str ProjectLead "project.name"
    } 

    DimAccount {
        str Division "excel"
        str AccountName "excel"
    }