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