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

# Figure Connect Marketplace 🌱

### Table Details

| Property          | Value                                       |
| ----------------- | ------------------------------------------- |
| Table Name        | `provenance.rwa.figure_connect_marketplace` |
| Table Status      | Beta 🌱                                     |
| Unique Key        | `transaction_hash`                          |
| Clustering Key(s) | `block_timestamp::date`                     |

### Table Columns

| Column Name                     | Data Type         | Description                                                                                                                   |
| ------------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------------------------- |
| transaction\_hash               | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                   |
| block\_timestamp                | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                       |
| block\_number                   | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block\_hash                     | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                |
| transaction\_index              | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                        |
| tx\_fee\_payer                  | VARCHAR(16777216) | Address that paid gas for this transaction.                                                                                   |
| connect\_initiated              | BOOLEAN           | TRUE if tx\_fee\_payer = Figure Connect account (pb10yr...).                                                                  |
| pool\_token\_legs               | NUMBER(38,0)      | Count of pm.\* pool-token commitment/release legs in this transaction.                                                        |
| is\_pool\_trade                 | BOOLEAN           | TRUE if pool\_token\_legs > 0 (actual loan trade, not an operational transaction).                                            |
| \_created\_at                   | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                      |
| \_updated\_at                   | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                 |
| \_changed\_since\_full\_refresh | BOOLEAN           | Indicates if the record has changed since the last full data refresh.                                                         |