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