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 '备注';
alter table T_ATS_ATTENDGROUPPERSON_L modify column FDESCRIPTION nvarchar(255) default null comment 'FDESCRIPTION';
推荐阅读