Table description
This table contains data about signers associated with users on the Farcaster protocol. Signers are authorized key pairs that can perform actions on behalf of a user.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 signer was revoked on the Farcaster protocol |
timestamp | TIMESTAMP | Timestamp when the signer was created on the Farcaster protocol |
fid | BIGINT | Farcaster user ID that the signer belongs to |
signer | VARBINARY | Public key of the authorized signer |
name | VARCHAR | Human-readable name assigned to the signer by the application |
app_fid | BIGINT | Farcaster user ID of the application that created the signer |