Skip to main content
Schema: thorchain.defi Table: fact_affiliate_fee_events Type: Base Table Fact table containing all affiliate fee events that occur in the Thorchain network

Columns

Column NameData TypeDescription
FACT_AFFILIATE_FEE_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_IDTEXTID of the confirmed block
TX_IDTEXTThe unique transaction id
FEE_AMTNUMBERThe affiliate fee amount collected for this transaction
GROSS_AMTNUMBERThe total transaction amount before fees
FEE_BPSNUMBERThe fee basis points charged for this affiliate transaction
MEMOTEXTThe memo for this event
ASSETTEXTAsset name or pool name
RUNE_ADDRESSTEXTThe RUNE address associated with the affiliate
THORNAMETEXTThe THORName identifier for the affiliate
EVENT_IDNUMBERUnique identifier for the affiliate fee event
_INSERTED_TIMESTAMPTIMESTAMP_NTZ
_AUDIT_RUN_IDTEXT
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.