09. 程序化 SEO 与规模化页面供给 · 资料陈述 · 教学步骤 3

把页面拆成稳定内容模型

稳定结构让内容能够批量生成、局部更新、审核和重跑。

原知识点：Woy的CMS把内容拆成Page、Section、Content与Tag，分别承载公共页面、章节、结构化内容和分类关系。

执行步骤

1. 先画实体关系：页面解决什么任务，Section承担哪些答案，Content保存哪些事实，Tag只用于哪些分类。
2. 为每个字段规定类型、是否必填、允许空值、唯一键和校验规则。
3. 为事实字段增加来源、获取时间、许可、有效期和审核状态。
4. 写出一条完整示例记录并渲染成页面，检查缺值、冲突和转义。
5. 给Schema标版本；字段变更先迁移预览数据再进入生产。

可复制工作表

# JSON Schema（复制后把__替换为实际值）
```json
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "__",
  "title": "RoutePage",
  "type": "object",
  "additionalProperties": false,
  "required": ["id", "slug", "originId", "destinationId", "facts", "status", "schemaVersion"],
  "properties": {
    "id": {"type": "string", "minLength": 1},
    "slug": {"type": "string", "pattern": "^[a-z0-9-]+{{INITIAL_CONTENT}}quot;},
    "originId": {"type": "string", "minLength": 1},
    "destinationId": {"type": "string", "minLength": 1},
    "facts": {
      "type": "array",
      "minItems": 1,
      "items": {
        "type": "object",
        "additionalProperties": false,
        "required": ["field", "value", "unit", "sourceUrl", "checkedAt", "licenseStatus"],
        "properties": {
          "field": {"enum": ["distanceKm", "durationMinutes", "fare"]},
          "value": {"type": "number", "minimum": 0},
          "unit": {"enum": ["km", "minute", "CNY"]},
          "sourceUrl": {"type": "string", "format": "uri", "pattern": "^https://"},
          "checkedAt": {"type": "string", "format": "date-time"},
          "licenseStatus": {"enum": ["approved", "restricted", "unknown"]}
        },
        "allOf": [
          {"if": {"properties": {"field": {"const": "distanceKm"}}, "required": ["field"]}, "then": {"properties": {"unit": {"const": "km"}}}},
          {"if": {"properties": {"field": {"const": "durationMinutes"}}, "required": ["field"]}, "then": {"properties": {"unit": {"const": "minute"}}}},
          {"if": {"properties": {"field": {"const": "fare"}}, "required": ["field"]}, "then": {"properties": {"unit": {"const": "CNY"}}}}
        ]
      }
    },
    "tags": {"type": "array", "items": {"type": "string"}, "uniqueItems": true},
    "status": {"enum": ["draft", "review", "published", "withdrawn"]},
    "schemaVersion": {"const": "__"}
  }
}
```

# 数据库Schema
```sql
CREATE TABLE route_page (
  id TEXT PRIMARY KEY,
  slug TEXT NOT NULL UNIQUE,
  origin_id TEXT NOT NULL,
  destination_id TEXT NOT NULL,
  status TEXT NOT NULL CHECK (status IN ('draft','review','published','withdrawn')),
  schema_version TEXT NOT NULL,
  UNIQUE(origin_id, destination_id)
);
CREATE TABLE page_fact (
  page_id TEXT NOT NULL REFERENCES route_page(id),
  field TEXT NOT NULL CHECK (field IN ('distanceKm','durationMinutes','fare')),
  value_json TEXT NOT NULL CHECK (json_valid(value_json)) CHECK (json_type(value_json) IN ('integer','real')) CHECK (CAST(value_json AS REAL) >= 0),
  unit TEXT NOT NULL CHECK (
    (field='distanceKm' AND unit='km') OR
    (field='durationMinutes' AND unit='minute') OR
    (field='fare' AND unit='CNY')
  ),
  source_url TEXT NOT NULL CHECK (source_url LIKE 'https://%'),
  checked_at TEXT NOT NULL CHECK (
    checked_at GLOB '????-??-??T??:??:??Z' AND
    datetime(checked_at) IS NOT NULL AND
    strftime('%Y-%m-%dT%H:%M:%SZ', checked_at)=checked_at
  ),
  license_status TEXT NOT NULL CHECK (license_status IN ('approved','restricted','unknown')),
  PRIMARY KEY(page_id, field, source_url)
);
```

# 示例记录
```json
{"id":"__","slug":"__","originId":"__","destinationId":"__","facts":[{"field":"distanceKm","value":0,"unit":"km","sourceUrl":"https://__","checkedAt":"__","licenseStatus":"approved"}],"tags":["__"],"status":"draft","schemaVersion":"__"}
```

校验命令/工具：__
预期通过：__
预期失败记录及错误：__
迁移前版本/记录：__
迁移步骤：__
迁移后版本/记录：__
回滚命令/条件：__

完整示例

完成清单

• JSON Schema和数据库都约束非负事实值、字段—单位、必填、唯一、枚举、来源与真实日历日期。
• 包含完整通过记录，以及错误类型、负数、非法JSON和无效日历日期等具有预期错误的失败记录。
• 迁移前后结构、数据转换、验证命令和回滚条件齐全。
• 约束与渲染测试能证明缺值、类型、数值范围、日期、冲突和转义行为符合发布门禁。

适用条件

页面类型和章节类型需有稳定语义，不能退化成无约束富文本。

来源：SEO友好的AI原生 CMS 的思考和实践