tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_bio_ecol_assessment_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.maintenance_event SET base_data = NEW.base_data , cost = NEW.cost , data_details = NEW.data_details , duration = NEW.duration , fk_dataowner = NEW.fk_dataowner , fk_measure = NEW.fk_measure , fk_operating_company = NEW.fk_operating_company , fk_provider = NEW.fk_provider , identifier = NEW.identifier , last_modification = NEW.last_modification , operator = NEW.operator , reason = NEW.reason , remark = NEW.remark , result = NEW.result , status = NEW.status , time_point = NEW.time_point WHERE obj_id = OLD.obj_id; UPDATE tww_od.bio_ecol_assessment SET obj_id = NEW.obj_id , comparison_last = NEW.comparison_last , date_last_examen = NEW.date_last_examen , impact_auxiliary_indic = NEW.impact_auxiliary_indic , impact_external_aspect = NEW.impact_external_aspect , impact_macroinvertebrates = NEW.impact_macroinvertebrates , impact_water_plants = NEW.impact_water_plants , intervention_demand = NEW.intervention_demand , io_calculation = NEW.io_calculation , kind_water_body = NEW.kind_water_body , outlet_pipe_clear_height = NEW.outlet_pipe_clear_height , q347 = NEW.q347 , relevance_matrix = NEW.relevance_matrix , relevant_slope = NEW.relevant_slope , surface_water_bodies = NEW.surface_water_bodies , water_specific_discharge_freight_nh4_n_current = NEW.water_specific_discharge_freight_nh4_n_current , water_specific_discharge_freight_nh4_n_current_opt = NEW.water_specific_discharge_freight_nh4_n_current_opt , water_specific_discharge_freight_nh4_n_planned = NEW.water_specific_discharge_freight_nh4_n_planned WHERE obj_id = OLD.obj_id; RETURN NEW; END;