| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 |
- DROP TABLE IF EXISTS `kx_rider_wallet_transaction`;
- CREATE TABLE `kx_rider_wallet_transaction` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
- `rider_id` bigint(20) NOT NULL COMMENT '骑手ID',
- `transaction_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '交易流水号',
- `amount` decimal(10, 2) NOT NULL COMMENT '交易金额',
- `balance` decimal(10, 2) NOT NULL COMMENT '交易后余额',
- `transaction_type` tinyint(4) NOT NULL COMMENT '交易类型(1:收入,2:支出,3:提现,4:退款)',
- `transaction_source` tinyint(4) NULL DEFAULT NULL COMMENT '交易来源(1:配送费,2:小费,3:系统调整,4:其他)',
- `order_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联订单ID',
- `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易备注',
- `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1:成功,2:处理中,3:失败)',
- `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
- `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
- `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `idx_transaction_no`(`transaction_no`) USING BTREE,
- INDEX `idx_rider_id`(`rider_id`) USING BTREE,
- INDEX `idx_create_time`(`create_time`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1916836015478145027 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '骑手钱包交易记录表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for kx_rider_withdrawal
- -- ----------------------------
- DROP TABLE IF EXISTS `kx_rider_withdrawal`;
- CREATE TABLE `kx_rider_withdrawal` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
- `rider_id` bigint(20) NOT NULL COMMENT '骑手ID',
- `amount` decimal(10, 2) NOT NULL COMMENT '提现金额',
- `bank_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
- `bank_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行账号',
- `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开户人姓名',
- `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态(0:待审核,1:审核通过,2:审核拒绝,3:已打款)',
- `audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
- `audit_admin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人',
- `audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核备注',
- `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '打款时间',
- `payment_admin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打款人',
- `payment_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打款备注',
- `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
- `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
- `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `payment_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打款URL',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `idx_rider_id`(`rider_id`) USING BTREE,
- INDEX `idx_status`(`status`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1917233244433039363 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '骑手提现记录表' ROW_FORMAT = Dynamic;
- INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1917360667413725185, '提现审核', 1704762913992278018, 3, 'withdraw', 'rider/withdraw/index', NULL, 1, 0, 'C', '0', '0', '', '#', 'admin', '2025-04-30 07:29:41', 'admin', '2025-04-30 07:29:41', '');
- ALTER TABLE `kx_rider`
- ADD COLUMN `wallet_balance` decimal(20, 2) NULL DEFAULT NULL COMMENT '钱包余额' AFTER `gzh_open_id`,
- ADD COLUMN `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行名称' AFTER `wallet_balance`,
- ADD COLUMN `bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行账号' AFTER `bank_name`,
- ADD COLUMN `account_holder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开户人姓名' AFTER `bank_account`,
- ADD COLUMN `id_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号码' AFTER `account_holder`;
- UPDATE `sys_config` SET `category` = 'riderWxMini' WHERE `config_id` = 1705582515376066561;
- UPDATE `sys_config` SET `category` = 'riderWxMini' WHERE `config_id` = 1705582465266716674;
|
