PUB_ALERTMESSAGE
预警消息返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ACCOUNTPKVARCHAR230     
2ALERTNAMEVARCHAR21024     
3BELONG_SYSTEMVARCHAR220     
4CREATEDATECHAR19     
5CREATETIMECHAR8     
6CURLANGVARCHAR220     
7DRNUMBER100  0 
8FILECONTENTBLOB4000     
9FILENAMEVARCHAR280     
10GROUPIDVARCHAR220   '~' 
11IMPLEMENTTYPENUMBER380    
12ISNEWCHAR1     
13ISTIMINGCHAR1     
14MESSAGEVARCHAR2256     
15PK_ALERTMESSAGECHAR20    主键
16PK_ALERTREGISTRYCHAR20   '~' 
17PK_MESSAGECHAR20     
18PRIORITYNUMBER380    
19RECEIVERIDVARCHAR230     
20RECEIVERNAMEVARCHAR250     
21SENDDATECHAR19     
22SENDMETHODNUMBER380    
23SENDTIMECHAR8     
24SENTDATECHAR19     
25SENTTIMECHAR8     
26TRIGGERMETHODNUMBER380    
27TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')