Table description
This table contains data about wallet address verifications connected to Farcaster profiles. Users verify ownership of Ethereum and other addresses to link their on-chain identity with their Farcaster account.Table Schema
| Column Name | Type | Description |
|---|---|---|
id | BIGINT | Auto-incrementing row identifier |
created_at | TIMESTAMP | Timestamp when the record was created in the database |
updated_at | TIMESTAMP | Timestamp when the record was last updated in the database |
deleted_at | TIMESTAMP | Timestamp when the verification was removed on the Farcaster protocol |
timestamp | TIMESTAMP | Timestamp when the verification was created on the Farcaster protocol |
fid | BIGINT | Farcaster user ID of the profile owner |
hash | VARBINARY | Unique hash of the verification message |
claim | VARCHAR | JSON-encoded verified wallet address and cryptographic proof of ownership |