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

--INSER