User · SQLite Schema · n8n-io/n8n · Skills Docs

User · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "user" ("id" varchar PRIMARY KEY, "email" varchar(255), "firstName" varchar(32), "lastName" varchar(32), "password" varchar, "personalizationAnswers" text, "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')), "settings" text, "disabled" boolean NOT NULL DEFAULT (FALSE), "mfaEnabled" boolean NOT NULL DEFAULT (FALSE), "mfaSecret" text, "mfaRecoveryCodes" text, "lastActiveAt" date, "roleSlug" varchar(128) NOT NULL DEFAULT ('global:member'), "kind" VARCHAR(16) NOT NULL DEFAULT 'person', CONSTRAINT "UQ_e12875dfb3b1d92d7d7c5377e22" UNIQUE ("email"), CONSTRAINT "FK_eaea92ee7bfb9c1b6cd01505d56" FOREIGN KEY ("roleSlug") REFERENCES "role" ("slug"))

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
disabled	boolean	FALSE	false
email	varchar(255)		true
firstName	varchar(32)		true
id	varchar		true	activity_event agent_eval_dataset agent_eval_rating agent_eval_run agent_execution_threads agent_history agent_publish_history ai_preference auth_identity chat_hub_agents chat_hub_sessions chat_hub_tools dynamic_credential_user_entry evaluation_collection idempotency_key instance_ai_mcp_registry_connections instance_ai_pending_confirmations instance_ai_thread_grants instance_ai_thread_tabs migration_workflow_owner oauth_access_tokens oauth_authorization_codes oauth_refresh_tokens oauth_user_consents project project_relation promotion_review promotion_run self_healing_configuration self_healing_configuration_reviewer self_healing_investigation self_healing_result service_account_details skill skill_source skill_version trusted_source_identity user_api_keys user_favorites workflow_builder_session workflow_publish_history workflow_review_activity workflow_review_activity_comment workflow_review_request workflow_review_request_authors workflow_review_request_reviewers workflow_suggestion workflow_suggestion_activity
kind	VARCHAR(16)	‘person’	false
lastActiveAt	date		true
lastName	varchar(32)		true
mfaEnabled	boolean	FALSE	false
mfaRecoveryCodes	TEXT		true
mfaSecret	TEXT		true
password	varchar		true
personalizationAnswers	TEXT		true
roleSlug	varchar(128)	‘global:member’	false		role
settings	TEXT		true
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (roleSlug) REFERENCES role (slug) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_user_1	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_user_2	UNIQUE	UNIQUE (email)

erDiagram

"activity_event" }o--o| "user" : "FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_eval_dataset" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_eval_rating" }o--o| "user" : "FOREIGN KEY (ratedById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_eval_run" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_execution_threads" }o--o| "user" : "FOREIGN KEY (ownerId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_history" }o--o| "user" : "FOREIGN KEY (publishedById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_publish_history" }o--o| "user" : "FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"ai_preference" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"ai_preference" }o--o| "user" : "FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"auth_identity" }o--o| "user" : "FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE"
"chat_hub_agents" }o--|| "user" : "FOREIGN KEY (ownerId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"chat_hub_sessions" }o--|| "user" : "FOREIGN KEY (ownerId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"chat_hub_tools" }o--|| "user" : "FOREIGN KEY (ownerId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"