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