dbc-schema

legacy3 的头像作者 legacy3

为WoW DBC表生成效果模式定义。当添加新的游戏数据表或更新现有模式时使用。

📖 中文导读:为WoW DBC表生成效果模式定义。当添加新的游戏数据表或更新现有模式时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: dbc-schema description: Generate Effect Schema definitions for WoW DBC tables. Use when adding new game data tables or updating existing schemas.

DBC Schema Generator

Generate Effect Schema definitions for WoW database tables.

Schema Location

packages/wowlab-core/src/internal/schemas/dbc/

Schema Template

// {TableName}Schema.ts
import * as Schema from "effect/Schema";

export class {TableName} extends Schema.Class<{TableName}>("{TableName}")({
  ID: Schema.Number,
  // Other fields - preserve CSV column order!
  Name: Schema.String,
  Description: Schema.String,
  Flags: Schema.Number,
  // ...
}) {}

export const {TableName}Schema = Schema.Array({TableName});

Important Rules

  1. Preserve CSV column order - perfectionist sorting is disabled for DBC schemas
  2. Use Schema primitives - Schema.Number, Schema.String, Schema.Boolean
  3. Nullable fields - Use Schema.NullOr(Schema.Number) for optional numeric fields
  4. Arrays - Use Schema.Array(Schema.Number) for array columns

Column Type Mapping

CSV Type Effect Schema
int Schema.Number
float Schema.Number
string Schema.String
localized string Schema.String
bool Schema.Boolean
foreign key Schema.Number (reference to another table ID)

Registration

After creating schema, register in DbcTableRegistry.ts:

import { {TableName} } from "./internal/schemas/dbc/{TableName}Schema.js";

// Add to registry type
export type DbcTableName =
  | "Spell"
  | "{TableName}"  // Add here
  | ...;

// Add to row type mapping
export type DbcRow<T extends DbcTableName> =
  T extends "{TableName}" ? {TableName} :
  ...;

Instructions

  1. Get CSV headers from DBC table
  2. Map columns to Schema types
  3. Generate schema class (preserve column order!)
  4. Register in DbcTableRegistry
  5. Re-export from Schemas.ts if public API