web-sql-5.4.2.1web-sql-5.4.2.1web-sql-5.4.2.1web-sql-5.4.2.1

-- MySQL dump 10.13 Distrib 5.7.32, for linux-glibc2.12 (x86_64) -- -- Host: localhost Database: trodb -- ------------------------------------------------------ -- Server version 5.7.32 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Temporary table structure for view `application_view` -- DROP TABLE IF EXISTS `application_view`; /*!50001 DROP VIEW IF EXISTS `application_view`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE VIEW `application_view` AS SELECT 1 AS `APPLICATION_ID`, 1 AS `APPLICATION_NAME`, 1 AS `TENANT_ID`, 1 AS `ENV_CODE`, 1 AS `TENANTAPPKEY`*/; SET character_set_client = @saved_cs_client; -- -- Table structure for table `e_patrol_activity_assert` -- DROP TABLE IF EXISTS `e_patrol_activity_assert`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `e_patrol_activity_assert` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `chain_id` bigint(20) DEFAULT NULL COMMENT '链路ID', `chain_type` int(2) DEFAULT NULL COMMENT '是否MQ：1-是；0-否', `assert_name` varchar(255) DEFAULT NULL COMMENT '断言名称', `param_type` int(2) DEFAULT NULL COMMENT '断言参数类型：1-出参；2-入参', `param_key` varchar(255) DEFAULT NULL COMMENT '参数名', `param_value` varchar(255) DEFAULT NULL COMMENT '标准值', `assert_condition` int(255) DEFAULT NULL COMMENT '断言方式：1-等于；2-不等于；3-包含；4-不包含', `mq_delay_time` bigint(255) DEFAULT NULL COMMENT 'mq延迟时间', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `modify_time` timestamp NULL DEFAULT NULL COMMENT '修改时间', `is_deleted` int(255) DEFAULT NULL COMMENT '是否删除：0-否；1-是', `assert_code` varchar(255) DEFAULT NULL COMMENT 'code', `tenant_id` bigint(20) DEFAULT '1' COMMENT '租户 id, 默认 1', `env_code` varchar(100) DEFAULT 'test' COMMENT '环境标识', PRIMARY KEY (`id`), KEY `idx_tenant_env` (`tenant_id`,`env_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='断言表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `e_patrol_activity_assert` -- LOCK TABLES `e_patrol_activity_assert` WRITE; /*!40000 ALTER TABLE `e_patrol_activity_assert` DISABLE KEYS */; /*!40000 ALTER TABLE `e_patrol_activity_assert` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `e_patrol_board` -- DROP TABLE IF EXISTS `e_patrol_board`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `e_patrol_board` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `customer_id` bigint(20) DEFAULT NULL COMMENT '租户id(已废弃)', `board_name` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '看板名称', `patrol_scene_num` int(11) DEFAULT NULL COMMENT '看板包含场景数量', `board_status` int(11) DEFAULT '0' COMMENT '看板状态（是否大屏展示）：0-否；1-是', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` int(2) NOT NULL DEFAULT '0' COMMENT '是否已删除', `is_merge` tinyint(1) DEFAULT NULL COMMENT '是否合并', `tenant_id` bigint(20) DEFAULT '1' COMMENT '租户 id, 默认 1', `env_code` varchar(100) COLLATE utf8_bin DEFAULT 'test' COMMENT '环境标识', `user_id` bigint(20) DEFAULT NULL COMMENT '用户id', `is_horizontally` tinyint(1) DEFAULT NULL COMMENT '是否横向', PRIMARY KEY (`id`), KEY `idx_tenant_env` (`tenant_id`,`env_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='看板信息表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `e_patrol_board` -- LOCK TABLES `e_patrol_board` WRITE; /*!40000 ALTER TABLE `e_patrol_board` DISABLE KEYS */; /*!40000 ALTER TABLE `e_patrol_board` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `e_patrol_board_scene` -- DROP TABLE IF EXISTS `e_patrol_board_scene`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `e_patrol_board_scene` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `patrol_board_id` bigint(20) DEFAULT NULL COMMENT '看板ID', `patrol_board_name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '看板名称', `patrol_scene_id` bigint(2) DEFAULT NULL COMMENT '场景id', `patrol_scene_name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '场景名称', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` int(2) NOT NULL DEFAULT '0' COMMENT '是否已删除', `tenant_id` bigint(20) DEFAULT '1' COMMENT '租户 id, 默认 1', `env_code` varchar(100) COLLATE utf8_bin DEFAULT 'test' COMMENT '环境标识', PRIMARY KEY (`id`), KEY `idx_tenant_env` (`tenant_id`,`env_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='看板-场景关联表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `e_patrol_board_scene` -- LOCK TABLES `e_patrol_board_scene` WRITE; /*!40000 ALTER TABLE `e_patrol_board_scene` DISABLE KEYS */; /*!40000 ALTER TABLE `e_patrol_board_scene` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `e_patrol_exception` -- DROP TABLE IF EXISTS `e_patrol_exception`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `e_patrol_exception` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `status` int(11) NOT NULL COMMENT '状态', `type` int(11) NOT NULL COMMENT '异常类型', `level` int(11) NOT NULL COMMENT '异常程度', `rt` double DEFAULT NULL COMMENT '响应时间', `success_rate` double DEFAULT NULL COMMENT '成功率', `start_time` datetime NOT NULL COMMENT '开始时间', `end_time` datetime DEFAULT NULL COMMENT '结束时间', `business_id` bigint(20) NOT NULL COMMENT '任务标识', `business_name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '任务名称', `business_type` int(11) NOT NULL COMMENT '任务类型', `business_rpc_type` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '业务入口', `scene_id` bigint(20) NOT NULL COMMENT '巡检场景', `scene_name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '巡检场景名称', `board_id` bigint(20) NOT NULL COMMENT '巡检看板', `board_name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '巡检看板名称', `is_finish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否处理完毕', `activity_id` bigint(20) DEFAULT NULL, `data_source` int(2) DEFAULT NULL COMMENT '异常数据来源：0.巡检 1.其他', `edge_id` varchar(2048) COLLATE utf8_bin DEFAULT NULL COMMENT '边ID', `tenant_id` bigint(20) DEFAULT '1' COMMENT '租户 id, 默认 1', `env_code` varchar(100) COLLATE utf8_bin DEFAULT 'test' COMMENT '环境标识', `user_id` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`), UNIQUE KEY `e_patrol_exception_id_uindex` (`id`), KEY `idx_tenant_env` (`tenant_id`,`env_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='巡检异常信息'; /*!4010