task1

Tables (5)

Goods Information (goods_info)

  • Goods ID (goods_id) — Primary key — NOT NULL
  • Time Last Updated (timestamp)
  • Shop ID (shop_id) — Foreign key → Shop Information.Shop ID — NOT NULL
  • Category (category)
  • Price (price)
  • Image Type (image_type)
  • Image Size (image_width)
  • Image Size (image_height)

Order Info (order_info)

  • Time (timestamp)
  • Price (price)
  • User ID (user_id) — Foreign key → User Event Logs.User ID — NOT NULL
  • Shop ID (shop_id) — Foreign key → Shop Information.Shop ID — NOT NULL
  • Goods ID (goods_id) — Foreign key → Goods Information.Goods ID — NOT NULL

Shop Information (shop_info)

  • Shop ID (shop_id) — Primary key — NOT NULL
  • Name (name)
  • Category (category)
  • Age (age)
  • Style (style)

User Event Logs (user_event_logs)

  • User ID (user_id) — Foreign key → User Information.User ID — NOT NULL
  • Time (timestamp)
  • Event Origin (event_origin)
  • Event Name (event_name)
  • Events Goods ID (event_goods_id)
  • Events Shop ID (event_shop_id)

User Information (user_info)

  • User ID (user_id) — Primary key — NOT NULL
  • Device (os)
  • Age (age)