TS_ATTEND_RECORD

TS_ATTEND_RECORD
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ADDRESS_DETAIL	VARCHAR2	200				√
2	APP_NAME	VARCHAR2	200				√
3	APPLY_TYPE	NUMBER	38	0			√
4	APPROVE_STATUS	NUMBER	38	0			√
5	APPROVER	VARCHAR2	36				√
6	APPROVER_NAME	VARCHAR2	128				√
7	ATTENDANCE_TYPE	NUMBER	38	0			√
8	BU_ID	VARCHAR2	36				√
9	CREATIONTIME	DATE	7				√
10	CREATOR	VARCHAR2	36				√
11	DEPT_ID	VARCHAR2	36				√
12	DEPT_NAME	VARCHAR2	128				√
13	DEVICE_ID	VARCHAR2	50				√
14	DEVICE_NAME	VARCHAR2	50				√
15	DR	NUMBER	10	0			√	0
16	FILEPATH	VARCHAR2	1024				√
17	ID	VARCHAR2	36		√
18	INSTANCEID	VARCHAR2	36				√
19	IS_ROOT	NUMBER	38	0			√
20	ISOUTSIDE	NUMBER	38	0			√
21	LAT	NUMBER	16	6			√
22	LNG	NUMBER	16	6			√
23	MANUAL_FILL	NUMBER	38	0			√	0
24	MEMBER_ID	VARCHAR2	50				√
25	MODIFIEDTIME	DATE	7				√
26	MODIFIER	VARCHAR2	36				√
27	ORG_ID	VARCHAR2	36				√
28	ORG_NAME	VARCHAR2	128				√
29	ORIG_SIGN_TIME	DATE	7				√
30	OUTSIDE_PROJECT_ID	VARCHAR2	36				√
31	OUTSIDE_PROJECT_NAME	VARCHAR2	256				√
32	OUTSIDE_TYPE	VARCHAR2	36				√
33	OUTSIDE_TYPENAME	VARCHAR2	20				√
34	OUTSIDEPLACE	VARCHAR2	128				√
35	PLACE_ID	VARCHAR2	36				√
36	PLACE_NAME	VARCHAR2	200				√
37	REMARK	VARCHAR2	512				√
38	SHIFT_ID	VARCHAR2	36				√
39	SHIFT_NAME	VARCHAR2	50				√
40	SIGN_STATUS	NUMBER	38	0			√
41	SIGN_TIME	DATE	7				√
42	SIGN_TYPE	NUMBER	38	0			√
43	SIGNDATE	DATE	7				√
44	SPACE_ID	VARCHAR2	36				√
45	STAFF_CODE	VARCHAR2	50				√
46	STAFF_ID	VARCHAR2	36				√
47	STAFF_NAME	VARCHAR2	50				√
48	STAFFJOB_ID	VARCHAR2	36				√
49	TENANTID	VARCHAR2	36				√
50	TS	DATE	7				√	sysdate