Create
Query
database.sqlite
—
user
annotation_tag_entity
auth_identity
auth_provider_sync_history
chat_hub_agents
chat_hub_messages
chat_hub_sessions
credentials_entity
data_table
data_table_column
event_destinations
execution_annotation_tags
execution_annotations
execution_data
execution_entity
execution_metadata
folder
folder_tag
insights_by_period
insights_metadata
insights_raw
installed_nodes
installed_packages
invalid_auth_token
migrations
oauth_access_tokens
oauth_authorization_codes
oauth_clients
oauth_refresh_tokens
oauth_user_consents
processed_data
project
project_relation
role
role_scope
scope
settings
shared_credentials
shared_workflow
sqlite_sequence
tag_entity
test_case_execution
test_run
user
user_api_keys
variables
webhook_entity
workflow_dependency
workflow_entity
workflow_history
workflow_statistics
workflows_tags
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into user
id
Primary key.
varchar
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')
Insert
Cancel