public.oauth_clients

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
clientSecret	varchar(255)		true
clientSecretExpiresAt	bigint		true
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
grantTypes	json		false
id	varchar		false	public.oauth_access_tokens public.oauth_authorization_codes public.oauth_refresh_tokens public.oauth_user_consents
isFirstParty	boolean	false	false
name	varchar(255)		false
redirectUris	json		false
tokenEndpointAuthMethod	varchar(255)	'none'::character varying	false			Possible values: none, client_secret_basic or client_secret_post
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
PK_c4759172d3431bae6f04e678e0d	PRIMARY KEY	PRIMARY KEY (id)
oauth_clients_createdAt_not_null	n	NOT NULL "createdAt"
oauth_clients_grantTypes_not_null	n	NOT NULL "grantTypes"
oauth_clients_id_not_null	n	NOT NULL id
oauth_clients_isFirstParty_not_null	n	NOT NULL "isFirstParty"
oauth_clients_name_not_null	n	NOT NULL name
oauth_clients_redirectUris_not_null	n	NOT NULL "redirectUris"
oauth_clients_tokenEndpointAuthMethod_not_null	n	NOT NULL "tokenEndpointAuthMethod"
oauth_clients_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
PK_c4759172d3431bae6f04e678e0d	CREATE UNIQUE INDEX "PK_c4759172d3431bae6f04e678e0d" ON public.oauth_clients USING btree (id)

Relations

erDiagram

"public.oauth_access_tokens" }o--|| "public.oauth_clients" : "FOREIGN KEY (#quot;clientId#quot;) REFERENCES oauth_clients(id) ON DELETE CASCADE"
"public.oauth_authorization_codes" }o--|| "public.oauth_clients" : "FOREIGN KEY (#quot;clientId#quot;) REFERENCES oauth_clients(id) ON DELETE CASCADE"
"public.oauth_refresh_tokens" }o--|| "public.oauth_clients" : "FOREIGN KEY (#quot;clientId#quot;) REFERENCES oauth_clients(id) ON DELETE CASCADE"
"public.oauth_user_consents" }o--|| "public.oauth_clients" : "FOREIGN KEY (#quot;clientId#quot;) REFERENCES oauth_clients(id) ON DELETE CASCADE"

"public.oauth_clients" {
  varchar_255_ clientSecret
  bigint clientSecretExpiresAt
  timestamp_3__with_time_zone createdAt
  json grantTypes
  varchar id
  boolean isFirstParty
  varchar_255_ name
  json redirectUris
  varchar_255_ tokenEndpointAuthMethod
  timestamp_3__with_time_zone updatedAt
}
"public.oauth_access_tokens" {
  varchar clientId FK
  varchar token
  uuid userId FK
}
"public.oauth_authorization_codes" {
  varchar clientId FK
  varchar_255_ code
  varchar codeChallenge
  varchar_255_ codeChallengeMethod
  timestamp_3__with_time_zone createdAt
  bigint expiresAt
  varchar redirectUri
  varchar resource
  json scope
  varchar state
  timestamp_3__with_time_zone updatedAt
  boolean used
  uuid userId FK
}
"public.oauth_refresh_tokens" {
  varchar clientId FK
  timestamp_3__with_time_zone createdAt
  bigint expiresAt
  varchar resource
  json scope
  varchar_255_ token
  timestamp_3__with_time_zone updatedAt
  uuid userId FK
}
"public.oauth_user_consents" {
  varchar clientId FK
  bigint grantedAt
  integer id
  json scope
  uuid userId FK
}

---

Generated by tbls