external.farcaster Table: fact_links Type: View
What
Represents a link between two FIDs (e.g. a follow, subscription, etc.). 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 | Farcaster ID (the user ID). |
| TARGET_FID | NUMBER | Farcaster ID of the target user. |
| HASH | BINARY | Message hash. |
| TIMESTAMP | TIMESTAMP_NTZ | Message timestamp in UTC. |
| TYPE | TEXT | Type of connection between users, e.g. follow. |
| DISPLAY_TIMESTAMP | TIMESTAMP_NTZ | When the row was last updated. |
| CREATED_AT | TIMESTAMP_NTZ | When the row was first created in this DB (not when the link itself was created on the network!) |
| UPDATED_AT | TIMESTAMP_NTZ | When the row was last updated |
| DELETED_AT | TIMESTAMP_NTZ | When the link was considered deleted by the hub (e.g. in response to a LinkRemoveMessage message, etc.) |