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
DROP TABLE IF EXISTS t_alarm_event;
CREATE TABLE t_alarm_event (
id serial NOT NULL ,
alarm_device_type int NOT NULL ,
alarm_event int NOT NULL ,
alarm_device_code varchar(100) NOT NULL ,
alarm_device_name varchar(64) NOT NULL ,
alarm_time date NOT NULL,
alarm_cause varchar(100) DEFAULT NULL ,
alarm_source int DEFAULT NULL ,
create_by varchar(30) DEFAULT NULL ,
modify_by varchar(30) DEFAULT NULL ,
create_time date DEFAULT NULL ,
modify_time date DEFAULT NULL ,
logic_del int DEFAULT 0 ,
PRIMARY KEY (id)
) ;
comment on table t_alarm_event is '设备告警事件表';
comment on column t_alarm_event.id is '主键id';
comment on column t_alarm_event.alarm_device_type is '告警设备类型【数据字典表；ALARM_TYPE】';
comment on column t_alarm_event.alarm_event is '告警事件【数据字典表；ALARM_EVENT】';
comment on column t_alarm_event.alarm_device_code is '告警设备编号';
comment on column t_alarm_event.alarm_device_name is '告警设备名称';
comment on column t_alarm_event.alarm_time is '告警时间';
comment on column t_alarm_event.alarm_cause is '告警原因';
comment on column t_alarm_event.alarm_source is '告警来源【1：设备推送。2：内部ping】';
comment on column t_alarm_event.create_by is '创建人';
comment on column t_alarm_event.modify_by is '修改人';
comment on column t_alarm_event.modify_time is '修改时间';
comment on column t_alarm_event.create_time is '创建时间';
comment on column t_alarm_event.logic_del is '0:未删除，1：已删除';
DROP TABLE IF EXISTS t_device;
CREATE TABLE t_device (
id serial NOT NULL ,
device_type int4 NOT NULL ,
device_code varchar(100) NOT NULL ,
device_name varchar(64) NOT NULL ,
device_brand varchar(64) NOT NULL ,
device_model varchar(64) NOT NULL ,
device_ip varchar(64) NOT NULL ,
install_position varchar(64) DEFAULT NULL ,
network_access_time date DEFAULT NULL,
maintenance_input_year int4 DEFAULT NULL ,
is_online int DEFAULT 1 ,
maintenance_time int DEFAULT NULL ,
create_by varchar(30) DEFAULT NULL ,
modify_by varchar(30) DEFAULT NULL,
create_time date DEFAULT NULL ,
modify_time date DEFAULT NULL ,
logic_del int DEFAULT 0 ,
PRIMARY KEY (id)
);
comment on table t_device is '设备表';
comment on column t_device.id is '主键id';
comment on column t_device.device_type is '设备类型';
comment on column t_device.device_code is '设备编号';
comment on column t_device.device_name is '设备名称';
comment on column t_device.device_brand is '设备品牌';
comment on column t_device.device_model is '设备型号';
comment on column t_device.device_ip is '设备ip';
comment on column t_device.install_position is '设备安装位置';
comment on column t_device.network_access_time is '设备入网时间';
comment on column t_device.maintenance_input_year is '维保其他输入年';
comment on column t_device.is_online is '是否在线【1：在线。2：离线】';
comment on column t_device.maintenance_time is '维保时间【数据字典表:WB_TIME】';
comment on column t_device.create_by is '创建人';
comment on column t_device.modify_by is '修改人';
comment on column t_device.modify_time is '修改时间';
comment on column t_device.create_time is '创建时间';
comment on column t_device.logic_del is '0:未删除，1：已删除';
DROP TABLE IF EXISTS t_devops_tool;
CREATE TABLE t_devops_tool (
id serial NOT NULL ,
ip_address varchar(20) NOT NULL ,
result int NOT NULL,
create_by varchar(30) DEFAULT NULL,
modify_by varchar(30) DEFAULT NULL ,
create_time date DEFAULT NULL ,
modify_time date DEFAULT NULL,
logic_del int DEFAULT 0 ,
PRIMARY KEY (id)
) ;
COMMENT on table t_devops_tool is '运维工具表' ;
COMMENT on column t_devops_tool.ip_address is 'ip地址' ;
COMMENT on column t_devops_tool.result is '结果【1：通过，2：未通过】' ;
comment on column t_devops_tool.create_by is '创建人';
comment on column t_devops_tool.modify_by is '修改人';
comment on column t_devops_tool.modify_time is '修改时间';
comment on column t_devops_tool.create_time is '创建时间';
comment on column t_devops_tool.logic_del is '0:未删除，1：已删除';
DROP TABLE IF EXISTS t_dict;
CREATE TABLE t_dict (
id int NOT NULL ,
dict_name varchar(20) NOT NULL ,
dict_value varchar(100) NOT NULL ,
dict_code varchar(20) NOT NULL ,
dict_type_id int DEFAULT NULL ,
create_by varchar(30) DEFAULT NULL ,
modify_by varchar(30) DEFAULT NULL ,
create_time date DEFAULT NULL ,
modify_time date DEFAULT NULL ,
logic_del int DEFAULT 0 ,
PRIMARY KEY (id)
);
COMMENT on table t_dict is '数据字典' ;
COMMENT on column t_dict.dict_name is '数据字典名称' ;
COMMENT on column t_dict.dict_value is '数据字典值' ;
COMMENT on column t_dict.dict_code is '数据字典类型表编码' ;
COMMENT on column t_dict.dict_type_id is '数据字典类型表id';
comment on column t_dict.create_by is '创建人';
comment on column t_dict.modify_by is '修改人';
comment on column t_dict.modify_time is '修改时间';
comment on column t_dict.create_time is '创建时间';
comment on column t_dict.logic_del is '0:未删除，1：已删除';
DROP TABLE IF EXISTS t_dict_type;
CREATE TABLE t_dict_type (
id serial NOT NULL ,
dict_code varchar(20) NOT NULL ,
create_by varchar(30) DEFAULT NULL ,
modify_by varchar(30) DEFAULT NULL ,
create_time date DEFAULT NULL ,
modify_time date DEFAULT NULL,
logic_del int DEFAULT 0,
PRIMARY KEY (id)
) ;
DROP TABLE IF EXISTS t_menu;
CREATE TABLE t_menu (
id serial NOT NULL ,
menu_name varchar(30) NOT NULL ,
component varchar(255) NOT NULL ,
menu_url varchar(255) NOT NULL ,
menu_code varchar(30) NOT NULL ,
menu_auth varchar(50) ,
order_no int DEFAULT NULL ,
parent_key int NOT NULL,
create_by varchar(30) DEFAULT NULL ,
modify_by varchar(30) DEFAULT NULL,
create_time date DEFAULT NULL ,
modify_time date DEFAULT NULL,
logic_del int DEFAULT 0 ,
PRIMARY KEY (id)
) ;
COMMENT on table t_menu is '菜单表' ;
COMMENT on column t_menu.menu_name is '菜单名称' ;
COMMENT on column t_menu.component is '菜单组件' ;
COMMENT on column t_menu.menu_url is '菜单地址' ;
COMMENT on column t_menu.menu_code is '菜单编码';
COMMENT on column t_menu.menu_auth is '菜单权限（后端）';
COMMENT on column t_menu.order_no is '菜单顺序';
COMMENT on column t_menu.parent_key is '所属上级';
comment on column t_menu.create_by is '创建人';
comment on column t_menu.modify_by is '修改人';
comment on column t_menu.modify_time is '修改时间';
comment on column t_menu.create_time is '创建时间';
comment on column t_menu.logic_del is '0:未删除，1：已删除';