Definitions & Acronyms

1. users:
   • Stores information about users.
     • id: Unique identifier for the user.
     • first_name: User's first name.
     • last_name: User's last name.
     • email: User's email address.
     • password_hash: User's password hash.
     • role: User's role (can be 'buyer', 'seller', or 'admin').
     • created_date: Date and time when the user account was created.
     • last_updated_date: Date and time when the user data was last updated.
     • address: User's address.
     • city: User's city.
     • postal_code: User's postal code.
     • country: User's country.
2. categories:
   • Stores information about product categories.
     • id: Unique identifier for the category.
     • categorie_name: Name of the category.
3. products:
   • Stores information about products sold on the platform.
     • id: Unique identifier for the product.
     • product_name: Name of the product.
     • product_description: Description of the product.
     • price: Price of the product.
     • seller_id: Identifier of the seller (references the users table).
     • category_id: Identifier of the category the product belongs to (references the categories table).
     • average_rating: Average rating of the product.
     • review_count: Number of reviews for the product.
     • stock_quantity: Quantity of the product in stock.
     • created_date: Date and time when the product was created.
     • last_updated_date: Date and time when the product was last updated.
4. delivery_services:
   • Stores information about delivery services.
     • id: Unique identifier for the delivery service.
     • name: Name of the delivery service.
     • website: Website of the delivery service.
5. orders:
   • Stores information about orders.
     • id: Unique identifier for the order.
     • user_id: Identifier of the user who made the order (references the users table).
     • total_price: Total price of the order.
     • delivery_service_id: Identifier of the delivery service chosen for the order (references the delivery_services table).
     • tracking_number: Tracking number for the order.
     • status: Status of the order ('pending' - in process, 'completed' - completed, 'cancelled' - cancelled).
     • created_date: Date and time when the order was created.
     • last_updated_date: Date and time when the order was last updated.
6. order_items:
   • Stores information about the products in an order.
     • id: Unique identifier for the order item.
     • order_id: Identifier of the order that the item belongs to (references the orders table).
     • product_id: Identifier of the product (references the products table).
     • quantity: Quantity of the product in the order.
     • price: Price of the product in the order.
7. payments:
   • Stores information about payments for orders.
     • id: Unique identifier for the payment.
     • order_id: Identifier of the order for which the payment was made (references the orders table).
     • payment_date: Date and time when the payment was made.
     • payment_method: Payment method used (e.g., "credit card", "PayPal", etc.).
     • amount: Amount of the payment.
     • status: Status of the payment ('success' - successful, 'failed' - failed, 'pending' - pending).
8. reviews:
   • Stores reviews left by users for products.
     • id: Unique identifier for the review.
     • product_id: Identifier of the product being reviewed (references the products table).
     • user_id: Identifier of the user who left the review (references the users table).
     • rating: Rating given to the product (between 1 and 5).
     • comment: Text comment for the review.
     • created_date: Date and time when the review was created.
9. carts:
   • Stores information about user carts.
     • id: Unique identifier for the cart.
     • user_id: Identifier of the user who owns the cart (references the users table).
     • created_date: Date and time when the cart was created.
     • last_updated_date: Date and time when the cart was last updated.
10. cart_items:
    • Stores information about products in a cart.
      • id: Unique identifier for the cart item.
      • cart_id: Identifier of the cart (references the carts table).
      • product_id: Identifier of the product in the cart (references the products table).
      • quantity: Quantity of the product in the cart.
11. favorites_sellers:
    • Stores information about sellers marked as favorites by users.
      • id: Unique identifier for the favorite seller entry.
      • user_id: Identifier of the user who marked the seller as favorite (references the users table).
      • seller_id: Identifier of the seller marked as favorite (references the users table).
      • created_date: Date and time when the seller was added to the favorites.
12. favorites_products:
13. seller_ratings:

Acronyms

• ID: Identifier
• FK: Foreign Key
• PK: Primary Key
• TIMESTAMP: A time representation (date and time)