ATS考勤2.15考勤计算（打卡记录表）

--建表脚本--

create table T_ATS_RECORD(

FID int not null  comment '主键'

,FCREATORID int default null  comment '创建人'

,FCREATEDATE datetime default null  comment '创建时间'

,FORGID int default null  comment '当前组织'

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

,FCHECKTIME datetime default null  comment '打卡时间'

,FCHECKDATETIME datetime default null  comment '打卡日期时间'

,FCHECKDATE datetime default null  comment '打卡日期'

,FPERSONID int default null  comment '人员id'

,FSTAFFID int default null  comment '员工id'

,FCARD nvarchar(80) default null  comment '考勤卡号'

,FHARDWARENUMBER nvarchar(80) default null  comment '硬件编号'

,FHARDWAREID int default null  comment '考勤硬件id'

,FMACHINENAME nvarchar(80) default null  comment '机器名'

,FPOSTNUMBER nvarchar(80) default null  comment '端口号'

,FCHECKTYPE nvarchar(30) default null  comment '进出类型说明该次打卡是进是出'

,FDOCID int default null  comment '考勤档案id'

,primary key (FID)

) comment = '打卡记录表'

--查询--

select FID as "fid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FORGID as "forgid",FMGRCENTERID as "fmgrcenterid",FCHECKTIME as "fchecktime",FCHECKDATETIME as "fcheckdatetime",FCHECKDATE as "fcheckdate",FPERSONID as "fpersonid",FSTAFFID as "fstaffid",FCARD as "fcard",FHARDWARENUMBER as "fhardwarenumber",FHARDWAREID as "fhardwareid",FMACHINENAME as "fmachinename",FPOSTNUMBER as "fpostnumber",FCHECKTYPE as "fchecktype",FDOCID as "fdocid" from T_ATS_RECORD

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

select FID as "主键",FCREATORID as "创建人",FCREATEDATE as "创建时间",FORGID as "当前组织",FMGRCENTERID as "人事管理中心",FCHECKTIME as "打卡时间",FCHECKDATETIME as "打卡日期时间",FCHECKDATE as "打卡日期",FPERSONID as "人员id",FSTAFFID as "员工id",FCARD as "考勤卡号",FHARDWARENUMBER as "硬件编号",FHARDWAREID as "考勤硬件id",FMACHINENAME as "机器名",FPOSTNUMBER as "端口号",FCHECKTYPE as "进出类型说明该次打卡是进是出",FDOCID as "考勤档案id" from T_ATS_RECORD

--INSERT脚本--

insert into T_ATS_RECORD(FID,FCREATORID,FCREATEDATE,FORGID,FMGRCENTERID,FCHECKTIME,FCHECKDATETIME,FCHECKDATE,FPERSONID,FSTAFFID,FCARD,FHARDWARENUMBER,FHARDWAREID,FMACHINENAME,FPOSTNUMBER,FCHECKTYPE,FDOCID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_RECORD set FID=?,FCREATORID=?,FCREATEDATE=?,FORGID=?,FMGRCENTERID=?,FCHECKTIME=?,FCHECKDATETIME=?,FCHECKDATE=?,FPERSONID=?,FSTAFFID=?,FCARD=?,FHARDWARENUMBER=?,FHARDWAREID=?,FMACHINENAME=?,FPOSTNUMBER=?,FCHECKTYPE=?,FDOCID=? where FID=?

--delete脚本--

delete from T_ATS_RECORD where FID=?

--给字段加备注--

alter table T_ATS_RECORD comment '打卡记录表';

alter table T_ATS_RECORD modify column FID int not null  comment '主键';

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

alter table T_ATS_RECORD modify column FCREATEDATE datetime default null  comment '创建时间';

alter table T_ATS_RECORD modify column FORGID int default null  comment '当前组织';

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

alter table T_ATS_RECORD modify column FCHECKTIME datetime default null  comment '打卡时间';

alter table T_ATS_RECORD modify column FCHECKDATETIME datetime default null  comment '打卡日期时间';

alter table T_ATS_RECORD modify column FCHECKDATE datetime default null  comment '打卡日期';

alter table T_ATS_RECORD modify column FPERSONID int default null  comment '人员id';

alter table T_ATS_RECORD modify column FSTAFFID int default null  comment '员工id';

alter table T_ATS_RECORD modify column FCARD nvarchar(80) default null  comment '考勤卡号';

alter table T_ATS_RECORD modify column FHARDWARENUMBER nvarchar(80) default null  comment '硬件编号';

alter table T_ATS_RECORD modify column FHARDWAREID int default null  comment '考勤硬件id';

alter table T_ATS_RECORD modify column FMACHINENAME nvarchar(80) default null  comment '机器名';

alter table T_ATS_RECORD modify column FPOSTNUMBER nvarchar(80) default null  comment '端口号';

alter table T_ATS_RECORD modify column FCHECKTYPE nvarchar(30) default null  comment '进出类型说明该次打卡是进是出';

alter table T_ATS_RECORD modify column FDOCID int default null  comment '考勤档案id';