Project

General

Profile

Task #317

Feature #315: 报警后台服务变更：增加恢复机制和开关类报警；

TB3001_ALMH增加确认和恢复相关字段

Added by xiangyang li over 4 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
pengfei xu
Start date:
11/12/2019
Due date:
11/13/2019
% Done:

100%

Estimated time:
Defect version:

Description

表SEDATUM.TB3001_ALMH中增加相应字段：

F3001_ACKTIME number(12) 确认时间（秒）
F3001_ACKMS number(6) 确认时间（毫秒）
F3001_RSTTIME number(12) 恢复时间（秒）
F3001_RSTMS number(6) 恢复时间（毫秒）
F3001_STATE number(3) 状态（位操作：1位-告警 2位-已确认 3位-已恢复）
F3001_ACKER char(24) 确认人

（SEMASTER.SYS_FIELDINFO表中增加相应记录）
oracle/mysql 都需要增加

Files

new_column.zip (1.75 KB) new_column.zip pengfei xu, 11/13/2019 04:28 PM

History

#1

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#2

Updated by pengfei xu over 4 years ago

  • File new_column.zip added
  • Status changed from New to In Progress
  • % Done changed from 0 to 50

mysql和oracle新增字段的SQL语句。

#3

Updated by pengfei xu over 4 years ago

  • Due date set to 11/13/2019
  • Status changed from In Progress to Resolved
  • % Done changed from 50 to 100

mysql与oracle的script建表语句修改完成（修改表TB3001_ALMH，增加六个字段）

#4

Updated by pengfei xu over 4 years ago

  • File deleted (new_column.zip)
#6

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#7

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#8

Updated by pengfei xu about 4 years ago

  • Description updated (diff)
#9

Updated by xiangyang li almost 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF