Shopping GO
Tables (10)
Cart
- cart_id — INT — Primary key
- user_num (user_num2) — INT — Foreign key → Users.user_num
- user_num — INT
- product_num — INT
- quantity — INT
Category
- category_id — INT — Primary key
- category_name — VARCHAR(255) — NOT NULL
MyInfos
- user_num (user_num2) — INT — Foreign key → Users.user_num
- order_id — INT — Foreign key → Orders.order_id
- MyInfo_id — INT
- name — VARCHAR(255)
- phone — VARCHAR(255)
- address — VARCHAR(255)
- user_num — INT
OrderDetails
- order_detail_id — INT — Primary key
- product_num (product_num2) — INT — Foreign key → Products.product_num
- order_id (order_id2) — INT — Foreign key → Orders.order_id
- category_id (category_id2) — INT — Foreign key → Products.category_id
- order_id — INT
- product_num — INT
- quantity — INT
Orders
- order_id — INT — Primary key
- user_num — INT
- total_price — DECIMAL(10,2)
- order_date — TIMESTAMP
Payments
- Payments_id — INT — Primary key
- user_num (user_num2) — INT — Foreign key → MyInfos.user_num
- order_id — INT — Foreign key → MyInfos.order_id
- cardNumber — VARCHAR(255)
- expiryDate — VARCHAR(255)
- cvc — VARCHAR(255)
- MyInfo_id — INT
- user_num — INT
Products
- product_num — INT — Primary key
- category_id (category_id2) — INT — Foreign key → Category.category_id
- product_name — VARCHAR(255)
- product_image — VARCHAR(255)
- product_price — DECIMAL(10,2)
- product_content — VARCHAR(255)
PromotionDetails
- promotion_id (promotion_id2) — INT — Foreign key → Promotions.promotion_id
- promotion_image_id — INT
- promotion_image_path — VARCHAR(255) — NOT NULL
- promotion_image_created_at — DATETIME
Promotions
- promotion_id — INT — Primary key
- promotion_title — VARCHAR(255) — NOT NULL
- promotion_content — TEXT
- promotion_is_visible — BOOLEAN
- promotion_start_date — DATE
- promotion_end_date — DATE
- promotion_banner_image_path — VARCHAR(255)
Users
- user_num — INT — Primary key
- user_id — VARCHAR(255)
- password — VARCHAR(255)
- user_name — VARCHAR(255)