tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_reach_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.wastewater_networkelement SET fk_dataowner = NEW.fk_dataowner , fk_provider = NEW.fk_provider , fk_wastewater_structure = NEW.fk_wastewater_structure , identifier = NEW.identifier , last_modification = NEW.last_modification , remark = NEW.remark WHERE obj_id = OLD.obj_id; UPDATE tww_od.reach SET obj_id = NEW.obj_id , clear_height = NEW.clear_height , coefficient_of_friction = NEW.coefficient_of_friction , elevation_determination = NEW.elevation_determination , fk_pipe_profile = NEW.fk_pipe_profile , fk_reach_point_from = NEW.fk_reach_point_from , fk_reach_point_to = NEW.fk_reach_point_to , flow_time_dry_weather = NEW.flow_time_dry_weather , horizontal_positioning = NEW.horizontal_positioning , hydraulic_load_current = NEW.hydraulic_load_current , inside_coating = NEW.inside_coating , leak_protection = NEW.leak_protection , length_effective = NEW.length_effective , material = NEW.material , progression3d_geometry = NEW.progression3d_geometry , reliner_material = NEW.reliner_material , reliner_nominal_size = NEW.reliner_nominal_size , relining_construction = NEW.relining_construction , relining_kind = NEW.relining_kind , ring_stiffness = NEW.ring_stiffness , slope_building_plan = NEW.slope_building_plan , swmm_default_coefficient_of_friction = NEW.swmm_default_coefficient_of_friction , wall_roughness = NEW.wall_roughness WHERE obj_id = OLD.obj_id; RETURN NEW; END;