Core

Tables (3)

Member (Untitled)

  • 회원 ID (member_id) — Primary key — NOT NULL
  • 회원 등급 (grade)

Order (Untitled3)

  • 주문 ID (order_id) — Primary key — NOT NULL
  • 회원 ID (member_id) — Foreign key → Member.회원 ID — NOT NULL
  • 상품 ID (product_id) — Foreign key → Product.상품 ID — NOT NULL
  • 주문 금액 (order_cost)

Product (Untitled2)

  • 상품 ID (product_id) — Primary key — NOT NULL
  • 상품명 (product_name)
  • Field (product_cost)