# 个人任务运营查询手册

更新时间：`2026-05-03`

## 任务配置

```powershell
spacetime sql <db> "SELECT * FROM profile_task_config ORDER BY updated_at DESC"
spacetime sql <db> "SELECT * FROM profile_task_config WHERE task_id = 'daily_login'"
```

## 任务进度

```powershell
spacetime sql <db> "SELECT * FROM profile_task_progress WHERE user_id = '<user_id>' ORDER BY updated_at DESC"
spacetime sql <db> "SELECT * FROM profile_task_progress WHERE user_id = '<user_id>' AND task_id = 'daily_login' ORDER BY day_key DESC"
```

## 领奖记录

```powershell
spacetime sql <db> "SELECT * FROM profile_task_reward_claim WHERE user_id = '<user_id>' ORDER BY claimed_at DESC"
spacetime sql <db> "SELECT * FROM profile_task_reward_claim WHERE claim_id = '<user_id>:daily_login:<day_key>'"
```

## 钱包流水对账

```powershell
spacetime sql <db> "SELECT * FROM profile_wallet_ledger WHERE user_id = '<user_id>' AND source_type = 'DailyTaskReward' ORDER BY created_at DESC"
spacetime sql <db> "SELECT * FROM profile_dashboard_state WHERE user_id = '<user_id>'"
```

每日登录奖励流水 ID 为 `task-reward:<user_id>:daily_login:<day_key>`，领奖记录中的 `wallet_ledger_id` 必须能在 `profile_wallet_ledger` 中查到。