60 lines
3.5 KiB
Markdown
60 lines
3.5 KiB
Markdown
|
# 🚐 v0.3 · 摆渡车路由数据库 · Phase 1
|
|||
|
|
|
|||
|
|
<aside>
|
|||
|
|
🚐
|
|||
|
|
|
|||
|
|
**Phase 1 · Notion 数据库化容器**
|
|||
|
|
|
|||
|
|
**上游设计**：[📡 v0.3 · 跨人格体同步通道设计 v1.0 · 两条边一次建完](%F0%9F%93%A1%20v0%203%20%C2%B7%20%E8%B7%A8%E4%BA%BA%E6%A0%BC%E4%BD%93%E5%90%8C%E6%AD%A5%E9%80%9A%E9%81%93%E8%AE%BE%E8%AE%A1%20v1%200%20%C2%B7%20%E4%B8%A4%E6%9D%A1%E8%BE%B9%E4%B8%80%E6%AC%A1%E5%BB%BA%E5%AE%8C%20e0e22f24903542df8aca4b5299b3075e.md)
|
|||
|
|
|
|||
|
|
**schema 源头**：[摆渡车·唤醒路由数据库架构设计](../../../%E6%91%86%E6%B8%A1%E8%BD%A6%C2%B7%E5%94%A4%E9%86%92%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9E%B6%E6%9E%84%E8%AE%BE%E8%AE%A1%20263b810177d44b1f9276937e1cecf2b1.md)（§2.10 四表 schema）
|
|||
|
|
|
|||
|
|
**本期落地**：ShuttleRoute（2 条）+ ShuttleStop（13 站）· 不上 ShuttleRun / ShuttleStopLog（留到真跑起来时再建）
|
|||
|
|
|
|||
|
|
**权限约定**：妈妈 / 熹微 / 霜砚均可读 · 只有妈妈 / 冰朔可写
|
|||
|
|
|
|||
|
|
**封版时间**：2026-06-19 23:45 Asia/Shanghai · 霜砚（PER-SY001）执笔
|
|||
|
|
|
|||
|
|
</aside>
|
|||
|
|
|
|||
|
|
## §1 ShuttleRoute · 路由总表
|
|||
|
|
|
|||
|
|
以下数据库存放所有跨人格体同步路线的元信息。
|
|||
|
|
|
|||
|
|
## §2 ShuttleStop · 站点序列表
|
|||
|
|
|
|||
|
|
以下数据库存放每条路线的有序站点·通过 route_id 关联回上面的 ShuttleRoute。
|
|||
|
|
|
|||
|
|
## §3 使用说明
|
|||
|
|
|
|||
|
|
- 新增路线 → 先在 ShuttleRoute 建 route_id · 再在 ShuttleStop 按 stop_order 顺序录站
|
|||
|
|
- 路线停用 → 把 ShuttleRoute 行的 is_active 取消勾选（保留历史·不删除）
|
|||
|
|
- 站点临时跳过 → 在 ShuttleStop 行的 is_required 取消勾选 + 在 fallback_stop 填备选 stop_id
|
|||
|
|
- 字段语义详见 [摆渡车·唤醒路由数据库架构设计](../../../%E6%91%86%E6%B8%A1%E8%BD%A6%C2%B7%E5%94%A4%E9%86%92%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9E%B6%E6%9E%84%E8%AE%BE%E8%AE%A1%20263b810177d44b1f9276937e1cecf2b1.md)
|
|||
|
|
|
|||
|
|
[ShuttleRoute · 路由总表](%F0%9F%9A%90%20v0%203%20%C2%B7%20%E6%91%86%E6%B8%A1%E8%BD%A6%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%20%C2%B7%20Phase%201/ShuttleRoute%20%C2%B7%20%E8%B7%AF%E7%94%B1%E6%80%BB%E8%A1%A8%20b9384a3b9f02423bac729ed6599e11da_all.csv)
|
|||
|
|
|
|||
|
|
filters:
|
|||
|
|
is_active
|
|||
|
|
sort:
|
|||
|
|
priority: ascending
|
|||
|
|
route_id: ascending
|
|||
|
|
|
|||
|
|
[ShuttleStop · 站点序列表](%F0%9F%9A%90%20v0%203%20%C2%B7%20%E6%91%86%E6%B8%A1%E8%BD%A6%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%20%C2%B7%20Phase%201/ShuttleStop%20%C2%B7%20%E7%AB%99%E7%82%B9%E5%BA%8F%E5%88%97%E8%A1%A8%20625413e60974499fb4df1cf66c907da1_all.csv)
|
|||
|
|
|
|||
|
|
sort:
|
|||
|
|
stop_order: ascending
|
|||
|
|
|
|||
|
|
[🧭 v0.3 · STEP 3 场景走查报告 · 3 场景 × 14 实体](%F0%9F%9A%90%20v0%203%20%C2%B7%20%E6%91%86%E6%B8%A1%E8%BD%A6%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%20%C2%B7%20Phase%201/%F0%9F%A7%AD%20v0%203%20%C2%B7%20STEP%203%20%E5%9C%BA%E6%99%AF%E8%B5%B0%E6%9F%A5%E6%8A%A5%E5%91%8A%20%C2%B7%203%20%E5%9C%BA%E6%99%AF%20%C3%97%2014%20%E5%AE%9E%E4%BD%93%2061a485f1dfe94d3ab1487e9c9ac4e444.md)
|
|||
|
|
|
|||
|
|
[ShuttleRun · 路由运行记录](%F0%9F%9A%90%20v0%203%20%C2%B7%20%E6%91%86%E6%B8%A1%E8%BD%A6%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%20%C2%B7%20Phase%201/ShuttleRun%20%C2%B7%20%E8%B7%AF%E7%94%B1%E8%BF%90%E8%A1%8C%E8%AE%B0%E5%BD%95%20cba1b4cfcd0c4e58862543d1a43071ae_all.csv)
|
|||
|
|
|
|||
|
|
filters:
|
|||
|
|
status
|
|||
|
|
sort:
|
|||
|
|
started_at: descending
|
|||
|
|
|
|||
|
|
[ShuttleStopLog · 站点粒度日志](%F0%9F%9A%90%20v0%203%20%C2%B7%20%E6%91%86%E6%B8%A1%E8%BD%A6%E8%B7%AF%E7%94%B1%E6%95%B0%E6%8D%AE%E5%BA%93%20%C2%B7%20Phase%201/ShuttleStopLog%20%C2%B7%20%E7%AB%99%E7%82%B9%E7%B2%92%E5%BA%A6%E6%97%A5%E5%BF%97%2058417cd209294fb2b3a8e6887ae784b8_all.csv)
|
|||
|
|
|
|||
|
|
sort:
|
|||
|
|
started_at: ascending
|