Table: t_attester_slashings

Table Documentation: `t_attester_slashings`

Summary:
The t_attester_slashings table captures data about attester slashings that occur on the Beacon Chain. Attester slashings are penalties applied to validators who sign conflicting attestations.

Description:
This table includes details about the slashing event, such as inclusion data, information about the attestations that were in conflict, and signatures that prove the slashing condition. This information is crucial for tracking validator behavior and ensuring the security of the network.

Schema Overview

Column Name	Data Type	Nullable	Description
`f_inclusion_slot`	INT64	YES	Slot number where the slashing was included
`f_inclusion_block_root`	STRING	YES	Root of the block including the slashing
`f_inclusion_index`	INT64	YES	Index of the inclusion within the block
`f_attestation_1_indices`	STRING	YES	Indices of validators from the first attestation
`f_attestation_1_slot`	INT64	YES	Slot of the first attestation
`f_attestation_1_committee_index`	INT64	YES	Committee index for the first attestation
`f_attestation_1_beacon_block_root`	STRING	YES	Beacon block root for the first attestation
`f_attestation_1_source_epoch`	INT64	YES	Source epoch for the first attestation
`f_attestation_1_source_root`	STRING	YES	Source root for the first attestation
`f_attestation_1_target_epoch`	INT64	YES	Target epoch for the first attestation
`f_attestation_1_target_root`	STRING	YES	Target root for the first attestation
`f_attestation_1_signature`	STRING	YES	Signature of the first attestation
`f_attestation_2_indices`	STRING	YES	Indices of validators from the second attestation
`f_attestation_2_slot`	INT64	YES	Slot of the second attestation
`f_attestation_2_committee_index`	INT64	YES	Committee index for the second attestation
`f_attestation_2_beacon_block_root`	STRING	YES	Beacon block root for the second attestation
`f_attestation_2_source_epoch`	INT64	YES	Source epoch for the second attestation
`f_attestation_2_source_root`	STRING	YES	Source root for the second attestation
`f_attestation_2_target_epoch`	INT64	YES	Target epoch for the second attestation
`f_attestation_2_target_root`	STRING	YES	Target root for the second attestation
`f_attestation_2_signature`	STRING	YES	Signature of the second attestation

Example SQL Query

SELECT * 
FROM raw_beacon_chain.t_attester_slashings
LIMIT 3;

Sample Query Result

Note: The above output is a truncated representation of the actual query result. The data shown includes the inclusion slot, block root, index, and a list of validators involved in the first conflicting attestation. The actual query will return complete data including both conflicting attestations and their signatures.

Updated 25 days ago