Oct 25, 2024

Yes, we have complete indexes in addition to validation metadata. The two "validated" tables are disposable, and in the case of reorgs would just get generated as necessary. Essentially they are state repositories that assist with concurrency. The "strong" table is not disposable, and only provides the reverse index from (confirmed) tx to its confirming block. This gets overwritten (to negative) in the case of a reorg out of the block. Navigation is possible from candidate or confirmed height to header, header to parent, header to txs (if block is stored), txs to spends (sequence) and outputs (script/value), spend to input (contains script/witness), input to point (output natural key), output to containing tx, spend to containing tx, tx to confirming header (and position in its block).