Table description
This table contains data about follower and following relationships on the Farcaster protocol. Each row represents a social graph link between two users.Table Schema
| Column Name | Type | Description |
|---|---|---|
id | BIGINT | Auto-incrementing row identifier |
fid | BIGINT | Farcaster user ID of the user who created the link |
target_fid | BIGINT | Farcaster user ID of the link target |
hash | VARBINARY | Unique hash of the link on the protocol |
timestamp | TIMESTAMP | Timestamp when the link was created on the Farcaster protocol |
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 link was removed on the Farcaster protocol |
type | VARCHAR | Link type (e.g. follow) |
display_timestamp | TIMESTAMP | Display-friendly timestamp for the link event |