The Vinchin backup server uses the vinchin_db database to manage all backup tasks, virtual machines, disaster recovery plans, and user/permission data. Below is a list of the main tables with a brief description of their purpose, which can help understand the system’s structure and functionality.
-- Login to MySQL
mysql -uroot -p
Enter password: Database@3R
-- Select the database
use vinchin_db;
-- Show all tables
show tables;
-- Login to MySQL
mysql -uroot -p
Enter password: Database@3R
-- Select the database
use vinchin_db;
-- Show all tables
show tables;
+--------------------------------+--------------------------------------+
| Tables_in_vinchin_db | Description |
+--------------------------------+--------------------------------------+
| backup_copy_item_list | Backup/Archive sources |
| backup_copy_task | Backup/Archive task details |
| bd_account_safe | System security configuration |
| bd_agent | Client |
| bd_agent_group | Client groups |
| bd_appliance | VM transfer appliance |
| bd_backup_timepoint | Backup timepoints |
| bd_billing | Billing policies |
| bd_billing_details | Tenant-specific billing details |
| bd_cpu_memory_monitor | CPU and memory monitoring |
| bd_domain_server | AD domain server |
| bd_email_notice | Email notifications |
| bd_global_speed_limit_strategy | Global speed limit strategy |
| bd_global_time_strategy | Global time strategy |
| bd_history_task | Historical tasks |
| bd_license | Licensing information |
| bd_message_push | Message push service |
| bd_module_server | Module services |
| bd_network_monitor | Network monitoring |
| bd_node | Node management |
| mt_user_resource | User-resource associations |
| mt_user_resource_group | User-resource group associations |
| mt_user_role | User-role associations |
| mt_user_tenant | User-tenant associations |
| mt_user_user_group | User-user group associations |
| orch_plan | Disaster recovery plan |
| orch_plan_child | Sub-plans |
| orch_plan_group | Plan groups |
| orch_plan_vm | Disaster recovery VMs |
| orch_proxy | DR plan proxy hosts |
| orch_report | Disaster recovery reports |
| orch_report_vm | DR report VM information |
| orch_task | Disaster recovery tasks |
| orch_task_instant | Emergency instant recovery |
| st_motion_task | — (to be confirmed) |
| vm_backup_timepoint | VM backup timepoints |
| vm_export_task | VM export tasks |
| vm_grain_info | VM fine-grained information |
| vm_host | VM host machines |
| vm_host_running_state | VM host running states |
| vm_instant | VM instant recovery |
| vm_log_cache | — (log cache) |
| vm_machine | VM machine information |
| vm_machine_list | VMs in tasks |
| vm_platform_meta_backup_data | Auto platform backups |
| vm_task | VM tasks |
| vm_task_log | VM task logs |
| vm_tree | Update VM tree in virtualization center |
| vm_vcenter | Virtualization center |
+--------------------------------+--------------------------------------+
