aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_room_type_init
Parameters
Name
Type
Mode
Definition
BEGIN IF (new.order_seq is null) THEN new.order_seq = (select coalesce(max(order_seq),0)+1 from room_type); END IF; NEW.include_adult := COALESCE(NEW.include_adult, 2); NEW.include_child := COALESCE(NEW.include_child, 0); NEW.include_infant := COALESCE(NEW.include_infant, 0); NEW.max_pax := NULLIF(NEW.max_pax, 0); RETURN NEW; END