Goods

Tables (17)

cart_item

  • cart_item_id — 장바구니항목고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • product_id — 상품고유번호` — NOT NULL — FK → product
  • quantity — 수량` — NOT NULL — 담은 수량
  • created_at — 생성일시` — NOT NULL
  • updated_at — 수정일시` — NOT NULL

category

  • category_id — 카테고리고유번호` — Primary key — NOT NULL
  • name — 카테고리명` — NOT NULL — 피규어 | 스니커즈 | 트레이딩카드 | 의류 | 전자기기 | 기타
  • parent_id — 상위카테고리번호` — FK → category (self, 계층형)
  • depth — 깊이` — NOT NULL
  • sort_order — 정렬순서` — NOT NULL
  • is_active — 활성여부` — NOT NULL
  • created_at — 생성일시` — NOT NULL

charge

  • charge_id — 충전고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • wallet_transaction_id — 지갑거래내역번호` — FK → wallet_transaction (성공 시)
  • requested_amount — 요청금액` — NOT NULL
  • approved_amount — 승인금액`
  • pg_provider — PG사` — NOT NULL — TOSS | KAKAO | NICE
  • pg_transaction_id — PG거래번호` — PG사 고유 거래번호
  • pg_raw_response — PG응답원문` — PG 응답 JSON (민감정보 암호화)
  • charge_status — 충전상태` — NOT NULL — PENDING | SUCCESS | FAILED | CANCELLED
  • requested_at — 요청일시` — NOT NULL
  • approved_at — 승인일시`

member

  • member_id — 회원고유번호` — Primary key — NOT NULL
  • email — 이메일` — NOT NULL — 로그인 ID (UNIQUE)
  • password — 비밀번호` — NOT NULL — 암호화 저장 (BCrypt)
  • nickname — 닉네임` — NOT NULL — UNIQUE
  • phone — 핸드폰`
  • address — 주소` — 배송지 주소
  • profile_image_url — 프로필이미지` — S3 URL
  • role — 역할` — NOT NULL — BUYER | SELLER | ADMIN
  • status — 상태` — NOT NULL — ACTIVE | SUSPENDED | DELETED
  • is_seller — 판매자여부` — NOT NULL — 판매자 등록 완료 시 TRUE
  • created_at — 생성일시` — NOT NULL
  • updated_at — 수정일시` — NOT NULL

member_restriction

  • restriction_id — 제재고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • admin_id — 관리자고유번호` — NOT NULL — FK → member (ADMIN)
  • reason — 사유` — NOT NULL
  • restriction_type — 제재유형` — NOT NULL — TRADE_BAN | LOGIN_BAN
  • duration_hours — 제재시간` — NOT NULL
  • end_at — 종료일시` — NOT NULL
  • is_active — 활성여부` — NOT NULL
  • created_at — 생성일시` — NOT NULL

notification

  • notification_id — 알림고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • type — 알림유형` — NOT NULL — ORDER_PLACED | ORDER_SHIPPED | ORDER_CONFIRMED | SETTLEMENT_COMPLETED | CHARGE_SUCCESS | SYSTEM
  • title — 제목` — NOT NULL
  • content — 내용` — NOT NULL
  • reference_type — 참조유형` — ORDER | PRODUCT | SETTLEMENT | CHARGE
  • reference_id — 참조ID`
  • is_read — 읽음여부` — NOT NULL
  • created_at — 생성일시` — NOT NULL

