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

What

Fact table that shows secure asset withdrawals

Columns

Column NameData TypeDescription
FACT_SECURE_ASSET_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
AMOUNT_E8NUMBERAMOUNT_E8 column
ASSETTEXTASSET column
ASSET_ADDRESSTEXTASSET_ADDRESS column
RUNE_ADDRESSTEXTRUNE_ADDRESS column
TX_IDTEXTTX_ID column
EVENT_IDNUMBEREVENT_ID 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.