ATS考勤1.4基础资料（打卡方式明细）

--建表脚本--

create table T_ATS_ATTENDCARDWAY(

FENTRYID int not null  comment '内码'

,FID int default null  comment '考勤档案内码'

,FCardType char(1) default null  comment '类型'

,FISFIRSTCARD char(1) default null  comment '是否主要打卡方式'

,FSystemRecordId nvarchar(80) default null  comment '系统登记号'

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

,FBEGINTIME datetime default null  comment '生效时间'

,FLASTMODIFIERID int default null  comment '修改人'

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

,primary key (FENTRYID)

) comment = '打卡方式明细'

--查询--

select FENTRYID as "fentryid",FID as "fid",FCardType as "fcardtype",FISFIRSTCARD as "fisfirstcard",FSystemRecordId as "fsystemrecordid",FCARD as "fcard",FBEGINTIME as "fbegintime",FLASTMODIFIERID as "flastmodifierid",FLASTMODIFYDATE as "flastmodifydate" from T_ATS_ATTENDCARDWAY

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

select FENTRYID as "内码",FID as "考勤档案内码",FCardType as "类型",FISFIRSTCARD as "是否主要打卡方式",FSystemRecordId as "系统登记号",FCARD as "考勤卡号",FBEGINTIME as "生效时间",FLASTMODIFIERID as "修改人",FLASTMODIFYDATE as "修改日期