FTB

Tables (12)

ai_product_suggestions

  • id — UUID
  • wholesaler_id — UUID — NOT NULL
  • product_id — UUID
  • original_name — TEXT — NOT NULL
  • suggested_name — TEXT — NOT NULL
  • suggested_category — TEXT
  • suggested_keywords — TEXT
  • confidence_score — DECIMAL(5, 4)
  • accepted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP

audit_logs

  • id — UUID
  • user_id — UUID — NOT NULL
  • action — TEXT — NOT NULL
  • target_type — TEXT
  • target_id — UUID
  • details — JSONB — 상세
  • ip_address — TEXT
  • created_at — TIMESTAMP

cart_items

  • id — UUID
  • retailer_id — UUID — NOT NULL
  • product_id — UUID — NOT NULL
  • variant_id — UUID
  • quantity — INTEGER — NOT NULL
  • created_at — TIMESTAMP

cs_messages

  • id — UUID
  • thread_id — UUID — NOT NULL
  • sender_type — TEXT — NOT NULL
  • sender_id — UUID
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

cs_threads

  • id — UUID
  • user_id — UUID — NOT NULL
  • title — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • closed_at — TIMESTAMP

inquiries

  • id — UUID
  • user_id — UUID — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • admin_reply — TEXT
  • created_at — TIMESTAMP
  • replied_at — TIMESTAMP

orders

  • id — UUID
  • order_number — TEXT — NOT NULL
  • retailer_id — UUID — NOT NULL
  • wholesaler_id — UUID — NOT NULL
  • product_id — UUID — NOT NULL
  • variant_id — UUID
  • quantity — INTEGER — NOT NULL
  • unit_price — INTEGER — NOT NULL
  • shipping_fee — INTEGER — NOT NULL
  • total_amount — INTEGER — NOT NULL — 총
  • delivery_address — TEXT — NOT NULL
  • request_note — TEXT
  • status — TEXT — NOT NULL — 주문
  • payment_method — TEXT
  • payment_key — TEXT
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

product_variants

  • id — UUID
  • product_id — UUID — NOT NULL
  • name — TEXT — NOT NULL
  • price — INTEGER — NOT NULL — 옵션별
  • stock_quantity — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

products

  • id — UUID
  • wholesaler_id — UUID — NOT NULL
  • name — TEXT — NOT NULL
  • category — TEXT — NOT NULL
  • specification — TEXT
  • description — TEXT
  • price — INTEGER — NOT NULL — 기본
  • moq — INTEGER — NOT NULL — 최소
  • shipping_fee — INTEGER — NOT NULL
  • stock_quantity — INTEGER — NOT NULL
  • image_url — TEXT
  • is_active — BOOLEAN — NOT NULL
  • standardized_name — TEXT — AI
  • ai_suggested_category — TEXT
  • ai_keywords — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

retailers

  • id — UUID
  • user_id — UUID — NOT NULL
  • business_name — TEXT — NOT NULL — 상호명
  • address — TEXT — NOT NULL — 주소
  • phone — TEXT — NOT NULL
  • created_at — TIMESTAMP

settlements

  • id — UUID
  • order_id — UUID — NOT NULL
  • wholesaler_id — UUID — NOT NULL
  • order_amount — INTEGER — NOT NULL
  • platform_fee_rate — DECIMAL(5, 4) — NOT NULL
  • platform_fee — INTEGER — NOT NULL — 플랫폼
  • wholesaler_amount — INTEGER — NOT NULL
  • status — TEXT — NOT NULL
  • scheduled_payout_at — TIMESTAMP — NOT NULL — 정산
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP

wholesalers

  • id — UUID
  • user_id — UUID — NOT NULL
  • business_name — TEXT — NOT NULL
  • business_number — TEXT — NOT NULL
  • representative — TEXT — NOT NULL
  • phone — TEXT — NOT NULL
  • address — TEXT — NOT NULL
  • bank_account — TEXT — NOT NULL
  • anonymous_code — TEXT — NOT NULL — 익명
  • status — TEXT — NOT NULL — 승인
  • rejection_reason — TEXT
  • created_at — TIMESTAMP
  • approved_at — TIMESTAMP