oauth_signing_keys


Description

{“what”:“Signing key records for OAuth2 token issuance; each row is a key pair with lifecycle timestamps.”,“why”:“Without it, there is no record of which key signed a token, so verification and rotation become impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.449685566+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
kid text 2147483647 null

{“what”:“Key identifier, a short string used in JWT header ‘kid’ to select the signing key.”,“why”:“Without it, clients cannot indicate which key signed a token, breaking verification during rotation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.462754343+00:00”}

public_jwk jsonb 2147483647 null

{“what”:“Public key in JSON Web Key format, used to verify token signatures.”,“why”:“Without it, verifiers cannot check token signatures, so tokens become untrusted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.476923968+00:00”}

private_key_path text 2147483647 null

{“what”:“Filesystem path to the private key used for signing tokens.”,“why”:“Without it, the signing service cannot produce signatures, so token issuance fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.492207365+00:00”}

alg text 2147483647 'RS256'::text

{“what”:“JWT signing algorithm, e.g., RS256; default is RS256.”,“why”:“Without it, the algorithm for signing/verifying is ambiguous, causing interoperability issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.514534086+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the key was created and made available for signing.”,“why”:“Without it, key rotation history is lost, making it unclear which key was active at a given time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.547436045+00:00”}

retired_at timestamptz 35,6 √ null

{“what”:“Timestamp when the key was retired; null means still active.”,“why”:“Without it, retired keys remain usable, risking acceptance of old tokens after rotation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:40.568550003+00:00”}

Indexes

Constraint Name Type Sort Column(s)
oauth_signing_keys_pkey Primary key Asc kid

Relationships