ATS考勤2.12考勤计算（额度扣减记录）

--建表脚本--

create table T_ATS_LIMITDEDUCTION(

FID int not null  comment 'FID'

,FHOLYDETAILSID int default null  comment 'FHOLYDETAILSID'

,FHOLYLIMITID int default null  comment 'FHOLYLIMITID'

,FUSEDLIMIT decimal(19,6) default null  comment 'FUSEDLIMIT'

,primary key (FID)

) comment = '额度扣减记录'

--查询--

select FID as "fid",FHOLYDETAILSID as "fholydetailsid",FHOLYLIMITID as "fholylimitid",FUSEDLIMIT as "fusedlimit" from T_ATS_LIMITDEDUCTION

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

select FID as "FID",FHOLYDETAILSID as "FHOLYDETAILSID",FHOLYLIMITID as "FHOLYLIMITID",FUSEDLIMIT as "FUSEDLIMIT" from T_ATS_LIMITDEDUCTION

--INSERT脚本--

insert into T_ATS_LIMITDEDUCTION(FID,FHOLYDETAILSID,FHOLYLIMITID,FUSEDLIMIT) values (?,?,?,?)

--UPDATE脚本--

update T_ATS_LIMITDEDUCTION set FID=?,FHOLYDETAILSID=?,FHOLYLIMITID=?,FUSEDLIMIT=? where FID=?

--delete脚本--

delete from T_ATS_LIMITDEDUCTION where FID=?

--给字段加备注--

alter table T_ATS_LIMITDEDUCTION comment '额度扣减记录';

alter table T_ATS_LIMITDEDUCTION modify column FID int not null  comment 'FID';

alter table T_ATS_LIMITDEDUCTION modify column FHOLYDETAILSID int default null  comment 'FHOLYDETAILSID';

alter table T_ATS_LIMITDEDUCTION modify column FHOLYLIMITID int default null  comment 'FHOLYLIMITID';

alter table T_ATS_LIMITDEDUCTION modify column FUSEDLIMIT decimal(19,6) default null  comment 'FUSEDLIMIT';