Nfts
The nova.nfts table provides indexed views of all NFTs.
Columns
| Name | Type | Description |
|---|---|---|
| contract_address | text |
Contract address of the NFT's collection. |
| description | text |
The NFT's description. |
| external_url | text |
The NFT's website URL. |
| flattened_properties | json |
The NFT's flattened properties (also referred to as attributes or traits). Better for searching. |
| image_url | text |
The NFT's image URL. |
| last_refreshed | timestamp |
The timestamp at which the collection was last refreshed by the Transpose backend (in ISO-8601 format). |
| media_url | text |
The NFT's additional media URL. |
| metadata_url | text |
The NFT's metadata URL. |
| minted_timestamp | timestamp |
The NFT's mint timestamp (in ISO-8601 format). |
| name | text |
The NFT's name. |
| properties | json |
The NFT's properties (also referred to as attributes or traits). |
| supply | numeric |
The NFT's supply (0 if NFT has been burned). |
| token_id | numeric |
The token ID of the NFT. |
| __updated_block_number | integer |
The block number at which the row was last updated. |
Indexes
| Index |
|---|
| name WHERE (name IS NOT NULL AND length(name <= 15) |
| minted_timestamp, contract_address, token_id |
| name WHERE (name IS NOT NULL AND length(name <= 15) |
| last_refreshed NULLS FIRST |
| flattened_properties |
| contract_address, minted_timestamp, token_id |
| contract_address, token_id |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.