shopping

Tables (7)

Address (Untitled3)

  • id (주소아이디) — Long — Primary key — NOT NULL
  • id (사용자아이디) — Long — Foreign key → User.id — NOT NULL
  • address (주소) — String
  • name (주소별칭) — String
  • zipcode (우편번호) — String
  • phone (전화번호) — String

Cart (장바구니)

  • id (장바니구아이디) — Long — Primary key — NOT NULL
  • id (사용자아이디) — Long — Foreign key → User.id — NOT NULL
  • totalPrice (총 가격) — Long
  • totalQuantity (총 수량) — Integer

CartItem (장바구니 물품)

  • id (장바구니물품아이디) — Long — Primary key — NOT NULL
  • id (장바니구아이디) — Long — Foreign key → Cart.id — NOT NULL
  • id (물품아이디) — Long — Foreign key → Product.id — NOT NULL
  • quantity (수량) — Integer

Order (Untitled)

  • id (주문아이디) — Long — Primary key — NOT NULL
  • id (사용자아이디) — Long — Foreign key → User.id — NOT NULL
  • address (주소) — String
  • name (주소명) — String
  • phone (전화번호) — String
  • orderDate (주문날짜) — LocalDateTime
  • orderStatus (주문상태) — OrderStatus

OrderItem (Untitled2)

  • id (주문상품아이디) — Long — Primary key — NOT NULL
  • id (물품아이디) — Long — Foreign key → Product.id — NOT NULL
  • id (주문아이디) — Long — Foreign key → Order.id — NOT NULL
  • productName (물품명) — String
  • unitPrice (개당가격) — Integer
  • quantity (수량) — Integer

Product (물품)

  • id (물품아이디) — Long — Primary key — NOT NULL
  • name (물품명) — String
  • price (가격) — Long
  • stock (재고) — Integer

User (사용자)

  • id (사용자아이디) — Long — Primary key — NOT NULL
  • name (이름) — String
  • email (이메일) — String
  • password (비밀번호) — String