> ## 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.

# Consolidations

### Table Details

| Property          | Value                               |
| ----------------- | ----------------------------------- |
| Table Name        | `beacon.raw.consolidations`         |
| Table Status      | Production-Ready                    |
| Unique Key        | `slot_timestamp::date`, `unique_id` |
| Clustering Key(s) | `slot_timestamp::date`              |

### 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.                                       |
| array\_index                    | NUMBER(38,0)       | 178,393                                                                                                                  |
| source\_address                 | VARCHAR(134217728) | The address of the source validator.                                                                                     |
| source\_pubkey                  | VARCHAR(134217728) | The source validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| source\_validator\_index        | NUMBER(38,0)       | The index of the source validator in the validator registry.                                                             |
| target\_pubkey                  | VARCHAR(134217728) | The target validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| target\_validator\_index        | NUMBER(38,0)       | The index of the target validator in the validator registry.                                                             |
| 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.                                                    |