thymeleaf

Tables (7)

Address (주소)

  • 주소id (address_id) — NOTNULL — Primary key — NOT NULL
  • 멤버id (member_id) — NOTNULL — Foreign key → Member.멤버id — NOT NULL
  • 전체주소 (fulladdress) — NOTNULL
  • 우편번호 (zip_code) — NOTNULL
  • 상세주소 (address_detail) — NOTNULL

CartItem (장바구니아이템)

  • 카트아이템id (cart_item_id) — NOTNULL — Primary key — NOT NULL
  • 장바구니id (cart_id) — NOTNULL — Foreign key → ShoppingCart.장바구니id — NOT NULL
  • 상품id (product_id) — NOTNULL — Foreign key → Product.상품id — NOT NULL
  • 수량 (quantity) — NOTNULL
  • 가격 (price) — NOTNULL

Member (회원)

  • 멤버id (member_id) — NOTNULL — Primary key — NOT NULL
  • 이름 (username) — NOTNULL
  • 이메일 (email) — NOTNULL
  • 비밀번호 (password) — NOTNULL
  • 역할 (ROLE) — NOTNULL

Order (주문)

  • 주문id (order_id) — NOTNULL — Primary key — NOT NULL
  • 멤버id (member_id) — NOTNULL — Foreign key → Member.멤버id — NOT NULL
  • 주소id (address_id) — NOTNULL — Foreign key → Address.주소id — NOT NULL
  • 주문일 (order_date) — NOTNULL

OrderItem (주문아이템)

  • 주문아이템id (id) — NOTNULL — Primary key — NOT NULL
  • 주문id (order_id) — NOTNULL — Foreign key → Order.주문id — NOT NULL
  • 상품id (product_id) — NOTNULL — Foreign key → Product.상품id — NOT NULL
  • 가격 (price) — NOTNULL
  • 수량 (quantity) — NOTNULL

Product (상품)

  • 상품id (product_id) — NOTNULL — Primary key — NOT NULL
  • 상품명 (name) — NOTNULL
  • 가격 (price) — NOTNULL
  • 재고량 (stock_quantity) — NOTNULL
  • Field

ShoppingCart (장바구니)

  • 장바구니id (cart_id) — NOTNULL — Primary key — NOT NULL
  • 멤버id (member_id) — NOTNULL — Foreign key → Member.멤버id — NOT NULL