-- MySQL dump 10.13 Distrib 8.0.35, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: tour_guide -- ------------------------------------------------------ -- Server version 8.0.35 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `guide_withdrawal` -- DROP TABLE IF EXISTS `guide_withdrawal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guide_withdrawal` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '提现申请主键', `withdrawal_no` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提现业务编号', `guide_id` bigint unsigned NOT NULL COMMENT '申请导游主键', `guide_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '导游姓名快照', `guide_mobile` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '导游手机号快照', `amount` decimal(10,2) NOT NULL COMMENT '提现金额', `bank_card_id` int DEFAULT NULL COMMENT '提现结算卡账户主键', `bank_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款银行快照', `card_masked` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款卡号掩码', `transfer_req_seq_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '主账户划账请求流水号', `transfer_req_date` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '主账户划账请求日期', `transfer_hf_seq_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '主账户划账汇付全局流水号', `transferred_at` datetime DEFAULT NULL COMMENT '主账户划账完成时间', `cash_req_seq_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '导游账户取现请求流水号', `cash_req_date` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '导游账户取现请求日期', `cash_hf_seq_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '导游账户取现汇付全局流水号', `payout_message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资金处理状态说明', `status` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING' COMMENT '状态：PENDING、APPROVED、REJECTED', `audit_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '处理备注', `processor` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后台处理人', `applied_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申请时间', `processed_at` datetime DEFAULT NULL COMMENT '处理时间', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除标记：0正常，1删除', PRIMARY KEY (`id`), UNIQUE KEY `uk_guide_withdrawal_no` (`withdrawal_no`), KEY `idx_guide_withdrawal_guide` (`guide_id`), KEY `idx_guide_withdrawal_status` (`status`), KEY `idx_guide_withdrawal_applied_at` (`applied_at`), KEY `idx_guide_withdrawal_guide_status` (`guide_id`,`status`), KEY `idx_guide_withdrawal_payout` (`status`,`updated_at`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='导游提现申请表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guide_withdrawal` -- LOCK TABLES `guide_withdrawal` WRITE; /*!40000 ALTER TABLE `guide_withdrawal` DISABLE KEYS */; INSERT INTO `guide_withdrawal` VALUES (1,'WD202608171135372460721',5,'1','17777777778',0.01,590,'中国工商银行','****1378',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'REJECTED','1','com.tourguide.security.AppUserPrincipal@281fa12f','2026-08-17 11:35:37','2026-08-17 11:37:14','2026-08-17 11:35:37','2026-08-17 11:35:37',0),(2,'WD202608171137359953259',5,'1','17777777778',0.01,590,'中国工商银行','****1378',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PENDING',NULL,NULL,'2026-08-17 11:37:36',NULL,'2026-08-17 11:37:36','2026-08-17 11:37:36',0),(3,'WD202608171351110092379',5,'1','17777777778',0.01,590,'中国工商银行','****1378','TF202608171351223475738','20260817','003500TOP2A260817135125P628ac139d1d00000','2026-08-17 13:51:23','CW202608181610034982111','20260818','003000TOP3A260818161008P166ac139c5300000','导游账户取现失败：等待系统重新发起取现','TRANSFERRED','1','com.tourguide.security.AppUserPrincipal@342b0eac','2026-08-17 13:51:11','2026-08-18 16:10:04','2026-08-17 13:51:11','2026-08-17 13:51:11',0),(4,'WD202608171404136365335',5,'1','17777777778',0.01,590,'中国工商银行','****1378','TF202608171404173990647','20260817','003500TOP2B260817140420P172ac139c7500000','2026-08-17 14:04:18','CW202608181610040336994','20260818','003000TOP1A260818161008P795ac139d5100000','导游账户取现失败：等待系统重新发起取现','TRANSFERRED',NULL,'com.tourguide.security.AppUserPrincipal@5a157506','2026-08-17 14:04:14','2026-08-18 16:10:05','2026-08-17 14:04:14','2026-08-17 14:04:14',0),(5,'WD202608171406268259691',5,'1','17777777778',0.01,590,'中国工商银行','****1378','TF202608171406380201633','20260817','003500TOP3B260817140640P835ac13684700000','2026-08-17 14:06:39','CW202608181610046915899','20260818','003000TOP1A260818161009P490ac139c3c00000','导游账户取现失败：等待系统重新发起取现','TRANSFERRED',NULL,'com.tourguide.security.AppUserPrincipal@32c318d5','2026-08-17 14:06:27','2026-08-18 16:10:05','2026-08-17 14:06:27','2026-08-17 14:06:27',0); /*!40000 ALTER TABLE `guide_withdrawal` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-08-18 16:16:25