tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_small_treatment_plant_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.wastewater_structure SET _bottom_label = NEW._bottom_label , _cover_label = NEW._cover_label , _depth = NEW._depth , _input_label = NEW._input_label , _label = NEW._label , _output_label = NEW._output_label , accessibility = NEW.accessibility , condition_score = NEW.condition_score , contract_section = NEW.contract_section , detail_geometry3d_geometry = NEW.detail_geometry3d_geometry , elevation_determination = NEW.elevation_determination , financing = NEW.financing , fk_dataowner = NEW.fk_dataowner , fk_main_cover = NEW.fk_main_cover , fk_main_wastewater_node = NEW.fk_main_wastewater_node , fk_operator = NEW.fk_operator , fk_owner = NEW.fk_owner , fk_provider = NEW.fk_provider , gross_costs = NEW.gross_costs , identifier = NEW.identifier , inspection_interval = NEW.inspection_interval , last_modification = NEW.last_modification , location_name = NEW.location_name , records = NEW.records , remark = NEW.remark , renovation_necessity = NEW.renovation_necessity , replacement_value = NEW.replacement_value , rv_base_year = NEW.rv_base_year , rv_construction_type = NEW.rv_construction_type , status = NEW.status , status_survey_year = NEW.status_survey_year , structure_condition = NEW.structure_condition , subsidies = NEW.subsidies , urgency_figure = NEW.urgency_figure , year_of_construction = NEW.year_of_construction , year_of_replacement = NEW.year_of_replacement WHERE obj_id = OLD.obj_id; UPDATE tww_od.small_treatment_plant SET obj_id = NEW.obj_id , approval_number = NEW.approval_number , function = NEW.function , installation_number = NEW.installation_number , remote_monitoring = NEW.remote_monitoring WHERE obj_id = OLD.obj_id; RETURN NEW; END;