ada
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
track_record_status_change()
Parameters
Name
Type
Mode
Definition
begin IF (TG_OP = 'INSERT') then insert into record_trails (record_id, status,status_on) values(new.id,new.process_status,new.updated_at); ELSIF (TG_OP = 'UPDATE') THEN IF NEW.process_status <> old.process_status then insert into record_trails (record_id, status,status_on) values(new.id,new.process_status,new.updated_at); END IF; end if; return new; END;