ATS考勤1.16基础资料（班次信息、多语言、轮班规则及明细）

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

T_ATS_SHIFTINFO(班次信息)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FID	内码	int			0
	FNUMBER	编码	nvarchar	30		' '
	FSHIFTTYPE	班次类型	char	1	✓		A:用户班次B:休息班次C:默认班次D:法定假日班次
	FFIRSTCARDTIME	取卡最早时间	datetime		✓
	FFIRSTCARDUNIT	取卡最早时间单位	char	1	✓
	FLASTCARDTIME	取卡最晚时间	datetime		✓
	FLASTCARDUNIT	取卡最晚时间单位	char	1	✓
	FISREST	休息班次	char	1	✓
	FSELECTIONRULE	取卡规则	char	1	✓
	FSTANDARDLABOR	标准工时	decimal	19,6	✓
	FALLOWLATE	迟到允许值	int		✓
	FALLOWEARLY	早退允许值	int		✓
	FABSENTSTART	旷工起始值	int		✓
	FOVERSTART	加班起始值	int		✓
	FREPAYTYPE	加班补偿方式	char	1	✓
	FISNOBILLBEFORE	班前加班无需加班单	char	1	✓
	FISNOBILLAFTER	班后加班无需加班单	char	1	✓
	FISHALFDAY	半天班	char	1	✓
	FISNIGHT	夜班	char	1	✓
	FHASFOOD	餐补	char	1	✓
	FSHIFTTIME	上下班时段	nvarchar	255	✓
	FCHECKIN	最早上班时间	datetime		✓
	FCHECKINUNIT	最早上班时间单位	char	1	✓
	FCHECKOUT	最晚下班时间	datetime		✓
	FCHECKOUTUNIT	最晚下班时间单位	char	1	✓
	FISSYSPRESET	系统预置	char	1	✓
	FMGRCENTERID	人事管理中心	int		✓
	FPERSONID	人员内码	int		✓
	FCREATEORGID	创建组织	int		✓
	FUSEORGID	使用组织	int		✓
	FCREATORID	创建人	int		✓
	FCREATEDATE	创建日期	datetime		✓
	FMODIFIERID	修改人	int		✓
	FMODIFYDATE	修改日期	datetime		✓
	FAUDITORID	审核人	int		✓
	FAUDITDATE	审核日期	datetime		✓
	FFORBIDDERID	禁用人	int		✓
	FFORBIDDATE	禁用日期	datetime		✓
	FDOCUMENTSTATUS	数据状态	char	1	✓
	FFORBIDSTATUS	禁用状态	char	1	✓
	FMASTERID	FMASTERID	int		✓	0
	FOVERTYPE	加班类型	char	1	✓

--建表脚本--

create table T_ATS_SHIFTINFO(

FID int not null comment '内码'

,FNUMBER nvarchar(30) not null comment '编码'

,FSHIFTTYPE char(1) default null comment '班次类型'

,FFIRSTCARDTIME datetime default null comment '取卡最早时间'

,FFIRSTCARDUNIT char(1) default null comment '取卡最早时间单位'

,FLASTCARDTIME datetime default null comment '取卡最晚时间'

,FLASTCARDUNIT char(1) default null comment '取卡最晚时间单位'

,FISREST char(1) default null comment '休息班次'

,FSELECTIONRULE char(1) default null comment '取卡规则'

,FSTANDARDLABOR decimal(19,6) default null comment '标准工时'

,FALLOWLATE int default null comment '迟到允许值'

,FALLOWEARLY int default null comment '早退允许值'

,FABSENTSTART int default null comment '旷工起始值'

,FOVERSTART int default null comment '加班起始值'

,FREPAYTYPE char(1) default null comment '加班补偿方式'

,FISNOBILLBEFORE char(1) default null comment '班前加班无需加班单'

,FISNOBILLAFTER char(1) default null comment '班后加班无需加班单'

,FISHALFDAY char(1) default null comment '半天班'

,FISNIGHT char(1) default null comment '夜班'

,FHASFOOD char(1) default null comment '餐补'

,FSHIFTTIME nvarchar(255) default null comment '上下班时段'

,FCHECKIN datetime default null comment '最早上班时间'

,FCHECKINUNIT char(1) default null comment '最早上班时间单位'

,FCHECKOUT datetime default null comment '最晚下班时间'

,FCHECKOUTUNIT char(1) default null comment '最晚下班时间单位'

,FISSYSPRESET char(1) default null comment '系统预置'

,FMGRCENTERID int default null comment '人事管理中心'

,FPERSONID int default null comment '人员内码'

,FCREATEORGID int default null comment '创建组织'

,FUSEORGID int default null comment '使用组织'

,FCREATORID int default null comment '创建人'

,FCREATEDATE datetime default null comment '创建日期'

,FMODIFIERID int default null comment '修改人'

,FMODIFYDATE datetime default null comment '修改日期'

,FAUDITORID int default null comment '审核人'

,FAUDITDATE datetime default null comment '审核日期'

,FFORBIDDERID int default null comment '禁用人'

,FFORBIDDATE datetime default null comment '禁用日期'

,FDOCUMENTSTATUS char(1) default null comment '数据状态'

,FFORBIDSTATUS char(1) default null comment '禁用状态'

,FMASTERID int default 0 comment 'FMASTERID'

,FOVERTYPE char(1) default null comment '加班类型'

,primary key (FID)

) comment = '班次信息'

