TS_SHIFT

TS_SHIFT
班次返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ABNORMAL_BEGTIME	DATE	7				√
2	ABNORMAL_ENDTIME	DATE	7				√
3	ALLOW_EARLY_LEN	NUMBER	38	0			√
4	ALLOW_LATE_LEN	NUMBER	38	0			√
5	BEGINDAY	NUMBER	38	0			√
6	BEGINTIME	DATE	7				√
7	BUSIORG	VARCHAR2	36				√
8	CODE	VARCHAR2	128				√		编码
9	COLOR	VARCHAR2	128				√
10	CREATIONTIME	DATE	7				√
11	CREATOR	VARCHAR2	36				√
12	DEDUCTOT_STR	VARCHAR2	128				√
13	DR	NUMBER	10	0			√	0
14	EARLYLEN_ISABSENT	NUMBER	38	0			√
15	ELASTIC_RULE	NUMBER	38	0			√
16	ENDDAY	NUMBER	38	0			√
17	ENDTIME	DATE	7				√
18	FIXEDTIME	NUMBER	18	2			√
19	ID	VARCHAR2	36		√				主键
20	ISDEDUCTREST	NUMBER	38	0			√
21	ISDEDUCTRESTSIGN	NUMBER	38	0			√
22	ISDEDUOVERTIME	NUMBER	38	0			√
23	ISDEFAULT	NUMBER	38	0			√
24	ISENABLE	NUMBER	38	0			√
25	ISSHOWFLAG	NUMBER	38	0			√
26	ISSYSFLAG	NUMBER	38	0			√
27	LATELEN_ISABSENT	NUMBER	38	0			√
28	MODIFIEDTIME	DATE	7				√
29	MODIFIER	VARCHAR2	36				√
30	REST_BEGTIME	DATE	7				√
31	REST_BEGTIME2	DATE	7				√
32	REST_BEGTIME3	DATE	7				√
33	REST_ENDTIME	DATE	7				√
34	REST_ENDTIME2	DATE	7				√
35	REST_ENDTIME3	DATE	7				√
36	REST_OVERTIME_BEGINDAY	NUMBER	38	0			√
37	REST_OVERTIME_BEGINTIME	DATE	7				√
38	REST_OVERTIME_ENDDAY	NUMBER	38	0			√
39	REST_OVERTIME_ENDTIME	DATE	7				√
40	RESTBEGINDAY	NUMBER	38	0			√
41	RESTBEGINDAY2	NUMBER	38	0			√
42	RESTBEGINDAY3	NUMBER	38	0			√
43	RESTENDDAY	NUMBER	38	0			√
44	RESTENDDAY2	NUMBER	38	0			√
45	RESTENDDAY3	NUMBER	38	0			√
46	SHIFT_TYPE	NUMBER	38	0			√
47	SHIFTNAME	VARCHAR2	128				√		名称
48	SIGN_BEGINDAY	NUMBER	38	0			√
49	SIGN_BEGINTIME	DATE	7				√
50	SIGN_ENDDAY	NUMBER	38	0			√
51	SIGN_ENDTIME	DATE	7				√
52	SPACE_ID	VARCHAR2	36				√
53	TENANTID	VARCHAR2	36				√
54	TS	DATE	7				√	sysdate
55	TYPE	VARCHAR2	36				√
56	WORK_HOURS	NUMBER	4	2			√