Data Model

erDiagram

    FactInvoiceLine {
        int_pk LineID
        int InvoiceID
        decimal Unit
        money Price
        money Amount
        string ContractNumber
        code LineType
        code Statuut

    }

    DimShift {
        int_pk ShiftID
        string PONumber
        decimal timeworked
        string job
    }

    DimSektie {
        int_pk SektieID
        pct IncomeTaxes
        pct PctOfGross
        pct SocialTaxes
        int CodeKind
    }

    DimSalaryCode {
        int_pk SalaryCodeID
        code CodeKind
        int CodeKind
    }

    DimClient {
        int_pk ClientID
        string ClientName
        string ClientCity
        etc Details
    }

    DimStudent {
        int_pk StudentID
        string StudentName
        etc Details
    }

    DimCalendar {
        date Date "StandardDateTable"
    }

    DimOffice {
        int_pk PlatformBranchID
        int_pk PratoBranchID
        string BranchCity
        string AccountManagerName
    }

    DimInvoiceLineType {
        code_pk InvoiceLineTypeCode "c or s"
    }


    FactInvoiceLine }o--|| DimStudent: Student
    FactInvoiceLine }o--|| DimClient: Client
    FactInvoiceLine }o--|| DimCalendar: ShiftDay
    FactInvoiceLine }o--|| DimCalendar: InvoiceDate
    FactInvoiceLine }o--|| DimSektie: Sektie
    FactInvoiceLine }o--|| DimSalaryCode: Code
    FactInvoiceLine }o--|| DimOffice: Branch
    FactInvoiceLine }o--|| DimShift: Shift
    FactInvoiceLine }o--|| DimInvoiceLineType: Type