Built-in tables for applications and major plugins

Introduction

This list explains common handling for built-in tables of applications and major plugins in Migration Manager, version control, and backup/restore. In most cases, users do not need to adjust tables one by one. Use the default strategy.

These mechanisms focus on different concerns:

Migration Manager: publishes across environments. Common strategies include overwrite, schema-only, and skip.
Version control: saves and restores key checkpoints during application building.
Backup/restore: backs up and restores the application runtime state.

The “Data type” column comes from built-in classification. System base data participates in version control; business runtime data does not; runtime temporary data is not backed up.

Built-in table reference

Database

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`migrations`	Executed ORM/SQL migration versions	System base data	Schema-only	Included	Backed up

Server

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`applicationPlugins`	Plugin list and versions loaded by the application	System base data	Overwrite	Included	Backed up
`applicationVersion`	Application and core version used for upgrade and compatibility checks	System base data	Schema-only	Included	Backed up

System settings

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`systemSettings`	Installation-level system parameters and feature switches	System base data	Overwrite	Included	Backed up

Client

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`desktopRoutes`	Desktop menu and route structure	System base data	Overwrite	Included	Backed up

Multi-space

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`spaces`	Top-level containers for space or workspace isolation	Business runtime data	Schema-only	Not included	Backed up
`spacesUsers`	Membership between users and spaces	Business runtime data	Schema-only	Not included	Backed up

App monitoring

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`apps`	Application entries managed by the app monitoring plugin	Business runtime data	Schema-only	Not included	Backed up

Main data source

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`collectionCategories`	UI grouping for business collections	System base data	Overwrite	Included	Backed up
`collections`	Business collection fields, indexes, and metadata	System base data	Overwrite	Included	Backed up
`fields`	Field types and constraints under collections	System base data	Overwrite	Included	Backed up

Data source manager

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`dataSources`	Main or external database connection configuration	System base data	Overwrite	Included	Backed up
`dataSourcesCollections`	Mapping for synced tables or collections from external sources	System base data	Overwrite	Included	Backed up
`dataSourcesFields`	Mapping between external fields and NocoBase fields	System base data	Overwrite	Included	Backed up
`dataSourcesRoles`	Access roles at data-source level	System base data	Overwrite	Included	Backed up
`dataSourcesRolesResources`	Collections and operations accessible by roles	System base data	Overwrite	Included	Backed up
`dataSourcesRolesResourcesActions`	Allowed actions such as create, read, update, and delete	System base data	Overwrite	Included	Backed up
`dataSourcesRolesResourcesScopes`	Row-level or filter-scope restrictions	System base data	Overwrite	Included	Backed up

External database connections

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`databaseServers`	Registered database instances available for connection	System base data	Overwrite	Included	Backed up

Visual data modeling

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`graphPositions`	Node positions in graph or flow editors	System base data	Overwrite	Included	Backed up

China region field

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`chinaRegions`	Province, city, and district geographic dictionary	Business runtime data	Schema-only	Not included	Backed up

Auto-number field

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`sequences`	Sequence table for auto-generated business numbers	System base data	Overwrite	Included	Backed up

UI Schema

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`uiButtonSchemasRoles`	Relationship between button permissions and roles	System base data	Overwrite	Included	Backed up
`uiSchemaServerHooks`	Server-side hook extension points for UI configuration	System base data	Overwrite	Included	Backed up
`uiSchemaTemplates`	Reusable form and detail layout fragments	System base data	Overwrite	Included	Backed up
`uiSchemaTreePath`	Materialized paths for component-tree hierarchy	System base data	Overwrite	Included	Backed up
`uiSchemas`	JSON layout definitions for pages and blocks	System base data	Overwrite	Included	Backed up

UI templates

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`flowModelTemplateUsages`	Entities instantiated from a flow template	System base data	Overwrite	Included	Backed up
`flowModelTemplates`	Reusable flow-structure templates	System base data	Overwrite	Included	Backed up

Flow engine

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`flowModelTreePath`	Materialized paths for flow-model tree structures	System base data	Overwrite	Included	Backed up
`flowModels`	Model definitions for the modern flow engine	System base data	Overwrite	Included	Backed up
`flowSql`	SQL snippets or scripts registered in flows	System base data	Overwrite	Included	Backed up

Block templates

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`blockTemplateLinks`	Relationships between pages and block templates	System base data	Overwrite	Included	Backed up
`blockTemplates`	Reusable UI block definitions	System base data	Overwrite	Included	Backed up

