9 final project

Tables (3)

Cart (Untitled2)

  • ID (id) — int — Primary key — NOT NULL
  • 유저ID (userId) — int — Primary key — NOT NULL
  • 상품ID (productId) — int — Primary key
  • 수량 (amount) — int

Order (Untitled3)

  • ID (id) — int — Primary key — NOT NULL
  • 상품ID (productId) — int — Primary key
  • 유저ID (userId) — int — Primary key
  • 수량 (amount) — int
  • 총가격 (totalPrice) — double

User (Untitled)

  • ID (id) — int — Primary key — NOT NULL
  • 비밀번호 (password) — String
  • 이메일 (email) — String
  • 전화번호 (phoneNumber) — String
  • 주소 (address) — String