itemenchant.dbss

Binary layout, intrinsic row framing, field semantics, and exact snapshot evidence for the itemenchant.dbss decoder in calpheonlabs.

Investigation status

Status	Value
Evidence state	Reconciled
Coverage	100%
Iteration	7
Last reviewed	2026-07-31
Captures examined	Build 2938; `Paz/pad00000.meta` SHA-256 `b7eefe6059818f84c0545f10020fe93bd3bd5d0647e043120caf78726ccafe8f`
Primary bytes	201,133,986; SHA-256 `2ae078a52410a4fb7cd2edf96bec6098ba2481e16b361317b03e7190e6d8451d`
Snapshot proof	168,061 modern-layout rows; normalized SHA-256 `e31993e45f742c405abcec354b296fd71b3290e3bbc6f1b62f1ca6ee62239359`
Decoder	`packages/scraper/src/tables/itemenchant.dbss.ts`
Remaining blockers	None

See Decoder methodology. The migrated production decoder has no offset-table import or join. Non-final rows are delimited by their repeated packed key and the next row’s intrinsic fixed-layout controls; only the final row uses EOF.

Field ledger

Field/path	Offset and width	Representation	Claimed meaning	Physical confidence	Representation confidence	Semantic confidence	Evidence	Status
`rowCount`, `rows[]`	file `+0`, 4; remainder	retained `u32`, count-derived array	Count and physical rows	Certain	Certain	Certain	168,061 rows consume exactly through EOF under strict decode	Closed
decoder packed-key preview	row `+0`, 4, non-consuming	`u32().peek()` feeding row schema	Intrinsic boundary key	Certain	Certain	Certain	Same bytes are emitted losslessly as `itemId` plus `enhancementLevel`; preview adds no output alias	Closed
`layout`	derived, 0 bytes	`"modern"` or `"legacy"` literal from ordered union	Fixed-tail layout family	Certain	Certain	Certain	Modern branch is present in all current rows; prior source-ledger capture proves the pre-expansion legacy branch	Closed
`itemId`	row `+0`, 3	`u24`	Item-family identifier	Certain	Certain	Certain	Low packed bytes agree with all offset identities	Closed
`enhancementLevel`	row `+3`, 1	`u8`	Enhancement discriminator	Certain	Certain	High	High packed byte agrees with all offset identities and item max-level lineage	Closed
`itemTypeCode`	row `+4`, 1	`u8`	Client item-type code	Certain	Certain	High	Shipped `CppEnums.ItemType` lineage and family invariance; former raw alias removed	Closed
`itemClassifyCode`	row `+5`, 1	`u8`	Client item-classification code	Certain	Certain	High	Shipped classification definitions cover the established values; former raw alias removed	Closed
`itemGradeCode`	row `+6`, 1	`u8`	Client item-grade code	Certain	Certain	High	Lua grade names and archived item-sheet correlation; former raw alias removed	Closed
`equipTypeCode`	row `+7`, 1	`u8`	Client equipment-type code	Certain	Certain	High	Client API and archived item-sheet correlation; former raw alias removed	Closed
`field08..field13`	row `+8..+13`, 1 each	six retained `u8`	Neutral byte controls	Certain	Certain	Unknown	Full values retained without the redundant `unknown08` byte-array alias	Closed
`equipSlotCode`	row `+14`, 1	`u8`	Client equipment-slot code	Certain	Certain	High	Shipped `EquipSlotNo` lineage; former raw alias removed	Closed
`field15..field18`	row `+15..+18`, 1 each	four retained `u8`	Neutral byte controls	Certain	Certain	Unknown	Full values retained without the redundant `unknown15` alias	Closed
`reserved19`	row `+19..+61`, 43	`0x2e`-checked `bytes(43).reserved()`	Fixed row-framing region	Certain	Certain	Unknown	Every current row matches; this intrinsic region also discriminates the following row boundary	Closed
`field62`	row `+62`, 1	`u8`	Neutral byte	Certain	Certain	Unknown	Exact position and full domain retained	Closed
`weightValue`	row `+63`, 4	`u32`	Weight in 1/10,000 LT	Certain	Certain	High	Source-ledger item comparisons and enhancement invariance	Closed
`isStackable`, `appliesDirectly`	row `+67`, 1; `+68`, 1	strict Boolean	Inventory/use controls	Certain	Certain	High	Client API and archived-column lineage; also strengthen next-row boundary discrimination	Closed
`unknown69`	row `+69..+72`, 4	retained bytes	Opaque bytes	Certain	Certain	Unknown	Exact bytes retained without interpretation	Closed
`vestingTypeCode`	row `+73`, 1	`u8`	Vesting/binding mode	Certain	Certain	High	Tooltip Lua and archived-column correlation	Closed
`isUserVested`, `isTradeable`	row `+74`, 1; `+75`, 1	strict Boolean	Vesting/trade controls	Certain	Certain	High	Client API and archived-column lineage; also strengthen boundary discrimination	Closed
`tradeTypeCode`	row `+76`, 1	`u8`	Numeric trade-mode discriminator	Certain	Certain	High	Client trade-mode API and archived-column lineage isolate this byte; individual numeric labels remain unresolved	Closed
`unknown77`	row `+77..+109`, 33	retained bytes	Opaque bytes	Certain	Certain	Unknown	Exact bytes retained without interpretation	Closed
`buyPrice`	row `+110`, 4	`u32`	NPC purchase price	Certain	Certain	High	Independent item-value comparisons in source lineage	Closed
`field114`	row `+114`, 4	`u32`	Neutral scalar word	Certain	Certain	Unknown	Full word retained without the redundant `unknown114` alias	Closed
`sellPrice`	row `+118`, 4	`u32`	NPC sale price	Certain	Certain	High	Independent item-value comparisons in source lineage	Closed
`field122`	row `+122`, 4	`u32`	Neutral scalar word	Certain	Certain	Unknown	Full word retained without the redundant `unknown122` alias	Closed
`repairPrice`	row `+126`, 4	`u32`	Stored repair price	Certain	Certain	High	Independent item-value comparisons in source lineage	Closed
both `unknown130Prefix`	row `+130..+148`, 19	retained bytes	Opaque fixed-tail prefix	Certain	Certain	Unknown	Exact bytes retained in both layout branches	Closed
modern `unknown149`, `reserved155`, `field160`	row `+149..+160`, 6/5/1	retained bytes, zero-checked reserved bytes, `u8`	Twelve-byte expansion	Certain	Certain	Unknown	Current capture exercises every modern field; only the checked byte range is omitted	Closed
modern `unknown161`, `isCash`, `unknown165`	row `+161..+195`, 3/1/31	retained bytes, Boolean, retained bytes	Opaque ranges and cash flag	Certain	Certain	High	Archived cash column isolates modern `+164`; Boolean also discriminates row boundaries	Closed
modern `isPersonalTrade`, `unknown197`, `field205`, `unknown207`	row `+196..+215`, 1/8/2/9	Boolean, bytes, `u16`, bytes	Personal-trade flag and neutral tail	Certain	Certain	High	Current capture and archived-column lineage; all neutral values remain	Closed
legacy `unknown149`, `isCash`, `unknown153`	row `+149..+183`, 3/1/31	retained bytes, Boolean, retained bytes	Pre-expansion opaque ranges and cash flag	Certain	Certain	High	Prior source-ledger capture isolates legacy `+152`	Closed
legacy `isPersonalTrade`, `unknown185`, `field193`, `unknown195`	row `+184..+203`, 1/8/2/9	Boolean, bytes, `u16`, bytes	Pre-expansion personal-trade flag and neutral tail	Certain	Certain	High	Prior source-ledger capture proves the complete legacy branch	Closed
boundary-search `lookahead`, `stride`	non-final payload, non-output scan	`find` over a 268-byte peek and 64-byte strides	Locates repeated-key trailer intrinsically	Certain	Certain	Certain	All 168,060 non-final boundaries agree with offset spans; an exhaustive audit found zero earlier false candidates after layout controls were included	Closed
`payload`	modern `+216..end-8`; legacy `+204..end-8`	retained bytes	Opaque variable payload	Certain	Certain	Unknown	Every byte is emitted; search previews are aliases and do not omit or alter payload data	Closed
`repeatedRowKey`	row `end-8`, 4	retained `u32().is(packedKey)`	Repeated packed identity	Certain	Certain	Certain	Equals the first four row bytes exhaustively and is the intrinsic delimiter	Closed
`trailerValue`	row `end-4`, 4	retained `u32`	Neutral final word	Certain	Certain	Unknown	Full word retained; redundant low-word/byte aliases intentionally removed	Closed
final-row boundary control	final payload, derived	`offset()` plus remaining byte count	EOF framing	Certain	Certain	Certain	Final payload consumes exactly to the eight-byte trailer under strict decode	Closed
row/table composition	all rows	ordered layout `union`, flattening transforms, uniform-layout check	Complete row sequence	Certain	Certain	Certain	Transforms only flatten containers/combine initial and final rows; every decoded value remains in output	Closed

