Skip to content

NFTs

The nfts table provides indexed views of all NFTs for a specified chain.

Columns

Name Description Type
contract_address Contract address of the NFT's collection. text
token_id The token ID of the NFT. numeric
minted_timestamp The NFT's mint timestamp (in ISO-8601 format). timestamp
supply The NFT's supply (0 if NFT has been burned). numeric
last_refreshed The timestamp at which the collection was last refreshed by the Transpose backend (in ISO-8601 format). timestamp
name The NFT's name. text
description The NFT's description. text
image_url The NFT's image URL. text
external_url The NFT's website URL. text
media_url The NFT's additional media URL. text
properties The NFT's properties (also referred to as attributes or traits). json
metadata_url The NFT's metadata URL. text

Indexes

The following indexes are available for this table:

(verified) WHERE verified = true
(last_refreshed ASC NULLS FIRST)
(contract_address, minted_timestamp, token_id)
(minted_timestamp, contract_address, token_id)
(name) WHERE name IS NOT NULL AND LENGTH(name) <= 15
GIST (name gist_trgm_ops) WHERE name IS NOT NULL AND LENGTH(name) <= 15
GIN (flattened_properties jsonb_ops)

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.