TS_LEAVE_APPLY

TS_LEAVE_APPLY
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	APPLICANT	VARCHAR2	36				√
2	APPLICANTNAME	VARCHAR2	36				√
3	APPLYDATE	DATE	7				√
4	APPLYSORT	NUMBER	38	0			√
5	APPLYTYPE	NUMBER	38	0			√
6	APPROVER	VARCHAR2	36				√
7	APPROVESTATUS	NUMBER	38	0			√
8	APPROVETYPE	VARCHAR2	36				√
9	CREATIONTIME	DATE	7				√
10	CREATOR	VARCHAR2	36				√
11	DEPTAPPLYID	VARCHAR2	36				√
12	DEPTID	VARCHAR2	36				√
13	DR	NUMBER	10	0			√	0
14	END_DAY_TYPE	NUMBER	38	0			√
15	EXTENSION	VARCHAR2	200				√
16	FILEPATH	VARCHAR2	2048				√
17	ID	VARCHAR2	36		√
18	INSTANCEID	VARCHAR2	36				√
19	ISREVOKED	CHAR	1				√
20	LEAVEBEGINTIME	DATE	7				√
21	LEAVEDAY	NUMBER	16	1			√
22	LEAVEENDTIME	DATE	7				√
23	LEAVEREMARK	VARCHAR2	512				√
24	LEAVETYPEID	VARCHAR2	36				√
25	MINUNIT	CHAR	1				√
26	MODIFIEDTIME	DATE	7				√
27	MODIFIER	VARCHAR2	36				√
28	OFFAPPROVESTATUS	NUMBER	38	0			√
29	OFFINSTANCEID	VARCHAR2	36				√
30	ORGID	VARCHAR2	36				√
31	SHOWBEGINDATE	DATE	7				√
32	SHOWENDDATE	DATE	7				√
33	STAFFID	VARCHAR2	36				√
34	STAFFJOBID	VARCHAR2	36				√
35	START_DAY_TYPE	NUMBER	38	0			√
36	TENANTID	VARCHAR2	36				√
37	TS	DATE	7				√	sysdate