1120

Tables (13)

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

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

cart_items

  • id — UUID
  • retailer_id — UUID — NOT NULL
  • product_id — UUID — NOT NULL
  • variant_id — UUID
  • 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

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 — TIMESTAMPTZ — NOT NULL
  • replied_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
  • 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_suggested_category — TEXT
  • ai_keywords — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

profiles

  • id — UUID
  • clerk_user_id — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • role — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • 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