Ryanzucchi/Eldritch_Lich / .agents/skills/categorization-audit
categorization-audit
VerifiedAudit the fidelity of Eldritch Lich manuscript imports and automatically categorized data against a source text such as a PDF. Use when asked to verify or correct extracted characters, places, items, events, timelines, family trees, import/export fidelity, orphan references, automation histories, or category assignment in an Eldritch Lich project.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 3.6 KB |
| references/schema-eldritch-lich.md | markdown | 1.6 KB |
| references/tipos-de-erro.md | markdown | 1.1 KB |
references/schema-eldritch-lich.md
View on GitHub# Schema Eldritch Lich: consulta da auditoria
O banco principal é Dexie/IndexedDB local, atualmente na versão 40, nomeado `EldritchDatabase_<activeProjectId>`. A fonte canônica e detalhada é `bd.md` na raiz do projeto e `apps/web/src/db/schema.ts`.
## Tabelas mínimas para auditoria
| Área | Tabelas |
|---|---|
| Manuscrito | `manuscripts`, `manuscriptVersions`, `pendingSaves`, `folders`, `comments` |
| Extração | `automationHistories`, `wikiEntities`, `characterSheets` |
| Universo | `familyRelations`, `factionSheets`, `locationSheets`, `creatureSheets`, `itemSheets`, `historicalEventSheets`, `entityRelationLinks` |
| Tempo | `timelines`, `timelineEvents` |
| Laboratório | `sandboxes`, `sandboxChanges` |
## Relações importantes
- `projectId` delimita registros do projeto e deve ser usado como filtro.
- `personId` e `relatedPersonId` de `familyRelations` apontam para `characterSheets`.
- `timelineEvents.timelineId` aponta para `timelines`.
- `manuscriptId` em versões, comentários, salvamentos e histórico aponta para `manuscripts`.
- Campos terminados em `Id` são referências lógicas: IndexedDB não tem chaves estrangeiras, cascatas ou RLS.
## Índices que importam para a auditoria
- `automationHistories`: `projectId`, `source`, `kind`, `status`, `manuscriptId`, `createdAt`.
- `familyRelations`: `projectId`, `personId`, `relatedPersonId`, `relationType`.
- `characterSheets`: `projectId`, `name`, `role`, `factionId`.
- `wikiEntities`: `projectId`, `name`, `type`, `isConfidential`.
- `timelineEvents`: `timelineId`, `sortOrder`.
`manuscripts` não possui índice Dexie por `projectId`; filtre a coleção lida pelo projeto ativo.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 470k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 470k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 470k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |