Inputs
The bitcoin.inputs table provides indexed views of all transaction inputs.
Columns
| Name | Type | Description |
|---|---|---|
| block_number | integer |
The block number the input was included in. |
| coinbase | text |
The coinbase transaction. |
| index | integer |
The index of the input. |
| output_index | integer |
The index of the referenced output. |
| output_transaction_hash | text |
The hash of the transaction that includes the referenced output. |
| script_sig_asm | text |
The script signature in ASM format. |
| script_sig_hex | text |
The script signature in hex format. |
| sequence | float |
The sequence number. |
| timestamp | timestamp |
The timestamp of the input (in ISO-8601 format). |
| transaction_hash | text |
The hash of the transaction that includes the input. |
| transaction_position | integer |
The position of the transaction in the block. |
| tx_in_witness | array |
The witness data. |
| __confirmed | boolean |
Flag indicating whether the input has been confirmed. |
Indexes
| Index |
|---|
| transaction_hash, index |
| block_number, transaction_position |
| transaction_hash, transaction_position |
| output_transaction_hash, output_index |
| __confirmed WHERE __confirmed = false |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.