This table contains data about the user information on the Farcaster protocol. It can be joined with fname or fid for additional details.

Column nameTypeDescription
idbigintRow id
created_attimestamp without timezoneTimestamp of creation within database
updated_attimestamp without timezoneTimestamp of update within database
deleted_attimestamp without timezoneTimestamp of deletion on Farcaster protocol
timestamptimestamp without timezoneTimestamp of creation on Farcaster protocol
fidbigintUser ID of user on Farcaster protocol
hashbyteaHash of user data
typesmallintType of user data: (1 = Avatar URL, 2 = Display name, 3 = Profile bio, 5 = URL of the user, 6 = Preferred fname)