| slot_number | NUMBER(38,0) | Slot number of the state where the pending deposits to beacon chain is fetched. |
| slot_timestamp | TIMESTAMP_NTZ(9) | Slot timestamp of the state where the pending deposits to beacon chain is fetched. |
| source_index | NUMBER(38,0) | Validator index of the source validator being consolidated |
| source_pubkey | VARCHAR(16777216) | The source validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| source_raw_balance | VARCHAR(16777216) | The source validator’s balance in gwei (1e9 gwei = 1 ETH on Beacon Chain) |
| source_balance | FLOAT | The source validator’s balance in ETH |
| source_raw_effective_balance | VARCHAR(16777216) | The source validator’s effective balance in gwei |
| source_effective_balance | FLOAT | The source validator’s effective balance in ETH used for consensus calculations |
| source_activation_epoch | VARCHAR(16777216) | Epoch when the source validator was activated |
| source_activation_eligibility_epoch | VARCHAR(16777216) | Epoch when the source validator became eligible for activation |
| source_exit_epoch | VARCHAR(16777216) | Epoch when the source validator exited or will exit |
| source_withdrawable_epoch | VARCHAR(16777216) | Epoch when the source validator’s balance becomes withdrawable |
| source_status | VARCHAR(16777216) | The source validator’s status (e.g., active_ongoing, exited_unslashed, exited_slashed) |
| source_slashed | BOOLEAN | Boolean flag indicating whether the source validator has been slashed |
| source_withdrawal_credentials | VARCHAR(16777216) | Source validator’s withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals |
| target_index | NUMBER(38,0) | Validator index of the target validator receiving the consolidation |
| target_pubkey | VARCHAR(16777216) | The target validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| target_raw_balance | VARCHAR(16777216) | The target validator’s balance in gwei (1e9 gwei = 1 ETH on Beacon Chain) |
| target_balance | FLOAT | The target validator’s balance in ETH |
| target_raw_effective_balance | VARCHAR(16777216) | The target validator’s effective balance in gwei |
| target_effective_balance | FLOAT | The target validator’s effective balance in ETH used for consensus calculations |
| target_activation_epoch | VARCHAR(16777216) | Epoch when the target validator was activated |
| target_activation_eligibility_epoch | VARCHAR(16777216) | Epoch when the target validator became eligible for activation |
| target_exit_epoch | VARCHAR(16777216) | Epoch when the target validator exited or will exit |
| target_withdrawable_epoch | VARCHAR(16777216) | Epoch when the target validator’s balance becomes withdrawable |
| target_status | VARCHAR(16777216) | The target validator’s status (e.g., active_ongoing, exited_unslashed, exited_slashed) |
| target_slashed | BOOLEAN | Boolean flag indicating whether the target validator has been slashed |
| target_withdrawal_credentials | VARCHAR(16777216) | Target validator’s withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals |
| execution_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| finalized | BOOLEAN | If the slot/epoch is finalized. |
| pending_consolidation_index | NUMBER(38,0) | Array index of the pending consolidation for the given epoch |
| has_pending_consolidations | BOOLEAN | Boolean flag indicating whether there are pending consolidations |
| pending_consolidation_count | NUMBER(38,0) | Total count of pending consolidations at this slot |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
