tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_param_ca_general_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.surface_runoff_parameters SET evaporation_loss = NEW.evaporation_loss , fk_catchment_area = NEW.fk_catchment_area , fk_dataowner = NEW.fk_dataowner , fk_provider = NEW.fk_provider , identifier = NEW.identifier , infiltration_loss = NEW.infiltration_loss , last_modification = NEW.last_modification , remark = NEW.remark , surface_storage = NEW.surface_storage , wetting_loss = NEW.wetting_loss WHERE obj_id = OLD.obj_id; UPDATE tww_od.param_ca_general SET obj_id = NEW.obj_id , dry_wheather_flow = NEW.dry_wheather_flow , flow_path_length = NEW.flow_path_length , flow_path_slope = NEW.flow_path_slope , population_equivalent = NEW.population_equivalent , surface_ca = NEW.surface_ca WHERE obj_id = OLD.obj_id; RETURN NEW; END;