Table description
This table contains Farcaster user profile data combined with their connected wallet addresses. It provides a convenient denormalized view for querying user identity alongside on-chain addresses.Table Schema
| Column Name | Type | Description |
|---|---|---|
fid | BIGINT | Farcaster user ID |
fname | VARCHAR | Farcaster username |
display_name | VARCHAR | Display name chosen by the user |
avatar_url | VARCHAR | URL to the user’s profile picture |
bio | VARCHAR | User’s profile biography text |
verified_addresses | VARCHAR | JSON-encoded array of verified EVM wallet addresses connected to the profile |
updated_at | TIMESTAMP | Timestamp when the profile data was last updated |