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

# Btc Credit Debit

### Table Details

| Property            | Value                                                                                     |
| ------------------- | ----------------------------------------------------------------------------------------- |
| Table Name          | `bitcoin.assets.btc_credit_debit`                                                         |
| Table Status        | Production-Ready                                                                          |
| Unique Key          | `block_timestamp::date`, `block_number`, `transaction_hash`, `unique_index_id`, `address` |
| Clustering Key(s)   | `block_timestamp::date, _address_short`                                                   |
| Search Optimization | `block_timestamp`, `block_number`, `transaction_hash`, `address`, `_address_short`        |

### Table Columns

| Column Name        | Data Type         | Description                                                                                                                                                                                |
| ------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| address            | VARCHAR(130)      | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.                                     |
| value              | NUMBER(38,5)      | Amount of native currency (e.g. ETH, MATIC) transferred with this transaction or trace, in the chain's smallest unit (Wei for EVM chains). Zero for calls that don't move native currency. |
| block\_timestamp   | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                                    |
| block\_number      | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                                                              |
| block\_hash        | VARCHAR(66)       | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                                                             |
| transaction\_index | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                                                                     |
| transaction\_hash  | VARCHAR(66)       | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                                |
| input\_index       | NUMBER(38,0)      | Zero-based index of this input within the transaction's input list.                                                                                                                        |
| output\_index      | NUMBER(38,0)      | Zero-based index of this output within the transaction's output list (equivalent to `vout`).                                                                                               |
| unique\_index\_id  | VARCHAR(16777216) | Unique index identifier for this credit/debit record within the Bitcoin assets pipeline.                                                                                                   |
| \_address\_short   | VARCHAR(130)      | Short prefix of the address for search optimization.                                                                                                                                       |
| \_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.                                                                                                                              |