> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# thorchain.defi_affiliate_fee_events

> THORChain affiliate fee collection events.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table Description

The `thorchain.defi_affiliate_fee_events` table event data for affiliate fee on THORChain. This table is partitioned by day.

## Column Descriptions

| **Column**                           | **Type**  | **Description**                         |
| ------------------------------------ | --------- | --------------------------------------- |
| **tx\_id**                           | bigint    | Transaction ID                          |
| **fee\_amt**                         | varchar   | Fee Amt                                 |
| **gross\_amt**                       | varchar   | Gross Amt                               |
| **fee\_bps**                         | varchar   | Fee Bps                                 |
| **memo**                             | varchar   | Transaction memo                        |
| **asset**                            | varchar   | Asset identifier                        |
| **rune\_address**                    | varchar   | Address                                 |
| **thorname**                         | varchar   | Thorname                                |
| **event\_id**                        | bigint    | Event identifier                        |
| **block\_timestamp**                 | timestamp | Timestamp of when the block was created |
| **block\_time**                      | timestamp | Timestamp of when the block was created |
| **block\_month**                     | timestamp | Block Month                             |
| **\_inserted\_timestamp**            | timestamp | Timestamp of the record                 |
| **fact\_affiliate\_fee\_events\_id** | bigint    | Surrogate key for the fact record       |
| **dim\_block\_id**                   | bigint    | Reference to the block dimension table  |
| **inserted\_timestamp**              | timestamp | Time when the record was inserted       |
| **modified\_timestamp**              | timestamp | Time when the record was last modified  |

## Table Sample

<TableSample tableSchema="thorchain" tableName="defi_affiliate_fee_events" />