Skip to main content
Schema: thorchain.defi Table: fact_bond_actions Type: Base Table

What

Fact table containing the clean bond action table to record the node operators’ behaviors

Columns

Column NameData TypeDescription
FACT_BOND_ACTIONS_IDTEXTThe surrogate key for the table. Will be unique and is used as a foreign key in other tables
BLOCK_TIMESTAMPTIMESTAMP_NTZTimestamp of block minting(without a timezone)
DIM_BLOCK_IDTEXTFK to DIM_BLOCK table
TX_IDTEXTThe unique transaction id
FROM_ADDRESSTEXTThe sending address for this event
TO_ADDRESSTEXTThe receiving address for this event
ASSETTEXTSame as pool name, which pool this bond events happens
BLOCKCHAINTEXTThe name of the blockchain
BOND_TYPETEXTBOND_TYPE column
ASSET_AMOUNTFLOATThe asset amount for this bond event
ASSET_USDFLOATUsed the price table to calculate the asset in the usd
MEMOTEXTThe memo for this event
_TX_TYPETEXT_TX_TYPE column
_INSERTED_TIMESTAMPTIMESTAMP_NTZ_INSERTED_TIMESTAMP column
_AUDIT_RUN_IDTEXT_AUDIT_RUN_ID column
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.