§L3 召回 SQL 重写到当前实现: - 子场景 4 → 10(K00–K09 全覆盖),表补全 base/dx/rec/cooldown/window/urgent/exclude (真理源 SUB_SCENARIOS + DiagnosisTreatmentMap@canonical-codes) - 入池 SQL 修正: · 只设时间下界 cooldown,⚠ ️ 去掉上界(W3 末:缺口不自愈,超 window 仍入池交 scorer 衰减) · COALESCE(occurred_at, planned_for)(诊断 vs 推荐) · 排除升级为牙位级 overlap(W4)+ 时间方向 tx.occurred_at >= sig + ⑤b拔除 ⑤c未来预约排除 - 合并逻辑:旧"取 days_since 最大丢其余" → tooth-overlap union-find · sub_key = '<sub>@<union(tooth)|whole>';同 patient 同 sub 不同牙位 = 多 reason 行 · cluster_triggers/factIds 全量;来源标签 dx+rec → "(诊断+医生建议)" - 总览图 mermaid "4 子规则" → 10 - 实现状态:scenario 3→10 子规则;DW 增量 cursor 🟡→✅ (统一 sync 重构)
| Name |
Last commit
|
Last update |
|---|---|---|
| .. | ||
| .obsidian | Loading commit data... | |
| algorithm | Loading commit data... | |
| scenarios | Loading commit data... | |
| architecture-v2.md | Loading commit data... | |
| architecture.md | Loading commit data... | |
| db-design-v2.md | Loading commit data... | |
| db-review-confirm.md | Loading commit data... | |
| db-review.md | Loading commit data... | |
| db-suggest-after-review.md | Loading commit data... | |
| demo-page-prompt.md | Loading commit data... | |
| deployment-data-ingest.md | Loading commit data... | |
| design-philosophy.md | Loading commit data... | |
| design-system.md | Loading commit data... | |
| design-v2.md | Loading commit data... | |
| design.md | Loading commit data... | |
| dw-data-source-issues.md | Loading commit data... | |
| host-data-dictionary-example.yaml | Loading commit data... | |
| host-data-request-checklist-v2.md | Loading commit data... | |
| host-data-request-checklist.md | Loading commit data... | |
| host-integration-clickhouse-view.md | Loading commit data... | |
| host-integration-v2.md | Loading commit data... | |
| host-integration.md | Loading commit data... | |
| onboarding-runbook.md | Loading commit data... | |
| pac-for-committee.md | Loading commit data... | |
| pac-goal-alignment.md | Loading commit data... | |
| prompt.md | Loading commit data... | |
| three-layer-model.md | Loading commit data... | |
| treatment-chain-followup-recall.md | Loading commit data... | |
| w1-report.md | Loading commit data... | |
| w2-report.md | Loading commit data... | |
| w3-report.md | Loading commit data... |