嗨玩后端开发规范

数据库表调整记录


易工会数据分析版本

-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_09001', 'EGH-API-FRONT-SYS-09001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_09002', 'EGH-API-FRONT-SYS-09002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_09003', 'EGH-API-FRONT-SYS-09003');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_09004', 'EGH-API-FRONT-SYS-09004');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_09005', 'EGH-API-FRONT-SYS-09005');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_09006', 'EGH-API-FRONT-SYS-09006');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_01001', 'EGH-API-FRONT-DATA-01001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_02001', 'EGH-API-FRONT-DATA-02001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_02002', 'EGH-API-FRONT-DATA-02002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_02003', 'EGH-API-FRONT-DATA-02003');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_02004', 'EGH-API-FRONT-DATA-02004');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_03001', 'EGH-API-FRONT-DATA-03001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_03002', 'EGH-API-FRONT-DATA-03002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_DATA_03003', 'EGH-API-FRONT-DATA-03003');

-- 数据配置表

-- 流水异常标准配置
CREATE TABLE `stm_error_config` (
  `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',

  `id` varchar(128) NOT NULL COMMENT '配置ID',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1-超额上升 2-超额下降',
  `critical_value` tinyint(1) unsigned NOT NULL COMMENT '临界值',
  `name` varchar(128) NOT NULL COMMENT '日均真实流水环比',

  `is_available` tinyint(1) unsigned 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_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=712 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- 公告配置
CREATE TABLE `announcement_config` (
  `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',

  `id` varchar(128) NOT NULL COMMENT '配置ID',
  `content` LONGTEXT DEFAULT NULL COMMENT '公告内容',

  `is_available` tinyint(1) unsigned 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_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=711 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- 插入默认配置
INSERT INTO `announcement_config` (`id`, `content`) VALUES ('AC1664182153764CA80C230B1E1458895D571DA19FFA419', NULL);
-- 插入默认流水错误配置
INSERT INTO `stm_error_config` (`id`, `type`, `critical_value`, `name`) VALUES ('SEC16641821537633470BAC0E2294E9A88DE3E836768F072', 1, 30, '日均流水真实环比');
INSERT INTO `stm_error_config` (`id`, `type`, `critical_value`, `name`) VALUES ('SEC1664182153763A1365AA5D1784E1F8024C6934C9FD518', 2, 30, '日均流水真实环比');

页面列表

ITEM_HTML