thorchain.defi_send_messages

THORChain send messages — internal transfer directives.

Table Description

The thorchain.defi_send_messages table contains outgoing send messages on THORChain.

Column Descriptions

Column	Type	Description
amount_e8	bigint	Amount in e8 units (1e8 = 1 unit)
asset	varchar	Asset identifier
from_address	varchar	Source address
to_address	varchar	Destination address
memo	varchar	Transaction memo
tx_id	bigint	Transaction ID
event_id	bigint	Event identifier
block_timestamp	timestamp	Timestamp of when the block was created
block_time	timestamp	Timestamp of when the block was created
block_month	timestamp	Block Month
_inserted_timestamp	timestamp	Timestamp of the record
fact_send_messages_id	bigint	Surrogate key for the fact record
dim_block_id	bigint	Reference to the block dimension table
inserted_timestamp	timestamp	Time when the record was inserted
modified_timestamp	timestamp	Time when the record was last modified

Table Sample