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

auth_identity

Description

Table Definition

CREATE TABLE "auth_identity" (
				"userId" VARCHAR(36) REFERENCES "user" (id),
				"providerId" VARCHAR(64) NOT NULL,
				"providerType" VARCHAR(32) NOT NULL,
				"createdAt" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
				"updatedAt" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
				PRIMARY KEY("providerId", "providerType")
			)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
userId	VARCHAR(36)		true		user
providerId	VARCHAR(64)		false
providerType	VARCHAR(32)		false
createdAt	timestamp	CURRENT_TIMESTAMP	false
updatedAt	timestamp	CURRENT_TIMESTAMP	false

Constraints

Name	Type	Definition
providerId	PRIMARY KEY	PRIMARY KEY (providerId)
providerType	PRIMARY KEY	PRIMARY KEY (providerType)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
sqlite_autoindex_auth_identity_1	PRIMARY KEY	PRIMARY KEY (providerId, providerType)

Indexes

Name	Definition
sqlite_autoindex_auth_identity_1	PRIMARY KEY (providerId, providerType)

Relations

erDiagram

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

"auth_identity" {
  VARCHAR_36_ userId FK
  VARCHAR_64_ providerId PK
  VARCHAR_32_ providerType PK
  timestamp createdAt
  timestamp updatedAt
}
"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