TS_ATTEND

TS_ATTEND_APPLY
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	APPLY_TYPE	NUMBER	38	0			√
2	APPLYDATE	DATE	7				√
3	APPROVE_NOTE	VARCHAR2	200				√
4	APPROVE_STATUS	NUMBER	38	0			√
5	APPROVE_TIME	DATE	7				√
6	APPROVER	VARCHAR2	36				√
7	APPROVERNAME	VARCHAR2	128				√
8	APPROVERPHOTO	VARCHAR2	256				√
9	ATTENDAPPLY_NOTE	VARCHAR2	140				√
10	ATTENDAPPLY_TYPE	VARCHAR2	36				√
11	BEGINTIME	DATE	7				√
12	BILLCODE	VARCHAR2	128				√
13	BILLNAME	VARCHAR2	128				√
14	CREATIONTIME	DATE	7				√
15	CREATOR	VARCHAR2	36				√
16	DEPT_ID	VARCHAR2	36				√
17	DEPTNAME	VARCHAR2	256				√
18	DR	NUMBER	10	0			√	0
19	ENDTIME	DATE	7				√
20	FILEPATH	VARCHAR2	128				√
21	ID	VARCHAR2	36		√
22	INSTANCEID	VARCHAR2	36				√
23	MODIFIEDTIME	DATE	7				√
24	MODIFIER	VARCHAR2	36				√
25	RESULT_ID	VARCHAR2	36				√
26	STAFF_ID	VARCHAR2	36				√
27	STAFFJOB_ID	VARCHAR2	36				√
28	SUBMITTER	VARCHAR2	36				√
29	SUBMITTERNAME	VARCHAR2	128				√
30	SUBMITTERPHOTO	VARCHAR2	256				√
31	TS	DATE	7				√	sysdate