> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# layer3_v1_zksyncera
> Tables in tt-contracts.layer3_v1_zksyncera
## Tables
### Cube\_CubeClaim\_event
Layer3 Cube NFT claim events emitted when users mint quest completion tokens. Records claimer address, quest identifier, token identifier, issue number, optional wallet provider and embed origin metadata.
| Column | Type | Description |
| ------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_questId` | `STRING` | Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest's ID. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_claimer` | `STRING` | Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_issueNumber` | `STRING` | Sequential identifier for the NFT claim within its quest. Numeric string representation of the claim sequence number. |
| `in_walletProvider` | `STRING` | Name of the wallet application or browser extension used to initiate the claim transaction. |
| `in_embedOrigin` | `STRING` | URL of the website or application where the Layer3 quest claim was embedded or initiated. |
| address | removed | log\_index | in\_claimer | in\_questId | in\_tokenId | block\_number | in\_embedOrigin | in\_issueNumber | block\_timestamp | transaction\_hash | in\_walletProvider |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | -------------------------------------- | ----------- | ------------- | --------------- | --------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ |
| 0xf77bd7c05598e094bc06e34bb81c07bd3b091db1 | false | 3 | 0xc7d285fb503b4392baf63a91253252a8d6bf3a94 | 73864929910910341822644595367334206379 | 2263688 | 41814407 | | 7550 | 2024-08-16T07:55:09.000Z | 0x7b3bc3fd7099aec01e7fa0804223a4291251fc847fc65f6c12ff719aec8b9c26 | |
| 0xf77bd7c05598e094bc06e34bb81c07bd3b091db1 | false | 3 | 0xd6e8141df974aad3e6533c71444877e2580483e2 | 73864929910910341822644595367334206379 | 2263790 | 41816765 | | 7629 | 2024-08-16T08:36:00.000Z | 0x364eee75a6cf8a500a20f26a120410ed289d3fac2e96cd73eacb08cb29d6b72e | |
| 0xf77bd7c05598e094bc06e34bb81c07bd3b091db1 | false | 3 | 0x2a1e510db1deb8a3bcb1b58e1b582519153e5aaf | 73864929910910341822644595367334206379 | 2264179 | 41827309 | | 7889 | 2024-08-16T11:41:13.000Z | 0xc1f530ab25ca9f1a8747862448f677ef778c13770150a5828040f3c05a48e2de | |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Cube_CubeClaim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Cube\_TokenReward\_event
Token reward distribution events from Layer3 Cube system containing reward amount, token details (address, type, and token ID), cube token identifier, and chain identifier. Used for tracking cross-chain reward allocations and token disbursements.
| Column | Type | Description |
| ------------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_cubeTokenId` | `STRING` | Unique identifier for a Cube token in the Layer3 platform. Numeric string representation of the Cube NFT's token ID. |
| `in_tokenAddress` | `STRING` | Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_chainId` | `STRING` | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_tokenType` | `INT64` | Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_tokenId | block\_number | in\_tokenType | in\_cubeTokenId | block\_timestamp | in\_tokenAddress | transaction\_hash |
| ------------------------------------------ | ------- | -------------------- | ---------- | ----------- | ----------- | ------------- | ------------- | --------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0xf77bd7c05598e094bc06e34bb81c07bd3b091db1 | false | 12500000000000000000 | 24 | 324 | 0 | 34869951 | 0 | 1400532 | 2024-05-25T08:06:54.000Z | 0xa995ad25ce5eb76972ab356168f5e1d9257e4d05 | 0xcb2f7101b3d01454991b6b411f6f0fd27310579b12ff8751b23006e5251325f6 |
| 0xf77bd7c05598e094bc06e34bb81c07bd3b091db1 | false | 12500000000000000000 | 83 | 324 | 0 | 34873147 | 0 | 1401258 | 2024-05-25T09:02:43.000Z | 0xa995ad25ce5eb76972ab356168f5e1d9257e4d05 | 0xee3fd46d1145dc897866e75f6d5925d908c0f9e637fa75a71b4b42608af638f8 |
| 0xf77bd7c05598e094bc06e34bb81c07bd3b091db1 | false | 12500000000000000000 | 31 | 324 | 0 | 34912085 | 0 | 1407278 | 2024-05-25T20:13:04.000Z | 0xa995ad25ce5eb76972ab356168f5e1d9257e4d05 | 0x61e8d850c240399a2c680f4dcfd7d1a024fa64aa18ca712e265ec18613f7b3d4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Cube_TokenReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Escrow\_EscrowERC20Transfer\_event
ERC-20 token escrow transfer events emitted when tokens are released from an escrow contract to a recipient. Contains token address, transfer amount, recipient address, and optional rake (fee) details with payout address for platform revenue tracking.
| Column | Type | Description |
| ---------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_rake` | `STRING` | Fee amount deducted from the transfer. Numeric string representation in smallest token denomination. |
| `in_rakePayoutAddress` | `STRING` | Address designated to receive the rake fee from the escrow transfer. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Escrow_EscrowERC20Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Escrow\_EscrowNativeTransfer\_event
Native token transfer events from escrow contracts containing recipient address, transfer amount, rake fee, and rake payout address. Used for tracking escrowed native asset movements and associated fee distributions across Layer3 platform deployments.
| Column | Type | Description |
| ---------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_rake` | `STRING` | Fee amount deducted from the transfer. Numeric string representation in smallest token denomination. |
| `in_rakePayoutAddress` | `STRING` | Address designated to receive the rake fee from the escrow transfer. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Escrow_EscrowNativeTransfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Escrow\_TokenPayout\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenAddress` | `STRING` | Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_tokenType` | `INT64` | Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens. |
| `in_questId` | `STRING` | Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest's ID. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Escrow_TokenPayout_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_EscrowRegistered\_event
Event log capturing escrow contract registrations in the Layer3 quest platform. Links quest identifiers to their deployed escrow contract addresses and registering parties for reward distribution tracking.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_registror` | `STRING` | Contract address that registered the escrow for the quest. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_escrowAddress` | `STRING` | Contract address of the escrow associated with the quest registration. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_questId` | `STRING` | Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest's ID. |
| address | removed | log\_index | in\_questId | block\_number | in\_registror | block\_timestamp | in\_escrowAddress | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | --------------------------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0xc3e7df62b4d6c1dc3330a3382eaf5a64f45959fb | false | 18 | 212981349668212110430712858913617115597 | 31896143 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d | 2024-04-19T13:28:55.000Z | 0x44bd083582218cb8019b06a4b8b12f2a589de0e3 | 0x875b4129fef75746c659fc1cc8a2cc35055ce9c603f690fbf00d121d29174d0d |
| 0xc3e7df62b4d6c1dc3330a3382eaf5a64f45959fb | false | 4 | 214245608344017283220061796302096080587 | 52974702 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d | 2025-01-05T21:26:51.000Z | 0x8bd97af30aea0677b138e179b840ccebccaa88e3 | 0xad20c79554d963db82d6ed4231495d47872698beec94cf0d61562a880abf2825 |
| 0xc3e7df62b4d6c1dc3330a3382eaf5a64f45959fb | false | 46 | 27700113922334506041974287622477583490 | 32213043 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d | 2024-04-23T09:35:35.000Z | 0x20f7b1d4696fb25e638f93911de58b5e39f9d9b3 | 0x72111b2b282174a0cd3cbab139b8a96826caae2aa8be4643ebb7c42a44eaabe9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Factory_EscrowRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_TokenPayout\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenAddress` | `STRING` | Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_tokenType` | `INT64` | Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens. |
| `in_questId` | `STRING` | Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest's ID. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layer3_v1_zksyncera.Pool_TokenPayout_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***