OSS合并FSS数据调整
<pre><code>-- 批次关系表
CREATE TABLE `wage_batch_relation` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(128) NOT NULL COMMENT '流水号',
`wage_batch_id` varchar(128) NOT NULL COMMENT '发放批次ID',
`pay_batch_id` varchar(128) COMMENT '支付批次ID',
`egh_batch_id` varchar(128) COMMENT '提现批次ID',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alpst_id` (`id`) USING BTREE,
UNIQUE KEY `uk_wage_batch_id` (`wage_batch_id`) USING BTREE,
UNIQUE KEY `uk_pay_batch_id` (`pay_batch_id`) USING BTREE,
UNIQUE KEY `uk_egh_batch_id` (`egh_batch_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8827 DEFAULT CHARSET=utf8mb4;
-- 发放流水与支付流水关系表
CREATE TABLE `wage_statement_and_pay_statement` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(128) NOT NULL COMMENT '流水号',
`wage_statement_type` tinyint(4) unsigned NOT NULL COMMENT '1银行卡 3支付宝',
`wage_statement_id` varchar(128) NOT NULL COMMENT '发放流水ID',
`pay_statement_id` varchar(128) NOT NULL COMMENT '支付流水ID',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alpst_id` (`id`) USING BTREE,
UNIQUE KEY `uk_wage_statement_id` (`wage_statement_id`) USING BTREE,
UNIQUE KEY `uk_pay_statement_id` (`pay_statement_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8827 DEFAULT CHARSET=utf8mb4;
-- 支付批次
CREATE TABLE `alipay_pay_bat` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL COMMENT '支付宝付款批次ID',
`payment_date` varchar(20) DEFAULT NULL COMMENT '发放日期',
`data_source` smallint(5) unsigned DEFAULT NULL COMMENT '发放数据来源',
`payer_id` varchar(100) NOT NULL COMMENT '发放主体ID',
`status` smallint(5) unsigned DEFAULT NULL,
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
`remark` varchar(100) DEFAULT NULL COMMENT '批次备注',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_batch_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 支付流水
CREATE TABLE `alipay_pay_stm` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL COMMENT '支付宝付款流水号',
`amount` decimal(11,2) NOT NULL COMMENT '付款金额',
`remark` varchar(100) DEFAULT NULL COMMENT '备注',
`account_num` varchar(50) NOT NULL COMMENT '收款账户账号',
`account_name` varchar(50) NOT NULL COMMENT '收款账户姓名',
`id_card_num` varchar(18) DEFAULT NULL COMMENT '收款账户绑定身份证号码',
`phone_num` char(11) DEFAULT NULL COMMENT '收款账户绑定手机号码',
`pay_id` varchar(100) DEFAULT NULL COMMENT '支付宝转账订单号',
`pay_sn` varchar(100) DEFAULT NULL COMMENT '支付宝支付资金流水号',
`pay_status` varchar(20) DEFAULT NULL COMMENT '转账单据状态',
`pay_time` bigint(20) DEFAULT NULL COMMENT '订单支付时间',
`batch_id` varchar(100) NOT NULL COMMENT '支付宝付款批次ID',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
`pay_err_code` varchar(50) DEFAULT NULL COMMENT '转账失败业务代码',
`pay_err_msg` varchar(50) DEFAULT NULL COMMENT '转账失败说明',
`pay_account` smallint(6) DEFAULT NULL,
`payer_id` varchar(100) NOT NULL COMMENT '发放主体ID',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_statement_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17353 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 支付错误信息
CREATE TABLE `alipay_pay_failure` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL,
`gateway_code` varchar(20) NOT NULL COMMENT '公共错误码',
`gateway_msg` varchar(50) NOT NULL COMMENT '公共错误码说明',
`biz_code` varchar(50) DEFAULT NULL COMMENT '业务错误码',
`biz_msg` char(50) DEFAULT NULL COMMENT '业务错误码说明',
`statement_no` int(10) unsigned NOT NULL COMMENT '支付宝付款流水表序号',
`statement_id` varchar(100) NOT NULL COMMENT '支付宝付款流水号',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_payment_failure_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1187 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;</code></pre>