MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE so (so_id INT PRIMARY KEY, 
                 inactive  boolean);
CREATE TABLE soi (soi_id INT PRIMARY KEY, 
                  inactive  boolean, 
                  so_id INT, 
                  FOREIGN KEY (so_id) REFERENCES so (so_id));
CREATE TABLE soir (soir_id INT PRIMARY KEY, 
                   inactive  boolean, 
                   soi_id INT, 
                   FOREIGN KEY (soi_id) REFERENCES soi (soi_id));
INSERT INTO so VALUES (11, 0), (111, 0);
INSERT INTO soi VALUES (22, 0, 11), (222, 0, 111);
INSERT INTO soir VALUES (33, 0, 22), (333, 0, 222);
CREATE TRIGGER tr_au_so
AFTER UPDATE
ON so
FOR EACH ROW
UPDATE soi SET inactive = NEW.inactive WHERE so_id = NEW.so_id;
CREATE TRIGGER tr_au_soi
AFTER UPDATE
ON soi
FOR EACH ROW
UPDATE soir SET inactive = NEW.inactive WHERE soi_id = NEW.soi_id;
SELECT * FROM so;
SELECT * FROM soi;
SELECT * FROM soir;
SELECT * 
FROM so
JOIN soi USING (so_id)
JOIN soir USING (soi_id);


so_id
inactive


11
0

111
0




soi_id
inactive
so_id


22
0
11

222
0
111




soir_id
inactive
soi_id


33
0
22

333
0
222




soi_id
so_id
inactive
inactive
soir_id
inactive


22
11
0
0
33
0

222
111
0
0
333
0


UPDATE so SET inactive = 1 WHERE so_id = 11;
SELECT * FROM so;
SELECT * FROM soi;
SELECT * FROM soir;
SELECT * 
FROM so
JOIN soi USING (so_id)
JOIN soir USING (soi_id);


so_id
inactive


11
1

111
0




soi_id
inactive
so_id


22
1
11

222
0
111




soir_id
inactive
soi_id


33
1
22

333
0
222




soi_id
so_id
inactive
inactive
soir_id
inactive


22
11
1
1
33
1

222
111
0
0
333
0