Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.attester_slashings |
| Table Status | Production-Ready |
| Unique Key | slot_timestamp::date, unique_id |
| Clustering Key(s) | slot_timestamp::date |
| Search Optimization | slot_number, attestation_slot_1 |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| 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. |
| eth1_block_hash | VARCHAR(134217728) | 0xc0efee09619b108b8c184d7c4981b96bcef8fe63e6887f3ee20728d5ca6d6e67 |
| eth1_block_number | NUMBER(38,0) | 17,030,996 |
| eth1_block_timestamp | TIMESTAMP_NTZ(9) | 2023-04-12 09:19:47 |
| proposer_index | NUMBER(38,0) | Index of the validator who proposed the block. |
| array_index | NUMBER(38,0) | 178,393 |
| slashed_attestors | ARRAY | Array of slashed attestors. The intersection of validator ids in the two attestation data objects gives the attestors (validators with the role of attesters) to be slashed. |
| attesting_indices_1 | VARIANT | Each attestation refers to an ordered set of attestors, stored in attesting_indices table |
| attestation_index_1 | NUMBER(38,0) | A number that identifies which committee the validator belongs to in a given slot. |
| beacon_block_root_1 | VARCHAR(134217728) | Root hash of the block the validator sees at the head of the chain (the result of applying the fork-choice algorithm). |
| attestation_slot_1 | NUMBER(38,0) | The slot number that the attestation refers to. |
| source_epoch_1 | NUMBER(38,0) | Source Epoch. Part of the finality vote indicating what the validators see as the most recent justified block. |
| source_root_1 | VARCHAR(134217728) | Source Root. Part of the finality vote indicating what the validators see as the most recent justified block. |
| target_epoch_1 | NUMBER(38,0) | Target epoch. Part of the finality vote indicating what the validators see as the first block in the current epoch. |
| target_root_1 | VARCHAR(134217728) | Target root. Part of the finality vote indicating what the validators see as the first block in the current epoch. |
| attestation_signature_1 | VARCHAR(134217728) | The BLS signature that aggregates the signatures of individual validators. |
| attesting_indices_2 | VARIANT | Refer to attesting_indices_1. |
| attestation_index_2 | NUMBER(38,0) | Refer to attestation_index_1. |
| beacon_block_root_2 | VARCHAR(134217728) | Refer to beacon_block_root1. |
| attestation_slot_2 | NUMBER(38,0) | Refer to attestation_slot_1. |
| source_epoch_2 | NUMBER(38,0) | Refer to source_epoch_1. |
| source_root_2 | VARCHAR(134217728) | Refer to source_root_1. |
| target_epoch_2 | NUMBER(38,0) | Refer to target_epoch_1. |
| target_root_2 | VARCHAR(134217728) | Refer to target_root_1. |
| attestation_signature_2 | VARCHAR(134217728) | Refer to signature_1. |
| unique_id | VARCHAR(134217728) | date-2023-05-10_validator_index-459015 |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |