Skip to main content

Table description

This table contains usernames (fnames) associated with Farcaster user IDs. Fnames are human-readable identifiers that can be transferred and expire.

Table Schema

Column NameTypeDescription
fnameVARCHARFarcaster username of the user
created_atTIMESTAMPTimestamp when the record was created in the database
updated_atTIMESTAMPTimestamp when the record was last updated in the database
custody_addressVARBINARYWallet address that holds custody of the Farcaster account
expires_atTIMESTAMPTimestamp when the username registration expires
fidBIGINTFarcaster user ID associated with this username
deleted_atTIMESTAMPTimestamp when the fname was removed on the Farcaster protocol

Table Sample