ATS考勤1.10基础资料（指纹信息）

--建表脚本--

create table T_ATS_FINGERPRINT(

FENTRYID int not null  comment '内码'

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

,FFINGERPRINT char(1) default null  comment '指纹'

,FENTERDATE datetime default null  comment '采集日期'

,primary key (FENTRYID)

) comment = '指纹信息'

--查询--

select FENTRYID as "fentryid",FID as "fid",FFINGERPRINT as "ffingerprint",FENTERDATE as "fenterdate" from T_ATS_FINGERPRINT

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

select FENTRYID as "内码",FID as "考勤档案内码",FFINGERPRINT as "指纹",FENTERDATE as "采集日期" from T_ATS_FINGERPRINT

--INSERT脚本--

insert into T_ATS_FINGERPRINT(FENTRYID,FID,FFINGERPRINT,FENTERDATE) values (?,?,?,?)

--UPDATE脚本--

update T_ATS_FINGERPRINT set FENTRYID=?,FID=?,FFINGERPRINT=?,FENTERDATE=? where FENTRYID=?

--delete脚本--

delete from T_ATS_FINGERPRINT where FENTRYID=?

--给字段加备注--

alter table T_ATS_FINGERPRINT comment '指纹信息';

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

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

alter table T_ATS_FINGERPRINT modify column FFINGERPRINT char(1) default null  comment '指纹';

alter table T_ATS_FINGERPRINT modify column FENTERDATE datetime default null  comment '采集日期';