esus
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
taa_atorpapelperfil
Parameters
Name
Type
Mode
Definition
begin if (tg_op = 'INSERT') then update tb_perfil set qt_referencia = (qt_referencia + 1) where co_seq_perfil = new.co_perfil; elsif (tg_op = 'DELETE') then update tb_perfil set qt_referencia = (qt_referencia - 1) where co_seq_perfil = old.co_perfil; end if; return NULL; end;