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.