ATS考勤1.5基础资料（考勤卡信息多语言）

--建表脚本--

create table T_ATS_ATTENDCARD_L(

FPKID int not null  comment '多语言内码'

,FENTRYID int default null  comment '考勤卡内码'

,FLOCALEID int default null  comment '语种'

,FDESCRIPTION nvarchar(255) default ' '  comment '备注'

,primary key (FPKID)

) comment = '考勤卡信息多语言'

--查询--

select FPKID as "fpkid",FENTRYID as "fentryid",FLOCALEID as "flocaleid",FDESCRIPTION as "fdescription" from T_ATS_ATTENDCARD_L

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

select FPKID as "多语言内码",FENTRYID as "考勤卡内码",FLOCALEID as "语种",FDESCRIPTION as "备注" from T_ATS_ATTENDCARD_L

--INSERT脚本--

insert into T_ATS_ATTENDCARD_L(FPKID,FENTRYID,FLOCALEID,FDESCRIPTION) values (?,?,?,?)

--UPDATE脚本--

update T_ATS_ATTENDCARD_L set FPKID=?,FENTRYID=?,FLOCALEID=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_ATS_ATTENDCARD_L where FPKID=?

--给字段加备注--

alter table T_ATS_ATTENDCARD_L comment '考勤卡信息多语言';

alter table T_ATS_ATTENDCARD_L modify column FPKID int not null  comment '多语言内码';

alter table T_ATS_ATTENDCARD_L modify column FENTRYID int default null  comment '考勤卡内码';

alter table T_ATS_ATTENDCARD_L modify column FLOCALEID int default null  comment '语种';

alter table T_ATS_ATTENDCARD_L modify column FDESCRIPTION nvarchar(255) default ' '  comment '备注';