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