external.farcaster Table: fact_reactions Type: View
What
Represents a user reacting (liking or recasting) content. 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 signed the message. |
| TARGET_FID | NUMBER | If target was a cast, the FID of the author of the cast. null otherwise. |
| TARGET_URL | TEXT | If target was a URL (e.g. NFT, a web URL, etc.), the URL. null otherwise. |
| REACTION_TYPE | NUMBER | Type of reaction. |
| HASH | BINARY | Message hash. |
| TARGET_HASH | BINARY | If target was a cast, the hash of the cast. null otherwise. |
| TIMESTAMP | TIMESTAMP_NTZ | Message timestamp in UTC. |
| CREATED_AT | TIMESTAMP_NTZ | When the row was first created in this DB (not the same as the message timestamp!) |
| UPDATED_AT | TIMESTAMP_NTZ | When the row was last updated. |
| DELETED_AT | TIMESTAMP_NTZ | When the reaction was considered deleted by the hub (e.g. in response to a ReactionRemove message, etc.) |