nuthatch data model
The `gooddollar-xdc` nest on xdc. (seeded from the ABI - edit semantic.toml to improve this)
COVERAGE
sealed_through = 109624453 (rows at or below this block are sealed Parquet);
tip = 109631878 - the `sql` tool reads both the sealed rows and the live tip above them.
first_indexed = 95249624 - no block before it is in this nest.
TABLES (one per contract event; query via the `sql` tool)
ubi_scheme__admin_changed - `AdminChanged(address,address)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per AdminChanged(address,address) event
columns: previousAdmin (address), newAdmin (address)
ubi_scheme__beacon_upgraded - `BeaconUpgraded(address)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per BeaconUpgraded(address) event
columns: beacon (address)
ubi_scheme__cycle_length_set - `CycleLengthSet(uint256)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per CycleLengthSet(uint256) event
columns: newCycleLength (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT
_overflow is that same sum): newCycleLength → newCycleLength_dec
⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: newCycleLength
ubi_scheme__day_set - `DaySet(uint256)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per DaySet(uint256) event
columns: newDay (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): newDay → newDay_dec
⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: newDay
ubi_scheme__initialized - `Initialized(uint8)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Initialized(uint8) event
columns: version (uint8)
ubi_scheme__should_withdraw_from_d_a_o_set - `ShouldWithdrawFromDAOSet(bool)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per ShouldWithdrawFromDAOSet(bool) event
columns: ShouldWithdrawFromDAO (bool)
ubi_scheme__u_b_i_calculated - `UBICalculated(uint256,uint256,uint256)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per UBICalculated(uint256,uint256,uint256) event
columns: day (uint256), dailyUbi (uint256), blockNumber (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): day → day_dec, dailyUbi → dailyUbi_dec, blockNumber → blockNumber_dec
⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: day, dailyUbi, blockNumber
ubi_scheme__u_b_i_claimed - `UBIClaimed(address,uint256)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per UBIClaimed(address,uint256) event
columns: claimer (address), amount (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): amount → amount_dec
⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: amount
ubi_scheme__u_b_i_cycle_calculated - `UBICycleCalculated(uint256,uint256,uint256,uint256)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per UBICycleCalculated(uint256,uint256,uint256,uint256) event
columns: day (uint256), pool (uint256), cycleLength (uint256), dailyUBIPool (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): day → day_dec, pool → pool_dec, cycleLength → cycleLength_dec, dailyUBIPool → dailyUBIPool_dec
⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: day, pool, cycleLength, dailyUBIPool
ubi_scheme__upgraded - `Upgraded(address)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per Upgraded(address) event
columns: implementation (address)
ubi_scheme__withdraw_from_dao - `WithdrawFromDao(uint256,uint256)` events emitted by the `ubi_scheme` contract. (seeded from the ABI - edit semantic.toml to improve this)
grain: one row per WithdrawFromDao(uint256,uint256) event
columns: prevBalance (uint256), newBalance (uint256)
⚠ big-int columns (exact text; SUM/AVG of `_dec` is the values that fit, and WHERE NOT _overflow is that same sum): prevBalance → prevBalance_dec, newBalance → newBalance_dec
⚠ wide columns (>128-bit) whose `_dec` is NULL above 38 digits. A sum of `_dec` is the values that fit; WHERE NOT _overflow is that same sum. Ids, nonces and hashes stay on the raw column: prevBalance, newBalance
FACTORIES (RFC-0009; only in a nest with templates/factories)
Children of a template share tables (`pool__swap`, …), distinguished by the `address` column. Each
template has a `{template}__children` view: which children were discovered, when, by which parent.