PUB_ALERTREGISTRY 预警条目与后台任务返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ACCOUNTPK | VARCHAR2 | 30 | | | | √ | | 帐套主键 |
2 | ALERTNAME | VARCHAR2 | 80 | | | | √ | | 预警条目名称 |
3 | ALERTNAME2 | VARCHAR2 | 80 | | | | √ | | 预警条目名称2 |
4 | ALERTNAME3 | VARCHAR2 | 80 | | | | √ | | 预警条目名称3 |
5 | ALERTNAME4 | VARCHAR2 | 80 | | | | √ | | 预警条目名称4 |
6 | ALERTNAME5 | VARCHAR2 | 80 | | | | √ | | 预警条目名称5 |
7 | ALERTNAME6 | VARCHAR2 | 80 | | | | √ | | 预警条目名称6 |
8 | CLUSTERFLAG | VARCHAR2 | 200 | | | | √ | | |
9 | CREATOR | VARCHAR2 | 20 | | | | √ | | 创建者 |
10 | CURLANG | VARCHAR2 | 20 | | | | √ | | |
11 | DESCRIPTION | VARCHAR2 | 256 | | | | √ | | 描述 |
12 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
13 | ENABLED | CHAR | 1 | | | | √ | | 是否启用 |
14 | FILENAME | VARCHAR2 | 80 | | | | √ | | 消息文件名前缀 |
15 | GROUPID | VARCHAR2 | 20 | | | | √ | '~' | 集团ID |
16 | ISMESSAGETEMPLATE | CHAR | 1 | | | | √ | | |
17 | ISTIMING | CHAR | 1 | | | | √ | | 是否即时 |
18 | MAXLOGS | NUMBER | 38 | 0 | | | √ | | 最大日志数 |
19 | MESSAGE | VARCHAR2 | 512 | | | | √ | | 消息title |
20 | MESSAGEFILE | VARCHAR2 | 128 | | | | √ | | 实际消息文件名称 |
21 | MSGTITLE | VARCHAR2 | 200 | | | | √ | | |
22 | MSGTITLE2 | VARCHAR2 | 200 | | | | √ | | |
23 | MSGTITLE3 | VARCHAR2 | 200 | | | | √ | | |
24 | PK_ALERTREGISTRY | CHAR | 20 | | √ | | | | 主键 |
25 | PK_ALERTTYPE | VARCHAR2 | 20 | | | | √ | '~' | 预警类型主键 |
26 | PK_MESSAGETEMPLATE | VARCHAR2 | 50 | | | | √ | | 消息模板主键 |
27 | PK_ORG | VARCHAR2 | 50 | | | | √ | | 业务单元主键 |
28 | PUSHABLE | CHAR | 1 | | | | √ | | |
29 | REGISTRYTYPE | NUMBER | 38 | 0 | | | √ | | 任务类型 |
30 | REPORTLIKEWORK | BLOB | 4000 | | | | √ | | 异步报表体 |
31 | SCHEDULETASKID | VARCHAR2 | 30 | | | | √ | | 异步任务id |
32 | SERVERNAME | VARCHAR2 | 200 | | | | √ | | |
33 | SIMPLEMESSAGE | VARCHAR2 | 500 | | | | √ | | |
34 | SIMPLEMESSAGE2 | VARCHAR2 | 500 | | | | √ | | |
35 | SIMPLEMESSAGE3 | VARCHAR2 | 500 | | | | √ | | |
36 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
37 | WITHTRANSCATION | CHAR | 1 | | | | √ | | |
|