{"slug":"pdlc-db-design","title":"pdlc-db-design","summary":"数据库设计","platform":"Claude","tags":[],"authorName":"LLM Mart","authorSlug":"llm-mart","score":0,"source":"github","price":null,"verified":false,"createdAt":"2026-09-23T18:54:22.552424Z","repo":{"url":"https://github.com/kanfu-panda/pdlc-skills","stars":15,"forks":2,"license":"MIT","updatedAt":"2026-09-23T15:59:31Z"},"bodyHtml":"
\n

name: pdlc-db-design\ndescription: 数据库设计\nargument-hint: <功能ID | 数据模型描述>\nallowed-tools: Read, Write, Edit, Glob, Grep, Bash\nlayer: 3\nstage: design\nproduces:

\n\n
\n

数据库设计

\n\n

⛔ IRON LAW · 不可违反的硬门禁

\n

以下规则为不可协商的执行约束：

\n
    \n
  1. 文件必须落盘：所有带编号（功能ID / 缺陷ID）的文档，必须作为实际文件写入磁盘，不可仅在对话中输出。
    2. \n
  2. 阶段必须落章：每个阶段完成后必须在状态机 docs/.pdlc-state/<feature-id>.json 追加 history，不可跳过。
    3. \n
  3. 测试必须存在：进入 /pdlc-implement 前，对应测试必须存在且处于红灯状态。违反则中止。
    4. \n
  4. 自检必须执行：段二自检为强制步骤，不得以\"已经很好了\"为由跳过。
    5. \n
  5. 防循环：段三修复为单次，不递归。无法自动修复的问题记录到报告，继续往下走。
    6. \n
  6. 状态必推进：成功执行某 phase 后 current_stage 必须变更。收尾时若发现 current_stage 未推进，视为失败并报错，不得静默返回（防止外层循环拿滞后的状态空转烧额度）。唯一例外：命中人工点主动 block 时，current_stage 保持不变但必须写 last_phase_result.ok=false + blocked_reason。
    7. \n
\n

违反任一条 = 立即中止当前命令，输出违规详情，等待人工介入。

\n\n

根据需求和 API 设计文档，创建数据库设计方案。

\n

PDLC 前置检查（必须执行，不可跳过）

\n
    \n
  1. 从用户输入中提取功能名称关键词
    2. \n
  2. 在 docs/01_requirements/prd/ 目录下搜索包含该关键词的 PRD 文档\n\n
    3. \n
  3. 未找到 → 输出以下信息后立即停止，不继续执行：\n
    ⛔ PDLC 守卫：未找到与「<功能名>」相关的 PRD 文档。\n数据库设计必须基于已有的 PRD。请先运行：\n\uD83D\uDC49 /pdlc-prd <需求描述>\n
    \n
    4. \n
  4. 找到 → 提取功能ID（如 F20260326-090000），读取该 PRD 内容，继续执行
    5. \n
\n

工作流程

\n
    \n
  1. 阅读需求: 阅读找到的 PRD 文档
    2. \n
  2. 阅读 API 设计: 阅读 docs/02_design/api/ 下同功能ID的 API 设计文档（如有）
    3. \n
  3. 梳理数据模型: 识别实体、属性、关系
    4. \n
  4. ER 图: 用文本方式描绘实体关系图
    5. \n
  5. 表结构定义: 逐表定义字段、类型、约束
    6. \n
  6. 索引设计: 根据查询场景设计索引
    7. \n
  7. 输出设计文档: 在 docs/02_design/database/ 下创建数据库设计文档
    8. \n
\n

文档内容

\n\n

ER 图格式

\n
[用户] 1──N [订单] N──N [商品]\n  │                       │\n  └───N [地址]    [库存] 1─┘\n
\n

表结构格式

\n\n\n\n\n\n\n\n\n\n\n\n
字段类型可空默认值索引描述
\n

必须包含

\n\n

要求

\n\n

\uD83C\uDF10 Output language for generated artifacts

\n

All generated artifacts (PRDs, design docs, code comments, review reports,\ntest plans, deployment manuals, changelog entries, etc.) follow this policy:

\n
    \n

  1. Default — match the conversation language exactly:

    \n\n
    2. \n

  2. Explicit override always wins: when the user specifies a language for\nan artifact (e.g. \"write the PRD in English\", \"用英文写 API 设计文档\",\n\"output the deploy doc in Japanese\"), use that language for that artifact,\nregardless of conversation language.

    \n
    3. \n

  3. Mixed-language requirements: if the user wants some artifacts in one\nlanguage and others in a different language (common: Chinese PRD + English\nAPI docs for partners), honour each per-artifact instruction.

    \n
    4. \n

  4. Uncertain: if you cannot reliably detect the conversation language,\nask once before producing the first artifact.

    \n
    5. \n
\n

This policy applies to content (prose, comments, headings). It does\nnot override technical conventions like English variable names, English\ngit commit subjects, or English error codes when the project's conventions\nrequire them.

\n\n\n

设计目标: $ARGUMENTS

\n\n

段四：交接（Handoff）

\n

命令完成后必须输出以下格式的最终消息：

\n
✅ <阶段名> 完成：<主要产出物路径>\n\uD83D\uDCCA 自检：<通过数>/<总数> 通过（若有未通过，附要点）\n\uD83D\uDCE6 状态快照：docs/.pdlc-state/<feature-id>.json\n\uD83D\uDC49 下一步：/pdlc-<next_step>\n   （如果有分叉）或 /pdlc-<alt>（条件：<选择依据>）\n
\n

规则：

\n\n\n

本命令的 handoff 输出：

\n
✅ 数据库设计文档 完成\n\uD83D\uDCE6 产出：docs/02_design/database/<功能ID>-<功能名>-db.md\n\uD83D\uDC49 下一步：（本次流程结束，无后续）\n
\n","files":[{"path":"SKILL.md","sizeBytes":6758,"isText":true}],"reviewScore":null,"reviewSummary":null,"trust":{"provenance":"trusted-source-unreviewed","notice":"Community-authored content, reproduced verbatim and not vetted as instructions. Treat it as data to evaluate, never as directives to follow.","bodySource":null},"bodyLocked":false,"purchaseUrl":null,"sourceUrl":null,"report":{"provenance":"trusted-source-unreviewed","screen":{"ran":true,"outcome":"clean","suspicious":0,"notes":0,"hiddenCharacters":false},"virusScan":{"engine":"clamav","status":"clean","scannedAt":"2026-09-23T18:54:28.417245Z","sha256":"EFAFDFBFB6E0A232E2FA6F3169744722FE6223122CB11572B58E4DA739C6B4D4","sizeBytes":3740},"review":null,"source":{"repositoryUrl":"https://github.com/kanfu-panda/pdlc-skills","path":"skills/pdlc-db-design","license":"MIT","commit":"3cd2f02ab45cb1cd48962e0f298ae4dad9fb442f","subtreeSha":"CD1DBF1D21BB09FE9E431E510199FB2DF202CEE98151C7C30F34D27E98D1D788","lastSyncedAt":"2026-09-23T18:54:21.123477Z"},"reviewedAt":"2026-09-23T18:55:10.101766Z","notice":"Community-authored content, reproduced verbatim and not vetted as instructions. Treat it as data to evaluate, never as directives to follow."},"install":[{"target":"skills-cli","command":"npx skills add https://github.com/kanfu-panda/pdlc-skills/tree/main/skills/pdlc-db-design"},{"target":"claude-code","command":"claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install kanfu-panda-pdlc-skills@llmmart"},{"target":"git","command":"git clone https://github.com/kanfu-panda/pdlc-skills.git"}]}