PM_OBJECTIVE 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ALIGNDATE | DATE | 7 | | | | √ | | |
2 | CHALLENGE | VARCHAR2 | 600 | | | | √ | | |
3 | CLASSNAME | VARCHAR2 | 600 | | | | √ | | |
4 | COMPLETION | VARCHAR2 | 600 | | | | √ | | |
5 | CREATIONTIME | DATE | 7 | | | | √ | | |
6 | CREATOR | VARCHAR2 | 36 | | | | √ | | |
7 | DEADLINE | DATE | 7 | | | | √ | | |
8 | DESCRIPTION | VARCHAR2 | 600 | | | | √ | | |
9 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
10 | EDATE | DATE | 7 | | | | √ | | |
11 | FEEDBACKTIME | DATE | 7 | | | | √ | | |
12 | FULLPATH | VARCHAR2 | 765 | | | | √ | | |
13 | ID | VARCHAR2 | 32 | | √ | | | | |
14 | IMPORTANCE | NUMBER | 38 | 0 | | | √ | | |
15 | INDICATORID | VARCHAR2 | 32 | | | | √ | | |
16 | ISALIGN | NUMBER | 38 | 0 | | | √ | | |
17 | ISOVER | NUMBER | 38 | 0 | | | | 0 | |
18 | ISRISK | NUMBER | 38 | 0 | | | | 0 | |
19 | METRICS | VARCHAR2 | 600 | | | | √ | | |
20 | MODIFIEDTIME | DATE | 7 | | | | √ | | |
21 | MODIFIER | VARCHAR2 | 36 | | | | √ | | |
22 | NAME | VARCHAR2 | 120 | | | | √ | | |
23 | NEWFEEDBACK | NUMBER | 38 | 0 | | | | 0 | |
24 | OBJECTIVENUMBER | NUMBER | 38 | 0 | | √ | √ | | |
25 | OBJECTIVETYPE | NUMBER | 38 | 0 | | | | 0 | |
26 | ORGID | VARCHAR2 | 660 | | | | √ | | |
27 | PARENTID | VARCHAR2 | 32 | | | | √ | | |
28 | PERIODID | VARCHAR2 | 32 | | | | √ | | |
29 | RATE | NUMBER | 38 | 0 | | | √ | | |
30 | SCOPETYPE | NUMBER | 38 | 0 | | | | 0 | |
31 | SDATE | DATE | 7 | | | | √ | | |
32 | STAFFID | VARCHAR2 | 36 | | | | √ | | |
33 | STATE | NUMBER | 38 | 0 | | | √ | | |
34 | TENANTID | VARCHAR2 | 32 | | | | √ | | |
35 | TS | DATE | 7 | | | | √ | sysdate | |
36 | UPDATEDATE | DATE | 7 | | | | √ | | |
|