tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_channel_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.channel SET obj_id = NEW.obj_id , bedding_encasement = NEW.bedding_encasement , connection_type = NEW.connection_type , function_amelioration = NEW.function_amelioration , function_hierarchic = NEW.function_hierarchic , function_hydraulic = NEW.function_hydraulic , jetting_interval = NEW.jetting_interval , pipe_length = NEW.pipe_length , seepage = NEW.seepage , usage_current = NEW.usage_current , usage_planned = NEW.usage_planned WHERE obj_id = OLD.obj_id; RETURN NEW; END;