ER_TXMQ_MESSAGEDATA 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BIZ_ID | VARCHAR2 | 100 | | | | √ | '~' | |
2 | CHANNEL_TYPE | VARCHAR2 | 50 | | | | | | |
3 | DELAY_LEVEL | NUMBER | 38 | 0 | | | | 0 | |
4 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
5 | ID | NUMBER | 38 | 0 | √ | | | 0 | |
6 | MESSAGE_BODY | VARCHAR2 | 4000 | | | | | '' | |
7 | MESSAGE_KEY | VARCHAR2 | 300 | | | | | '' | |
8 | MESSAGE_TAG | VARCHAR2 | 500 | | | | | '' | |
9 | MESSAGE_TOPIC | VARCHAR2 | 200 | | | | | '' | |
10 | MESSAGE_TYPE | VARCHAR2 | 50 | | | | | '' | |
11 | ORDER_TYPE | NUMBER | 38 | 0 | | | | 0 | |
12 | PARENT_ID | NUMBER | 38 | 0 | | | | | |
13 | POSITION | VARCHAR2 | 50 | | | | | '' | |
14 | PRODUCER_CODE | VARCHAR2 | 50 | | | | | '' | |
15 | TASK_STATUS | VARCHAR2 | 50 | | | | | | |
16 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
17 | VERSION | NUMBER | 38 | 0 | | | | 0 | |
|