Table description
This table contains all casts (posts and replies) on the Farcaster protocol, including text content, embeds, mentions, and threading information.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 cast was deleted on the Farcaster protocol |
timestamp | TIMESTAMP | Timestamp when the cast was created on the Farcaster protocol |
fid | BIGINT | Farcaster user ID of the cast author |
hash | VARBINARY | Unique hash of the cast |
parent_hash | VARBINARY | Hash of the parent cast (for replies) |
parent_fid | BIGINT | Farcaster user ID of the parent cast author |
parent_url | VARCHAR | Channel URL where the cast was posted (null for direct replies) |
text | VARCHAR | Text content of the cast |
embeds | VARCHAR | JSON-encoded attachments (images, links, frames, etc.) |
mentions | ARRAY(BIGINT) | Array of Farcaster user IDs mentioned in the cast |
mentions_positions | ARRAY(INTEGER) | Byte positions in the cast text where mentions are placed |
root_parent_hash | VARBINARY | Hash of the root cast that started the thread |
root_parent_url | VARCHAR | Channel URL of the root cast in the thread |