Project Overview

Vendohub is a full-scale MLM e-commerce solution engineered to manage user hierarchies, financial transactions, and product operations within a unified system. Its database architecture is designed for performance, scalability, and data integrity — forming the backbone of a multi-tier distribution model.

The foundation of this project lies in its Entity-Relationship (ER) Diagram, which meticulously maps key entities like Users, Products, MLM Networks, Orders, and Commissions. These entities are interlinked to ensure relational consistency and optimized data operations.

Core Database Components

The database design is modular, composed of table groups that collectively manage users, transactions, commissions, and reviews.

User Management

• Users: Stores primary user details including authentication metadata.
• User Addresses: Manages multiple billing and shipping addresses.

MLM Network Management

• IBO Ranks: Defines MLM rank tiers and associated performance thresholds.
• IBO Network: Tracks parent-child relationships across the MLM hierarchy.
• IBO PV History: Records Individual and Team Personal Volume (PV) values vital for commission calculation.
• Rank Commission Rates: Specifies payout percentages tied to each IBO rank.

Product Management

• Categories: Organizes products into logical groups.
• Products: Maintains details, pricing, and PV values of each product.

Shopping Cart System

• Shopping Cart: Tracks active user sessions and cart statuses.
• Cart Items: Stores detailed product entries per cart instance.

Payment Framework

• Payment Types: Defines available payment categories (Card, Bank, UPI, etc.).
• Payment Methods: Stores user-specific payment preferences.
• Payment Details: Securely manages financial credentials using encryption protocols.

Order Management

• Orders: Captures high-level order data and user linkage.
• Order Items: Lists products associated with each order transaction.
• Order Payments: Logs payment methods and verification for order completion.

Commission Management

• Commission Earnings: Tracks all revenue earned by Independent Business Owners (IBOs).
• Commission Payments: Logs payout details and histories.
• Commission Payment Breakdown: Provides transparent audit of individual earnings components.

Review Management System

A structured feedback system ensures transparency and reliability across the platform.

Product Review Management

• Product Reviews: Enables customers to rate and comment on products.
• Verified Purchase: Ensures only legitimate buyers can post reviews.
• Status Tracking: Monitors review approval and moderation progress.

IBO Review Management

• IBO Reviews: Captures user feedback on Independent Business Owners’ service quality.
• Review Categorization: Differentiates reviews by knowledge, responsiveness, or transaction quality.
• Verified Transaction: Confirms review authenticity through sales linkage.

Review Voting

• Review Votes: Logs user interactions indicating helpfulness of reviews.
• Implements constraints to ensure one vote per user per review.

Security & Data Integrity

Multiple layers of protection are implemented to maintain data confidentiality, consistency, and reliability.

• Data Encryption: Secures sensitive financial fields such as card or UPI details.
• Unique Constraints: Prevents data duplication across relational tables.
• Controlled Access: Ensures referential integrity and limits unauthorized modifications.

Conclusion

Vendohub’s database architecture forms a resilient and modular framework ideal for MLM-based e-commerce ecosystems. With a focus on scalability, transparency, and compliance, it ensures smooth integration of user management, product operations, and hierarchical commission tracking across the entire business flow.