oauth_clients


Description

{“what”:“Registered OAuth client applications and their configuration.”,“why”:“Without it, the authorization server cannot validate client requests or issue tokens.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.360452296+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
client_id text 2147483647 null
oauth_authorization_codes.client_id oauth_authorization_codes_client_id_fkey R
oauth_refresh_tokens.client_id oauth_refresh_tokens_client_id_fkey R

{“what”:“Unique client identifier string, e.g., UUID or generated value.”,“why”:“Without it, clients cannot be referenced in authorization requests or token issuance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.515606925+00:00”}

client_secret_hash text 2147483647 √ null

{“what”:“Hashed client secret for confidential clients; null for public clients.”,“why”:“Without it, confidential clients cannot prove their identity during token requests.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.556978796+00:00”}

client_name text 2147483647 null

{“what”:“Human-readable client name shown on consent screens.”,“why”:“Without it, users cannot identify which application requests access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.602960955+00:00”}

redirect_uris _text 2147483647 null

{“what”:“Allowed redirect URIs for authorization code flow.”,“why”:“Without it, authorization responses cannot be safely sent to the client.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.719222839+00:00”}

post_logout_redirect_uris _text 2147483647 '{}'::text[]

{“what”:“Allowed post-logout redirect URIs for end-session flow.”,“why”:“Without it, logout redirects would be unrestricted or impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.782676171+00:00”}

allowed_scopes _text 2147483647 '{openid}'::text[]

{“what”:“Scopes the client is permitted to request, e.g., openid, profile.”,“why”:“Without it, clients could request any scope, risking over-privileged tokens.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.795760868+00:00”}

grant_types _text 2147483647 '{authorization_code}'::text[]

{“what”:“OAuth grant types the client may use, e.g., authorization_code, refresh_token.”,“why”:“Without it, clients could use unintended flows, weakening security.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.896463088+00:00”}

is_first_party bool 1 false

{“what”:“True if client is owned by the same organization.”,“why”:“Without it, first-party clients cannot be given elevated trust or different UX.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:53.908895678+00:00”}

is_public bool 1 false

{“what”:“True if client cannot keep a secret, e.g., SPA or mobile app.”,“why”:“Without it, token endpoint cannot enforce appropriate client authentication.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:54.717569382+00:00”}

include_role_claim bool 1 false

{“what”:“True if ID token should include user’s role claim.”,“why”:“Without it, role information may be missing from tokens for this client.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:54.798438218+00:00”}

disabled bool 1 false

{“what”:“True if client is deactivated and cannot authenticate.”,“why”:“Without it, compromised or deprecated clients cannot be revoked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:54.864494227+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when client record was created, in UTC.”,“why”:“Without it, audit and lifecycle decisions lose temporal context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:59:54.893420106+00:00”}

Indexes

Constraint Name Type Sort Column(s)
oauth_clients_pkey Primary key Asc client_id

Relationships