--查询--

select FID as "fid",FNUMBER as "fnumber",FSHIFTTYPE as "fshifttype",FFIRSTCARDTIME as "ffirstcardtime",FFIRSTCARDUNIT as "ffirstcardunit",FLASTCARDTIME as "flastcardtime",FLASTCARDUNIT as "flastcardunit",FISREST as "fisrest",FSELECTIONRULE as "fselectionrule",FSTANDARDLABOR as "fstandardlabor",FALLOWLATE as "fallowlate",FALLOWEARLY as "fallowearly",FABSENTSTART as "fabsentstart",FOVERSTART as "foverstart",FREPAYTYPE as "frepaytype",FISNOBILLBEFORE as "fisnobillbefore",FISNOBILLAFTER as "fisnobillafter",FISHALFDAY as "fishalfday",FISNIGHT as "fisnight",FHASFOOD as "fhasfood",FSHIFTTIME as "fshifttime",FCHECKIN as "fcheckin",FCHECKINUNIT as "fcheckinunit",FCHECKOUT as "fcheckout",FCHECKOUTUNIT as "fcheckoutunit",FISSYSPRESET as "fissyspreset",FMGRCENTERID as "fmgrcenterid",FPERSONID as "fpersonid",FCREATEORGID as "fcreateorgid",FUSEORGID as "fuseorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FMASTERID as "fmasterid",FOVERTYPE as "fovertype" from T_ATS_SHIFTINFO

--查询(中文字段)--

select FID as "内码",FNUMBER as "编码",FSHIFTTYPE as "班次类型",FFIRSTCARDTIME as "取卡最早时间",FFIRSTCARDUNIT as "取卡最早时间单位",FLASTCARDTIME as "取卡最晚时间",FLASTCARDUNIT as "取卡最晚时间单位",FISREST as "休息班次",FSELECTIONRULE as "取卡规则",FSTANDARDLABOR as "标准工时",FALLOWLATE as "迟到允许值",FALLOWEARLY as "早退允许值",FABSENTSTART as "旷工起始值",FOVERSTART as "加班起始值",FREPAYTYPE as "加班补偿方式",FISNOBILLBEFORE as "班前加班无需加班单",FISNOBILLAFTER as "班后加班无需加班单",FISHALFDAY as "半天班",FISNIGHT as "夜班",FHASFOOD as "餐补",FSHIFTTIME as "上下班时段",FCHECKIN as "最早上班时间",FCHECKINUNIT as "最早上班时间单位",FCHECKOUT as "最晚下班时间",FCHECKOUTUNIT as "最晚下班时间单位",FISSYSPRESET as "系统预置",FMGRCENTERID as "人事管理中心",FPERSONID as "人员内码",FCREATEORGID as "创建组织",FUSEORGID as "使用组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FMASTERID as "FMASTERID",FOVERTYPE as "加班类型" from T_ATS_SHIFTINFO

--INSERT脚本--

