DP_ecommerce

Tables (5)

Login Logs (login_logs)

  • Log Id (log_id) — Primary key — NOT NULL
  • User Id (user_id) — bigint — Foreign key → USER.User Id — NOT NULL
  • Login Time (login_time)
  • Device Type (device_type)

Product View Logs (product_view_logs)

  • Log Id (log_id) — Foreign key → Login Logs.Log Id — NOT NULL
  • Field (user_id)
  • Field2 (product_id)
  • Field3 (view_time)
  • Field (device_type)
  • Field2 (category)
  • Field3 (is_recommended)

Products (products)

  • Product Id (product_id) — bigint — Primary key — NOT NULL
  • Vendor Id (vendor_id) — bigint — Foreign key → Vendors.Vendor Id — NOT NULL
  • Product Name (product_name) — varchar
  • Category (category) — varchar
  • Price (price) — int
  • Rating (rating) — float
  • Review Count (review_count) — int

USER (users)

  • User Id (user_id) — bigint — Primary key — NOT NULL
  • Device Type (device_type) — varchar
  • Country (country) — varchar
  • Signup Date (signup_date) — timestamp

Vendors (vendors)

  • Vendor Id (vendor_id) — bigint — Primary key — NOT NULL
  • Vendor Rating (vendor_rating) — float