数据库连接测试

核心管理库 (saas_core_db)

连接成功

共有 256 个表

查看表列表
activation_codes admin_login_logs admin_operation_logs admin_users agent_channel_permissions agents app_version_downloads app_versions auto_collected_images barcode_import_records central_barcode_library central_barcode_usage_log central_barcode_usage_logs central_product_categories electronic_receipt_logs employee_shift_records_00 employee_shift_records_01 employee_shift_records_02 employee_shift_records_03 employee_shift_records_04 employee_shift_records_05 employee_shift_records_06 employee_shift_records_07 employee_shift_records_08 employee_shift_records_09 image_cache industries inventory_check_items_00 inventory_check_items_01 inventory_check_items_02 inventory_check_items_03 inventory_check_items_04 inventory_check_items_05 inventory_check_items_06 inventory_check_items_07 inventory_check_items_08 inventory_check_items_09 inventory_checks_00 inventory_checks_01 inventory_checks_02 inventory_checks_03 inventory_checks_04 inventory_checks_05 inventory_checks_06 inventory_checks_07 inventory_checks_08 inventory_checks_09 inventory_transfer_items_00 inventory_transfer_items_01 inventory_transfer_items_02 inventory_transfer_items_03 inventory_transfer_items_04 inventory_transfer_items_05 inventory_transfer_items_06 inventory_transfer_items_07 inventory_transfer_items_08 inventory_transfer_items_09 inventory_transfers_00 inventory_transfers_01 inventory_transfers_02 inventory_transfers_03 inventory_transfers_04 inventory_transfers_05 inventory_transfers_06 inventory_transfers_07 inventory_transfers_08 inventory_transfers_09 member_balance_logs_global member_balances_global merchant_clean_logs merchant_id_sequence merchant_index merchant_payment_channels merchant_permanent_delete_logs merchant_restore_logs merchant_roles_00 merchant_roles_01 merchant_roles_02 merchant_roles_03 merchant_roles_04 merchant_roles_05 merchant_roles_06 merchant_roles_07 merchant_roles_08 merchant_roles_09 merchants merchants_00 mini_program_orders_00 mini_program_orders_01 mini_program_orders_02 mini_program_orders_03 mini_program_orders_04 mini_program_orders_05 mini_program_orders_06 mini_program_orders_07 mini_program_orders_08 mini_program_orders_09 miniprogram_boss_config miniprogram_config miniprogram_global_config miniprogram_mall_config miniprogram_merchant_qrcodes miniprogram_qrcodes oss_config oss_files payment_channel_platform_configs payment_channels payment_orders payment_suixingfu_config product_details_00 product_details_01 product_details_02 product_details_03 product_details_04 product_details_05 product_details_06 product_details_07 product_details_08 product_details_09 product_distribution_settings_00 product_distribution_settings_01 product_distribution_settings_02 product_distribution_settings_03 product_distribution_settings_04 product_distribution_settings_05 product_distribution_settings_06 product_distribution_settings_07 product_distribution_settings_08 product_distribution_settings_09 product_images product_import_records_00 product_import_records_01 product_import_records_02 product_import_records_03 product_import_records_04 product_import_records_05 product_import_records_06 product_import_records_07 product_import_records_08 product_import_records_09 product_store_sync_records_00 product_store_sync_records_01 product_store_sync_records_02 product_store_sync_records_03 product_store_sync_records_04 product_store_sync_records_05 product_store_sync_records_06 product_store_sync_records_07 product_store_sync_records_08 product_store_sync_records_09 product_units_00 product_units_01 product_units_02 product_units_03 product_units_04 product_units_05 product_units_06 product_units_07 product_units_08 product_units_09 purchase_inbound_items_00 purchase_inbound_items_01 purchase_inbound_items_02 purchase_inbound_items_03 purchase_inbound_items_04 purchase_inbound_items_05 purchase_inbound_items_06 purchase_inbound_items_07 purchase_inbound_items_08 purchase_inbound_items_09 purchase_inbounds_00 purchase_inbounds_01 purchase_inbounds_02 purchase_inbounds_03 purchase_inbounds_04 purchase_inbounds_05 purchase_inbounds_06 purchase_inbounds_07 purchase_inbounds_08 purchase_inbounds_09 purchase_orders_00 purchase_orders_01 purchase_orders_02 purchase_orders_03 purchase_orders_04 purchase_orders_05 purchase_orders_06 purchase_orders_07 purchase_orders_08 purchase_orders_09 purchase_return_items_00 purchase_return_items_01 purchase_return_items_02 purchase_return_items_03 purchase_return_items_04 purchase_return_items_05 purchase_return_items_06 purchase_return_items_07 purchase_return_items_08 purchase_return_items_09 purchase_returns_00 purchase_returns_01 purchase_returns_02 purchase_returns_03 purchase_returns_04 purchase_returns_05 purchase_returns_06 purchase_returns_07 purchase_returns_08 purchase_returns_09 refunds_00 refunds_01 refunds_02 refunds_03 refunds_04 refunds_05 refunds_06 refunds_07 refunds_08 refunds_09 shift_order_relations_00 shift_order_relations_01 shift_order_relations_02 shift_order_relations_03 shift_order_relations_04 shift_order_relations_05 shift_order_relations_06 shift_order_relations_07 shift_order_relations_08 shift_order_relations_09 sms_config sms_logs sms_send_logs sms_templates super_admins suppliers_00 suppliers_01 suppliers_02 suppliers_03 suppliers_04 suppliers_05 suppliers_06 suppliers_07 suppliers_08 suppliers_09 system_configs system_permissions wechat_config wechat_member_card_config wechat_member_card_logs wechat_message_logs wechat_official_config wechat_template_messages wechat_template_send_logs wechat_templates wechat_users
商户分片数据库
saas_merchant_db_00

连接成功

113 个表
saas_merchant_db_01

连接成功

158 个表
saas_merchant_db_02

连接成功

108 个表
saas_merchant_db_03

连接成功

111 个表
saas_merchant_db_04

连接成功

108 个表
saas_merchant_db_05

连接成功

108 个表
saas_merchant_db_06

连接成功

105 个表
saas_merchant_db_07

连接成功

108 个表
saas_merchant_db_08

连接成功

107 个表
saas_merchant_db_09

连接成功

107 个表
数据库架构说明:
  • saas_core_db:核心管理库,存储超管、代理商、激活码等管理数据
  • saas_merchant_db_00~49:商户业务数据分片,根据商户ID取模50进行分片,使用DatabaseShardService管理
  • saas_log_db:日志统计库,存储系统日志和统计数据