indexes

var AddressableEvent = next()

AddressableEvent stores parameterized replaceable events (kinds 30000-39999) with inline data. Optimized storage for addressable events identified by pubkey+kind+d-tag. Key format enables direct lookup without additional index traversal.

prefix|8 pubkey_hash|2 kind|8 dtag_hash|2 size_uint16|data (variable length, max 384 bytes)

var CreatedAt = next()

CreatedAt is an index that allows search for the timestamp on the event.

3 prefix|8 timestamp|5 serial

var Event = next()

Event is the whole event stored in binary format

prefix|5 serial - event in binary format

var EventPubkeyGraph = next()

EventPubkeyGraph creates a bidirectional graph edge between events and pubkeys This stores event_serial -> pubkey_serial relationships with event kind and direction Direction: 0=author, 1=p-tag-out (event references pubkey)

3 prefix|5 event serial|5 pubkey serial|2 kind|1 direction

var Expiration = next()

Expiration

3 prefix|8 timestamp|5 serial

var FullIdPubkey = next()

FullIdPubkey is an index designed to enable sorting and filtering of results found via other indexes, without having to decode the event.

3 prefix|5 serial|32 ID|8 pubkey hash|8 timestamp

var Id = next()

Id contains a truncated 8-byte hash of an event index. This is the secondary key of an event, the primary key is the serial found in the Event.

3 prefix|8 ID hash|5 serial

var Kind = next()

Kind

3 prefix|2 kind|8 timestamp|5 serial

var KindPubkey = next()

KindPubkey

3 prefix|2 kind|8 pubkey hash|8 timestamp|5 serial

var Pubkey = next()

Pubkey is a composite index that allows search by pubkey filtered by timestamp.

3 prefix|8 pubkey hash|8 timestamp|5 serial

var PubkeyEventGraph = next()

PubkeyEventGraph creates the reverse edge: pubkey_serial -> event_serial with event kind and direction This enables querying all events related to a pubkey, optionally filtered by kind and direction Direction: 0=is-author, 2=p-tag-in (pubkey is referenced by event)

3 prefix|5 pubkey serial|2 kind|1 direction|5 event serial

var PubkeySerial = next()

PubkeySerial maps a pubkey hash to its unique serial number

3 prefix|8 pubkey hash|5 serial

var ReplaceableEvent = next()

ReplaceableEvent stores replaceable events (kinds 0,3,10000-19999) with inline data. Optimized storage for metadata events that are frequently replaced. Key format enables direct lookup by pubkey+kind without additional index traversal.

prefix|8 pubkey_hash|2 kind|2 size_uint16|data (variable length, max 384 bytes)

var SerialPubkey = next()

SerialPubkey maps a pubkey serial to the full 32-byte pubkey This stores the full pubkey (32 bytes) as the value, not inline

3 prefix|5 serial -> 32 byte pubkey value

var SmallEvent = next()

SmallEvent stores events <=384 bytes with inline data to avoid double lookup. This is a Reiser4-inspired optimization for small event packing. 384 bytes covers: ID(32) + Pubkey(32) + Sig(64) + basic fields + small content

prefix|5 serial|2 size_uint16|data (variable length, max 384 bytes)

var Tag = next()

Tag allows searching for a tag and filter by timestamp.

3 prefix|1 key letter|8 value hash|8 timestamp|5 serial

var TagKind = next()

TagKind

3 prefix|1 key letter|8 value hash|2 kind|8 timestamp|5 serial

var TagKindPubkey = next()

TagKindPubkey

3 prefix|1 key letter|8 value hash|2 kind|8 pubkey hash|8 bytes timestamp|5 serial

var TagPubkey = next()

TagPubkey allows searching for a pubkey, tag and timestamp.

3 prefix|1 key letter|8 value hash|8 pubkey hash|8 timestamp|5 serial

var Version = next()

Version

3 prefix|4 version

var Word = next()

Word index for tokenized search terms

3 prefix|8 word-hash|5 serial