iframe block

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`iframeHtml`	HTML configuration required by embedded iframes	System base data	Overwrite	Included	Backed up

Mobile

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`mobileRoutes`	Mobile app menus and routes	System base data	Overwrite	Included	Backed up

Theme editor

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`themeConfig`	Light/dark themes and brand colors	System base data	Overwrite	Included	Backed up

Map block

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`mapConfiguration`	Map widget center, zoom, and base-map configuration	System base data	Overwrite	Included	Backed up

Public forms

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`publicForms`	External forms and submission-entry configuration	System base data	Overwrite	Included	Backed up

Template printing

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`printingTemplates`	Print layouts for list or detail views	System base data	Overwrite	Included	Backed up

ACL

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`roles`	Role definitions for permission sets	System base data	Overwrite	Included	Backed up
`rolesResources`	Resources granted to roles	System base data	Overwrite	Included	Backed up
`rolesResourcesActions`	Actions allowed on resources, such as view and update	System base data	Overwrite	Included	Backed up
`rolesResourcesScopes`	Data filter scopes visible to roles	System base data	Overwrite	Included	Backed up
`rolesUsers`	Many-to-many relationship between users and roles	Business runtime data	Schema-only	Not included	Backed up

Authentication

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`authenticators`	Password and third-party login method configuration	System base data	Overwrite	Included	Backed up
`tokenControlConfig`	Session duration and refresh strategy	System base data	Overwrite	Included	Backed up
`issuedTokens`	Issued login or API access tokens	Business runtime data	Schema-only	Not included	Backed up
`tokenBlacklist`	Tokens that have been logged out or forcibly invalidated	Business runtime data	Schema-only	Not included	Backed up
`usersAuthenticators`	Bindings between users and authentication methods	Business runtime data	Schema-only	Not included	Backed up

Two-factor authentication

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`twoFactorAuthSettings`	2FA methods and user-level switches	System base data	Overwrite	Included	Backed up

API keys

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`apiKeys`	Open API keys and permission scopes	Business runtime data	Schema-only	Not included	Backed up

Password policy

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`passwordPolicy`	Password complexity and expiration policies	System base data	Overwrite	Included	Backed up
`lockedUsers`	Accounts temporarily locked by policy	Business runtime data	Schema-only	Not included	Backed up
`userPasswordHistory`	Recent password hashes used to prevent reuse	Business runtime data	Schema-only	Not included	Backed up

IP restriction

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`ipRestrictionConfig`	IP allowlist or blocklist rules	System base data	Overwrite	Included	Backed up

Users

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`users`	Login accounts, profiles, and basic status	Business runtime data	Schema-only	Not included	Backed up

Departments

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`departments`	Department tree in the organization structure	Business runtime data	Overwrite	Not included	Backed up
`departmentsRoles`	Bindings between departments and default roles	Business runtime data	Overwrite	Not included	Backed up
`departmentsUsers`	Relationships between users and departments	Business runtime data	Schema-only	Not included	Backed up

User data sync

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`userDataSyncSources`	External identity source or account-system connection configuration	System base data	Overwrite	Included	Backed up
`userDataSyncRecords`	Execution records for synchronization jobs	Business runtime data	Schema-only	Not included	Backed up
`userDataSyncRecordsResources`	Tables or resources involved in synchronization jobs	Business runtime data	Schema-only	Not included	Backed up
`userDataSyncTasks`	Synchronization task records	Business runtime data	Schema-only	Not included	Backed up

Workflow

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`flow_nodes`	Workflow nodes	System base data	Overwrite	Included	Backed up
`workflows`	Automation flow charts, triggers, and node configuration	System base data	Overwrite	Included	Backed up
`jobs`	Execution result of each node in a workflow run	Business runtime data	Schema-only	Not included	Backed up
`executions`	Status, inputs, outputs, and log indexes for workflow runs	Business runtime data	Schema-only	Not included	Backed up
`userWorkflowTasks`	Task-count statistics for users	Business runtime data	Schema-only	Not included	Backed up
`workflowCategories`	Workflow grouping in the UI	Business runtime data	Overwrite	Not included	Backed up
`workflowCategoryRelations`	Many-to-many relationship between workflows and categories	Business runtime data	Overwrite	Not included	Backed up
`workflowStats`	Aggregated metrics such as run count and success rate	Business runtime data	Schema-only	Not included	Backed up
`workflowTasks`	Task execution records for automation nodes	Business runtime data	Schema-only	Not included	Backed up
`workflowVersionStats`	Execution and performance statistics by workflow version	Business runtime data	Schema-only	Not included	Backed up

