Overview
This database contains 14 tables that manage a comprehensive food delivery platform. The database follows a relational design with proper foreign key relationships and includes both dimension tables (master data) and fact tables (transactional data).
Table Categories
Dimension Tables (Master Data)
- restaurant_categories
- item_categories
- restaurants
- menu_items
- users
- user_addresses
- delivery_personnel
- promotions
- restaurant_operating_hours
Fact Tables (Transactional Data)
- orders
- order_items
- deliveries
- payments
- reviews