insert into T_ATS_SHIFTINFO(FID,FNUMBER,FSHIFTTYPE,FFIRSTCARDTIME,FFIRSTCARDUNIT,FLASTCARDTIME,FLASTCARDUNIT,FISREST,FSELECTIONRULE,FSTANDARDLABOR,FALLOWLATE,FALLOWEARLY,FABSENTSTART,FOVERSTART,FREPAYTYPE,FISNOBILLBEFORE,FISNOBILLAFTER,FISHALFDAY,FISNIGHT,FHASFOOD,FSHIFTTIME,FCHECKIN,FCHECKINUNIT,FCHECKOUT,FCHECKOUTUNIT,FISSYSPRESET,FMGRCENTERID,FPERSONID,FCREATEORGID,FUSEORGID,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDDERID,FFORBIDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS,FMASTERID,FOVERTYPE) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_SHIFTINFO set FID=?,FNUMBER=?,FSHIFTTYPE=?,FFIRSTCARDTIME=?,FFIRSTCARDUNIT=?,FLASTCARDTIME=?,FLASTCARDUNIT=?,FISREST=?,FSELECTIONRULE=?,FSTANDARDLABOR=?,FALLOWLATE=?,FALLOWEARLY=?,FABSENTSTART=?,FOVERSTART=?,FREPAYTYPE=?,FISNOBILLBEFORE=?,FISNOBILLAFTER=?,FISHALFDAY=?,FISNIGHT=?,FHASFOOD=?,FSHIFTTIME=?,FCHECKIN=?,FCHECKINUNIT=?,FCHECKOUT=?,FCHECKOUTUNIT=?,FISSYSPRESET=?,FMGRCENTERID=?,FPERSONID=?,FCREATEORGID=?,FUSEORGID=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FMASTERID=?,FOVERTYPE=? where FID=?

--delete脚本--

delete from T_ATS_SHIFTINFO where FID=?

--给字段加备注--

alter table T_ATS_SHIFTINFO comment '班次信息';

alter table T_ATS_SHIFTINFO modify column FID int not null comment '内码';

alter table T_ATS_SHIFTINFO modify column FNUMBER nvarchar(30) not null comment '编码';

alter table T_ATS_SHIFTINFO modify column FSHIFTTYPE char(1) default null comment '班次类型';

alter table T_ATS_SHIFTINFO modify column FFIRSTCARDTIME datetime default null comment '取卡最早时间';

alter table T_ATS_SHIFTINFO modify column FFIRSTCARDUNIT char(1) default null comment '取卡最早时间单位';

alter table T_ATS_SHIFTINFO modify column FLASTCARDTIME datetime default null comment '取卡最晚时间';

alter table T_ATS_SHIFTINFO modify column FLASTCARDUNIT char(1) default null comment '取卡最晚时间单位';

alter table T_ATS_SHIFTINFO modify column FISREST char(1) default null comment '休息班次';

alter table T_ATS_SHIFTINFO modify column FSELECTIONRULE char(1) default null comment '取卡规则';

alter table T_ATS_SHIFTINFO modify column FSTANDARDLABOR decimal(19,6) default null comment '标准工时';

alter table T_ATS_SHIFTINFO modify column FALLOWLATE int default null comment '迟到允许值';

alter table T_ATS_SHIFTINFO modify column FALLOWEARLY int default null comment '早退允许值';

alter table T_ATS_SHIFTINFO modify column FABSENTSTART int default null comment '旷工起始值';

alter table T_ATS_SHIFTINFO modify column FOVERSTART int default null comment '加班起始值';

alter table T_ATS_SHIFTINFO modify column FREPAYTYPE char(1) default null comment '加班补偿方式';

alter table T_ATS_SHIFTINFO modify column FISNOBILLBEFORE char(1) default null comment '班前加班无需加班单';

alter table T_ATS_SHIFTINFO modify column FISNOBILLAFTER char(1) default null comment '班后加班无需加班单';

alter table T_ATS_SHIFTINFO modify column FISHALFDAY char(1) default null comment '半天班';

alter table T_ATS_SHIFTINFO modify column FISNIGHT char(1) default null comment '夜班';

alter table T_ATS_SHIFTINFO modify column FHASFOOD char(1) default null comment '餐补';

alter table T_ATS_SHIFTINFO modify column FSHIFTTIME nvarchar(255) default null comment '上下班时段';

alter table T_ATS_SHIFTINFO modify column FCHECKIN datetime default null comment '最早上班时间';

alter table T_ATS_SHIFTINFO modify column FCHECKINUNIT char(1) default null comment '最早上班时间单位';

alter table T_ATS_SHIFTINFO modify column FCHECKOUT datetime default null comment '最晚下班时间';

alter table T_ATS_SHIFTINFO modify column FCHECKOUTUNIT char(1) default null comment '最晚下班时间单位';

alter table T_ATS_SHIFTINFO modify column FISSYSPRESET char(1) default null comment '系统预置';

alter table T_ATS_SHIFTINFO modify column FMGRCENTERID int default null comment '人事管理中心';

alter table T_ATS_SHIFTINFO modify column FPERSONID int default null comment '人员内码';

alter table T_ATS_SHIFTINFO modify column FCREATEORGID int default null comment '创建组织';

alter table T_ATS_SHIFTINFO modify column FUSEORGID int default null comment '使用组织';

alter table T_ATS_SHIFTINFO modify column FCREATORID int default null comment '创建人';

alter table T_ATS_SHIFTINFO modify column FCREATEDATE datetime default null comment '创建日期';

