tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_examination_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.examination SET obj_id = NEW.obj_id , equipment = NEW.equipment , fk_reach_point = NEW.fk_reach_point , from_point_identifier = NEW.from_point_identifier , inspected_length = NEW.inspected_length , recording_type = NEW.recording_type , to_point_identifier = NEW.to_point_identifier , vehicle = NEW.vehicle , videonumber = NEW.videonumber , weather = NEW.weather WHERE obj_id = OLD.obj_id; RETURN NEW; END;