n8n/docs/generated/sqlite-schema/user_api_keys.md

user_api_keys

Description

Table Definition

CREATE TABLE "user_api_keys" ("id" varchar(36) PRIMARY KEY NOT NULL, "userId" varchar NOT NULL, "label" varchar(100) NOT NULL, "apiKey" varchar NOT NULL, "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "scopes" text, "audience" varchar NOT NULL DEFAULT ('public-api'), "lastUsedAt" datetime(3), CONSTRAINT "UQ_1ef35bac35d20bdae979d917a36" UNIQUE ("apiKey"), CONSTRAINT "UQ_63d7bbae72c767cf162d459fccd" UNIQUE ("userId", "label"), CONSTRAINT "FK_e131705cbbc8fb589889b02d457" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(36)		false
userId	varchar		false		user
label	varchar(100)		false
apiKey	varchar		false
createdAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
scopes	TEXT		true
audience	varchar	'public-api'	false
lastUsedAt	datetime(3)		true

Constraints

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_user_api_keys_3	UNIQUE	UNIQUE (userId, label)
sqlite_autoindex_user_api_keys_2	UNIQUE	UNIQUE (apiKey)
sqlite_autoindex_user_api_keys_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
sqlite_autoindex_user_api_keys_3	UNIQUE (userId, label)
sqlite_autoindex_user_api_keys_2	UNIQUE (apiKey)
sqlite_autoindex_user_api_keys_1	PRIMARY KEY (id)

Relations

erDiagram

"user_api_keys" }o--|| "user" : "FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"user_api_keys" {
  varchar_36_ id PK
  varchar userId FK
  varchar_100_ label
  varchar apiKey
  datetime_3_ createdAt
  datetime_3_ updatedAt
  TEXT scopes
  varchar audience
  datetime_3_ lastUsedAt
}
"user" {
  varchar id PK
  varchar_255_ email
  varchar_32_ firstName
  varchar_32_ lastName
  varchar password
  TEXT personalizationAnswers
  datetime_3_ createdAt
  datetime_3_ updatedAt
  TEXT settings
  boolean disabled
  boolean mfaEnabled
  TEXT mfaSecret
  TEXT mfaRecoveryCodes
  date lastActiveAt
  varchar_128_ roleSlug FK
}

---

Generated by tbls