| hash | VARCHAR(66) | Unique identifier or hash of the transaction. |
| size | NUMBER(38,0) | The size of the transaction in bytes. |
| virtual_size | NUMBER(38,0) | The virtual size of the transaction, used for fee calculation. |
| version | NUMBER(38,0) | The version number of the transaction format. |
| lock_time | NUMBER(38,0) | The block number or timestamp at which the transaction becomes valid. |
| index | NUMBER(38,0) | The position of the transaction within its block. |
| block_hash | VARCHAR(66) | Hash of the block containing this transaction. |
| block_number | NUMBER(38,0) | Number of the block containing this transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the block containing this transaction was mined. |
| input_count | NUMBER(38,0) | Number of inputs in this transaction. |
| output_count | NUMBER(38,0) | Number of outputs in this transaction. |
| output_value | NUMBER(38,0) | Total amount of DOGE in satoshis (smallest unit) in all outputs. |
| is_coinbase | BOOLEAN | Indicates if this is a coinbase transaction. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated in the database. |
