tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_wastewater_node_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.wastewater_node SET obj_id = NEW.obj_id , _function_hierarchic = NEW._function_hierarchic , _status = NEW._status , _usage_current = NEW._usage_current , backflow_level_current = NEW.backflow_level_current , bottom_level = NEW.bottom_level , elevation_accuracy = NEW.elevation_accuracy , fk_hydr_geometry = NEW.fk_hydr_geometry , function_node_amelioration = NEW.function_node_amelioration , situation3d_geometry = NEW.situation3d_geometry , wwtp_number = NEW.wwtp_number WHERE obj_id = OLD.obj_id; RETURN NEW; END;