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 as "失效状态",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期" from T_ATS_ATTENDCARD

--INSERT脚本--

insert into T_ATS_ATTENDCARD(FENTRYID,FID,FMGRCENTERID,FPERSONID,FCardType,FISFIRSTCARD,FCARD,FBEGINTIME,FENDTIME,FOLDCARDPKID,FOLDCARD,FDISABLEDTYPE,FDISABLEDSTATUS,FMODIFIERID,FMODIFYDATE) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_ATTENDCARD set FENTRYID=?,FID=?,FMGRCENTERID=?,FPERSONID=?,FCardType=?,FISFIRSTCARD=?,FCARD=?,FBEGINTIME=?,FENDTIME=?,FOLDCARDPKID=?,FOLDCARD=?,FDISABLEDTYPE=?,FDISABLEDSTATUS=?,FMODIFIERID=?,FMODIFYDATE=? where FENTRYID=?

--delete脚本--

delete from T_ATS_ATTENDCARD where FENTRYID=?

--给字段加备注--

alter table T_ATS_ATTENDCARD comment '考勤卡信息';

alter table T_ATS_ATTENDCARD modify column FENTRYID int not null  comment '内码';

alter table T_ATS_ATTENDCARD modify column FID int default null  comment '考勤档案内码';

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

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

alter table T_ATS_ATTENDCARD modify column FCardType char(1) default null  comment '类型';

alter table T_ATS_ATTENDCARD modify column FISFIRSTCARD char(1) default null  comment '是否主卡';

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

alter table T_ATS_ATTENDCARD modify column FBEGINTIME datetime default null  comment '生效时间';

alter table T_ATS_ATTENDCARD modify column FENDTIME datetime default null  comment '失效时间';

alter table T_ATS_ATTENDCARD modify column FOLDCARDPKID int default null  comment '原考勤卡记录';

alter table T_ATS_ATTENDCARD modify column FOLDCARD nvarchar(80) default null  comment '原考勤卡号';

alter table T_ATS_ATTENDCARD modify column FDISABLEDTYPE char(1) default null  comment '失效类型';

alter table T_ATS_ATTENDCARD modify column FDISABLEDSTATUS char(1) default null  comment '失效状态';

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

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