zianxin/biz-api-cloud-zax
1
0 Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
biz-api-cloud-zax/db/1000pjcloudx_thirdparty.sql
T
dzc df1eeef0d0 feat:极光推送
2026-07-07 17:05:50 +08:00

300 lines
19 KiB
SQL
Raw Permalink Blame History

create
database `pjcloudx_thirdparty` default character set utf8mb4 collate utf8mb4_general_ci;
-- ----------------------------
-- Table structure for third_zy_log
-- ----------------------------
DROP TABLE IF EXISTS `third_zy_log`;
CREATE TABLE `third_zy_log`
(
`id` bigint NOT NULL COMMENT '主键',
`biz_type` tinytext NOT NULL COMMENT '同步类型',
`biz_id` varchar(2048) DEFAULT NULL COMMENT '同步类型id',
`api_url` text DEFAULT NULL COMMENT 'api url',
`org_res` text DEFAULT NULL COMMENT '原始res',
`encipher_res` text DEFAULT NULL COMMENT '加密res',
`org_req` text DEFAULT NULL COMMENT '原始req',
`encipher_req` text DEFAULT NULL COMMENT '加密req',
`error` text DEFAULT NULL COMMENT '调用错误',
`version` char(64) DEFAULT NULL COMMENT '同步版本格式化为14位字符串，如果是数字不足14位的，前面补0',
`time_consuming` char(64) DEFAULT NULL COMMENT '同步版本格式化为14位字符串，如果是数字不足14位的，前面补0',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='正元日志表';
-- ----------------------------
-- Table structure for third_door_log
-- ----------------------------
DROP TABLE IF EXISTS `third_door_log`;
CREATE TABLE `third_door_log`
(
`id` bigint NOT NULL COMMENT '主键',
`api_type` tinytext NOT NULL COMMENT '请求类型',
`biz_type` tinytext NOT NULL COMMENT 'api类型',
`biz_id` varchar(2048) DEFAULT NULL COMMENT 'api类型id',
`request_id` varchar(64) DEFAULT NULL COMMENT '请求id',
`api_url` text DEFAULT NULL COMMENT 'api url',
`res` text DEFAULT NULL COMMENT 'res',
`req` text DEFAULT NULL COMMENT 'req',
`error` text DEFAULT NULL COMMENT '调用错误',
`time_consuming` char(64) DEFAULT NULL COMMENT '耗时(毫秒)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='智能柜日志';
-- ----------------------------
-- Table structure for third_pay_log
-- ----------------------------
DROP TABLE IF EXISTS `third_pay_log`;
CREATE TABLE `third_pay_log`
(
`id` bigint NOT NULL COMMENT '主键',
`pay_source_type` varchar(32) NOT NULL COMMENT '支付发起方类型id',
`biz_type` varchar(32) NOT NULL COMMENT '支付类型',
`biz_id` varchar(2048) DEFAULT NULL COMMENT '支付类型id',
`api_url` text DEFAULT NULL COMMENT 'api-url',
`header` text DEFAULT NULL COMMENT 'header',
`res` text DEFAULT NULL COMMENT 'res',
`req` text DEFAULT NULL COMMENT 'req',
`error` text DEFAULT NULL COMMENT '调用错误',
`time_consuming` char(64) DEFAULT NULL COMMENT '耗时(毫秒)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='第三方支付日志';
-- ----------------------------
-- Table structure for third_key_manage
-- ----------------------------
DROP TABLE IF EXISTS `third_key_manage`;
CREATE TABLE `third_key_manage`
(
`id` bigint NOT NULL COMMENT '主键',
`name` varchar(32) NOT NULL COMMENT '第三方名字',
`biz_type` varchar(32) NOT NULL COMMENT '第三方类型id(常量)',
`app_key` varchar(256) DEFAULT NULL COMMENT 'appKey',
`app_secret` varchar(256) DEFAULT NULL COMMENT 'appSecret',
`field_key` varchar(256) DEFAULT NULL COMMENT '字段加密key',
`status` varchar(32) DEFAULT '1' COMMENT '状态',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='第三方密钥管理';
-- ----------------------------
-- Table structure for third_zy_id_dict
-- ----------------------------
DROP TABLE IF EXISTS `third_zy_id_dict`;
CREATE TABLE `third_zy_id_dict`
(
`id` bigint NOT NULL COMMENT '主键',
`self_id` varchar(64) NOT NULL COMMENT '自己这边的id映射',
`zy_id` varchar(64) NOT NULL COMMENT '正元id映射',
`biz_type` tinytext NOT NULL COMMENT '同步类型',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='正元字典id对应 id + bizType 唯一';
-- ----------------------------
-- Table structure for third_pay_order
-- ----------------------------
DROP TABLE IF EXISTS `third_pay_order`;
CREATE TABLE `third_pay_order`
(
`id` bigint NOT NULL COMMENT '主键',
`pay_platform_type` varchar(32) NOT NULL COMMENT '支付平台类型',
`biz_type` varchar(32) NOT NULL COMMENT '支付类型',
`biz_id` varchar(128) NOT NULL COMMENT '支付相关id',
`user_id` bigint NOT NULL COMMENT '用户id',
`user_code` varchar(64) DEFAULT NULL COMMENT '用户code',
`price` int NOT NULL COMMENT '支付金额(分)',
`status` varchar(128) DEFAULT NULL COMMENT '支付状态',
`pay_no` varchar(128) DEFAULT NULL COMMENT '支付订单号',
`pay_time` datetime DEFAULT NULL COMMENT '支付时间',
`pay_res` text DEFAULT NULL COMMENT '支付返回',
`refund_no` varchar(128) DEFAULT NULL COMMENT '退款订单号',
`refund_time` datetime DEFAULT NULL COMMENT '退款时间',
`refund_res` text DEFAULT NULL COMMENT '退款返回',
`expire_time` datetime DEFAULT NULL COMMENT '订单过期时间',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='第三方支付订单';
-- ----------------------------
-- Table structure for third_fz_order
-- ----------------------------
DROP TABLE IF EXISTS `third_fz_order`;
CREATE TABLE `third_fz_order`
(
`id` bigint NOT NULL COMMENT '主键',
`pay_no` varchar(128) DEFAULT NULL COMMENT '支付订单号',
`fz_no` varchar(128) DEFAULT NULL COMMENT '分账订单号',
`create_req` text DEFAULT NULL COMMENT '发起分账req',
`create_res` text DEFAULT NULL COMMENT '发起分账res',
`create_error` text DEFAULT NULL COMMENT '发起分账error',
`status` varchar(128) DEFAULT NULL COMMENT '支付状态',
`fz_time` datetime DEFAULT NULL COMMENT '分账时间',
`fz_refund_no` varchar(128) DEFAULT NULL COMMENT '分账退款订单号',
`fz_refund_time` datetime DEFAULT NULL COMMENT '分账退款时间',
`fz_refund_req` text DEFAULT NULL COMMENT '分账退款req',
`fz_refund_res` text DEFAULT NULL COMMENT '分账退款res',
`fz_refund_error` text DEFAULT NULL COMMENT '分账退款error',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`update_by` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除时间',
`tenant_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC COMMENT ='第三方支付分账';
-- ----------------------------
-- Table structure for third_push_conf
-- ----------------------------
DROP TABLE IF EXISTS third_push_conf;
CREATE TABLE third_push_conf
(
id bigint NOT NULL COMMENT '主键',
biz_type varchar(32) NOT NULL COMMENT '业务类型',
biz_id varchar(256) NOT NULL COMMENT '业务id',
title varchar(64) NOT NULL COMMENT '通知标题',
content varchar(256) NOT NULL COMMENT '通知内容',
enable varchar(32) NOT NULL COMMENT '是否开启',
inform_type int NOT NULL COMMENT '每天、每月',
inform_time time NOT NULL COMMENT '通知时间',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id),
KEY idx_third_push_conf_biz (tenant_id, biz_type, biz_id, del_flag),
KEY idx_third_push_conf_inform (tenant_id, enable, inform_type, inform_time, del_flag)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='推送配置';
-- ----------------------------
-- Table structure for third_push_record
-- ----------------------------
DROP TABLE IF EXISTS `third_push_record`;
CREATE TABLE `third_push_record`
(
`id` bigint NOT NULL COMMENT '主键',
`conf_id` bigint NOT NULL COMMENT '推送配置id',
`batch_no` varchar(64) NOT NULL COMMENT '推送批次号',
`biz_type` varchar(32) NOT NULL COMMENT '业务类型',
`biz_id` varchar(256) NOT NULL COMMENT '业务id',
`title` varchar(64) NOT NULL COMMENT '通知标题',
`content` varchar(256) NOT NULL COMMENT '通知内容',
`inform_type` int NOT NULL COMMENT '每天、每月',
`inform_time` time NOT NULL COMMENT '通知时间',
`receiver_count` int DEFAULT 0 COMMENT '接收总人数',
`success_count` int DEFAULT 0 COMMENT '成功人数',
`fail_count` int DEFAULT 0 COMMENT '失败人数',
`send_time` datetime DEFAULT NULL COMMENT '发送时间',
`status` varchar(32) NOT NULL COMMENT '批次状态',
`push_result` text DEFAULT NULL COMMENT '推送结果摘要',
`error_msg` varchar(512) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '失败原因',
`create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`del_flag` char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
`tenant_id` bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id`) USING BTREE,
KEY idx_third_push_record_conf_id (`conf_id`),
KEY idx_third_push_record_batch_no (`batch_no`),
KEY idx_third_push_record_biz (`tenant_id`, `biz_type`, `biz_id`, `del_flag`),
KEY idx_third_push_record_send_time (`tenant_id`, `send_time`),
KEY idx_third_push_record_status_time (`tenant_id`, `status`, `send_time`)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='推送通知批次记录';
-- ----------------------------
-- Table structure for third_push_record_user
-- ----------------------------
DROP TABLE IF EXISTS `third_push_record_user`;
CREATE TABLE `third_push_record_user`
(
`id` bigint NOT NULL COMMENT '主键',
`record_id` bigint NOT NULL COMMENT '推送批次记录id',
`conf_id` bigint NOT NULL COMMENT '推送配置id',
`batch_no` varchar(64) NOT NULL COMMENT '推送批次号',
`user_id` bigint NOT NULL COMMENT '接收用户id',
`biz_type` varchar(32) NOT NULL COMMENT '业务类型',
`biz_id` varchar(256) NOT NULL COMMENT '业务id',
`send_time` datetime DEFAULT NULL COMMENT '发送时间',
`status` varchar(32) NOT NULL COMMENT '发送状态',
`error_msg` varchar(512) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '失败原因',
`read_time` datetime DEFAULT NULL COMMENT '已读时间',
`create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`del_flag` char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
`tenant_id` bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id`) USING BTREE,
KEY idx_third_push_record_user_record_id (`record_id`),
KEY idx_third_push_record_user_batch_no (`batch_no`),
KEY idx_third_push_record_user_user_time (`tenant_id`, `user_id`, `send_time`),
KEY idx_third_push_record_user_status_time (`tenant_id`, `status`, `send_time`),
KEY idx_third_push_record_user_biz (`tenant_id`, `biz_type`, `biz_id`, `del_flag`)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='推送通知用户明细记录';
Reference in new issue View Git Blame Copy Permalink