shopping
Tables (9)
Cart (Untitled3)
- user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
- product_id (상품 id) — long — Foreign key → Product.Id — NOT NULL
- quantity (수량) — itn
Cupon (Untitled6)
- Id (id) — long — Primary key — NOT NULL
- code (코드) — UUID
- name (이름) — String
- discount (할인율) — int
- type (종류) — enum
- max_discount (한도) — int
- status (상태) — enum
- create_at (생성일자) — TimeStamp
- modified_at (수정일자) — TimeStamp
Delivery (Untitled4)
- Id (uuid) — UUID — Primary key — NOT NULL
- user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
- status (배송 상태) — Enum
- order_date (주문 날짜) — Date
- modified_at (수정 날짜) — TimeStamp
- products (상품) — List<Object>
- total_price (총 가격) — int
- discount_rate (할인율) — int
- cupon (쿠폰) — List<Object>
Order_Product (Untitled5)
- delivery_id (uuid) — UUID — Foreign key → Delivery.Id — NOT NULL
- product_id (상품 id) — long — Foreign key → Product.Id — NOT NULL
- price (가격) — int
- quantity (수량) — int
Product (Untitled)
- Id (Key) — long — Primary key — NOT NULL
- name (제품명) — String
- price (가격) — int
- product_info (제품 정보) — String
- discount_rate (할인율) — int
- shipping_info (배송정보) — String
- storage_method (보관 방법) — String
- expiration_date (소비기한) — String
- details (제품 상세) — String
- files (파일 경로) — String
- create_at (생성일자) — TimeStamp
- modified_at (수정일자) — TimeStamp
- deleted_at (삭제일자) — TimeStamp
Quantity (Untitled2)
- Id (상품 id) — long — Foreign key → Product.Id — NOT NULL
- quantity (수량) — int
Review (Untitled8)
- Id (Key) — long — Primary key — NOT NULL
- user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
- product_id (상품 id) — long — Foreign key → Product.Id — NOT NULL
- files (파일 경로) — String
- content (내용) — String
User (user)
- Id (uuid) — UUID — Primary key — NOT NULL
- user_id (유저 아이디) — String
- password (비밀번호) — String
- nickname (닉네임) — String
- role (역할) — Enum
- cupons (쿠폰) — List<Object>
- created_at (생성일자) — TimeStamp
- modified_at (수정일자) — TimeStamp
- deleted_at (삭제일자) — TimeStamp
User_Cupon (Untitled7)
- Id (Key) — long — Primary key — NOT NULL
- user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
- cupon_id (id) — long — Foreign key → Cupon.Id — NOT NULL
- delivery_id (배송 uuid) — UUID — Foreign key → Delivery.Id — NOT NULL
- quantity (수량) — int
- staus (상태) — enum
- created_at (생성일자) — TimeStamp
- modified_at (수정일자) — TimeStamp