alter table T_ATS_SHIFTINFO modify column FMODIFIERID int default null comment '修改人';

alter table T_ATS_SHIFTINFO modify column FMODIFYDATE datetime default null comment '修改日期';

alter table T_ATS_SHIFTINFO modify column FAUDITORID int default null comment '审核人';

alter table T_ATS_SHIFTINFO modify column FAUDITDATE datetime default null comment '审核日期';

alter table T_ATS_SHIFTINFO modify column FFORBIDDERID int default null comment '禁用人';

alter table T_ATS_SHIFTINFO modify column FFORBIDDATE datetime default null comment '禁用日期';

alter table T_ATS_SHIFTINFO modify column FDOCUMENTSTATUS char(1) default null comment '数据状态';

alter table T_ATS_SHIFTINFO modify column FFORBIDSTATUS char(1) default null comment '禁用状态';

alter table T_ATS_SHIFTINFO modify column FMASTERID int default 0 comment 'FMASTERID';

alter table T_ATS_SHIFTINFO modify column FOVERTYPE char(1) default null comment '加班类型';

T_ATS_SHIFTINFO_L(班次信息多语言)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FPKID	多语言内码	int			0
	FID	班次信息内码	int		✓
	FLOCALEID	语种	int		✓
	FDESCRIPTION	备注	nvarchar	255		' '
	FNAME	班次名称	nvarchar	80		' '

--建表脚本--

create table T_ATS_SHIFTINFO_L(

FPKID int not null comment '多语言内码'

,FID int default null comment '班次信息内码'

,FLOCALEID int default null comment '语种'

,FDESCRIPTION nvarchar(255) not null comment '备注'

,FNAME nvarchar(80) not null comment '班次名称'

,primary key (FPKID)

) comment = '班次信息多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FDESCRIPTION as "fdescription",FNAME as "fname" from T_ATS_SHIFTINFO_L

--查询(中文字段)--

select FPKID as "多语言内码",FID as "班次信息内码",FLOCALEID as "语种",FDESCRIPTION as "备注",FNAME as "班次名称" from T_ATS_SHIFTINFO_L

--INSERT脚本--

insert into T_ATS_SHIFTINFO_L(FPKID,FID,FLOCALEID,FDESCRIPTION,FNAME) values (?,?,?,?,?)

--UPDATE脚本--

update T_ATS_SHIFTINFO_L set FPKID=?,FID=?,FLOCALEID=?,FDESCRIPTION=?,FNAME=? where FPKID=?

--delete脚本--

delete from T_ATS_SHIFTINFO_L where FPKID=?

--给字段加备注--

alter table T_ATS_SHIFTINFO_L comment '班次信息多语言';

alter table T_ATS_SHIFTINFO_L modify column FPKID int not null comment '多语言内码';

alter table T_ATS_SHIFTINFO_L modify column FID int default null comment '班次信息内码';

alter table T_ATS_SHIFTINFO_L modify column FLOCALEID int default null comment '语种';

alter table T_ATS_SHIFTINFO_L modify column FDESCRIPTION nvarchar(255) not null comment '备注';

alter table T_ATS_SHIFTINFO_L modify column FNAME nvarchar(80) not null comment '班次名称';

T_ATS_SHIFTRULE(轮班规则)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FID	内码	int			0
	FNUMBER	编码	nvarchar	30		' '
	FCYCLE	轮班周期	int		✓
	FCYCLEUNIT	轮班周期单位	char	1	✓
	FISSYSPRESET	系统预置	char	1	✓
	FMGRCENTERID	人事管理中心	int		✓
	FCREATEORGID	创建组织	int		✓
	FUSEORGID	使用组织	int		✓
	FCREATORID	创建人	int		✓
	FCREATEDATE	创建日期	datetime		✓
	FMODIFIERID	修改人	int		✓
	FMODIFYDATE	修改日期	datetime		✓
	FAUDITORID	审核人	int		✓
	FAUDITDATE	审核日期	datetime		✓
	FFORBIDDERID	禁用人	int		✓
	FFORBIDDATE	禁用日期	datetime		✓
	FDOCUMENTSTATUS	数据状态	char	1	✓
	FFORBIDSTATUS	禁用状态	char	1	✓
	FMASTERID	FMASTERID	int		✓	0

--建表脚本--

