Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin_cash.assets.credit_debit |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(130) | Address of the account. |
| amount_raw_str | VARCHAR(16777216) | String of the change in value to the address (unnormalized). |
| amount_raw | NUMBER(38,8) | Change in value to the address (unnormalized). |
| amount_str | VARCHAR(16777216) | String of the change in value, normalized by the decimal points defined by the BCH protocol in sats. One sat = 1e-8 BCH. |
| amount | FLOAT | Change in value to the address, normalized by the decimal points defined by the BCH protocol in sats. One sat = 1e-8 BCH. |
| usd_amount | FLOAT | The change in value to the address, in $USD. |
| usd_exchange_rate | FLOAT | The exchange rate used to calculate the usd_amount. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that resulted in the change in balance. |
| block_number | NUMBER(38,0) | The number of the block that resulted in the change in balance. |
| block_hash | VARCHAR(66) | The hash of the block that resulted in the change in balance. |
| transaction_index | NUMBER(38,0) | Index of the transaction that resulted in the change in balance. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that resulted in the change in balance. |
| input_index | NUMBER(38,0) | Index of the input that resulted in the change in balance (debit). |
| output_index | NUMBER(38,0) | Index of the output that resulted in the change in balance (credit). |
| unique_index_id | VARCHAR(16777216) | Unique ID of the credit debit entry. |
| _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. |