Fahrer Bonus ADM

The ADM is similar to the Auftragsanalyse.

erDiagram


    FactOrder {
        id OrderID
        dte StartDate
    }

    DimDriver {
        id DriverID
        txt DriverName
    }

    DimCalendar {
        dte Date
    }

    DimVehicle {
        id VehicleTypeID
        code VehicleTypeCode
        text VehicleTypeName
        text VehicleDisplayName
    }

    DimDispositionType {
        int DispositionTypeID
        txt DispositionTypeDescription
        int Points "e.g. stellen = 1, wechseln = 2, etc."
    }

    DimCalendar ||--o{ FactOrder: EndDate
    DimDriver ||--o{ FactOrder: DriverID
    DimVehicle ||--o{ FactOrder: VehicleID
    DimDispositionType ||--o{ FactOrder: DispositionTypeID