store

Tables (15)

Cart (Untitled5)

  • id (cart_id) — Long — Primary key — NOT NULL
  • id (member_id) — Long — Foreign key → Member.id — NOT NULL

CartItem (Untitled6)

  • id (cart_item_id) — Long — Primary key — NOT NULL
  • 상품 (product_id) — Long
  • 수량 (quantity) — itn
  • id (cart_id) — Long — Foreign key → Cart.id — NOT NULL

Category (Untitled12)

  • id (category_id) — Long — Primary key — NOT NULL
  • 이름 (name) — varchar(255)

Coupon (Untitled4)

  • id (coupon_id) — Long — Primary key — NOT NULL
  • 제목 (title) — varchar(255)
  • 수량 (total_quantity) — int
  • 발급수량 (issed_quantity) — int

Delivery (Untitled3)

  • id (delivery_id) — Long — Primary key — NOT NULL
  • 수신사 (recipient) — varchar(255)
  • 주소 (address) — varchar(255)
  • 전화번호 (phone_number) — varchar(255)
  • 요청사항 (reqeust) — varchar(255)
  • 체크 (delivery_checked) — enum
  • id (member_id) — Long — Foreign key → Member.id — NOT NULL

FailedTask (Untitled7)

  • id (failed_task_id) — Long — Primary key — NOT NULL
  • 타입 (task_type) — varchar(255)
  • 데이터 (task_data) — varchar(255)
  • 실패시간 (failed_at) — LoclaDateTime
  • 재시도횟수 (retry_count) — int
  • 상태 (status) — enum

Member (Untitled)

  • id (member_id) — Long — Primary key — NOT NULL
  • 이메일 (emali) — varchar(255)
  • 이름 (name) — varchar(255)
  • 패스워드 (password) — varchar(255)
  • 성별 (gender) — varchar(255)
  • 생년월일 (birthDate) — LocalDateTime
  • 권한 (role) — enum

MemberCoupon (Untitled2)

  • id (member_coupon_id) — Long — Primary key — NOT NULL
  • 발급시간 (date_issued) — LocalDateTime
  • 쿠폰사용시간 (date_used) — LocalDateTime
  • Field
  • id (member_id) — Long — Foreign key → Member.id — NOT NULL
  • id (coupon_id2) — Long — Foreign key → Coupon.id — NOT NULL

Order (Untitled8)

  • id (order_id) — Long — Primary key — NOT NULL
  • 유저 (member_id) — Long
  • 배송 (delivery_id) — Long
  • 총가격 (total_price) — 총가격
  • 상태 (status) — enum

OrderItem (Untitled9)

  • id (order_item_id) — Long — Primary key — NOT NULL
  • 주문 (order_id) — Long
  • 상품 (product_id) — Long
  • id (order_id2) — Long — Foreign key → Order.id — NOT NULL

OutboxEvent (Untitled10)

  • id (outbox_event_id) — Long — Primary key — NOT NULL
  • 타입 (aggregate_type) — varchar(255)
  • 아이디 (aggregate_id) — varchar(255)
  • 이벤트타입 (event_type) — varchar(255)
  • 정보 (pay_load) — varchar(255)

Product (Untitled13)

  • id (product_id) — Long — Primary key — NOT NULL
  • 제목 (title) — varchar(255)
  • 가격 (price) — int
  • 수량 (quantity) — int
  • 판매수량 (sale_quantity) — int
  • id (category_id) — Long — Foreign key → Category.id — NOT NULL

ProductDetail (Untitled14)

  • id (product_detail_id) — Long — Primary key — NOT NULL
  • 설명 (description) — varchar(255)
  • id (product_id) — Long — Foreign key → Product.id — NOT NULL

Review (Untitled15)

  • id (review_id) — Long — Primary key — NOT NULL
  • 별점 (rating) — int
  • 제목 (title) — varchar(255)
  • 내용 (content) — varchar(255)
  • 유저 (member_id) — Long
  • id (product_id) — Long — Foreign key → Product.id — NOT NULL

payment (Untitled11)

  • id (payment_id) — Long — Primary key — NOT NULL
  • 주문 (order_id) — Long
  • 유저 (user_id) — Long
  • 수량 (amount) — int
  • 상태 (status) — enum
  • 실패이유 (failure_reason) — varchar(255)(