Skip to content

Collections

The basegoerli.collections table provides indexed views of all NFT collections.

Columns

Name Type Description
contract_address text Contract address of the collection.
count integer The number of NFTs in the collection (NFTs minted minus NFTs burned).
created_timestamp timestamp The collection's timestamp of creation (in ISO-8601 format).
description text The collection's description.
external_url text The collection's website URL.
image_url text The collection's image URL in the Transpose CDN.
is_nsfw boolean The collection's NSFW status.
last_refreshed timestamp The timestamp at which the collection was last refreshed by the Transpose backend (in ISO-8601 format).
name text The collection's name.
opensea_slug text The collection's OpenSea slug.
opensea_url text The collection's OpenSea URL.
standard text The collection's NFT standard (ERC-721 or ERC-1155)
symbol text The collection's symbol.

Indexes

Index
contract_address
standard, created_timestamp, contract_address
created_timestamp, contract_address
last_refreshed NULLS FIRST
name WHERE (name IS NOT NULL AND length(name <= 15)
symbol WHERE (symbol IS NOT NULL AND length(symbol <= 15)
name WHERE (name IS NOT NULL AND length(name <= 15)
symbol WHERE (symbol IS NOT NULL AND length(symbol <= 15)

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.