Skip to main content
Schema: thorchain.defi Table: fact_rewards_events Type: Base Table Fact table that shows the entries for the rewards

Columns

Column NameData TypeDescription
FACT_REWARDS_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
BOND_E8NUMBERThe rune amount of the bond for this pool at this block
_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.