ATS考勤1.6基础资料（所属考勤组、多言语）

--建表脚本--

create table T_ATS_ATTENDGROUPPERSON(

FENTRYID int not null  comment '内码'

,FSEQ int default null  comment '序号'

,FID int default null  comment '考勤档案内码'

,FGROUPID int default null  comment '所属考勤组'

,primary key (FENTRYID)

) comment = '所属考勤组'

--查询--

select FENTRYID as "fentryid",FSEQ as "fseq",FID as "fid",FGROUPID as "fgroupid" from T_ATS_ATTENDGROUPPERSON

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

select FENTRYID as "内码",FSEQ as "序号",FID as "考勤档案内码",FGROUPID as "所属考勤组" from T_ATS_ATTENDGROUPPERSON

--INSERT脚本--

insert into T_ATS_ATTENDGROUPPERSON(FENTRYID,FSEQ,FID,FGROUPID) values (?,?,?,?)

--UPDATE脚本--

update T_ATS_ATTENDGROUPPERSON set FENTRYID=?,FSEQ=?,FID=?,FGROUPID=? where FENTRYID=?

--delete脚本--

delete from T_ATS_ATTENDGROUPPERSON where FENTRYID=?

--给字段加备注--

alter table T_ATS_ATTENDGROUPPERSON comment '所属考勤组';

alter table T_ATS_ATTENDGROUPPERSON modify column FENTRYID int not null  comment '内码';

alter table T_ATS_ATTENDGROUPPERSON modify column FSEQ int default null  comment '序号';

alter table T_ATS_ATTENDGROUPPERSON modify column FID int default null  comment '考勤档案内码';

alter table T_ATS_ATTENDGROUPPERSON modify column FGROUPID int default null  comment '所属考勤组';

--建表脚本--

create table T_ATS_ATTENDGROUPPERSON_L(

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

,FENTRYID int default null  comment '所属考勤组内码'

,FLOCALEID int default null  comment '语种'

,FGROUPDESCRIPTION nvarchar(255) not null  comment '备注'

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

,primary key (FPKID)

) comment = '所属考勤组多语言'

--查询--

select FPKID as "fpkid",FENTRYID as "fentryid",FLOCALEID as "flocaleid",FGROUPDESCRIPTION as "fgroupdescription",FDESCRIPTION as "fdescription" from T_ATS_ATTENDGROUPPERSON_L

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

select FPKID as "多语言内码",FENTRYID as "所属考勤组内码",FLOCALEID as "语种",FGROUPDESCRIPTION as "备注",FDESCRIPTION as "FDESCRIPTION" from T_ATS_ATTENDGROUPPERSON_L

--INSERT脚本--

insert into T_ATS_ATTENDGROUPPERSON_L(FPKID,FENTRYID,FLOCALEID,FGROUPDESCRIPTION,FDESCRIPTION) values (?,?,?,?,?)

--UPDATE脚本--

update T_ATS_ATTENDGROUPPERSON_L set FPKID=?,FENTRYID=?,FLOCALEID=?,FGROUPDESCRIPTION=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_ATS_ATTENDGROUPPERSON_L where FPKID=?

--给字段加备注--

alter table T_ATS_ATTENDGROUPPERSON_L comment '所属考勤组多语言';

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

alter table T_ATS_ATTENDGROUPPERSON_L modify column FENTRYID int default null  comment '所属考勤组内码';

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

alter table T_ATS_ATTENDGROUPPERSON_L modify column FGROUPDESCRIPTION nvarchar(255) not null  comment '备注';

alter table T_ATS_ATTENDGROUPPERSON_L modify column FDESCRIPTION nvarchar(255) default null  comment 'FDESCRIPTION';