create table T_ATS_SHIFTRULE(

FID int not null comment '内码'

,FNUMBER nvarchar(30) not null comment '编码'

,FCYCLE int default null comment '轮班周期'

,FCYCLEUNIT char(1) default null comment '轮班周期单位'

,FISSYSPRESET char(1) default null comment '系统预置'

,FMGRCENTERID int default null comment '人事管理中心'

,FCREATEORGID int default null comment '创建组织'

,FUSEORGID int default null comment '使用组织'

,FCREATORID int default null comment '创建人'

,FCREATEDATE datetime default null comment '创建日期'

,FMODIFIERID int default null comment '修改人'

,FMODIFYDATE datetime default null comment '修改日期'

,FAUDITORID int default null comment '审核人'

,FAUDITDATE datetime default null comment '审核日期'

,FFORBIDDERID int default null comment '禁用人'

,FFORBIDDATE datetime default null comment '禁用日期'

,FDOCUMENTSTATUS char(1) default null comment '数据状态'

,FFORBIDSTATUS char(1) default null comment '禁用状态'

,FMASTERID int default 0 comment 'FMASTERID'

,primary key (FID)

) comment = '轮班规则'

--查询--

select FID as "fid",FNUMBER as "fnumber",FCYCLE as "fcycle",FCYCLEUNIT as "fcycleunit",FISSYSPRESET as "fissyspreset",FMGRCENTERID as "fmgrcenterid",FCREATEORGID as "fcreateorgid",FUSEORGID as "fuseorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FMASTERID as "fmasterid" from T_ATS_SHIFTRULE

--查询(中文字段)--

select FID as "内码",FNUMBER as "编码",FCYCLE as "轮班周期",FCYCLEUNIT as "轮班周期单位",FISSYSPRESET as "系统预置",FMGRCENTERID as "人事管理中心",FCREATEORGID as "创建组织",FUSEORGID as "使用组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FMASTERID as "FMASTERID" from T_ATS_SHIFTRULE

--INSERT脚本--

insert into T_ATS_SHIFTRULE(FID,FNUMBER,FCYCLE,FCYCLEUNIT,FISSYSPRESET,FMGRCENTERID,FCREATEORGID,FUSEORGID,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDDERID,FFORBIDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS,FMASTERID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_SHIFTRULE set FID=?,FNUMBER=?,FCYCLE=?,FCYCLEUNIT=?,FISSYSPRESET=?,FMGRCENTERID=?,FCREATEORGID=?,FUSEORGID=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FMASTERID=? where FID=?

--delete脚本--

delete from T_ATS_SHIFTRULE where FID=?

--给字段加备注--

alter table T_ATS_SHIFTRULE comment '轮班规则';

alter table T_ATS_SHIFTRULE modify column FID int not null comment '内码';

alter table T_ATS_SHIFTRULE modify column FNUMBER nvarchar(30) not null comment '编码';

alter table T_ATS_SHIFTRULE modify column FCYCLE int default null comment '轮班周期';

alter table T_ATS_SHIFTRULE modify column FCYCLEUNIT char(1) default null comment '轮班周期单位';

alter table T_ATS_SHIFTRULE modify column FISSYSPRESET char(1) default null comment '系统预置';

alter table T_ATS_SHIFTRULE modify column FMGRCENTERID int default null comment '人事管理中心';

alter table T_ATS_SHIFTRULE modify column FCREATEORGID int default null comment '创建组织';

alter table T_ATS_SHIFTRULE modify column FUSEORGID int default null comment '使用组织';

alter table T_ATS_SHIFTRULE modify column FCREATORID int default null comment '创建人';

alter table T_ATS_SHIFTRULE modify column FCREATEDATE datetime default null comment '创建日期';

alter table T_ATS_SHIFTRULE modify column FMODIFIERID int default null comment '修改人';

alter table T_ATS_SHIFTRULE modify column FMODIFYDATE datetime default null comment '修改日期';

alter table T_ATS_SHIFTRULE modify column FAUDITORID int default null comment '审核人';

alter table T_ATS_SHIFTRULE modify column FAUDITDATE datetime default null comment '审核日期';

alter table T_ATS_SHIFTRULE modify column FFORBIDDERID int default null comment '禁用人';

alter table T_ATS_SHIFTRULE modify column FFORBIDDATE datetime default null comment '禁用日期';

alter table T_ATS_SHIFTRULE modify column FDOCUMENTSTATUS char(1) default null comment '数据状态';

alter table T_ATS_SHIFTRULE modify column FFORBIDSTATUS char(1) default null comment '禁用状态';

alter table T_ATS_SHIFTRULE modify column FMASTERID int default 0 comment 'FMASTERID';

T_ATS_SHIFTRULED(轮班规则明细)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FEntryID	轮班规则明细内码	int			0
	FID	轮班规则内码	int		✓
	FSEQ	序号	int		✓
	FSHIFTINFOID	班次内码	int		✓