Table of contents
The aptos_mainnet.user_transactions table provides indexed views of all user_transactions.
Columns
| Name | Type | Description |
|---|---|---|
| block_height | integer | N/A |
| block_time | date | N/A |
| block_hash | varchar | N/A |
| timestamp | integer | N/A |
| version | integer | N/A |
| type | varchar | N/A |
| hash | varchar | N/A |
| sender | varchar | N/A |
| receiver | varchar | N/A |
| function | varchar | N/A |
| proposer | varchar | N/A |
| amount | integer | N/A |
| gas_used | integer | N/A |
| gas_unit_price | integer | N/A |
| max_gas_limit | integer | N/A |
| success | boolean | N/A |
| vm_status | varchar | N/A |
| smart_contract | varchar | N/A |
| expiration_time | date | N/A |
| signature | varchar | N/A |
| epoch | integer | N/A |
| round | integer | N/A |
| sequence_number | integer | N/A |
| state_change_hash | varchar | N/A |
| event_root_hash | varchar | N/A |
| accumulator_root_hash | varchar | N/A |