ATS考勤1.2基础资料（考勤项目多语言表）

--建表脚本--

create table T_ATS_ATSITEM_L(

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

,FID int default null  comment '项目内码'

,FLOCALEID int not null  comment '语言码'

,FNAME nvarchar(80) default ' '  comment '名称'

,FDESCRIPTION nvarchar(255) default null  comment '描述'

,primary key (FPKID)

) comment = '考勤项目多语言表'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription" from T_ATS_ATSITEM_L

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

select FPKID as "多语言内码",FID as "项目内码",FLOCALEID as "语言码",FNAME as "名称",FDESCRIPTION as "描述" from T_ATS_ATSITEM_L

--IN