esus
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
control_ref_gestores_e_administradores
Parameters
Name
Type
Mode
Definition
begin if(tg_op = 'INSERT') then UPDATE tb_ator_papel SET qt_referencia = (qt_referencia+1) WHERE co_ator = (SELECT co_ator FROM tb_ator_papel WHERE co_seq_ator_papel = new.co_ator_papel) AND no_tipo_ator_papel IN ('PROFISSIONAL', 'UNIDADE_SAUDE'); end if; return NULL; end;