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

# Transactions

### Table Columns

Unique Key:

| Column Name                       | Data Type         | Description                                               |
| --------------------------------- | ----------------- | --------------------------------------------------------- |
| block\_number                     | BIGINT            | Block number containing this transaction                  |
| block\_hash                       | VARCHAR           | Hash of the block containing this transaction             |
| consensus\_timestamp              | TIMESTAMP\_NTZ(9) | The consensus timestamp when the transaction was executed |
| transaction\_hash                 | VARCHAR           | Hash of the transaction                                   |
| transaction\_id                   | VARCHAR           | Unique identifier for the transaction                     |
| nonce                             | BIGINT            | Nonce of the transaction                                  |
| result                            | VARCHAR           | Result of the transaction execution                       |
| transaction\_type                 | VARCHAR           | Type of transaction (CRYPTOTRANSFER, CONTRACTCALL, etc.)  |
| payer\_account\_id                | VARCHAR           | Account ID of the account that paid for the transaction   |
| entity\_id                        | VARCHAR           | ID of the entity involved in the transaction              |
| charged\_tx\_fee                  | BIGINT            | Transaction fee charged in tinybars                       |
| max\_fee                          | BIGINT            | Maximum fee set for the transaction                       |
| memo                              | VARCHAR           | Memo attached to the transaction                          |
| scheduled                         | BOOLEAN           | Whether this is a scheduled transaction                   |
| node                              | VARCHAR           | Node that processed the transaction                       |
| valid\_duration\_seconds          | BIGINT            | Duration for which the transaction is valid               |
| parent\_consensus\_timestamp      | TIMESTAMP\_NTZ(9) | Consensus timestamp of the parent transaction             |
| valid\_start\_timestamp           | TIMESTAMP\_NTZ(9) | Timestamp when the transaction becomes valid              |
| contract\_result                  | VARIANT           | Result data from contract execution                       |
| bytes                             | VARCHAR           | Raw transaction bytes                                     |
| transfers                         | VARIANT           | HBAR transfers in the transaction                         |
| token\_transfers                  | VARIANT           | Token transfers in the transaction                        |
| nft\_transfers                    | VARIANT           | NFT transfers in the transaction                          |
| staking\_reward\_transfers        | VARIANT           | Staking reward transfers in the transaction               |
| consensus\_timestamp\_raw         | DECIMAL(29,9)     | Raw consensus timestamp as decimal                        |
| parent\_consensus\_timestamp\_raw | DECIMAL(29,9)     | Raw parent consensus timestamp as decimal                 |
| valid\_start\_timestamp\_raw      | DECIMAL(29,9)     | Raw valid start timestamp as decimal                      |
| log\_count                        | BIGINT            | Number of logs generated by the transaction               |
| extra\_evm\_fields                | VARIANT           | Additional EVM-specific fields                            |
| \_created\_at                     | TIMESTAMP\_NTZ(9) | Timestamp when this record was created                    |
| \_updated\_at                     | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated               |