tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_infiltration_installation_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.infiltration_installation SET obj_id = NEW.obj_id , absorption_capacity = NEW.absorption_capacity , defects = NEW.defects , dimension1 = NEW.dimension1 , dimension2 = NEW.dimension2 , distance_to_aquifer = NEW.distance_to_aquifer , effective_area = NEW.effective_area , emergency_overflow = NEW.emergency_overflow , filling_material = NEW.filling_material , fk_dss15_aquifer = NEW.fk_dss15_aquifer , kind = NEW.kind , labeling = NEW.labeling , seepage_utilization = NEW.seepage_utilization , upper_elevation = NEW.upper_elevation , vehicle_access = NEW.vehicle_access , watertightness = NEW.watertightness WHERE obj_id = OLD.obj_id; RETURN NEW; END;