eshop

Tables (10)

Copy Of Untitled (top_selling_products)

  • Key (id) — Primary key — NOT NULL
  • Field (rank)
  • Field (period)
  • Field (total_selling)
  • Field (aggregation_type)
  • Field (aggregation_datetime)
  • Key (product_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (wallets)

  • Key (id) — Primary key — NOT NULL
  • Field (amount)
  • Key (user_id) — Foreign key → users.Key — NOT NULL

Untitled (wallet_history)

  • Key (id) — Primary key — NOT NULL
  • Field (action)
  • Field (amount)
  • Key (wallet_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (products)

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (price)
  • Field (stock)

Untitled (inventory)

  • Key (id) — Primary key — NOT NULL
  • Field (quantity)
  • Key (product_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (orders)

  • Key (id) — Primary key — NOT NULL
  • Field (order_date)
  • Field (total_price)
  • Key (user_id) — Foreign key → users.Key — NOT NULL

Untitled (order_details)

  • Key (id) — Primary key — NOT NULL
  • Field (price)
  • Field (quantity)
  • Key (order_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (top_revenue_products)

  • Key (id) — Primary key — NOT NULL
  • Field (rank)
  • Field (period)
  • Field (total_revenue)
  • Field (aggregation_type)
  • Field (aggregation_datetime)
  • Key (product_id) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (carts)

  • Key (id) — Primary key — NOT NULL
  • Field (product_id)
  • Field (quantity)
  • Key (user_id) — Foreign key → users.Key — NOT NULL

users

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (password)