MLsql2

Tables (11)

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
  • confidence_score — DECIMAL(5, 4)
  • accepted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

audit_logs

  • id — UUID
  • user_id — UUID — NOT NULL
  • action — TEXT — NOT NULL
  • target_type — TEXT — 대상
  • target_id — UUID
  • ip_address — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

cart_items

  • id — UUID
  • retailer_id — UUID — NOT NULL
  • product_id — UUID — NOT NULL — products
  • variant_id — UUID — product_variants
  • quantity — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

cs_messages

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

cs_threads

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

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 — TossPayments
  • paid_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

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 — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

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가
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

retailers

  • id — UUID
  • user_id — UUID — NOT NULL
  • business_name — TEXT — NOT NULL
  • address — TEXT — NOT NULL
  • phone — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

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 — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

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 — TIMESTAMPTZ — NOT NULL
  • approved_at — TIMESTAMPTZ