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

What

Fact table containing all withdraw events

Columns

Column NameData TypeDescription
FACT_WITHDRAW_EVENTS_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
BLOCKCHAINTEXTThe name of the blockchain
FROM_ADDRESSTEXTThe sending address for this event
TO_ADDRESSTEXTThe receiving address for this event
ASSETTEXTAsset name or pool name
ASSET_E8NUMBERThe asset amount for this bond, using the price table we can calculate the rune amount by asset amount
EMIT_ASSET_E8NUMBEREMIT_ASSET_E8 column
EMIT_RUNE_E8NUMBEREMIT_RUNE_E8 column
MEMOTEXTThe memo for this event
POOL_NAMETEXTName of the pool — also asset name in other tables
STAKE_UNITSNUMBERSTAKE_UNITS column
BASIS_POINTSNUMBERBASIS_POINTS column
ASYMMETRYFLOATASYMMETRY column
IMP_LOSS_PROTECTION_E8NUMBERIMP_LOSS_PROTECTION_E8 column
_EMIT_ASSET_IN_RUNE_E8NUMBER_EMIT_ASSET_IN_RUNE_E8 column
_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.