external.farcaster Table: dim_fnames Type: View
What
Stores all usernames that are currently registered. Note that in the case a username is deregistered, the row is soft-deleted via thedeleted_at column until a new username is registered
for the given FID. For more info see
Neynar or
schema
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FID | NUMBER | FID the username belongs to. |
| FNAME | TEXT | Username, e.g. dwr if an fname, or dwr.eth if an ENS name. |
| CUSTODY_ADDRESS | BINARY | Address that owns the FID. |
| EXPIRES_AT | TIMESTAMP_NTZ | EXPIRES_AT column |
| CREATED_AT | TIMESTAMP_NTZ | When the row was first created in this DB (not the same as when the key was created on the network!) |
| UPDATED_AT | TIMESTAMP_NTZ | When the row was last updated. |
| DELETED_AT | TIMESTAMP_NTZ | When the proof was revoked or the fname was otherwise deregistered from this user. |