Fork me on GitHub

Open-Falcon数据库表结构

Open-Falcon数据库表结构

1_uic-db-schema.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
create database uic
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
USE uic;
SET NAMES utf8;

DROP TABLE if exists team;
CREATE TABLE `team` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`resume` varchar(255) not null default '',
`creator` int(10) unsigned NOT NULL DEFAULT '0',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_team_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/**
* role: -1:blocked 0:normal 1:admin 2:root
*/
DROP TABLE if exists `user`;
CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`passwd` varchar(64) not null default '',
`cnname` varchar(128) not null default '',
`email` varchar(255) not null default '',
`phone` varchar(16) not null default '',
`im` varchar(32) not null default '',
`qq` varchar(16) not null default '',
`role` tinyint not null default 0,
`creator` int(10) unsigned NOT NULL DEFAULT 0,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_user_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE if exists `rel_team_user`;
CREATE TABLE `rel_team_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tid` int(10) unsigned not null,
`uid` int(10) unsigned not null,
PRIMARY KEY (`id`),
KEY `idx_rel_tid` (`tid`),
KEY `idx_rel_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE if exists `session`;
CREATE TABLE `session` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned not null,
`sig` varchar(32) not null,
`expired` int(10) unsigned not null,
PRIMARY KEY (`id`),
KEY `idx_session_uid` (`uid`),
KEY `idx_session_sig` (`sig`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*900150983cd24fb0d6963f7d28e17f72*/
/*insert into `user`(`name`, `passwd`, `role`, `created`) values('root', md5('abc'), 2, now());*/

2_portal-db-schema.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
CREATE DATABASE falcon_portal
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
USE falcon_portal;
SET NAMES utf8;

/**
* 这里的机器是从机器管理系统中同步过来的
* 系统拿出来单独部署需要为hbs增加功能,心跳上来的机器写入host表
*/
DROP TABLE IF EXISTS host;
CREATE TABLE host
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
hostname VARCHAR(255) NOT NULL DEFAULT '',
ip VARCHAR(16) NOT NULL DEFAULT '',
agent_version VARCHAR(16) NOT NULL DEFAULT '',
plugin_version VARCHAR(128) NOT NULL DEFAULT '',
maintain_begin INT UNSIGNED NOT NULL DEFAULT 0,
maintain_end INT UNSIGNED NOT NULL DEFAULT 0,
update_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY idx_host_hostname (hostname)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


/**
* 机器分组信息
* come_from 0: 从机器管理同步过来的;1: 从页面创建的
*/
DROP TABLE IF EXISTS grp;
CREATE TABLE `grp` (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
grp_name VARCHAR(255) NOT NULL DEFAULT '',
create_user VARCHAR(64) NOT NULL DEFAULT '',
create_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
come_from TINYINT(4) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
UNIQUE KEY idx_host_grp_grp_name (grp_name)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


DROP TABLE IF EXISTS grp_host;
CREATE TABLE grp_host
(
grp_id INT UNSIGNED NOT NULL,
host_id INT UNSIGNED NOT NULL,
KEY idx_grp_host_grp_id (grp_id),
KEY idx_grp_host_host_id (host_id)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


/**
* 监控策略模板
* tpl_name全局唯一,命名的时候可以适当带上一些前缀,比如:sa.falcon.base
*/
DROP TABLE IF EXISTS tpl;
CREATE TABLE tpl
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
tpl_name VARCHAR(255) NOT NULL DEFAULT '',
parent_id INT UNSIGNED NOT NULL DEFAULT 0,
action_id INT UNSIGNED NOT NULL DEFAULT 0,
create_user VARCHAR(64) NOT NULL DEFAULT '',
create_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY idx_tpl_name (tpl_name),
KEY idx_tpl_create_user (create_user)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


DROP TABLE IF EXISTS strategy;
CREATE TABLE `strategy` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`metric` VARCHAR(128) NOT NULL DEFAULT '',
`tags` VARCHAR(256) NOT NULL DEFAULT '',
`max_step` INT(11) NOT NULL DEFAULT '1',
`priority` TINYINT(4) NOT NULL DEFAULT '0',
`func` VARCHAR(16) NOT NULL DEFAULT 'all(#1)',
`op` VARCHAR(8) NOT NULL DEFAULT '',
`right_value` VARCHAR(64) NOT NULL,
`note` VARCHAR(128) NOT NULL DEFAULT '',
`run_begin` VARCHAR(16) NOT NULL DEFAULT '',
`run_end` VARCHAR(16) NOT NULL DEFAULT '',
`tpl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_strategy_tpl_id` (`tpl_id`)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


DROP TABLE IF EXISTS expression;
CREATE TABLE `expression` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`expression` VARCHAR(1024) NOT NULL,
`func` VARCHAR(16) NOT NULL DEFAULT 'all(#1)',
`op` VARCHAR(8) NOT NULL DEFAULT '',
`right_value` VARCHAR(16) NOT NULL DEFAULT '',
`max_step` INT(11) NOT NULL DEFAULT '1',
`priority` TINYINT(4) NOT NULL DEFAULT '0',
`note` VARCHAR(1024) NOT NULL DEFAULT '',
`action_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`create_user` VARCHAR(64) NOT NULL DEFAULT '',
`pause` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


