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