> ## 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.

# Mints

Our NFT mints table contain the following minting programs on the Solana blockchain.

### Table Details

| Property            | Value                                       |
| ------------------- | ------------------------------------------- |
| Table Name          | `solana.nfts.mints`                         |
| Table Status        | Production-Ready                            |
| Unique Key          | `block_timestamp::date`, `unique_id`        |
| Clustering Key(s)   | `block_timestamp::date`                     |
| Search Optimization | `protocol`, `txn_id`, `is_cnft`, `asset_id` |

### Protocols

| Minting Program      | NFTs                 |
| -------------------- | -------------------- |
| Candy Machine v2, v3 | Regular NFT mints    |
| Bubble Gum           | Compressed NFT mints |

### Table Columns

| Column Name                     | Data Type          | Description                                                                                                                                                            |
| ------------------------------- | ------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| platform                        | VARCHAR(134217728) | Platform where the NFT was minted from (if relevant).                                                                                                                  |
| protocol                        | VARCHAR(134217728) | Minting protocol, if applicable.                                                                                                                                       |
| program\_id                     | VARCHAR(44)        | Program ID of the minting protocol.                                                                                                                                    |
| mint\_type                      | VARCHAR(134217728) | Type of mint event, can be SINGLE\_MINT or BUNDLE\_MINT.                                                                                                               |
| total\_item\_quantity           | NUMBER(38,0)       | Total item minted in the transaction.                                                                                                                                  |
| signer                          | VARCHAR(44)        | Transaction signer, which is often the account minting the NFTs. Althought NFTs can also be minted to other wallet accounts.                                           |
| payer                           | VARCHAR(44)        | Transaction payer of the mint, if applicable.                                                                                                                          |
| token\_standard                 | VARCHAR(134217728) | Token standard of the NFT. `erc721` for non-fungible tokens (unique IDs, balance 0 or 1), `erc1155` for semi-fungible tokens (multiple copies per ID).                 |
| item\_quantity                  | NUMBER(38,0)       | Total item minted.                                                                                                                                                     |
| token\_mint                     | VARCHAR(44)        | Token mint address.                                                                                                                                                    |
| token\_metadata                 | VARCHAR(44)        | Token metadata address.                                                                                                                                                |
| token\_metadata\_program        | VARCHAR(44)        | Token metadata program address.                                                                                                                                        |
| collection\_mint                | VARCHAR(44)        | Collection mint address of the NFT minted.                                                                                                                             |
| collection\_metadata            | VARCHAR(44)        | Collection metadata address of the NFT minted.                                                                                                                         |
| collection\_master\_edition     | VARCHAR(44)        | Collection mater edition address of the NFT minted.                                                                                                                    |
| is\_cnft                        | BOOLEAN            | Boolean indicator on whether the NFT is a cNFT (compressed NFT).                                                                                                       |
| merkle\_tree                    | VARCHAR(44)        | cNFT data: The account that contains the Merkle tree, initialized by create\_tree.                                                                                     |
| leaf\_index                     | NUMBER(38,0)       | cNFT data: The index of the leaf node in the Merkle tree. Can be retrieved from off-chain data store.                                                                  |
| asset\_id                       | VARCHAR(134217728) | Asset address ID.                                                                                                                                                      |
| name                            | VARCHAR(134217728) | Name of NFT.                                                                                                                                                           |
| symbol                          | VARCHAR(134217728) | Symbol of NFT.                                                                                                                                                         |
| collection\_name                | VARCHAR(134217728) | Collection name of NFT.                                                                                                                                                |
| collection\_symbol              | VARCHAR(134217728) | Collection symbol of NFT.                                                                                                                                              |
| currency\_mint                  | VARCHAR(44)        | Currency used for mint.                                                                                                                                                |
| currency\_symbol                | VARCHAR(134217728) | Symbol used for mint.                                                                                                                                                  |
| raw\_price                      | VARCHAR(134217728) | Raw, unnormalized price of the NFT mint.                                                                                                                               |
| price                           | FLOAT              | Normalized price of the NFT mint.                                                                                                                                      |
| usd\_price                      | FLOAT              | USD price of the NFT mint.                                                                                                                                             |
| txn\_fee                        | FLOAT              | Transaction fee paid (in SOL) for the minting transaction.                                                                                                             |
| block\_slot                     | NUMBER(38,0)       | Block slot at the time of the mint.                                                                                                                                    |
| block\_height                   | NUMBER(38,0)       | Block height at the time of the mint.                                                                                                                                  |
| block\_timestamp                | TIMESTAMP\_NTZ(9)  | Block timestamp at the mint.                                                                                                                                           |
| block\_hash                     | VARCHAR(44)        | Block hash at the time of the mint,                                                                                                                                    |
| txn\_id                         | VARCHAR(88)        | Transaction id of the minting transaction.                                                                                                                             |
| txn\_index                      | NUMBER(38,0)       | Transaction index number.                                                                                                                                              |
| instruction\_index              | NUMBER(38,0)       | Instruction index of the transaction.                                                                                                                                  |
| inner\_instruction\_index       | NUMBER(38,0)       | Zero-based position of this inner instruction within its parent instruction's inner instructions array. -1 for top-level instructions that are not inner instructions. |
| outer\_program\_id              | VARCHAR(44)        | Program ID of the outermost instruction that invoked this inner instruction on Solana                                                                                  |
| \_metadata\_updated\_at         | TIMESTAMP\_NTZ(9)  | When the stablecoin metadata was last updated.                                                                                                                         |
| \_changed\_since\_full\_refresh | BOOLEAN            | Indicates if the record has changed since the last full data refresh.                                                                                                  |
| \_updated\_at                   | TIMESTAMP\_NTZ(9)  | Timestamp of when the entry was last updated in the database.                                                                                                          |
| unique\_id                      | VARCHAR(134217728) | Unique ID assigned for the minting transaction.                                                                                                                        |
| \_created\_at                   | TIMESTAMP\_NTZ(9)  | Timestamp of when the entry was created in the database.                                                                                                               |
| extra\_fields                   | VARIANT            | Protocol-specific fields as a JSON object. Keys: transfer\_uuid (transfer identifier, uint128 as varchar, from the event).                                             |