Overview
This schema contains 13 tables and views for External data.Tables and Views
Dim Fids
Stores all registered FIDs on the Farcaster network.
Dim Fnames
Stores all usernames that are currently registered.
Dim Profile With Addresses
This table contains farcaster users profile data and their connected addresses.
Fact Blocks
Represents users that have blocked or been blocked.
Fact Casts
Represents a cast authored by a user.
Fact Channel Follows
Represents follows for a Farcaster channel.
Fact Links
Represents a link between two FIDs (e.g.
Fact Reactions
Represents a user reacting (liking or recasting) content.
Fact Signers
Stores all registered signers.
Fact Storage
Stores how many units of storage each FID has purchased, and when it expires.
Fact User Data
Represents data associated with a user (e.g.
Fact Verifications
Represents a user verifying something on the network.
Fact Warpcast Power Users
Represents data associated with power users, based on Warpcast power badges.