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

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：3

T_ATS_ATTENDGROUPPERSON(所属考勤组)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FENTRYID	内码	int			0
	FSEQ	序号	int		✓
	FID	考勤档案内码	int		✓
	FGROUPID	所属考勤组	int		✓

--建表脚本--

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 '所属考勤组';

T_ATS_ATTENDGROUPPERSON_L(所属考勤组多语言)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FPKID	多语言内码	int			0
	FENTRYID	所属考勤组内码	int		✓
	FLOCALEID	语种	int		✓
	FGROUPDESCRIPTION	备注	nvarchar	255		' '
	FDESCRIPTION	FDESCRIPTION	nvarchar	255	✓

--建表脚本--

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 '备注';