aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_trg_registration_before_update_extend_stay
Parameters
Name
Type
Mode
Definition
DECLARE log_text text; BEGIN -- ================== -- created by T.Supol 16-May-2025 -- ================== if (new.departure > old.departure) and (old.status = 'I') then new.approved := false; end if; return new; END