Table description
This table contains data about likes and recast events on the Farcaster protocol. Each row represents a single reaction by a user to a cast or URL.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 reaction was removed on the Farcaster protocol |
timestamp | TIMESTAMP | Timestamp when the reaction was created on the Farcaster protocol |
reaction_type | BIGINT | Type of reaction (1 = like, 2 = recast) |
fid | BIGINT | Farcaster user ID of the user who reacted |
hash | VARBINARY | Unique hash of the reaction |
target_hash | VARBINARY | Hash of the cast being reacted to |
target_fid | BIGINT | Farcaster user ID of the author of the target cast |
target_url | VARCHAR | URL being reacted to (for URL-targeted reactions) |