ATS考勤1.17基础资料（轮班规则多语言表、班次时段信息）

--建表脚本--

create table T_ATS_SHIFTRULE_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_SHIFTRULE_L

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

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

--INSERT脚本--

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

--UPDATE脚本--

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

--delete脚本--

delete from T_ATS_SHIFTRULE_L where FPKID=?

--给字段加备注--

alter table T_ATS_SHIFTRULE_L comment '轮班规则多语言表';

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

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

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

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

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

--建表脚本--

create table T_ATS_SHIFTTIMEINFO(

FEntryID int not null  comment '内码'

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

,FTIMEPART int default null  comment '时段序号'

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

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

,FISCHECKIN char(1) default null  comment '上班是否打卡'

,FCHECKINBEGIN datetime default null  comment '上班取卡开始值'

,FCHECKINBEGINUNIT char(1) default null  comment '上班取卡开始单位'

,FCHECKINEND datetime default null  comment '上班取卡结束值'

,FCHECKINENDUNIT char(1) default null  comment '上班取卡结束单位'

,FCHECKINADJUST int default null  comment '上班浮动调整值'

,FRESTTIME int default null  comment '段内休息'

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

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

,FISCHECKOUT char(1) default null  comment '下班是否打卡'

,FCHECKOUTBEGIN datetime default null  comment '下班取卡开始值'

,FCHECKOUTBEGINUNIT char(1) default null  comment '下班取卡开始单位'

,FCHECKOUTEND datetime default null  comment '下班取卡结束值'

,FCHECKOUTENDUNIT char(1) default null  comment '下班取卡结束单位'

,FCHECKOUTADJUST int default null  comment '下班浮动调整值'

,FATTENDTYPE char(1) default null  comment '出勤类型'

,FISEMPTY char(1) default null  comment '是否空行'

,FREALCHECKINBEGIN datetime default null  comment '实际上班取卡开始'

,FREALCHECKINEND datetime default null  comment '实际上班取卡结束'

,FREALCHECKOUTBEGIN datetime default null  comment '实际下班取卡开始'

,FREALCHECKOUTEND datetime default null  comment '实际下班取卡结束'

,FREALCHECKINBEGINUNIT char(1) default null  comment '实际上班取卡开始单位'

,FREALCHECKINENDUNIT char(1) default null  comment '实际上班取卡结束单位'

,FREALCHECKOUTBEGINUNIT char(1) default null  comment '实际下班取卡开始单位'

,FREALCHECKOUTENDUNIT char(1) default null  comment '实际下班取卡结束单位'

,primary key (FEntryID)

) comment = '班次时段信息'

--查询--

select FEntryID as "fentryid",FID as "fid",FTIMEPART as "ftimepart",FCHECKIN as "fcheckin",FCHECKINUNIT as "fcheckinunit",FISCHECKIN as "fischeckin",FCHECKINBEGIN as "fcheckinbegin",FCHECKINBEGINUNIT as "fcheckinbeginunit",FCHECKINEND as "fcheckinend",FCHECKINENDUNIT as "fcheckinendunit",FCHECKINADJUST as "fcheckinadjust",FRESTTIME as "fresttime",FCHECKOUT as "fcheckout",FCHECKOUTUNIT as "fcheckoutunit",FISCHECKOUT as "fischeckout",FCHECKOUTBEGIN as "fcheckoutbegin",FCHECKOUTBEGINUNIT as "fcheckoutbeginunit",FCHECKOUTEND as "fcheckoutend",FCHECKOUTENDUNIT as "fcheckoutendunit",FCHECKOUTADJUST as "fcheckoutadjust",FATTENDTYPE as "fattendtype",FISEMPTY as "fisempty",FREALCHECKINBEGIN as "frealcheckinbegin",FREALCHECKINEND as "frealcheckinend",FREALCHECKOUTBEGIN as "frealcheckoutbegin",FREALCHECKOUTEND as "frealcheckoutend",FREALCHECKINBEGINUNIT as "frealcheckinbeginunit",FREALCHECKINENDUNIT as "frealcheckinendunit",FREALCHECKOUTBEGINUNIT as "frealchecko