/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : localhost:3306
 Source Schema         : sentinel

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 07/01/2021 17:30:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_sentinel_metric
-- ----------------------------
DROP TABLE IF EXISTS `t_sentinel_metric`;
CREATE TABLE `t_sentinel_metric`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id，主键',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `app` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用名称',
  `timestamp` datetime(0) NULL DEFAULT NULL COMMENT '统计时间',
  `resource` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源名称',
  `pass_qps` int(11) NULL DEFAULT NULL COMMENT '通过qps',
  `success_qps` int(11) NULL DEFAULT NULL COMMENT '成功qps',
  `block_qps` int(11) NULL DEFAULT NULL COMMENT '限流qps',
  `exception_qps` int(11) NULL DEFAULT NULL COMMENT '发送异常的次数',
  `rt` double NULL DEFAULT NULL COMMENT '所有successQps的rt的和',
  `_count` int(11) NULL DEFAULT NULL COMMENT '本次聚合的总条数',
  `resource_code` int(11) NULL DEFAULT NULL COMMENT '资源的hashCode',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `app_idx`(`app`) USING BTREE,
  INDEX `resource_idx`(`resource`) USING BTREE,
  INDEX `timestamp_idx`(`timestamp`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 204 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;