CREATE TABLE TESTDELLOG (
    TRG  CHAR(2),
    ID   INTEGER
)

Create Generator TestGen


CREATE TABLE TESTDELMASTER (
    ID  INTEGER NOT NULL,
    Constraint TDM_PK Primary Key (ID)
)

CREATE TRIGGER TDM_BD FOR TESTDELMASTER BEFORE DELETE
as
begin Insert Into testdellog (id, trg) Values (gen_id(testdel,1),'MB');
end

CREATE TRIGGER TDM_AD FOR TESTDELMASTER AFTER DELETE
as
begin Insert Into testdellog (id, TRG) Values (gen_id(testdel,1), 'MA');
end


CREATE TABLE TESTDELDETAIL (
    ID  INTEGER NOT NULL,
    Constraint TDD_FK Foregn Key (ID) References TestDelMaster (ID) On Delete Cascade
);

CREATE TRIGGER TDD_BD FOR TESTDELDETAIL BEFORE DELETE
as
begin Insert Into testdellog (id, TRG) Values (gen_id(testdel,1), 'DB');
end

CREATE TRIGGER TDD_AD FOR TESTDELDETAIL AFTER DELETE
as
begin Insert Into testdellog (id,TRG) Values (gen_id(testdel,1),'DA');
end

Insert into TestDelMaster (id) values (1)
Insert into TestDelDetail (id) values (1)
Insert into TestDelDetail (id) values (1)

Delete from TestDelMaster

Select from TestDelLog order by (ID)

TRG	ID
MB	1
MA	2
DB	3
DA	4
DB	5
DA	6