Sales Star Schema

erDiagram
  DIM_DATE ||--o{ FACT_SALES : "sold on"
  DIM_CUSTOMER ||--o{ FACT_SALES : buys
  DIM_PRODUCT ||--o{ FACT_SALES : "sold as"
  DIM_STORE ||--o{ FACT_SALES : "sold at"
  DIM_PROMOTION ||--o{ FACT_SALES : applies
  FACT_SALES {
    bigint sales_key PK
    int date_key FK
    int customer_key FK
    int product_key FK
    int store_key FK
    int promotion_key FK
    int quantity
    decimal net_amount
    decimal discount
    decimal cost
  }
  DIM_DATE {
    int date_key PK
    date full_date
    string month
    string fiscal_quarter
    boolean is_holiday
  }
  DIM_CUSTOMER {
    int customer_key PK
    string customer_id
    string city
    string segment
    date valid_from
    date valid_to
  }
  DIM_PRODUCT {
    int product_key PK
    string sku
    string category
    string brand
  }
  DIM_STORE {
    int store_key PK
    string name
    string region
  }
  DIM_PROMOTION {
    int promotion_key PK
    string name
    string type
  }