Workflow approval

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`approvalAudienceUsers`	Relationship between approval audiences and users	Business runtime data	Schema-only	Not included	Backed up
`approvalAudiences`	Approval notification or participation scope grouped by role or user	Business runtime data	Schema-only	Not included	Backed up
`approvalExecutions`	Runtime status and current node of an approval flow	Business runtime data	Schema-only	Not included	Backed up
`approvalMsgTpls`	Message templates for approval notices and tasks	Business runtime data	Overwrite	Not included	Backed up
`approvalRecords`	Approval tasks and processing results from a personal view	Business runtime data	Schema-only	Not included	Backed up
`approvals`	Approval-flow templates and step configuration	Business runtime data	Schema-only	Not included	Backed up

Workflow manual node

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`workflowManualTasks`	Manual-node tasks that require human handling	Business runtime data	Schema-only	Not included	Backed up

Workflow CC

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`workflowCcTasks`	Read-only copied workflow tasks	Business runtime data	Schema-only	Not included	Backed up

Notification manager

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`notificationChannels`	Delivery channel configuration such as in-app messages and email	System base data	Overwrite	Included	Backed up
`notificationSendLogs`	Delivery status and failure reason for notifications	Business runtime data	Schema-only	Not included	Backed up

In-app messages

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`notificationInAppMessages`	In-app messages received by users	Business runtime data	Schema-only	Not included	Backed up

Verification

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`verifiers`	Configuration for who can initiate or complete verification	System base data	Overwrite	Included	Backed up
`otpRecords`	SMS or email OTP issue and verification records	Business runtime data	Schema-only	Not included	Backed up
`usersVerifiers`	Bindings between users and verification channels or entities	Business runtime data	Schema-only	Not included	Backed up

Mail manager

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`mailGeneralSettings`	Global mail behavior and default values	System base data	Overwrite	Included	Backed up
`mailSettings`	Mail plugin switches and parameters	System base data	Overwrite	Included	Backed up
`mailAccounts`	Sending mailbox accounts and SMTP configuration	Business runtime data	Overwrite	Not included	Backed up
`mailMassMessages`	Mass-mail tasks and recipient batches	Business runtime data	Schema-only	Not included	Backed up
`mailMessageLabels`	Mail category label definitions	Business runtime data	Schema-only	Not included	Backed up
`mailMessageNotes`	Internal notes for individual emails	Business runtime data	Schema-only	Not included	Backed up
`mailMessages`	Indexes for synced or sent email content	Business runtime data	Schema-only	Not included	Backed up
`mailTemplates`	HTML/text templates for notification emails	Business runtime data	Schema-only	Not included	Backed up
`mailmessagelabelsMailmessages`	Join table between emails and many-to-many labels	Business runtime data	Schema-only	Not included	Backed up
`mailmessagelabelsMailmessagesRel`	Auxiliary fields or extension table for mail-label relationships	Business runtime data	Schema-only	Not included	Backed up

AI

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`aiEmployees`	AI employee profiles: nickname, skills, models, knowledge bases, and related configuration	System base data	Overwrite	Included	Backed up
`aiSettings`	AI basic settings	System base data	Overwrite	Included	Backed up
`rolesAiEmployees`	Relationship between AI employees and roles	System base data	Overwrite	Included	Backed up
`llmServices`	LLM providers and model endpoint configuration	System base data	Overwrite	Included	Backed up
`aiContextDatasources`	Business collections, fields, and filters queryable by AI employees	Business runtime data	Schema-only	Not included	Backed up
`aiConversations`	Conversation context for sessions, topics, and message threads	Business runtime data	Schema-only	Not included	Backed up
`aiFiles`	Uploaded files and storage references generated by the AI plugin	Business runtime data	Schema-only	Not included	Backed up
`aiMessages`	User and assistant messages in conversations	Business runtime data	Schema-only	Not included	Backed up
`aiToolMessages`	Requests and responses for function or tool calls	Business runtime data	Schema-only	Not included	Backed up
`usersAiEmployees`	Relationship between user custom prompts and AI employees	Business runtime data	Schema-only	Not included	Backed up
`lcCheckpointBlobs`	Binary blocks for LLM conversation checkpoints	Runtime temporary data	Schema-only	Not included	Not backed up
`lcCheckpointWrites`	Incremental checkpoint write records	Runtime temporary data	Schema-only	Not included	Not backed up
`lcCheckpoints`	LangGraph checkpoint metadata for recoverable conversations	Runtime temporary data	Schema-only	Not included	Not backed up

