SecondFit개인

테이블 (11)

categories

  • id (카테고리ID) — BIGINT — 기본 키 — NOT NULL
  • parent_id (상위카테고리ID) — BIGINT — 외래 키 → categories.id
  • name (이름) — VARCHAR(50) — NOT NULL
  • sort_order (정렬순서) — INT — NOT NULL

inbounds

  • id (입고ID) — BIGINT — 기본 키 — NOT NULL
  • product_id (상품ID) — BIGINT — 외래 키 → products.id — NOT NULL
  • admin_id (관리자ID) — BIGINT — 외래 키 → users.id
  • status (입고상태) — ENUM('AWAITING','CONFIRMED') — NOT NULL
  • tracking_no (송장번호) — VARCHAR(50)
  • confirmed_at (입고확인일시) — DATETIME
  • created_at (생성일시) — DATETIME — NOT NULL

orders

  • id (주문ID) — BIGINT — 기본 키 — NOT NULL
  • product_id (상품ID) — BIGINT — 외래 키 → products.id — NOT NULL
  • buyer_id (구매자ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • order_price (주문가격) — INT — NOT NULL
  • status (주문상태) — ENUM('PAID','SHIPPED','DELIVERED','CONFIRMED','CANCELLED') — NOT NULL
  • receiver_name (수령인이름) — VARCHAR(50) — NOT NULL
  • receiver_phone (수령인전화번호) — VARCHAR(20) — NOT NULL
  • zipcode (우편번호) — VARCHAR(10) — NOT NULL
  • address1 (기본주소) — VARCHAR(255) — NOT NULL
  • address2 (상세주소) — VARCHAR(255)
  • tracking_no (송장번호) — VARCHAR(50)
  • paid_at (결제일시) — DATETIME — NOT NULL
  • shipped_at (출고일시) — DATETIME
  • delivered_at (배송완료일시) — DATETIME
  • confirmed_at (거래확정일시) — DATETIME
  • created_at (생성일시) — DATETIME — NOT NULL
  • updated_at (수정일시) — DATETIME — NOT NULL

payments

  • id (결제ID) — BIGINT — 기본 키 — NOT NULL
  • order_id (주문ID) — BIGINT — 외래 키 → orders.id — NOT NULL
  • amount (결제금액) — INT — NOT NULL
  • method (결제수단) — ENUM('CARD','BANK_TRANSFER','MOCK') — NOT NULL
  • status (결제상태) — ENUM('PAID','REFUNDED','FAILED') — NOT NULL
  • pg_tid (거래식별자) — VARCHAR(100)
  • paid_at (결제일시) — DATETIME — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL

product_images

  • id (상품이미지ID) — BIGINT — 기본 키 — NOT NULL
  • product_id (상품ID) — BIGINT — 외래 키 → products.id — NOT NULL
  • image_url (이미지주소) — VARCHAR(500) — NOT NULL
  • is_thumbnail (대표이미지여부) — BOOLEAN — NOT NULL
  • sort_order (정렬순서) — INT — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL

products

  • id (상품ID) — BIGINT — 기본 키 — NOT NULL
  • seller_id (판매자ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • category_id (카테고리ID) — BIGINT — 외래 키 → categories.id
  • title (제목) — VARCHAR(150) — NOT NULL
  • description (설명) — TEXT
  • price (가격) — INT — NOT NULL
  • size (사이즈) — VARCHAR(20)
  • color (색상) — VARCHAR(30)
  • condition_grade (상태등급) — ENUM('NEW','LIKE_NEW','GOOD','FAIR','POOR') — NOT NULL
  • status (거래상태) — ENUM('PENDING_INBOUND','ON_SALE','PAID','SHIPPED','DELIVERED','SETTLED') — NOT NULL
  • view_count (조회수) — INT — NOT NULL
  • ai_suggested_category (AI추천카테고리) — VARCHAR(50)
  • ai_suggested_color (AI추천색상) — VARCHAR(30)
  • ai_confidence (AI신뢰도) — DECIMAL(5,4)
  • created_at (생성일시) — DATETIME — NOT NULL
  • updated_at (수정일시) — DATETIME — NOT NULL

reports

  • id (신고ID) — BIGINT — 기본 키 — NOT NULL
  • reporter_id (신고자ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • product_id (상품ID) — BIGINT — 외래 키 → products.id
  • admin_id (관리자ID) — BIGINT — 외래 키 → users.id
  • reason (신고사유) — ENUM('FAKE','ABUSE','PROHIBITED','SPAM','ETC') — NOT NULL
  • detail (상세내용) — VARCHAR(500)
  • status (처리상태) — ENUM('RECEIVED','REVIEWING','RESOLVED','REJECTED') — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL
  • resolved_at (처리일시) — DATETIME

reviews

  • id (리뷰ID) — BIGINT — 기본 키 — NOT NULL
  • order_id (주문ID) — BIGINT — 외래 키 → orders.id — NOT NULL
  • reviewer_id (작성자ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • seller_id (판매자ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • rating (평점) — TINYINT — NOT NULL
  • content (내용) — VARCHAR(1000)
  • created_at (생성일시) — DATETIME — NOT NULL

settlements

  • id (정산ID) — BIGINT — 기본 키 — NOT NULL
  • order_id (주문ID) — BIGINT — 외래 키 → orders.id — NOT NULL
  • seller_id (판매자ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • admin_id (관리자ID) — BIGINT — 외래 키 → users.id
  • gross_amount (판매금액) — INT — NOT NULL
  • fee_amount (수수료) — INT — NOT NULL
  • net_amount (실지급액) — INT — NOT NULL
  • status (정산상태) — ENUM('PENDING','COMPLETED') — NOT NULL
  • settled_at (정산완료일시) — DATETIME
  • created_at (생성일시) — DATETIME — NOT NULL

users

  • id (회원ID) — BIGINT — 기본 키 — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • nickname (닉네임) — VARCHAR(50) — NOT NULL
  • role (권한) — ENUM('USER','ADMIN') — NOT NULL
  • phone (전화번호) — VARCHAR(20)
  • profile_image (프로필이미지) — VARCHAR(500)
  • status (계정상태) — ENUM('ACTIVE','SUSPENDED','WITHDRAWN') — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL
  • updated_at (수정일시) — DATETIME — NOT NULL

wishlists

  • id (찜ID) — BIGINT — 기본 키 — NOT NULL
  • user_id (회원ID) — BIGINT — 외래 키 → users.id — NOT NULL
  • product_id (상품ID) — BIGINT — 외래 키 → products.id — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL