# custom-framework

**Repository Path**: budingxie/custom-framework

## Basic Information

- **Project Name**: custom-framework
- **Description**: 自定义框架设计
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-10-17
- **Last Updated**: 2022-04-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 微服务框架
## 项目结构
### custom-ability | 基础能力微服务

### custom-business | 业务功能微服务

### custom-common | 公共功能微服务

### custom-config | 配置功能微服务

### custom-data | 数据访问微服务
## 设计说明

## 建表语句
### 消息模板表
```sql
CREATE TABLE `message_template` (
  `template_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板id',
  `template_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '模板名称',
  `template_type` int(4) NOT NULL DEFAULT '0' COMMENT '模板类型：默认为0普通信息模板，',
  `template_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '模板内容：尊敬的${userName}您好，您收到了昨日已触发但未处理的告警总计${alarmNumber}条，请您尽快登录PC端查看并处理风控事件',
  `variable_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '变量属性：userName-用户名；alarmNumber-手机号；',
  `template_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '模板说明',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del_flag` int(4) NOT NULL DEFAULT '0' COMMENT '删除标识：默认为0生效',
  PRIMARY KEY (`template_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
```

### 消息记录表
```sql
CREATE TABLE `message_record`  (
  `record_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '消息记录主键',
  `template_id` bigint(20) NOT NULL COMMENT '模板id',
  `message_id` varchar(50) NOT NULL DEFAULT '' COMMENT 'mq中消息唯一键；如果不是mq的任务，设置空串',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '消息内容',
  `status` int(4) NOT NULL DEFAULT 0 COMMENT '0：创建还未执行发送；1:发送成功；2:外部平台已接收，但是消息发送失败；3:外部平台服务异常',
  `sender` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '发送人',
  `receiver` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '接收人',
  `fail_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '失败原因',
  `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  `del_flag` int(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`record_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
```