--建表脚本--

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 "修改日期" from T_ATS_ATTENDCARDWAY

--INSERT脚本--

insert into T_ATS_ATTENDCARDWAY(FENTRYID,FID,FCardType,FISFIRSTCARD,FSystemRecordId,FCARD,FBEGINTIME,FLASTMODIFIERID,FLASTMODIFYDATE) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_ATTENDCARDWAY set FENTRYID=?,FID=?,FCardType=?,FISFIRSTCARD=?,FSystemRecordId=?,FCARD=?,FBEGINTIME=?,FLASTMODIFIERID=?,FLASTMODIFYDATE=? where FENTRYID=?

--delete脚本--

delete from T_ATS_ATTENDCARDWAY where FENTRYID=?

--给字段加备注--

alter table T_ATS_ATTENDCARDWAY comment '打卡方式明细';

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

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

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

alter table T_ATS_ATTENDCARDWAY modify column FISFIRSTCARD char(1) default null  comment '是否主要打卡方式';

alter table T_ATS_ATTENDCARDWAY modify column FSystemRecordId nvarchar(80) default null  comment '系统登记号';

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

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

alter table T_ATS_ATTENDCARDWAY modify column FLASTMODIFIERID int default null  comment '修改人';

alter table T_ATS_ATTENDCARDWAY modify column FLASTMODIFYDATE datetime default null  comment '修改日期';