tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_tww_measurement_series_insert()
Parameters
Name
Type
Mode
IN
Definition
BEGIN NEW.identifier = COALESCE(NEW.identifier, NEW.obj_id); INSERT INTO tww_od.measurement_series ( obj_id , dimension , fk_dataowner , fk_measuring_point , fk_provider , fk_wastewater_networkelement , identifier , kind , last_modification , remark ) VALUES ( NEW.obj_id , NEW.dimension , NEW.fk_dataowner , NEW.fk_measuring_point , NEW.fk_provider , NEW.fk_wastewater_networkelement , NEW.identifier , NEW.kind , NEW.last_modification , NEW.remark ); RETURN NEW; END;