> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Attestations

### Table Details

| Property            | Value                                           |
| ------------------- | ----------------------------------------------- |
| Table Name          | `beacon.raw.attestations`                       |
| Table Status        | Production-Ready                                |
| Unique Key          | `slot_timestamp::date`, `unique_id`             |
| Clustering Key(s)   | `slot_timestamp::date`                          |
| Search Optimization | `slot_number`, `proposer_index`, `target_epoch` |

### 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                                                                                                                                                                                |
| array\_index                    | NUMBER(38,0)       | 178,393                                                                                                                                                                                            |
| proposer\_index                 | NUMBER(38,0)       | Index of the validator who proposed the block.                                                                                                                                                     |
| attestation\_index              | NUMBER(38,0)       | 9                                                                                                                                                                                                  |
| aggregation\_bits               | VARCHAR(134217728) | 0xfdfffffffffffffffffffffffffffff9fffff7fff7ffffffffffffbfffffffffffff0f                                                                                                                           |
| beacon\_block\_root             | VARCHAR(134217728) | 0xb5879b53ac4f9909860b3d072538e20e89cd3dc68beb93bcbd0e3309c6f2a367                                                                                                                                 |
| attestation\_slot               | NUMBER(38,0)       | 6,205,596                                                                                                                                                                                          |
| source\_epoch                   | NUMBER(38,0)       | 193,923                                                                                                                                                                                            |
| source\_root                    | VARCHAR(134217728) | 0x224f895b66497a41d80a68425721ac2b76a08a03464c2811dab4bd306d9d69fb                                                                                                                                 |
| target\_epoch                   | NUMBER(38,0)       | 193,924                                                                                                                                                                                            |
| target\_root                    | VARCHAR(134217728) | 0x9f1552c4c27be5ba449eab378015bfd9a5e36c0829586fa6c51a8319ac852071                                                                                                                                 |
| attestation\_signature          | VARCHAR(134217728) | 0x94a253070e95f22cb83a295f1ee5b19438701ff1aa60de46ee5aa05df459762776a1d58dc36cbaa973f7e0e009360eba10a1f6995ffd719af209597206b737d2793c533236edb7c73aa59e0dddf47560eb1968f7e665022bfa2ba51dfadc5247 |
| 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.                                                                                                                              |