Skip to content

Nfts

The scroll.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).
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.