DROP TABLE IF EXISTS grp_tpl;
CREATE TABLE `grp_tpl` (
`grp_id` INT(10) UNSIGNED NOT NULL,
`tpl_id` INT(10) UNSIGNED NOT NULL,
`bind_user` VARCHAR(64) NOT NULL DEFAULT '',
KEY `idx_grp_tpl_grp_id` (`grp_id`),
KEY `idx_grp_tpl_tpl_id` (`tpl_id`)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;

CREATE TABLE `plugin_dir` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`grp_id` INT(10) UNSIGNED NOT NULL,
`dir` VARCHAR(255) NOT NULL,
`create_user` VARCHAR(64) NOT NULL DEFAULT '',
`create_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_plugin_dir_grp_id` (`grp_id`)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;


DROP TABLE IF EXISTS action;
CREATE TABLE `action` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`uic` VARCHAR(255) NOT NULL DEFAULT '',
`url` VARCHAR(255) NOT NULL DEFAULT '',
`callback` TINYINT(4) NOT NULL DEFAULT '0',
`before_callback_sms` TINYINT(4) NOT NULL DEFAULT '0',
`before_callback_mail` TINYINT(4) NOT NULL DEFAULT '0',
`after_callback_sms` TINYINT(4) NOT NULL DEFAULT '0',
`after_callback_mail` TINYINT(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;

/**
* nodata mock config
*/
DROP TABLE IF EXISTS `mockcfg`;
CREATE TABLE `mockcfg` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'name of mockcfg, used for uuid',
`obj` VARCHAR(10240) NOT NULL DEFAULT '' COMMENT 'desc of object',
`obj_type` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'type of object, host or group or other',
`metric` VARCHAR(128) NOT NULL DEFAULT '',
`tags` VARCHAR(1024) NOT NULL DEFAULT '',
`dstype` VARCHAR(32) NOT NULL DEFAULT 'GAUGE',
`step` INT(11) UNSIGNED NOT NULL DEFAULT 60,
`mock` DOUBLE NOT NULL DEFAULT 0 COMMENT 'mocked value when nodata occurs',
`creator` VARCHAR(64) NOT NULL DEFAULT '',
`t_create` DATETIME NOT NULL COMMENT 'create time',
`t_modify` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last modify time',
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_name` (`name`)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

/**
* aggregator cluster metric config table
*/
DROP TABLE IF EXISTS `cluster`;
CREATE TABLE `cluster` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`grp_id` INT NOT NULL,
`numerator` VARCHAR(10240) NOT NULL,
`denominator` VARCHAR(10240) NOT NULL,
`endpoint` VARCHAR(255) NOT NULL,
`metric` VARCHAR(255) NOT NULL,
`tags` VARCHAR(255) NOT NULL,
`ds_type` VARCHAR(255) NOT NULL,
`step` INT NOT NULL,
`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`creator` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE =InnoDB
DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

/**
* alert links
*/
DROP TABLE IF EXISTS alert_link;
CREATE TABLE alert_link
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
path VARCHAR(16) NOT NULL DEFAULT '',
content TEXT NOT NULL,
create_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY alert_path(path)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;

3_dashboard-db-schema.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
-- MySQL dump 10.13  Distrib 5.5.31, for Linux (x86_64)
--
-- Host: 127.0.0.1 Database: dashboard
-- ------------------------------------------------------
-- Server version 5.5.31-log

/*!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 */;

--
-- Table structure for table `dashboard_graph`
--

CREATE DATABASE dashboard
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
USE dashboard;
SET NAMES utf8;

DROP TABLE IF EXISTS `dashboard_graph`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dashboard_graph` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` char(128) NOT NULL,
`hosts` varchar(10240) NOT NULL DEFAULT '',
`counters` varchar(1024) NOT NULL DEFAULT '',
`screen_id` int(11) unsigned NOT NULL,
`timespan` int(11) unsigned NOT NULL DEFAULT '3600',
`graph_type` char(2) NOT NULL DEFAULT 'h',
`method` char(8) DEFAULT '',
`position` int(11) unsigned NOT NULL DEFAULT '0',
`falcon_tags` varchar(512) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `idx_sid` (`screen_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dashboard_screen`
--

DROP TABLE IF EXISTS `dashboard_screen`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dashboard_screen` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) unsigned NOT NULL DEFAULT '0',
`name` char(128) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_pid` (`pid`),
UNIQUE KEY `idx_pid_n` (`pid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tmp_graph`
--

DROP TABLE IF EXISTS `tmp_graph`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmp_graph` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`endpoints` varchar(10240) NOT NULL DEFAULT '',
`counters` varchar(10240) NOT NULL DEFAULT '',
`ck` varchar(32) NOT NULL,
`time_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_ck` (`ck`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

4_graph-db-schema.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
CREATE DATABASE graph
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
USE graph;
SET NAMES utf8;

DROP TABLE if exists `graph`.`endpoint`;
CREATE TABLE `graph`.`endpoint` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`endpoint` varchar(255) NOT NULL DEFAULT '',
`ts` int(11) DEFAULT NULL,
`t_create` DATETIME NOT NULL COMMENT 'create time',
`t_modify` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last modify time',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_endpoint` (`endpoint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE if exists `graph`.`endpoint_counter`;
CREATE TABLE `graph`.`endpoint_counter` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`endpoint_id` int(10) unsigned NOT NULL,
`counter` varchar(255) NOT NULL DEFAULT '',
`step` int(11) not null default 60 comment 'in second',
`type` varchar(16) not null comment 'GAUGE|COUNTER|DERIVE',
`ts` int(11) DEFAULT NULL,
`t_create` DATETIME NOT NULL COMMENT 'create time',
`t_modify` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last modify time',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_endpoint_id_counter` (`endpoint_id`, `counter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE if exists `graph`.`tag_endpoint`;
CREATE TABLE `graph`.`tag_endpoint` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tag` varchar(255) NOT NULL DEFAULT '' COMMENT 'srv=tv',
`endpoint_id` int(10) unsigned NOT NULL,
`ts` int(11) DEFAULT NULL,
`t_create` DATETIME NOT NULL COMMENT 'create time',
`t_modify` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last modify time',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_tag_endpoint_id` (`tag`, `endpoint_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

5_alarms-db-schema.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
CREATE DATABASE alarms
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
USE alarms;
SET NAMES utf8;

/*
* 建立告警归档资料表, 主要存储各个告警的最后触发状况
*/
DROP TABLE IF EXISTS event_cases;
CREATE TABLE IF NOT EXISTS event_cases(
id VARCHAR(50),
endpoint VARCHAR(100) NOT NULL,
metric VARCHAR(200) NOT NULL,
func VARCHAR(50),
cond VARCHAR(200) NOT NULL,
note VARCHAR(500),
max_step int(10) unsigned,
current_step int(10) unsigned,
priority INT(6) NOT NULL,
status VARCHAR(20) NOT NULL,
timestamp Timestamp NOT NULL,
update_at Timestamp NULL DEFAULT NULL,
closed_at Timestamp NULL DEFAULT NULL,
closed_note VARCHAR(250),
user_modified int(10) unsigned,
tpl_creator VARCHAR(64),
expression_id int(10) unsigned,
strategy_id int(10) unsigned,
template_id int(10) unsigned,
process_note MEDIUMINT,
process_status VARCHAR(20) DEFAULT 'unresolved',
PRIMARY KEY (id),
INDEX (endpoint, strategy_id, template_id)
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8;


/*
* 建立告警归档资料表, 存储各个告警触发状况的历史状态
*/
DROP TABLE IF EXISTS events;
CREATE TABLE IF NOT EXISTS events (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
event_caseId VARCHAR(50),
step int(10) unsigned,
cond VARCHAR(200) NOT NULL,
status int(3) unsigned DEFAULT 0,
timestamp Timestamp,
PRIMARY KEY (id),
INDEX(event_caseId),
FOREIGN KEY (event_caseId) REFERENCES event_cases(id)
ON DELETE CASCADE
ON UPDATE CASCADE
)
ENGINE =InnoDB
DEFAULT CHARSET =utf8;

/*
* 告警留言表
*/
CREATE TABLE IF NOT EXISTS event_note (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
event_caseId VARCHAR(50),
note VARCHAR(300),
case_id VARCHAR(20),
status VARCHAR(15),
timestamp Timestamp,
user_id int(10) unsigned,
PRIMARY KEY (id),
INDEX (event_caseId),
FOREIGN KEY (event_caseId) REFERENCES event_cases(id)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (user_id) REFERENCES uic.user(id)
ON DELETE CASCADE
ON UPDATE CASCADE
);

常用比较重要的表

  • falcon_portal.strategy 报警规则表

======================================================
希望各位朋友支持一下

本文作者:dongsheng
本文地址https://mds1455975151.github.io/archives/75152a89.html
版权声明:转载请注明出处!

坚持技术分享,您的支持将鼓励我继续创作!