쇼핑몰 ERD
테이블 (9)
고객 (Customer)
- CustomerID (customer_id) — 기본 키
- Name (name)
- Email (email)
- Phone (phone_number)
- PasswordHash (password_hash)
- MemberLevel (member_level)
- Address (address)
고객_쿠폰 (Customer_Coupon)
- CustomerID (customer_id) — 외래 키 → 고객.CustomerID
- CouponID (coupon_id) — 외래 키 → 쿠폰.CouponID
- Used (used)
리뷰 (Review)
- ReviewID (review_id) — 기본 키
- Rating (rating)
- Content (content)
- ReviewDate (review_date)
- ProductID (product_id)
- CustomerID (customer_id) — 외래 키 → 고객.CustomerID
상품 (Product)
- ProductID (product_id) — 기본 키
- ProductName (product_name)
- Brand (brand)
- Price (price)
- Size (size)
- Material (material)
- ProductDiscoutRate (product_discoutrate)
- ImageURL (image_url)
- CategoryID (category_id) — 외래 키 → 카테고리.CategoryID
재고 (Inventory)
- ProductID (product_id) — 외래 키 → 상품.ProductID
- Quantity (quantity)
- WarehouseLocation (warehouse_location)
- StockDate (stock_date)
주문 (Order)
- OrderID (order_id) — 기본 키
- OrderDate (order_date)
- PaymentMethod (payment_method)
- TotalAmount (total_amount)
- OrderStatus (order_status)
- CustomerID (customer_id) — 외래 키 → 고객.CustomerID
주문_상품 (Order_Product)
- OrderID (order_id) — 외래 키 → 주문.OrderID
- ProductID (product_id) — 외래 키 → 상품.ProductID
- Quantity (quantity)
카테고리 (Category)
- CategoryID (category_id) — 기본 키
- CategoryName (category_name)
쿠폰 (Coupon)
- CouponID (coupon_id) — 기본 키
- CouponName (coupon_name)
- Coupon_DiscountRate (coupon_discount_rate)
- ExpirationDate (expiration_date)
- Used (used)