---

[!info] Current vs Future State This document distinguishes the current implementation in code from proposed/future-state enhancements.

• Store: field_catalog
• Key path: id
• Type source: packages/core/src/types/storage.ts
• Database version: wodwiki-db (v23)

Derived typed field identity for authoring-surface typeahead (V17, ticket 14). Reference-counted: rows prune when sourceCount hits zero; deltas commit atomically with the source mutation.

Field	Type	Notes
id	string	Collision-free typed key — fieldRefKey
path	string	Normalized full path — ordered prefix-lookup key for typeahead
kind	string
dimension?	string	Physical/named dimension of a numeric variant
spellings	Record<string, number>	Observed original spellings → supporting-source counts
units	Record<string, number>	Observed effective units → supporting-source counts
sourceCount	number	Sources currently supporting this identity
firstSeen / lastSeen	number

Index	Key path	Unique	Purpose
by-path	path	no	ordered normalized-path prefix lookup

• FieldValueRecord.fieldId
• FieldSourceRecord.contributions[].fieldId

• FieldSourceRecord — reversal records feeding this entry
• FieldValueRecord — observed categorical values

---

• Retains current schema; tracks contributions from future sessions records alongside notes.

!