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)