ehoks
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
hoksit_casc_delete()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE hankittavat_koulutuksen_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE hankittavat_yhteiset_tutkinnon_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE hankittavat_ammat_tutkinnon_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE hankittavat_paikalliset_tutkinnon_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE aiemmin_hankitut_yhteiset_tutkinnon_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE aiemmin_hankitut_ammat_tutkinnon_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); UPDATE aiemmin_hankitut_paikalliset_tutkinnon_osat SET deleted_at = NEW.deleted_at, updated_at = coalesce(NEW.deleted_at, current_timestamp) WHERE hoks_id = OLD.id AND (deleted_at IS NULL OR deleted_at = OLD.deleted_at); RETURN NEW; END;