OSS合并FSS数据调整

-- 批次关系表
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;