Tabel bawaan aplikasi dan plugin utama

Pendahuluan

Daftar ini menjelaskan perlakuan umum untuk tabel bawaan aplikasi dan plugin utama dalam migrasi, kontrol versi, dan backup/restore. Pada umumnya pengguna tidak perlu menyesuaikan tabel satu per satu. Gunakan strategi default.

Mekanisme ini memiliki fokus berbeda:

  • Migration Manager: mempublikasikan antar-environment. Strategi umum meliputi overwrite, schema-only, dan skip.
  • Kontrol versi: menyimpan dan memulihkan titik penting saat membangun aplikasi.
  • Backup/restore: mencadangkan dan memulihkan status runtime aplikasi.

Kolom “Tipe data” berasal dari klasifikasi bawaan. Data dasar sistem ikut kontrol versi; data runtime bisnis tidak; data sementara runtime tidak dibackup.

Referensi tabel bawaan

Database

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
migrationsExecuted ORM/SQL migration versionsData dasar sistemSchema-onlyIkutDibackup

Server

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
applicationPluginsPlugin list and versions loaded by the applicationData dasar sistemOverwriteIkutDibackup
applicationVersionApplication and core version used for upgrade and compatibility checksData dasar sistemSchema-onlyIkutDibackup

System settings

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
systemSettingsInstallation-level system parameters and feature switchesData dasar sistemOverwriteIkutDibackup

Client

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
desktopRoutesDesktop menu and route structureData dasar sistemOverwriteIkutDibackup

Multi-space

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
spacesTop-level containers for space or workspace isolationData runtime bisnisSchema-onlyTidak ikutDibackup
spacesUsersMembership between users and spacesData runtime bisnisSchema-onlyTidak ikutDibackup

App monitoring

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
appsApplication entries managed by the app monitoring pluginData runtime bisnisSchema-onlyTidak ikutDibackup

Main data source

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
collectionCategoriesUI grouping for business collectionsData dasar sistemOverwriteIkutDibackup
collectionsBusiness collection fields, indexes, and metadataData dasar sistemOverwriteIkutDibackup
fieldsField types and constraints under collectionsData dasar sistemOverwriteIkutDibackup

Data source manager

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
dataSourcesMain or external database connection configurationData dasar sistemOverwriteIkutDibackup
dataSourcesCollectionsMapping for synced tables or collections from external sourcesData dasar sistemOverwriteIkutDibackup
dataSourcesFieldsMapping between external fields and NocoBase fieldsData dasar sistemOverwriteIkutDibackup
dataSourcesRolesAccess roles at data-source levelData dasar sistemOverwriteIkutDibackup
dataSourcesRolesResourcesCollections and operations accessible by rolesData dasar sistemOverwriteIkutDibackup
dataSourcesRolesResourcesActionsAllowed actions such as create, read, update, and deleteData dasar sistemOverwriteIkutDibackup
dataSourcesRolesResourcesScopesRow-level or filter-scope restrictionsData dasar sistemOverwriteIkutDibackup

External database connections

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
databaseServersRegistered database instances available for connectionData dasar sistemOverwriteIkutDibackup

Visual data modeling

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
graphPositionsNode positions in graph or flow editorsData dasar sistemOverwriteIkutDibackup

China region field

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
chinaRegionsProvince, city, and district geographic dictionaryData runtime bisnisSchema-onlyTidak ikutDibackup

Auto-number field

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
sequencesSequence table for auto-generated business numbersData dasar sistemOverwriteIkutDibackup

UI Schema

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
uiButtonSchemasRolesRelationship between button permissions and rolesData dasar sistemOverwriteIkutDibackup
uiSchemaServerHooksServer-side hook extension points for UI configurationData dasar sistemOverwriteIkutDibackup
uiSchemaTemplatesReusable form and detail layout fragmentsData dasar sistemOverwriteIkutDibackup
uiSchemaTreePathMaterialized paths for component-tree hierarchyData dasar sistemOverwriteIkutDibackup
uiSchemasJSON layout definitions for pages and blocksData dasar sistemOverwriteIkutDibackup

UI templates

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
flowModelTemplateUsagesEntities instantiated from a flow templateData dasar sistemOverwriteIkutDibackup
flowModelTemplatesReusable flow-structure templatesData dasar sistemOverwriteIkutDibackup

