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

All transactions, starting from genesis.

### Table Details

| Property            | Value                        |
| ------------------- | ---------------------------- |
| Table Name          | `dogecoin.raw.transactions`  |
| Table Status        | Production-Ready             |
| Unique Key          | `hash`                       |
| Clustering Key(s)   | `to_date("block_timestamp")` |
| Search Optimization | `hash`                       |

All transactions, starting from genesis.

### Table Columns

| Column Name      | Data Type         | Description                                                           |
| ---------------- | ----------------- | --------------------------------------------------------------------- |
| hash             | VARCHAR(66)       | Unique identifier or hash of the transaction.                         |
| size             | NUMBER(38,0)      | The size of the transaction in bytes.                                 |
| virtual\_size    | NUMBER(38,0)      | The virtual size of the transaction, used for fee calculation.        |
| version          | NUMBER(38,0)      | The version number of the transaction format.                         |
| lock\_time       | NUMBER(38,0)      | The block number or timestamp at which the transaction becomes valid. |
| index            | NUMBER(38,0)      | The position of the transaction within its block.                     |
| block\_hash      | VARCHAR(66)       | Hash of the block containing this transaction.                        |
| block\_number    | NUMBER(38,0)      | Number of the block containing this transaction.                      |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp when the block containing this transaction was mined.       |
| input\_count     | NUMBER(38,0)      | Number of inputs in this transaction.                                 |
| output\_count    | NUMBER(38,0)      | Number of outputs in this transaction.                                |
| output\_value    | NUMBER(38,0)      | Total amount of DOGE in satoshis (smallest unit) in all outputs.      |
| is\_coinbase     | BOOLEAN           | Indicates if this is a coinbase transaction.                          |
| \_created\_at    | TIMESTAMP\_NTZ(9) | Timestamp when this record was created in the database.               |
| \_updated\_at    | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated in the database.          |