This project defines a comprehensive and scalable MySQL database schema for an e-commerce platform. It supports key entities like products, brands, categories, variations (size, color, etc.), and extensible product attributes.
- Structured product catalog with brands and categories
- Support for product variations (size, color, style)
- Customizable product attributes and attribute types
- Hierarchical product categories (nested categories)
- Inventory tracking with product_item
- Image management for products
- Timestamp tracking for auditing and updates
Stores brand information for products.
Supports nested categories using `parent_category_id.
Defines base product information including price, brand, and category.
Support for size classification and specific size values (e.g., S, M, L).
Color options with optional hex codes for UI display.
Captures variations by type (e.g., size, color, style) and their values.
Represents SKUs or physical inventory items with quantity and price.
Supports multiple images per product with primary flag and display order.
Allow grouping and typing of dynamic product attributes.
Stores attribute values per product (e.g., material, warranty, etc.).
- Cynthia Mwaura
- Valery Akinyi
- Niver Ngeywo
- Mahlatse Mokhabela