public.oauth_refresh_tokens
Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| clientId |
varchar |
|
false |
|
public.oauth_clients |
|
| createdAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| expiresAt |
bigint |
|
false |
|
|
Unix timestamp in milliseconds |
| resource |
varchar |
|
false |
|
|
RFC 8707 resource indicator the grant was approved for (e.g. https://n8n.example.com/mcp-server/http); the audience of every access token minted from this refresh token. |
| scope |
json |
'["tool:listWorkflows","tool:getWorkflowDetails"]'::json |
false |
|
|
OAuth scopes granted for this refresh token |
| token |
varchar(255) |
|
false |
|
|
|
| updatedAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| userId |
uuid |
|
false |
|
public.user |
|
Constraints
| Name |
Type |
Definition |
| FK_a699f3ed9fd0c1b19bc2608ac53 |
FOREIGN KEY |
FOREIGN KEY ("userId") REFERENCES "user"(id) ON DELETE CASCADE |
| FK_b388696ce4d8be7ffbe8d3e4b69 |
FOREIGN KEY |
FOREIGN KEY ("clientId") REFERENCES oauth_clients(id) ON DELETE CASCADE |
| PK_74abaed0b30711b6532598b0392 |
PRIMARY KEY |
PRIMARY KEY (token) |
| oauth_refresh_tokens_clientId_not_null |
n |
NOT NULL "clientId" |
| oauth_refresh_tokens_createdAt_not_null |
n |
NOT NULL "createdAt" |
| oauth_refresh_tokens_expiresAt_not_null |
n |
NOT NULL "expiresAt" |
| oauth_refresh_tokens_resource_not_null |
n |
NOT NULL resource |
| oauth_refresh_tokens_scope_not_null |
n |
NOT NULL scope |
| oauth_refresh_tokens_token_not_null |
n |
NOT NULL token |
| oauth_refresh_tokens_updatedAt_not_null |
n |
NOT NULL "updatedAt" |
| oauth_refresh_tokens_userId_not_null |
n |
NOT NULL "userId" |
Indexes
| Name |
Definition |
| PK_74abaed0b30711b6532598b0392 |
CREATE UNIQUE INDEX "PK_74abaed0b30711b6532598b0392" ON public.oauth_refresh_tokens USING btree (token) |
Relations
erDiagram
"public.oauth_refresh_tokens" }o--|| "public.oauth_clients" : "FOREIGN KEY (#quot;clientId#quot;) REFERENCES oauth_clients(id) ON DELETE CASCADE"
"public.oauth_refresh_tokens" }o--|| "public.user" : "FOREIGN KEY (#quot;userId#quot;) REFERENCES #quot;user#quot;(id) ON DELETE CASCADE"
"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_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.user" {
timestamp_3__with_time_zone createdAt
boolean disabled
varchar_255_ email
varchar_32_ firstName
uuid id
date lastActiveAt
varchar_32_ lastName
boolean mfaEnabled
text mfaRecoveryCodes
text mfaSecret
varchar_255_ password
json personalizationAnswers
varchar_128_ roleSlug FK
json settings
timestamp_3__with_time_zone updatedAt
}
Generated by tbls