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

# Rewards

### Table Details

| Property            | Value                                       |
| ------------------- | ------------------------------------------- |
| Table Name          | `casper.raw.rewards`                        |
| Table Status        | Production-Ready                            |
| Unique Key          | `block_timestamp`, `era_id`, `reward_index` |
| Clustering Key(s)   | `to_date("block_timestamp")`                |
| Search Optimization | `address`                                   |

### Table Columns

| Column Name            | Data Type         | Description                                                                   |
| ---------------------- | ----------------- | ----------------------------------------------------------------------------- |
| era\_id                | NUMBER(38,0)      | Era (epoch) for which the reward was distributed.                             |
| reward\_index          | NUMBER(38,0)      | Index of the reward entry within the era.                                     |
| address                | VARCHAR(16777216) | Recipient address of the staking reward.                                      |
| address\_type          | VARCHAR(16777216) | Type of the recipient address (Account, Contract, or Hash).                   |
| amount\_str            | VARCHAR(16777216) | Reward amount in motes as a string (preserves full precision).                |
| amount                 | FLOAT             | Reward amount in motes.                                                       |
| validator\_public\_key | VARCHAR(16777216) | Public key of the validator that earned or distributed the reward.            |
| delegator\_public\_key | VARCHAR(16777216) | Public key of the delegator receiving the reward; null for validator rewards. |
| state\_root\_hash      | VARCHAR(16777216) | Global state root hash at which the reward was applied.                       |
| api\_version           | VARCHAR(16777216) | Node API version that produced the reward payload.                            |
| block\_timestamp       | TIMESTAMP\_NTZ(9) | Timestamp of the block this event was included in.                            |
| block\_height          | NUMBER(38,0)      | Height of the block this event was included in.                               |
| block\_hash            | VARCHAR(16777216) | Hash of the block this event was included in.                                 |
| \_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.                 |