Introduction to Vendohub

Vendohub is an MLM e-commerce platform meticulously designed to streamline complex operations from user interaction to financial calculations. Its core purpose is to provide a robust framework for managing various aspects of an MLM business within an e-commerce environment.

This project focuses on the foundational ER (Entity-Relationship) Diagram, which illustrates the relational structure of Vendohub's database. It highlights key entities such as Users, Products, MLM Networks, Orders, and Commissions, along with the critical relationships connecting them, ensuring data integrity and comprehensive functionality.

Core Database Components

The Vendohub database is structured around several interconnected table categories, each handling specific functionalities of the MLM e-commerce platform.

User Management Tables

• **Users:** Stores essential user details.
• **User Addresses:** Manages both billing and shipping addresses for users.

MLM Structure Tables

• **IBO Ranks:** Defines various ranks within the MLM network for Independent Business Owners (IBOs).
• **IBO Network:** Tracks the intricate hierarchy and relationships within the MLM network.
• **IBO PV History:** Logs personal and team Personal Volume (PV) values for commission calculations.
• **Rank Commission Rates:** Defines specific commission rates applicable to different IBO ranks.

Product Management Tables

• **Categories:** Organizes products into logical categories.
• **Products:** Stores detailed information about each product, including price and associated PV value.

Shopping Cart Tables

• **Shopping Cart:** Tracks active shopping cart sessions for users.
• **Cart Items:** Manages individual products added to a user's shopping cart.

Payment Management Tables

• **Payment Types:** Defines all accepted payment types.
• **Payment Methods:** Manages user-specific payment options.
• **Bank, Card, and UPI Payment Details:** Securely stores sensitive payment information.

Order Management Tables

• **Orders:** Captures comprehensive details of user orders.
• **Order Items:** Details the specific products included within each order.
• **Order Payments:** Logs payment details associated with individual orders.

Commission Management Tables

• **Commission Earnings:** Tracks all commissions earned by IBOs.
• **Commission Payments:** Logs payouts of earned commissions.
• **Commission Payment Details:** Tracks specific earnings components within commission payouts.

Review Management System

Vendohub incorporates a comprehensive review system to gather feedback and maintain platform integrity.

Product Review Management

• **Product Reviews:** Manages user feedback and ratings for products.
• **Verified Purchase:** Ensures that reviews originate from actual buyers.
• **Status:** Tracks the moderation status of product reviews.

IBO Review Management

• **IBO Reviews:** Allows users to provide feedback on Independent Business Owners.
• **Review Type:** Categorizes reviews by service quality, product knowledge, or responsiveness.
• **Verified Transaction:** Ensures the authenticity of IBO reviews through transaction verification.

Review Votes Management

• **Review Votes:** Tracks helpfulness votes for both product and IBO reviews.
• Ensures unique votes per review per user.

Security Features

The database design incorporates several features to ensure data security and integrity:

• **Encrypted Sensitive Data:** Implements encryption for critical data fields, such as account numbers.
• **Unique Constraints:** Prevents duplicate entries within tables, maintaining data accuracy.
• **Controlled Data Access:** Ensures data integrity and security through relational integrity rules.

Conclusion

Vendohub's database architecture provides a robust, scalable, and secure foundation essential for managing complex MLM e-commerce operations. It is designed to ensure data integrity, enhance security, and deliver comprehensive functionality across the entire platform.