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)(