| transaction_hash | Unique hash of the transaction that contains this input. |
| block_hash | Hash of the block containing this input’s transaction. |
| block_number | Number of the block containing this input’s transaction. |
| block_timestamp | Timestamp when the block containing this input was mined. |
| index | The position of this input within its transaction. |
| spent_transaction_hash | Hash of the transaction that created the output being spent by this input. |
| spent_output_index | The index of the output being spent within its transaction. |
| script_asm | The script in assembly format that unlocks the spent output. |
| script_hex | The script in hexadecimal format that unlocks the spent output. |
| sequence | The sequence number of this input, used for relative time-locks. |
| coinbase | For coinbase transactions, contains the coinbase data. NULL for non-coinbase inputs. |
| input_id | Unique identifier for this input, composed of transaction_hash and index. |
| spent_utxo_id | Unique identifier for the spent output, composed of spent_transaction_hash and spent_output_index. |
| _created_at | Timestamp when this record was created in the database. |
| _updated_at | Timestamp when this record was last updated in the database. |
