T_ATS_ATTENDCARD(考勤卡信息) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FENTRYID | 内码 | int | 0 | |||
FID | 考勤档案内码 | int | ✓ | ||||
FMGRCENTERID | 人事管理中心 | int | ✓ | ||||
FPERSONID | 人员内码 | int | ✓ | ||||
FCardType | 类型 | char | 1 | ✓ | |||
FISFIRSTCARD | 是否主卡 | char | 1 | ✓ | |||
FCARD | 考勤卡号 | nvarchar | 80 | ✓ | |||
FBEGINTIME | 生效时间 | datetime | ✓ | ||||
FENDTIME | 失效时间 | datetime | ✓ | ||||
FOLDCARDPKID | 原考勤卡记录 | int | ✓ | ||||
FOLDCARD | 原考勤卡号 | nvarchar | 80 | ✓ | |||
FDISABLEDTYPE | 失效类型 | char | 1 | ✓ | |||
FDISABLEDSTATUS | 失效状态 | char | 1 | ✓ | |||
FMODIFIERID | 修改人 | int | ✓ | ||||
FMODIFYDATE | 修改日期 | datetime | ✓ |
--建表脚本--
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 '修改日期';
推荐阅读