external.farcaster Table: fact_signers Type: View
What
Stores all registered signers. For more info see Neynar or schemaColumns
| Column Name | Data Type | Description |
|---|---|---|
| ID | NUMBER | Generic identifier specific to this DB (a.k.a. surrogate key) |
| FID | NUMBER | FID of the user that authorized this signer. |
| APP_FID | NUMBER | FID of the user/app that requested this signer. |
| NAME | TEXT | NAME column |
| SIGNER | BINARY | SIGNER column |
| TIMESTAMP | TIMESTAMP_NTZ | TIMESTAMP 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 | Timestamp of the block where this signer was removed. |