Fact table of individual orders
| Column | Type | Key |
|---|---|---|
| order_id | INTEGER | PK |
| customer_id | INTEGER | FK → customers.customer_id |
| order_date | DATE | |
| region | VARCHAR | |
| product_line | VARCHAR | |
| amount | DECIMAL |
Dimension table of customer accounts
| Column | Type | Key |
|---|---|---|
| customer_id | INTEGER | PK |
| name | VARCHAR | |
| segment | VARCHAR |