# Tables and views

Query runs, candidates, observations, call frames, state reads and writes, logs, and state changes.

Canonical HTML: <https://determica.com/docs/tables>

- [evm.execution_accesses](/docs/tables/evm-execution-accesses.md) — Canonical execution-keyed evidence projection.
- [evm.execution_asset_claims](/docs/tables/evm-execution-asset-claims.md) — Canonical execution-keyed evidence projection.
- [evm.execution_assumptions](/docs/tables/evm-execution-assumptions.md) — Canonical execution-keyed evidence projection.
- [evm.execution_attempts](/docs/tables/evm-execution-attempts.md) — One row per contextual owner association to one physical attempt. Program-step owners have step_index and no observation_key; observation-call owners have observation_key and no step_index. Reuse may expose the same attempt_id under multiple owners.
- [evm.execution_blockhash_reads](/docs/tables/evm-execution-blockhash-reads.md) — Canonical execution-keyed evidence projection.
- [evm.execution_checkpoints](/docs/tables/evm-execution-checkpoints.md) — Canonical execution-keyed evidence projection.
- [evm.execution_creates](/docs/tables/evm-execution-creates.md) — Canonical execution-keyed evidence projection.
- [evm.execution_effect_summary](/docs/tables/evm-execution-effect-summary.md) — Exactly one row per execution, including invalid or zero-attempt executions. Counts include program-step attempts only; observation-call effects are excluded. Final dispositions include ancestor outcomes.
- [evm.execution_frames](/docs/tables/evm-execution-frames.md) — One row per contextual attempt owner and frame_index. A reused physical attempt expands once for each execution step or observation owner; use attempt_id for physical deduplication.
- [evm.execution_logs](/docs/tables/evm-execution-logs.md) — One row per contextual attempt owner and log_index. effect_status is the final disposition after all ancestor outcomes.
- [evm.execution_observation_facts](/docs/tables/evm-execution-observation-facts.md) — Authored address labels.
- [evm.execution_observation_pairs](/docs/tables/evm-execution-observation-pairs.md) — One row per logical observation key with pre and terminal values side by side. changed compares exact raw bytes; numeric projections are populated only for complete integer pairs.
- [evm.execution_observations](/docs/tables/evm-execution-observations.md) — One row per expanded observation point. observation_index supplies canonical point ordering and disambiguates checkpoints sharing one byte-exact logical key.
- [evm.execution_selfdestructs](/docs/tables/evm-execution-selfdestructs.md) — Canonical execution-keyed evidence projection.
- [evm.execution_state_deltas](/docs/tables/evm-execution-state-deltas.md) — One row per artifact-backed execution, step_index, and delta_index. Rows are committed checkpoint transitions, not merely attempted writes.
- [evm.execution_state_reads](/docs/tables/evm-execution-state-reads.md) — One row per contextual attempt owner and read_index. Lookup probes and internal selection relation hashes are intentionally omitted from the public projection.
- [evm.execution_state_writes](/docs/tables/evm-execution-state-writes.md) — One row per contextual attempt owner and write_index. effect_status is the final disposition after all ancestor outcomes.
- [evm.execution_steps](/docs/tables/evm-execution-steps.md) — Immutable selected per-step PROGRAM lineage.
- [evm.execution_transient_accesses](/docs/tables/evm-execution-transient-accesses.md) — Canonical execution-keyed evidence projection.
- [evm.executions](/docs/tables/evm-executions.md) — Contextual PROGRAM execution associations.
- [evm.runs](/docs/tables/evm-runs.md) — Completed atomic PROGRAM invocations.