tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_cover_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.structure_part 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 , renovation_demand = NEW.renovation_demand WHERE obj_id = OLD.obj_id; UPDATE tww_od.cover SET obj_id = NEW.obj_id , brand = NEW.brand , cover_shape = NEW.cover_shape , diameter = NEW.diameter , fastening = NEW.fastening , level = NEW.level , material = NEW.material , positional_accuracy = NEW.positional_accuracy , situation3d_geometry = NEW.situation3d_geometry , sludge_bucket = NEW.sludge_bucket , venting = NEW.venting WHERE obj_id = OLD.obj_id; RETURN NEW; END;