Flow engine

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
flowModelTreePathMaterialized paths for flow-model tree structuresData dasar sistemOverwriteIkutDibackup
flowModelsModel definitions for the modern flow engineData dasar sistemOverwriteIkutDibackup
flowSqlSQL snippets or scripts registered in flowsData dasar sistemOverwriteIkutDibackup

Block templates

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
blockTemplateLinksRelationships between pages and block templatesData dasar sistemOverwriteIkutDibackup
blockTemplatesReusable UI block definitionsData dasar sistemOverwriteIkutDibackup

iframe block

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
iframeHtmlHTML configuration required by embedded iframesData dasar sistemOverwriteIkutDibackup

Mobile

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
mobileRoutesMobile app menus and routesData dasar sistemOverwriteIkutDibackup

Theme editor

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
themeConfigLight/dark themes and brand colorsData dasar sistemOverwriteIkutDibackup

Map block

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
mapConfigurationMap widget center, zoom, and base-map configurationData dasar sistemOverwriteIkutDibackup

Public forms

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
publicFormsExternal forms and submission-entry configurationData dasar sistemOverwriteIkutDibackup

Template printing

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
printingTemplatesPrint layouts for list or detail viewsData dasar sistemOverwriteIkutDibackup

ACL

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
rolesRole definitions for permission setsData dasar sistemOverwriteIkutDibackup
rolesResourcesResources granted to rolesData dasar sistemOverwriteIkutDibackup
rolesResourcesActionsActions allowed on resources, such as view and updateData dasar sistemOverwriteIkutDibackup
rolesResourcesScopesData filter scopes visible to rolesData dasar sistemOverwriteIkutDibackup
rolesUsersMany-to-many relationship between users and rolesData runtime bisnisSchema-onlyTidak ikutDibackup

Authentication

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
authenticatorsPassword and third-party login method configurationData dasar sistemOverwriteIkutDibackup
tokenControlConfigSession duration and refresh strategyData dasar sistemOverwriteIkutDibackup
issuedTokensIssued login or API access tokensData runtime bisnisSchema-onlyTidak ikutDibackup
tokenBlacklistTokens that have been logged out or forcibly invalidatedData runtime bisnisSchema-onlyTidak ikutDibackup
usersAuthenticatorsBindings between users and authentication methodsData runtime bisnisSchema-onlyTidak ikutDibackup

Two-factor authentication

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
twoFactorAuthSettings2FA methods and user-level switchesData dasar sistemOverwriteIkutDibackup

API keys

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
apiKeysOpen API keys and permission scopesData runtime bisnisSchema-onlyTidak ikutDibackup

Password policy

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
passwordPolicyPassword complexity and expiration policiesData dasar sistemOverwriteIkutDibackup
lockedUsersAccounts temporarily locked by policyData runtime bisnisSchema-onlyTidak ikutDibackup
userPasswordHistoryRecent password hashes used to prevent reuseData runtime bisnisSchema-onlyTidak ikutDibackup

IP restriction

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
ipRestrictionConfigIP allowlist or blocklist rulesData dasar sistemOverwriteIkutDibackup

Users

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
usersLogin accounts, profiles, and basic statusData runtime bisnisSchema-onlyTidak ikutDibackup

Departments

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
departmentsDepartment tree in the organization structureData runtime bisnisOverwriteTidak ikutDibackup
departmentsRolesBindings between departments and default rolesData runtime bisnisOverwriteTidak ikutDibackup
departmentsUsersRelationships between users and departmentsData runtime bisnisSchema-onlyTidak ikutDibackup

User data sync

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
userDataSyncSourcesExternal identity source or account-system connection configurationData dasar sistemOverwriteIkutDibackup
userDataSyncRecordsExecution records for synchronization jobsData runtime bisnisSchema-onlyTidak ikutDibackup
userDataSyncRecordsResourcesTables or resources involved in synchronization jobsData runtime bisnisSchema-onlyTidak ikutDibackup
userDataSyncTasksSynchronization task recordsData runtime bisnisSchema-onlyTidak ikutDibackup

