Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin_cash.raw.outputs |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, transaction_hash, index |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | utxo_id, transaction_hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| value | NUMBER(38,0) | Value in sats (unnormalized). One sat = 1e-8 BCH. |
| script_asm | VARCHAR(16777216) | Symbolic representation of the script language op-codes. |
| script_hex | VARCHAR(16777216) | Hexadecimal representation of the script language op-codes. |
| required_signatures | NUMBER(38,0) | Required signatures. |
| type | VARCHAR(16777216) | The address type of the output. |
| addresses | ARRAY | Addresses used in the transaction output. |
| address0 | VARCHAR(16777216) | Index 0 of the addresses. |
| index | NUMBER(38,0) | The index of the output. |
| utxo_id | VARCHAR(16777216) | UTXO ID generated from transaction hash and index. |
| transaction_hash | VARCHAR(66) | Unique hash of the transaction containing the output. |
| block_hash | VARCHAR(66) | Block hash of the transaction output. |
| block_number | NUMBER(38,0) | Block number or block height of the transaction output. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the transaction output. |
| _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. |
| value_str | VARCHAR(16777216) | String of the output value in sats (unnormalized). One sat = 1e-8 BCH. |
| value_float | FLOAT | The output value as a float in sats (unnormalized). One sat = 1e-8 BCH. |