> ## Documentation Index > Fetch the complete documentation index at: https://docs.neynar.com/llms.txt > Use this file to discover all available pages before exploring further. # Replicator Schema The following tables are created in Postgres DB where data from the Hubs are stored: ## chain\_events All onchain events received from the hub event stream are stored in this table. These events represent any onchain action including registrations, transfers, signer additions/removals, storage rents, etc. Events are never deleted (i.e. this table is append-only). | Column Name | Data Type | Description | | ------------------ | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as the message timestamp!) | | block\_timestamp | `timestamp with time zone` | Timestamp of the block this event was emitted in UTC. | | fid | `bigint` | FID of the user that signed the message. | | chain\_id | `bigint` | Chain ID. | | block\_number | `bigint` | Block number of the block this event was emitted. | | transaction\_index | `smallint` | Index of the transaction in the block. | | log\_index | `smallint` | Index of the log event in the block. | | type | `smallint` | Type of chain event. | | block\_hash | `bytea` | Hash of the block where this event was emitted. | | transaction\_hash | `bytea` | Hash of the transaction triggering this event. | | body | `json` | JSON representation of the chain event body (changes shape based on `type`). | | raw | `bytea` | Raw bytes representing the serialized `OnChainEvent` [protobuf](https://protobuf.dev/). | ## fids Stores all registered FIDs on the Farcaster network. | Column Name | Data Type | Description | | ----------------- | -------------------------- | ------------------------------------------------------------------------------------------- | | fid | `bigint` | FID of the user (primary key) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as registration date!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | registered\_at | `timestamp with time zone` | Timestamp of the block in which the user was registered. | | chain\_event\_id | `uuid` | ID of the row in the `chain_events` table corresponding to this FID's initial registration. | | custody\_address | `bytea` | Address that owns the FID. | | recovery\_address | `bytea` | Address that can initiate a recovery for this FID. | ## signers Stores all registered account keys (signers). | Column Name | Data Type | Description | | ------------------------ | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as when the key was created on the network!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | added\_at | `timestamp with time zone` | Timestamp of the block where this signer was added. | | removed\_at | `timestamp with time zone` | Timestamp of the block where this signer was removed. | | fid | `bigint` | FID of the user that authorized this signer. | | requester\_fid | `bigint` | FID of the user/app that requested this signer. | | add\_chain\_event\_id | `uuid` | ID of the row in the `chain_events` table corresponding to the addition of this signer. | | remove\_chain\_event\_id | `uuid` | ID of the row in the `chain_events` table corresponding to the removal of this signer. | | key\_type | `smallint` | Type of key. | | metadata\_type | `smallint` | Type of metadata. | | key | `bytea` | Public key bytes. | | metadata | `bytea` | Metadata bytes as stored on the blockchain. | ## username\_proofs Stores all username proofs that have been seen. This includes proofs that are no longer valid, which are soft-deleted via the `deleted_at` column. When querying usernames, you probably want to query the `fnames` table directly, rather than this table. | Column Name | Data Type | Description | | ----------- | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as when the key was created on the network!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | timestamp | `timestamp with time zone` | Timestamp of the proof message. | | deleted\_at | `timestamp with time zone` | When this proof was revoked or otherwise invalidated. | | fid | `bigint` | FID that the username in the proof belongs to. | | type | `smallint` | Type of proof (either fname or ENS). | | username | `text` | Username, e.g. `dwr` if an fname, or `dwr.eth` if an ENS name. | | signature | `bytea` | Proof signature. | | owner | `bytea` | Address of the wallet that owns the ENS name, or the wallet that provided the proof signature. | ## fnames Stores all usernames that are currently registered. Note that in the case a username is deregistered, the row is soft-deleted via the `deleted_at` column until a new username is registered for the given FID. | Column Name | Data Type | Description | | -------------- | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as when the key was created on the network!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | registered\_at | `timestamp with time zone` | Timestamp of the username proof message. | | deleted\_at | `timestamp with time zone` | When the proof was revoked or the fname was otherwise deregistered from this user. | | fid | `bigint` | FID the username belongs to. | | type | `smallint` | Type of username (either fname or ENS). | | username | `text` | Username, e.g. `dwr` if an fname, or `dwr.eth` if an ENS name. | ## messages All Farcaster messages retrieved from the hub are stored in this table. Messages are never deleted, only soft-deleted ( i.e. marked as deleted but not actually removed from the DB). | Column Name | Data Type | Description | | ----------------- | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as the message timestamp!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | timestamp | `timestamp with time zone` | Message timestamp in UTC. | | deleted\_at | `timestamp with time zone` | When the message was deleted by the hub (e.g. in response to a `CastRemove` message, etc.) | | pruned\_at | `timestamp with time zone` | When the message was pruned by the hub. | | revoked\_at | `timestamp with time zone` | When the message was revoked by the hub due to revocation of the signer that signed the message. | | fid | `bigint` | FID of the user that signed the message. | | type | `smallint` | Message type. | | hash\_scheme | `smallint` | Message hash scheme. | | signature\_scheme | `smallint` | Message signature scheme. | | hash | `bytea` | Message hash. | | signature | `bytea` | Message signature. | | signer | `bytea` | Signer used to sign this message. | | body | `json` | JSON representation of the body of the message. | | raw | `bytea` | Raw bytes representing the serialized message [protobuf](https://protobuf.dev/). | ## casts Represents a cast authored by a user. | Column Name | Data Type | Description | | ------------------- | -------------------------- | ----------------------------------------------------------------------------------------------------------------- | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as the message timestamp!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | timestamp | `timestamp with time zone` | Message timestamp in UTC. | | deleted\_at | `timestamp with time zone` | When the cast was considered deleted/revoked/pruned by the hub (e.g. in response to a `CastRemove` message, etc.) | | fid | `bigint` | FID of the user that signed the message. | | parent\_fid | `bigint` | If this cast was a reply, the FID of the author of the parent cast. `null` otherwise. | | hash | `bytea` | Message hash. | | root\_parent\_hash | `bytea` | If this cast was a reply, the hash of the original cast in the reply chain. `null` otherwise. | | parent\_hash | `bytea` | If this cast was a reply, the hash of the parent cast. `null` otherwise. | | root\_parent\_url | `text` | If this cast was a reply, then the URL that the original cast in the reply chain was replying to. | | parent\_url | `text` | If this cast was a reply to a URL (e.g. an NFT, a web URL, etc.), the URL. `null` otherwise. | | text | `text` | The raw text of the cast with mentions removed. | | embeds | `json` | Array of URLs or cast IDs that were embedded with this cast. | | mentions | `json` | Array of FIDs mentioned in the cast. | | mentions\_positions | `json` | UTF8 byte offsets of the mentioned FIDs in the cast. | ## reactions Represents a user reacting (liking or recasting) content. | Column Name | Data Type | Description | | ------------------ | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as the message timestamp!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | timestamp | `timestamp with time zone` | Message timestamp in UTC. | | deleted\_at | `timestamp with time zone` | When the reaction was considered deleted by the hub (e.g. in response to a `ReactionRemove` message, etc.) | | fid | `bigint` | FID of the user that signed the message. | | target\_cast\_fid | `bigint` | If target was a cast, the FID of the author of the cast. `null` otherwise. | | type | `smallint` | Type of reaction. | | hash | `bytea` | Message hash. | | target\_cast\_hash | `bytea` | If target was a cast, the hash of the cast. `null` otherwise. | | target\_url | `text` | If target was a URL (e.g. NFT, a web URL, etc.), the URL. `null` otherwise. | ## links Represents a link between two FIDs (e.g. a follow, subscription, etc.) | Column Name | Data Type | Description | | ------------------ | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not when the link itself was created on the network!) | | updated\_at | `timestamp with time zone` | When the row was last updated | | timestamp | `timestamp with time zone` | Message timestamp in UTC. | | deleted\_at | `timestamp with time zone` | When the link was considered deleted by the hub (e.g. in response to a `LinkRemoveMessage` message, etc.) | | fid | `bigint` | Farcaster ID (the user ID). | | target\_fid | `bigint` | Farcaster ID of the target user. | | display\_timestamp | `timestamp with time zone` | When the row was last updated. | | type | `text` | Type of connection between users, e.g. `follow`. | | hash | `bytea` | Message hash. | ## verifications Represents a user verifying something on the network. Currently, the only verification is proving ownership of an Ethereum wallet address. | Column Name | Data Type | Description | | --------------- | -------------------------- | ------------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as the message timestamp!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | timestamp | `timestamp with time zone` | Message timestamp in UTC. | | deleted\_at | `timestamp with time zone` | When the verification was considered deleted by the hub (e.g. in response to a `VerificationRemove` message, etc.) | | fid | `bigint` | FID of the user that signed the message. | | hash | `bytea` | Message hash. | | signer\_address | `bytea` | Address of the wallet being verified. | | block\_hash | `bytea` | Block hash of the latest block at the time the ownership was verified. | | signature | `bytea` | Ownership proof signature. | ## user\_data Represents data associated with a user (e.g. profile photo, bio, username, etc.) | Column Name | Data Type | Description | | ----------- | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB (not the same as the message timestamp!) | | updated\_at | `timestamp with time zone` | When the row was last updated. | | timestamp | `timestamp with time zone` | Message timestamp in UTC. | | deleted\_at | `timestamp with time zone` | When the data was considered deleted by the hub | | fid | `bigint` | FID of the user that signed the message. | | type | `smallint` | The type of user data (PFP, bio, username, etc.) | | hash | `bytea` | Message hash. | | value | `text` | The string value of the field. | ## storage\_allocations Stores how many units of storage each FID has purchased, and when it expires. | Column Name | Data Type | Description | | ---------------- | -------------------------- | ------------------------------------------------------------------------------------------------------------ | | id | `uuid` | Generic identifier specific to this DB (a.k.a. [surrogate key](https://en.wikipedia.org/wiki/Surrogate_key)) | | created\_at | `timestamp with time zone` | When the row was first created in this DB | | updated\_at | `timestamp with time zone` | When the row was last updated. | | rented\_at | `timestamp with time zone` | Message timestamp in UTC. | | expires\_at | `timestamp with time zone` | When this storage allocation will expire. | | chain\_event\_id | `uuid` | ID of the row in the `chain_events` table representing the onchain event where storage was allocated. | | fid | `bigint` | FID that owns the storage. | | units | `smallint` | Number of storage units allocated. | | payer | `bytea` | Wallet address that paid for the storage. |