tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_reach_insert()
Parameters
Name
Type
Mode
IN
Definition
BEGIN INSERT INTO tww_od.wastewater_networkelement ( obj_id , fk_dataowner , fk_provider , fk_wastewater_structure , identifier , last_modification , remark ) VALUES ( COALESCE( NEW.obj_id, tww_app.generate_oid('tww_od'::text, 'reach'::text) ) , NEW.fk_dataowner , NEW.fk_provider , NEW.fk_wastewater_structure , CASE WHEN NEW.identifier IS NOT NULL AND NEW.identifier::text <> '' THEN NEW.identifier ELSE COALESCE( NEW.obj_id, tww_app.generate_oid('tww_od'::text, 'reach'::text) ) END , NEW.last_modification , NEW.remark ) RETURNING obj_id INTO NEW.obj_id; INSERT INTO tww_od.reach ( obj_id , clear_height , coefficient_of_friction , elevation_determination , fk_pipe_profile , fk_reach_point_from , fk_reach_point_to , flow_time_dry_weather , horizontal_positioning , hydraulic_load_current , inside_coating , leak_protection , length_effective , material , progression3d_geometry , reliner_material , reliner_nominal_size , relining_construction , relining_kind , ring_stiffness , slope_building_plan , swmm_default_coefficient_of_friction , wall_roughness ) VALUES ( NEW.obj_id , NEW.clear_height , NEW.coefficient_of_friction , NEW.elevation_determination , NEW.fk_pipe_profile , NEW.fk_reach_point_from , NEW.fk_reach_point_to , NEW.flow_time_dry_weather , NEW.horizontal_positioning , NEW.hydraulic_load_current , NEW.inside_coating , NEW.leak_protection , NEW.length_effective , NEW.material , NEW.progression3d_geometry , NEW.reliner_material , NEW.reliner_nominal_size , NEW.relining_construction , NEW.relining_kind , NEW.ring_stiffness , NEW.slope_building_plan , NEW.swmm_default_coefficient_of_friction , NEW.wall_roughness ); RETURN NEW; END;