今天因为原来项目方法的问题导致计算数据错误,现在需要将以前的数据更改回来,需要更改的表如下:
表A (学员培训信息表)
stus_id INTEGER not null,
stu_idcard VARCHAR2(50) not null,
mas_idcard VARCHAR2(30),
stus_starttime DATE not null,
stus_endtime DATE,
stus_totalminute INTEGER,
stus_totalmileage INTEGER,
stus_sinfoid INTEGER not null,
stus_checktype VARCHAR2(50),
stus_isok VARCHAR2(30) default 1,
stus_carid INTEGER,
stus_deviceid VARCHAR2(50) not null,
ds_id INTEGER,
consumetypeid INTEGER default 0 not null,
createdate DATE,
sumofconsumption NUMBER(18,2),
createby INTEGER,
stus_isnormal INTEGER default 1,
stus_errorcausa VARCHAR2(100),
region_ratio NUMBER default 0 not null,
region_min_ratio NUMBER default 0 not null,
options VARCHAR2(200),
stus_ispass INTEGER default 1,
stus_remark VARCHAR2(1000),