Last updated
Last updated
Transactions are cryptographically signed instructions from accounts. An account will initiate a transaction to update the state of the Ethereum network. Transactions will always originate from externally owned accounts, a smart contract cannot initiate a transaction.
Transactions need to be broadcast to the whole network. Any node can broadcast a request for a transaction to be executed on the EVM; after this happens, a miner will execute the transaction and propagate the resulting state change to the rest of the network.
Examples
Examples
hash
str
nonce
int
transaction_index
int
from_address
str
to_address
str
value
int
gas
int
gas_price
int
input
str
receipt_cumulative_gas_used
int
receipt_gas_used
int
receipt_contract_address
str
receipt_root
str
receipt_status
int
block_timestamp
timestamp
block_number
int
block_hash
str
max_fee_per_gas
int
max_priority_fee_per_gas
int
transaction_type
int
receipt_effective_gas_price
int
receipt_l1_fee
int
receipt_l1_gas_used
int
receipt_l1_gas_price
int
receipt_l1_fee_scalar
float
receipt_blob_gas_used
int
receipt_blob_gas_price
int
blob_versioned_hashes
list
exist_error
bool
error
str
revert_reason
str
hash
bytea
primary key
transaction_index
integer
from_address
bytea
to_address
bytea
value
numeric(100)
transaction_type
integer
input
bytea
nonce
integer
block_hash
bytea
block_number
bigint
block_timestamp
timestamp
gas
numeric(100)
gas_price
numeric(100)
max_fee_per_gas
numeric(100)
max_priority_fee_per_gas
numeric(100)
receipt_root
bytea
receipt_status
integer
receipt_gas_used
numeric(100)
receipt_cumulative_gas_used
numeric(100)
receipt_effective_gas_price
numeric(100)
receipt_l1_fee
numeric(100)
receipt_l1_fee_scalar
numeric(100, 18)
receipt_l1_gas_used
numeric(100)
receipt_l1_gas_price
numeric(100)
receipt_blob_gas_used
numeric(100)
receipt_blob_gas_price
numeric(100)
blob_versioned_hashes
bytea[]
receipt_contract_address
bytea
exist_error
boolean
error
text
revert_reason
text
create_time
timestamp
default now()
update_time
timestamp
default now()
reorg
boolean
method_id
varchar
generated always as (substr(((input)::character varying)::text, 3, 8)) stored