esus
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
taa_cdscaddomiciliar
Parameters
Name
Type
Mode
Definition
BEGIN IF(tg_op = 'INSERT') THEN UPDATE TB_CDS_DOMICILIO SET QT_REFERENCIA = (QT_REFERENCIA + 1) WHERE CO_UNICO_DOMICILIO = NEW.CO_UNICO_DOMICILIO; ELSIF (tg_op = 'DELETE') then UPDATE TB_CDS_DOMICILIO SET QT_REFERENCIA = (QT_REFERENCIA - 1) WHERE CO_UNICO_DOMICILIO = OLD.CO_UNICO_DOMICILIO; END IF; RETURN NULL; END;