Skip to content

Data Model

erDiagram
    FactAmount {
        id TransactionNumber
        eur Amount "signed amount (+/-)"
    }

    DimCalendar {
        date Date
        etc etc
    }

    DimAccount {
        int AccountCode "81200"
        txt AccountName
        code AccountGroup "1020"
        txt AccountGroupName
    }

    DimCalendar ||--o{ FactAmount: refs
    DimAccount ||--o{ FactAmount: refs