Create
Query
database.sqlite
—
workflow_entity
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 workflow_entity
id
Primary key.
varchar(36) NOT NULL
name
varchar(128) NOT NULL
active
boolean NOT NULL
nodes
TEXT
connections
TEXT
settings
TEXT
staticData
TEXT
pinData
TEXT
versionId
varchar(36) NOT NULL
triggerCount
INTEGER (default 0)
meta
TEXT
parentFolderId
varchar(36)
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'))
isArchived
boolean NOT NULL (default FALSE)
versionCounter
INTEGER NOT NULL (default 1)
description
TEXT
Insert
Cancel