TS_ATTEND_RULE 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ALLOW_LEGWORK | CHAR | 1 | | | | √ | | |
2 | ATTEND_PERIOD | VARCHAR2 | 36 | | | | √ | | |
3 | BUSIORG | VARCHAR2 | 36 | | | | √ | | |
4 | CHANGESCHEDUDAY | NUMBER | 38 | 0 | | | √ | | |
5 | CHANGESHIFT | CHAR | 1 | | | | √ | | |
6 | COMMIT_LEGWORK_APPROVE | CHAR | 1 | | | | √ | | |
7 | CREATIONTIME | DATE | 7 | | | | √ | | |
8 | CREATOR | VARCHAR2 | 36 | | | | √ | | |
9 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
10 | ID | VARCHAR2 | 36 | | √ | | | | |
11 | IS_CALCULATE | CHAR | 1 | | | | √ | | |
12 | IS_FACE_DETECT | CHAR | 1 | | | | √ | | |
13 | IS_LATE_EARLY_NOTICE | CHAR | 1 | | | | √ | | |
14 | IS_WORK_SHIFT | CHAR | 1 | | | | √ | | |
15 | ISENABLE | CHAR | 1 | | | | √ | | |
16 | LEGWORK_APPROVE_TYPE | CHAR | 1 | | | | √ | | |
17 | LIMIT_TIME | NUMBER | 38 | 0 | | | √ | | |
18 | LOOSE_CLASSES_MONTH | CHAR | 1 | | | | √ | | |
19 | MOBILE_SCHEDULE | CHAR | 1 | | | | √ | | |
20 | MODIFIEDTIME | DATE | 7 | | | | √ | | |
21 | MODIFIER | VARCHAR2 | 36 | | | | √ | | |
22 | NOTICE_TYPE | CHAR | 1 | | | | √ | | |
23 | OVERTIME_APPROVAL | CHAR | 1 | | | | √ | | |
24 | REPLACESHIFT | CHAR | 1 | | | | √ | | |
25 | ROLE_ID | VARCHAR2 | 36 | | | | √ | | |
26 | ROLE_NAME | VARCHAR2 | 36 | | | | √ | | |
27 | SHIFT_ID | VARCHAR2 | 400 | | | | √ | | |
28 | SHIFT_ID_NAME | VARCHAR2 | 36 | | | | √ | | |
29 | SHIFT_MODE_FIX | CHAR | 1 | | | | √ | | |
30 | SHIFT_NAME | VARCHAR2 | 100 | | | | √ | | |
31 | SPACE_ID | VARCHAR2 | 36 | | | | √ | | |
32 | SWITCHSHIFT | CHAR | 1 | | | | √ | | |
33 | TENANTID | VARCHAR2 | 36 | | | | √ | | |
34 | TIMES_PER_MONTH | NUMBER | 38 | 0 | | | √ | | |
35 | TS | DATE | 7 | | | | √ | sysdate | |
36 | USE_PLACE | CHAR | 1 | | | | √ | | |
37 | USE_WIFI | CHAR | 1 | | | | √ | | |
38 | WORK_CALENDAR_ID | VARCHAR2 | 36 | | | | √ | | |
39 | WORK_CALENDAR_NAME | VARCHAR2 | 36 | | | | √ | | |
40 | WORKHOUR | CHAR | 1 | | | | √ | | |
|