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

# Accounts

### Table Details

| Property            | Value                       |
| ------------------- | --------------------------- |
| Table Name          | `hedera.raw.accounts`       |
| Table Status        | Production-Ready            |
| Unique Key          | `account_id`                |
| Search Optimization | `account_id`, `evm_address` |

### Table Columns

| Column Name                         | Data Type         | Description                                                                                                       |
| ----------------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------------- |
| account\_id                         | VARCHAR(16777216) | Hedera account ID in the format `{shard}.{realm}.{num}` (e.g. `0.0.12345`). Identifies a specific Hedera account. |
| evm\_address                        | VARCHAR(16777216) | EVM-compatible 20-byte address for this Hedera account.                                                           |
| alias                               | VARCHAR(16777216) | EVM-compatible alias (public-key-derived) address for this Hedera account.                                        |
| key                                 | VARIANT           | Serialized key structure controlling this Hedera account (single key, key list, or threshold key).                |
| created\_timestamp                  | VARCHAR(16777216) | Timestamp when this account was created.                                                                          |
| expiry\_timestamp                   | VARCHAR(16777216) | Timestamp at which this Hedera account expires and must be renewed or it will be deleted.                         |
| auto\_renew\_period                 | NUMBER(38,0)      | Duration in seconds for which this account is automatically renewed before expiring.                              |
| deleted                             | BOOLEAN           | True if this Hedera account has been deleted from the network.                                                    |
| memo                                | VARCHAR(16777216) | Optional short memo string associated with this Hedera account.                                                   |
| ethereum\_nonce                     | NUMBER(38,0)      | Ethereum-compatible nonce for this Hedera account, used for EVM transactions.                                     |
| decline\_reward                     | BOOLEAN           | True if this Hedera account has opted out of staking rewards.                                                     |
| pending\_reward                     | NUMBER(38,0)      | Pending staking reward in tinybars not yet claimed by this account.                                               |
| staked\_account\_id                 | VARCHAR(16777216) | Hedera account ID to which this account has delegated its stake.                                                  |
| staked\_node\_id                    | NUMBER(38,0)      | Hedera node ID to which this account has staked its HBAR.                                                         |
| stake\_period\_start                | VARCHAR(16777216) | Start of the current staking period for this account.                                                             |
| max\_automatic\_token\_associations | NUMBER(38,0)      | Maximum number of token types this account can receive without explicit association.                              |
| receiver\_sig\_required             | BOOLEAN           | True if this account requires the receiver's signature to receive funds.                                          |
| balance                             | VARIANT           | Current HBAR balance snapshot of this account, including per-token balances.                                      |
| \_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.                                                     |