Workflow

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
flow_nodesWorkflow nodesData dasar sistemOverwriteIkutDibackup
workflowsAutomation flow charts, triggers, and node configurationData dasar sistemOverwriteIkutDibackup
jobsExecution result of each node in a workflow runData runtime bisnisSchema-onlyTidak ikutDibackup
executionsStatus, inputs, outputs, and log indexes for workflow runsData runtime bisnisSchema-onlyTidak ikutDibackup
userWorkflowTasksTask-count statistics for usersData runtime bisnisSchema-onlyTidak ikutDibackup
workflowCategoriesWorkflow grouping in the UIData runtime bisnisOverwriteTidak ikutDibackup
workflowCategoryRelationsMany-to-many relationship between workflows and categoriesData runtime bisnisOverwriteTidak ikutDibackup
workflowStatsAggregated metrics such as run count and success rateData runtime bisnisSchema-onlyTidak ikutDibackup
workflowTasksTask execution records for automation nodesData runtime bisnisSchema-onlyTidak ikutDibackup
workflowVersionStatsExecution and performance statistics by workflow versionData runtime bisnisSchema-onlyTidak ikutDibackup

Workflow approval

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
approvalAudienceUsersRelationship between approval audiences and usersData runtime bisnisSchema-onlyTidak ikutDibackup
approvalAudiencesApproval notification or participation scope grouped by role or userData runtime bisnisSchema-onlyTidak ikutDibackup
approvalExecutionsRuntime status and current node of an approval flowData runtime bisnisSchema-onlyTidak ikutDibackup
approvalMsgTplsMessage templates for approval notices and tasksData runtime bisnisOverwriteTidak ikutDibackup
approvalRecordsApproval tasks and processing results from a personal viewData runtime bisnisSchema-onlyTidak ikutDibackup
approvalsApproval-flow templates and step configurationData runtime bisnisSchema-onlyTidak ikutDibackup

Workflow manual node

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
workflowManualTasksManual-node tasks that require human handlingData runtime bisnisSchema-onlyTidak ikutDibackup

Workflow CC

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
workflowCcTasksRead-only copied workflow tasksData runtime bisnisSchema-onlyTidak ikutDibackup

Notification manager

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
notificationChannelsDelivery channel configuration such as in-app messages and emailData dasar sistemOverwriteIkutDibackup
notificationSendLogsDelivery status and failure reason for notificationsData runtime bisnisSchema-onlyTidak ikutDibackup

In-app messages

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
notificationInAppMessagesIn-app messages received by usersData runtime bisnisSchema-onlyTidak ikutDibackup

Verification

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
verifiersConfiguration for who can initiate or complete verificationData dasar sistemOverwriteIkutDibackup
otpRecordsSMS or email OTP issue and verification recordsData runtime bisnisSchema-onlyTidak ikutDibackup
usersVerifiersBindings between users and verification channels or entitiesData runtime bisnisSchema-onlyTidak ikutDibackup

Mail manager

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
mailGeneralSettingsGlobal mail behavior and default valuesData dasar sistemOverwriteIkutDibackup
mailSettingsMail plugin switches and parametersData dasar sistemOverwriteIkutDibackup
mailAccountsSending mailbox accounts and SMTP configurationData runtime bisnisOverwriteTidak ikutDibackup
mailMassMessagesMass-mail tasks and recipient batchesData runtime bisnisSchema-onlyTidak ikutDibackup
mailMessageLabelsMail category label definitionsData runtime bisnisSchema-onlyTidak ikutDibackup
mailMessageNotesInternal notes for individual emailsData runtime bisnisSchema-onlyTidak ikutDibackup
mailMessagesIndexes for synced or sent email contentData runtime bisnisSchema-onlyTidak ikutDibackup
mailTemplatesHTML/text templates for notification emailsData runtime bisnisSchema-onlyTidak ikutDibackup
mailmessagelabelsMailmessagesJoin table between emails and many-to-many labelsData runtime bisnisSchema-onlyTidak ikutDibackup
mailmessagelabelsMailmessagesRelAuxiliary fields or extension table for mail-label relationshipsData runtime bisnisSchema-onlyTidak ikutDibackup

