ATS考勤1.3基础资料（考勤卡信息）

--建表脚本--

create table T_ATS_ATTENDCARD(

FENTRYID int not null  comment '内码'

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

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

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

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

,FISFIRSTCARD char(1) default null  comment '是否主卡'

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

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

,FENDTIME datetime default null  comment '失效时间'

,FOLDCARDPKID int default null  comment '原考勤卡记录'

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

,FDISABLEDTYPE char(1) default null  comment '失效类型'

,FDISABLEDSTATUS char(1) default null  comment '失效状态'

,FMODIFIERID int default null  comment '修改人'

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

,primary key (FENTRYID)

) comment = '考勤卡信息'

--查询--

select FENTRYID as "fentryid",FID as "fid",FMGRCENTERID as "fmgrcenterid",FPERSONID as "fpersonid",FCardType as "fcardtype",FISFIRSTCARD as "fisfirstcard",FCARD as "fcard",FBEGINTIME as "fbegintime",FENDTIME as "fendtime",FOLDCARDPKID as "foldcardpkid",FOLDCARD as "foldcard",FDISABLEDTYPE as "fdisabledtype",FDISABLEDSTATUS as "fdisabledstatus",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate" from T_ATS_ATTENDCARD

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

select FENTRYID as "内码",FID as "考勤档案内码",FMGRCENTERID as "人事管理中心",FPERSONID as "人员内码",FCardType as "类型",FISFIRSTCARD as "是否主卡",FCARD as "考勤卡号",FBEGINTIME as "生效时间",FENDTIME as "失效时间",FOLDCARDPKID as "原考勤卡记录",FOLDCARD as "原考勤卡号",FDISABLEDTYPE as "失效类型",FDISABLEDSTATUS