数据仓库星型模型

erDiagram
    FACT_ORDERS }o--|| DIM_CUSTOMER : "ordered by"
    FACT_ORDERS }o--|| DIM_PRODUCT : "line item"
    FACT_ORDERS }o--|| DIM_DATE : "ordered on"
    FACT_ORDERS {
        int order_id PK
        int customer_key FK
        int product_key FK
        int date_key FK
        decimal revenue
        int quantity
    }
    DIM_CUSTOMER {
        int customer_key PK
        string segment
        string region
    }
    DIM_PRODUCT {
        int product_key PK
        string category
        string brand
    }
    DIM_DATE {
        int date_key PK
        date calendar_date
        int fiscal_quarter
    }