order_item

  • order_item_id — 주문항목고유번호` — Primary key — NOT NULL
  • order_id — 주문고유번호` — NOT NULL — FK → orders
  • product_id — 상품고유번호` — NOT NULL — FK → product
  • seller_id — 판매자고유번호` — NOT NULL — FK → member (판매자)
  • quantity — 수량` — NOT NULL
  • unit_price — 단가` — NOT NULL — 구매 시점의 가격 (스냅샷)
  • subtotal — 소계` — NOT NULL — unit_price x quantity
  • item_status — 항목상태` — NOT NULL — PENDING | PAID | SHIPPING | DELIVERED | CONFIRMED | CANCELLED | REFUNDED
  • created_at — 생성일시` — NOT NULL

orders

  • order_id — 주문고유번호` — Primary key — NOT NULL
  • buyer_id — 구매자고유번호` — NOT NULL — FK → member
  • total_amount — 총주문금액` — NOT NULL
  • order_status — 주문상태` — NOT NULL — PENDING | PAID | SHIPPING | DELIVERED | CONFIRMED | CANCELLED | REFUNDED
  • shipping_address — 배송주소` — NOT NULL
  • shipping_name — 수령인이름` — NOT NULL
  • shipping_phone — 수령인연락처` — NOT NULL
  • tracking_number — 운송장번호` — 배송 시작 후 입력
  • created_at — 생성일시` — NOT NULL
  • updated_at — 수정일시` — NOT NULL

payment

  • payment_id — 결제고유번호` — Primary key — NOT NULL
  • order_id — 주문고유번호` — NOT NULL — FK → orders
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • amount — 결제금액` — NOT NULL
  • payment_method — 결제수단` — NOT NULL — WALLET(예치금) | PG(직접결제)
  • payment_status — 결제상태` — NOT NULL — PENDING | COMPLETED | CANCELLED | REFUNDED
  • pg_transaction_id — PG거래번호` — PG 직접결제 시
  • created_at — 생성일시` — NOT NULL
  • updated_at — 수정일시` — NOT NULL

product

  • product_id — 상품고유번호` — Primary key — NOT NULL
  • seller_id — 판매자고유번호` — NOT NULL — FK → member (판매자)
  • category_id — 카테고리고유번호` — NOT NULL — FK → category
  • title — 상품명` — NOT NULL
  • description — 상품설명`
  • brand — 브랜드` — Nike, Lego, Bandai 등
  • price — 판매가격` — NOT NULL
  • stock — 재고수량` — NOT NULL — 0이면 품절
  • condition_grade — 상품등급` — NOT NULL — NEW | LIKE_NEW | USED_A | USED_B
  • is_limited — 한정판여부` — NOT NULL — TRUE면 한정판 뱃지 표시
  • release_date — 발매일` — 원래 발매일 (한정판의 경우)
  • status — 판매상태` — NOT NULL — ACTIVE | SOLD_OUT | HIDDEN | DELETED
  • sale_type — 판매유형` — NOT NULL — FIXED(고정가) | AUCTION(경매) - 경매 확장용
  • view_count — 조회수` — NOT NULL
  • created_at — 생성일시` — NOT NULL
  • updated_at — 수정일시` — NOT NULL

product_image

  • image_id — 이미지고유번호` — Primary key — NOT NULL
  • product_id — 상품고유번호` — NOT NULL — FK → product
  • image_url — 이미지URL` — NOT NULL — S3/CDN URL
  • sort_order — 노출순서` — NOT NULL
  • is_thumbnail — 대표이미지여부` — NOT NULL
  • created_at — 생성일시` — NOT NULL

seller_info

  • seller_info_id — 판매자정보고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member (UNIQUE, 1인 1판매자)
  • business_name — 상호명` — 사업자명 (개인판매자는 NULL)
  • business_number — 사업자번호` — 사업자등록번호 (선택)
  • bank_name — 은행명` — NOT NULL — 정산 계좌 은행
  • account_number — 계좌번호` — NOT NULL — 정산 계좌번호 (암호화 저장)
  • account_holder — 예금주` — NOT NULL
  • commission_rate — 수수료율` — NOT NULL — 판매 수수료율 (기본 10%)
  • seller_grade — 판매자등급` — NOT NULL — NORMAL | POWER | PREMIUM
  • approved_at — 승인일시` — 판매자 승인 시각
  • created_at — 생성일시` — NOT NULL

settlement

  • settlement_id — 정산고유번호` — Primary key — NOT NULL
  • seller_id — 판매자고유번호` — NOT NULL — FK → member (판매자)
  • settlement_period — 정산기간` — NOT NULL — 정산 월 (예: 2025-03)
  • total_sales — 총매출액` — NOT NULL — 해당 월 총 판매 금액
  • commission_amount — 수수료금액` — NOT NULL — 플랫폼 수수료
  • settlement_amount — 정산금액` — NOT NULL — 총매출 - 수수료 = 판매자 수령액
  • settlement_status — 정산상태` — NOT NULL — PENDING | PROCESSING | COMPLETED | FAILED
  • settled_at — 정산완료일시` — 실제 정산 완료 시각
  • created_at — 생성일시` — NOT NULL

settlement_item

  • settlement_item_id — 정산항목고유번호` — Primary key — NOT NULL
  • settlement_id — 정산고유번호` — NOT NULL — FK → settlement
  • order_item_id — 주문항목고유번호` — NOT NULL — FK → order_item
  • sale_amount — 판매금액` — NOT NULL
  • commission_rate — 수수료율` — NOT NULL
  • commission_amount — 수수료금액` — NOT NULL
  • net_amount — 정산금액` — NOT NULL — 판매금액 - 수수료
  • created_at — 생성일시` — NOT NULL

wallet

  • wallet_id — 지갑고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member (UNIQUE, 1인 1지갑)
  • balance — 잔액` — NOT NULL
  • created_at — 생성일시` — NOT NULL
  • updated_at — 수정일시` — NOT NULL

wallet_transaction

  • transaction_id — 거래내역고유번호` — Primary key — NOT NULL
  • wallet_id — 지갑고유번호` — NOT NULL — FK → wallet
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • amount — 거래금액` — NOT NULL — +충전/-사용
  • balance_after — 거래후잔액` — NOT NULL
  • transaction_type — 거래유형` — NOT NULL — CHARGE | PURCHASE | SALE_INCOME | WITHDRAWAL | REFUND | SETTLEMENT
  • reference_id — 참조ID` — 관련 주문/충전/정산 ID
  • reference_type — 참조유형` — ORDER | CHARGE | SETTLEMENT
  • description — 설명`
  • created_at — 생성일시` — NOT NULL

wish

  • wish_id — 찜고유번호` — Primary key — NOT NULL
  • member_id — 회원고유번호` — NOT NULL — FK → member
  • product_id — 상품고유번호` — NOT NULL — FK → product
  • created_at — 생성일시` — NOT NULL