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)