AI knowledge base

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`aiKnowledgeBaseDocs`	Document chunks and index metadata stored in knowledge bases	Business runtime data	Schema-only	Not included	Backed up
`aiKnowledgeBase`	Knowledge-base type, external ID, and base information	Business runtime data	Schema-only	Not included	Backed up
`aiVectorDatabases`	Vector database service and connection configuration	Business runtime data	Schema-only	Not included	Backed up
`aiVectorStoreConfig`	Relationship between vector database connections and embedding models	Business runtime data	Schema-only	Not included	Backed up

Environment variables

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`environmentVariables`	Deployment-related key-value entries, such as secret placeholder names	System base data	Schema-only	Included	Backed up

Migration manager

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`migrationRules`	Rules and scope configuration in the migration manager	System base data	Schema-only	Included	Backed up

Backup manager

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`backupSettings`	Automatic backup and retention policy	Business runtime data	Overwrite	Not included	Backed up

Audit logs

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`auditTrails`	Trace of who operated on which resources and when	Business runtime data	Schema-only	Not included	Backed up

Async tasks

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`asyncTasks`	Queue, status, and result of long-running tasks	Business runtime data	Schema-only	Not included	Backed up

Record history

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`recordHistoryCollections`	Collections with field history enabled	System base data	Overwrite	Included	Backed up
`recordHistoryFields`	Fields that need history records	System base data	Overwrite	Included	Backed up
`recordHistoryTemplate`	Display template for history records	System base data	Overwrite	Included	Backed up
`recordFieldHistories`	Historical values and timeline for field changes	Business runtime data	Schema-only	Not included	Backed up
`recordFieldSnapshots`	Snapshot proof of field values at a point in time	Business runtime data	Schema-only	Not included	Backed up
`recordHistories`	Versioned change records for entire records	Business runtime data	Schema-only	Not included	Backed up

File manager

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`storages`	Local, S3, OSS, and other storage bucket configuration	System base data	Overwrite	Included	Backed up
`attachments`	File attachment metadata associated with business records	Business runtime data	Schema-only	Not included	Backed up

Localization

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`localizationTexts`	Keys and default text awaiting translation	System base data	Overwrite	Included	Backed up
`localizationTranslations`	Actual translated content for each language	System base data	Overwrite	Included	Backed up

Localization tester

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`localeTester`	Entries used for localization debugging or testing	Business runtime data	Schema-only	Not included	Backed up

Custom request

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`customRequests`	Custom HTTP request actions with URL and method configuration	System base data	Overwrite	Included	Backed up
`customRequestsRoles`	Roles allowed to call custom requests	System base data	Overwrite	Included	Backed up

Custom variables

Table	Description	Data type	Default migration strategy	Version control	Backup/restore
`customVariables`	Variable definitions and default values available to flows or globally	System base data	Overwrite	Included	Backed up

User-defined tables

User-defined tables are treated as business data by default. In most cases, migrate only the table structure and choose schema-only.

If a user-defined table stores business configuration, categories, templates, rules, or other metadata, and those records should be synchronized from development to staging or production with the release, choose overwrite based on the business scenario.

If a user-defined table stores runtime data such as customers, orders, tickets, approval records, messages, or logs, avoid overwriting production records.

#Built-in tables for applications and major plugins

#Introduction

#Built-in table reference

#Database

#Server

#System settings

#Client

#Multi-space

#App monitoring

#Main data source

#Data source manager

#External database connections

#Visual data modeling

#China region field

#Auto-number field

#UI Schema

#UI templates

#Flow engine

#Block templates

#iframe block

#Mobile

#Theme editor

#Map block

#Public forms

#Template printing

#ACL

#Authentication

#Two-factor authentication

#API keys

#Password policy

#IP restriction

#Users

#Departments

#User data sync

#Workflow

#Workflow approval

#Workflow manual node

#Workflow CC

#Notification manager

#In-app messages

#Verification

#Mail manager

#AI

#AI knowledge base

#Environment variables

#Migration manager

#Backup manager

#Audit logs

#Async tasks

#Record history

#File manager

#Localization

#Localization tester

#Custom request

#Custom variables

#User-defined tables