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