Active assumptions

Findings

ID	Finding	Evidence	Schema/documentation impact	Status
IE-01	The repeated key is an intrinsic delimiter when combined with next-row layout evidence.	A key-only scan has overlapping false candidates; adding the next row’s dot region, common Booleans, and layout-specific controls yields zero early matches across 168,060 boundaries.	Production uses BSD `find` with bounded lookahead and does not load `itemenchantoffset.dbss`.	Resolved
IE-02	The final row requires a distinct EOF seam.	It has no following row whose fixed controls can validate the boundary.	The retained row count decodes all preceding rows intrinsically and lets the last payload consume to its eight-byte trailer.	Resolved
IE-03	Legacy overlapping raw/scalar views were representation aliases.	The transformed reference removes byte-array aliases where the same bytes are emitted as scalars, and full snapshot parity remains exact.	Every physical byte remains represented once; opaque regions remain bytes and known scalar views remain typed.	Resolved
IE-04	The offset table is falsification evidence rather than runtime framing.	All 168,061 offset starts, widths, keys, and the complete byte partition agree with the strict intrinsic snapshot.	No production import, load, or join to the offset decoder remains.	Resolved
IE-05	Both historical fixed-tail layouts remain structurally modeled.	Source lineage proves the pre-expansion branch; the current capture exercises the expanded branch in all rows.	An ordered BSD union retains explicit `layout` discriminants and layout-specific Boolean/reserved evidence.	Resolved