PM_SCHEME 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ABSTENTIONMODE | NUMBER | 38 | 0 | | | √ | | |
2 | APPLYOBJ | NUMBER | 38 | 0 | | | √ | | |
3 | CREATIONTIME | DATE | 7 | | | | √ | | |
4 | CREATOR | VARCHAR2 | 36 | | | | √ | | |
5 | DISTID | VARCHAR2 | 32 | | | | √ | | |
6 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
7 | FDATE | DATE | 7 | | | | √ | | |
8 | GRADEID | VARCHAR2 | 32 | | | | | | |
9 | ID | VARCHAR2 | 32 | | √ | | | | |
10 | ISALLOWFILLUP | NUMBER | 38 | 0 | | | | | |
11 | ISDOUBLEWEIGHT | NUMBER | 38 | 0 | | | | 0 | |
12 | ISMERGEMSG | NUMBER | 38 | 0 | | | | 0 | |
13 | ISRESULTAUDITED | NUMBER | 38 | 0 | | | | | |
14 | ISTURN | NUMBER | 38 | 0 | | | | | |
15 | MODIFIEDTIME | DATE | 7 | | | | √ | | |
16 | MODIFIER | VARCHAR2 | 36 | | | | √ | | |
17 | ORGID | VARCHAR2 | 165 | | | | | '' | |
18 | PERIODCODE | VARCHAR2 | 13 | | | | | | |
19 | PERIODID | VARCHAR2 | 32 | | | | | | |
20 | REMARK | VARCHAR2 | 600 | | | | √ | | |
21 | SCHEMECODE | VARCHAR2 | 20 | | | | √ | | |
22 | SCHEMEMODE | NUMBER | 38 | 0 | | | √ | | |
23 | SCHEMENAME | VARCHAR2 | 120 | | | | | | |
24 | SCHEMESTATE | NUMBER | 38 | 0 | | | √ | | |
25 | SCORERULEID | VARCHAR2 | 32 | | | | √ | | |
26 | SCOREWAY | NUMBER | 38 | 0 | | | √ | | |
27 | TDATE | DATE | 7 | | | | √ | | |
28 | TENANTID | VARCHAR2 | 32 | | | | √ | | |
29 | TS | DATE | 7 | | | | √ | sysdate | |
|