AI

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
aiEmployeesAI employee profiles: nickname, skills, models, knowledge bases, and related configurationData dasar sistemOverwriteIkutDibackup
aiSettingsAI basic settingsData dasar sistemOverwriteIkutDibackup
rolesAiEmployeesRelationship between AI employees and rolesData dasar sistemOverwriteIkutDibackup
llmServicesLLM providers and model endpoint configurationData dasar sistemOverwriteIkutDibackup
aiContextDatasourcesBusiness collections, fields, and filters queryable by AI employeesData runtime bisnisSchema-onlyTidak ikutDibackup
aiConversationsConversation context for sessions, topics, and message threadsData runtime bisnisSchema-onlyTidak ikutDibackup
aiFilesUploaded files and storage references generated by the AI pluginData runtime bisnisSchema-onlyTidak ikutDibackup
aiMessagesUser and assistant messages in conversationsData runtime bisnisSchema-onlyTidak ikutDibackup
aiToolMessagesRequests and responses for function or tool callsData runtime bisnisSchema-onlyTidak ikutDibackup
usersAiEmployeesRelationship between user custom prompts and AI employeesData runtime bisnisSchema-onlyTidak ikutDibackup
lcCheckpointBlobsBinary blocks for LLM conversation checkpointsData sementara runtimeSchema-onlyTidak ikutTidak dibackup
lcCheckpointWritesIncremental checkpoint write recordsData sementara runtimeSchema-onlyTidak ikutTidak dibackup
lcCheckpointsLangGraph checkpoint metadata for recoverable conversationsData sementara runtimeSchema-onlyTidak ikutTidak dibackup

AI knowledge base

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
aiKnowledgeBaseDocsDocument chunks and index metadata stored in knowledge basesData runtime bisnisSchema-onlyTidak ikutDibackup
aiKnowledgeBaseKnowledge-base type, external ID, and base informationData runtime bisnisSchema-onlyTidak ikutDibackup
aiVectorDatabasesVector database service and connection configurationData runtime bisnisSchema-onlyTidak ikutDibackup
aiVectorStoreConfigRelationship between vector database connections and embedding modelsData runtime bisnisSchema-onlyTidak ikutDibackup

Environment variables

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
environmentVariablesDeployment-related key-value entries, such as secret placeholder namesData dasar sistemSchema-onlyIkutDibackup

Migration manager

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
migrationRulesRules and scope configuration in the migration managerData dasar sistemSchema-onlyIkutDibackup

Backup manager

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
backupSettingsAutomatic backup and retention policyData runtime bisnisOverwriteTidak ikutDibackup

Audit logs

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
auditTrailsTrace of who operated on which resources and whenData runtime bisnisSchema-onlyTidak ikutDibackup

Async tasks

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
asyncTasksQueue, status, and result of long-running tasksData runtime bisnisSchema-onlyTidak ikutDibackup

Record history

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
recordHistoryCollectionsCollections with field history enabledData dasar sistemOverwriteIkutDibackup
recordHistoryFieldsFields that need history recordsData dasar sistemOverwriteIkutDibackup
recordHistoryTemplateDisplay template for history recordsData dasar sistemOverwriteIkutDibackup
recordFieldHistoriesHistorical values and timeline for field changesData runtime bisnisSchema-onlyTidak ikutDibackup
recordFieldSnapshotsSnapshot proof of field values at a point in timeData runtime bisnisSchema-onlyTidak ikutDibackup
recordHistoriesVersioned change records for entire recordsData runtime bisnisSchema-onlyTidak ikutDibackup

File manager

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
storagesLocal, S3, OSS, and other storage bucket configurationData dasar sistemOverwriteIkutDibackup
attachmentsFile attachment metadata associated with business recordsData runtime bisnisSchema-onlyTidak ikutDibackup

Localization

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
localizationTextsKeys and default text awaiting translationData dasar sistemOverwriteIkutDibackup
localizationTranslationsActual translated content for each languageData dasar sistemOverwriteIkutDibackup

Localization tester

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
localeTesterEntries used for localization debugging or testingData runtime bisnisSchema-onlyTidak ikutDibackup

Custom request

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
customRequestsCustom HTTP request actions with URL and method configurationData dasar sistemOverwriteIkutDibackup
customRequestsRolesRoles allowed to call custom requestsData dasar sistemOverwriteIkutDibackup

Custom variables

TabelDeskripsiTipe dataStrategi migrasi defaultKontrol versiBackup/restore
customVariablesVariable definitions and default values available to flows or globallyData dasar sistemOverwriteIkutDibackup

Tabel buatan pengguna

Tabel buatan pengguna secara default diperlakukan sebagai data bisnis. Umumnya cukup migrasikan struktur dan pilih schema-only.

Jika tabel menyimpan konfigurasi, kategori, template, rule, atau metadata, overwrite dapat dipilih sesuai skenario bisnis.

Jika tabel menyimpan pelanggan, order, tiket, approval, pesan, atau log, hindari overwrite data production.