T_ATS_FINGERPRINT(指纹信息) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FENTRYID | 内码 | int | 0 | |||
FID | 考勤档案内码 | int | ✓ | ||||
FFINGERPRINT | 指纹 | char | 1 | ✓ | |||
FENTERDATE | 采集日期 | datetime | ✓ | ||||
备注:T_ATS_FINGERPRINT(指纹信息) |
--建表脚本--
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 '采集日期';
推荐阅读