ehoks
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
hyto_osa_alue_casc_delete()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE yhteisen_tutkinnon_osan_osa_alueen_osaamisen_hankkimistavat SET deleted_at = NEW.deleted_at WHERE yhteisen_tutkinnon_osan_osa_alue_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE yhteisen_tutkinnon_osan_osa_alueen_naytot SET deleted_at = NEW.deleted_at WHERE yhteisen_tutkinnon_osan_osa_alue_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); RETURN NEW; END;